模糊查询
List<FoodTable> list = DBManager.getInstance().getDaoSession()
//根据标题模糊查询
.queryBuilder(FoodTable.class)
.where(FoodTableDao.Properties.Id.like("%" + "油焖大虾"+ "%"))
.list();
LogUtils.json(list);
插入数据,查询数据库
FoodEnter foodEnter = new Gson().fromJson(json, FoodEnter.class);
List<FoodEnter.DataBean> data = foodEnter.getData();
DaoMaster daoMaster = DBManager.getInstance().getDaoMaster(MainActivity.this);
插入数据
for (int i = 0; i < data.size(); i++) {
daoMaster.newSession().insert(new FoodTable(null, data.get(i).getTitle()));
}
查询数据库
List<FoodTable> foodTables = daoMaster.newSession().loadAll(FoodTable.class):
LogUtils.json(foodTables);
删除数据
DaoMaster daoMaster = new DBManager().getDaoMaster(this);
UserTable user_d = new UserTable(1l, "标题");
daoMaster.newSession().delete(user_d);
修改数据
DaoMaster daoMaster = new DBManager().getDaoMaster(this);
UserTable user = new UserTable(3l, "标题");
daoMaster.newSession().update(user);