GreenDao的简单使用

initDB

这个一定要写上
如果写bean类记着加上“@Entity”和“ @Id，这个下面一定要放主键，
（这是自增，可写可不写，(autoincrement = true)）”

  private void initDB() {
        DaoMaster.DevOpenHelper helper = new DaoMaster.DevOpenHelper(MainActivity.this, "ab");
        SQLiteDatabase database = helper.getWritableDatabase();
        DaoMaster daoMaster = new DaoMaster(database);
        DaoSession daoSession = daoMaster.newSession();
        leftBeanDao = daoSession.getLeftBeanDao();
        rightBeanDao = daoSession.getRightBeanDao();
    }

添加到数据库

        for (int i = 0; i < result.size(); i++) {
                //添加
            LeftBean leftBean = new LeftBean();
            leftBean.setPid(Long.valueOf(result.get(i).getId()));
            leftBean.setId(result.get(i).getId());
            leftBean.setName(result.get(i).getName());
            leftBeanDao.insertOrReplace(leftBean);
            }

查询，把传到数据库的拿出来

 //查询
            QueryBuilder<LeftBean> builder = leftBeanDao.queryBuilder();
            List<LeftBean> list = builder.where(LeftBeanDao.Properties.Name.eq(result.get(i).getName()))
                    .orderAsc(LeftBeanDao.Properties.Name)
                    .list();
          

遍历Toast一下，写不写无所谓

  for (Object o : list) {
                if (o instanceof LeftBean) {
                    Toast.makeText(this, ((LeftBean) o).getName(), Toast.LENGTH_SHORT).show();
                }
            }

把添加跟查询连到一起，要写到for循环里面

for (int i = 0; i < result.size(); i++) {
            //添加
            LeftBean leftBean = new LeftBean();
            leftBean.setPid(Long.valueOf(result.get(i).getId()));
            leftBean.setId(result.get(i).getId());
            leftBean.setName(result.get(i).getName());
            leftBeanDao.insertOrReplace(leftBean);
            //查询
            QueryBuilder<LeftBean> builder = leftBeanDao.queryBuilder();
            List<LeftBean> list = builder.where(LeftBeanDao.Properties.Name.eq(result.get(i).getName()))
                    .orderAsc(LeftBeanDao.Properties.Name)
                    .list();
                    //遍历
            for (Object o : list) {
                if (o instanceof LeftBean) {
                    Toast.makeText(this, ((LeftBean) o).getName(), Toast.LENGTH_SHORT).show();
                }
            }
        }