Android 快速开发系列 ORMLite 框架最佳实践之实现历史记录搜索

首先在build.gald中添加compile 'com.j256.ormlite:ormlite-android:4.48'的引用

 compile 'com.j256.ormlite:ormlite-android:4.48' 

之后开始创建DatabaseHelper数据库版主类 基于ormlite，这里以SearchHistroy2.class为例，可以添加很多个运用到数据库的类

public class DatabaseHelper extends OrmLiteSqliteOpenHelper{

    private static final String TABLE_NAME = "pspsp.db";
    private static final int DB_VERSION = 3;

    private Map<String, Dao> daos = new HashMap<String, Dao>();

    private DatabaseHelper(Context context)
    {
        super(context, TABLE_NAME, null, DB_VERSION);
    }
    @Override
    public void onCreate(SQLiteDatabase database, ConnectionSource connectionSource) {
        try
        {
            TableUtils.createTable(connectionSource, SearchHistroy2.class);
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
    }

    @Override
    public void onUpgrade(SQLiteDatabase database, ConnectionSource connectionSource, int oldVersion, int newVersion) {
        try
        {
            TableUtils.dropTable(connectionSource, SearchHistroy2.class, true);
            onCreate(database, connectionSource);
        } catch (SQLException e)
        {
            e.printStackTrace();
        }
    }

    private static DatabaseHelper instance;

    /**
     * 单例获取该Helper
     *
     * @param context
     * @return
     */
    public static synchronized DatabaseHelper getHelper(Context context)
    {
        context = context.getApplicationContext();
        if (instance == null)
        {
            synchronized (DatabaseHelper.class)
            {
                if (instance == null)
                    instance = new DatabaseHelper(context);
            }
        }

        return instance;
    }

    public synchronized Dao getDao(Class clazz) throws SQLException
    {
        Dao dao = null;
        String className = clazz.getSimpleName();

        if (daos.containsKey(className))
        {
            dao = daos.get(className);
        }
        if (dao == null)
        {
            dao = super.getDao(clazz);
            daos.put(className, dao);
        }
        return dao;
    }

    /**
     * 释放资源
     */
    @Override
    public void close()
    {
        super.close();

        for (String key : daos.keySet())
        {
            Dao dao = daos.get(key);
            dao = null;
        }
    }

}

好！主类写好了，下面我们要对每个Bean创建一个XXXDao来处理当前Bean的数据库操作，当然真正去和数据库打交道的对象，通过上面代码中的getDao（T t）进行获取

getDao为一个泛型方法，会根据传入Class对象进行创建Dao，并且使用一个Map来保持所有的Dao对象，只有第一次调用时才会去调用底层的getDao()。

public class SearchDao2 {

    private Context context;
    private Dao<SearchHistroy2, Integer> userDaoOpe;
    private DatabaseHelper helper;

    public SearchDao2(Context context) {
        this.context = context;
        try {
            helper = DatabaseHelper.getHelper(context);
            userDaoOpe = helper.getDao(SearchHistroy2.class);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    /**
     * 增加一个用户
     *
     * @param model
     */
    public void add(SearchHistroy2 model) {
        try {
            SearchHistroy2 searchHistroy = userDaoOpe.queryBuilder().where().eq("name", model.getName()).queryForFirst();
            if (searchHistroy == null || StringUtils.isEmpty(searchHistroy.getName()) && !StringUtils.isEmpty(model.getName())) {
                userDaoOpe.create(model);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
    /**
     * 清楚所有
     */
    public void deteAll() {
        try {
            userDaoOpe.deleteBuilder().delete();
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

    /**
     * 获取所有查询记录
     *
     * @return
     */
    public List<SearchHistroy2> getAllList() {
        try {
            return userDaoOpe.queryForAll();
        } catch (SQLException e) {
            e.printStackTrace();
            return new ArrayList<SearchHistroy2>();
        }
    }
}

其实在写Dao文件之前应该现在数据中建表

@DatabaseTable(tableName = "search_history2")
public class SearchHistroy2 {

    @DatabaseField(generatedId = true)
    private int id;

    @DatabaseField(columnName = "name")
    private String name;

    private boolean isDelete=false;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public boolean isDelete() {
        return isDelete;
    }

    public void setIsDelete(boolean isDelete) {
        this.isDelete = isDelete;
    }

    //    @DatabaseField(canBeNull = true, foreign = true, columnName = "user_id")
//    private User user;
}

数据库建表以及对表的增删改查的方法准备好了，现在就以历史列表的搜索为例进行增删改查了

 

@ContentView(R.layout.activity_comm_search)
public class CommSearch2Activity extends BaseAppActivity implements UITableViewDelegate {

    private EditText edtValue;
    private SearchDao2 searchDao;

    @ViewInject(R.id.recyclerView)
    private RecyclerView recyclerView;
    private List<SearchHistroy2> list;
    @Override
    protected void init() {
        searchDao = new SearchDao2(this);
        list = new ArrayList<SearchHistroy2>();
        setCustomView(R.layout.view_search_top2);
        edtValue = (EditText) findViewById(R.id.edtValue);
        edtValue.clearFocus();
        list = searchDao.getAllList();
        recyclerView.setDelegate(this);
        recyclerView.setDataSource(list);
        recyclerView.getRecyclerView().addItemDecoration(new DividerItemDecoration(this, DividerLineDecoration.VERTICAL, true));
    }
    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        mToolbarManager.createMenu(R.menu.menu_search);
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        if (item.getItemId() == R.id.tb_add) {
            String strValue = edtValue.getText().toString().trim();
            strValue = strValue.replace("", "");
            if (!StringUtils.isEmpty(strValue)) {
                SearchHistroy2 histroy = new SearchHistroy2();
                histroy.setName(strValue);
                searchDao.add(histroy);
            }
        }
        return super.onOptionsItemSelected(item);
    }

    @Override
    public android.support.v7.widget.RecyclerView.ViewHolder getItemViewHolder(ViewGroup viewGroup, int i) {
        View view = LayoutInflater.from(this).inflate(R.layout.list_item_serch_history, viewGroup, false);
        return new MyViewHolder(view);
    }
    @Override
    public void onBindData(BaseViewHolder baseViewHolder, int i) {
        MyViewHolder holder = (MyViewHolder) baseViewHolder;
        final SearchHistroy2 histroy = list.get(i);
        holder.txtV.setText(histroy.getName());
        holder.itemView.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                searchDao.add(histroy);
            }
        });

        if (i == list.size() - 1) {
            holder.btnClean.setVisibility(View.VISIBLE);
            holder.btnClean.setOnClickListener(new View.OnClickListener() {
                @Override
                public void onClick(View v) {
                    searchDao.deteAll();
                    list.clear();
                    recyclerView.setDataSource(list);
                }
            });
        } else
            holder.btnClean.setVisibility(View.GONE);
    }

    private class MyViewHolder extends BaseViewHolder {
        private TextView txtV;
        private View btnClean;

        public MyViewHolder(View itemView) {
            super(itemView);
            this.txtV = (TextView) itemView.findViewById(R.id.txtValue);
            this.btnClean = itemView.findViewById(R.id.btnClean);
        }

        @Override
        public void onClick(View view) {
        }

        @Override
        public boolean onLongClick(View view) {
            return false;
        }
    }

}

 

界面大概是这样的

希望帮到大家了