public void cli(View view) {
//创建daomaster的helper
DaoMaster.DevOpenHelper openHelper = new DaoMaster.DevOpenHelper(this, "kson.db");
//db
SQLiteDatabase db = openHelper.getWritableDatabase();
//创建daomater
DaoMaster daoMaster = new DaoMaster(db);
DaoSession daoSession = daoMaster.newSession();
ProductBeanDao productBeanDao = daoSession.getProductBeanDao();
//增加数据
ProductBean productBean = new ProductBean();
productBean.price = "199";
productBean.title = "锤子手机";
//
// productBeanDao.insert(productBean);//添加数据库成功
//查询数据
//第一种方式
List<ProductBean> list = productBeanDao.queryBuilder().list();
List<ProductBean> list2 = productBeanDao.loadAll();
System.out.println("size1:"+list.size());
System.out.println("size2:"+list2.size());
// productBeanDao.deleteAll();
//删除
// for (ProductBean bean : list) {
//
// productBeanDao.delete(bean);//删除
//
//
// }
System.out.println("size0:"+list.size());
// //更新
productBean.title="小米8";
productBeanDao.update(productBean);//更新
List<ProductBean> list3 = productBeanDao.loadAll();
for (ProductBean bean : list3) {
System.out.println("title:"+bean.title);
}
}
}
//创建daomaster的helper
DaoMaster.DevOpenHelper openHelper = new DaoMaster.DevOpenHelper(this, "kson.db");
//db
SQLiteDatabase db = openHelper.getWritableDatabase();
//创建daomater
DaoMaster daoMaster = new DaoMaster(db);
DaoSession daoSession = daoMaster.newSession();
ProductBeanDao productBeanDao = daoSession.getProductBeanDao();
//增加数据
ProductBean productBean = new ProductBean();
productBean.price = "199";
productBean.title = "锤子手机";
//
// productBeanDao.insert(productBean);//添加数据库成功
//查询数据
//第一种方式
List<ProductBean> list = productBeanDao.queryBuilder().list();
List<ProductBean> list2 = productBeanDao.loadAll();
System.out.println("size1:"+list.size());
System.out.println("size2:"+list2.size());
// productBeanDao.deleteAll();
//删除
// for (ProductBean bean : list) {
//
// productBeanDao.delete(bean);//删除
//
//
// }
System.out.println("size0:"+list.size());
// //更新
productBean.title="小米8";
productBeanDao.update(productBean);//更新
List<ProductBean> list3 = productBeanDao.loadAll();
for (ProductBean bean : list3) {
System.out.println("title:"+bean.title);
}
}
}