dbUtils = DbUtils.create(this, "studentDb");
try {
dbUtils.createTableIfNotExist(User.class);
} catch (DbException e) {
e.printStackTrace();
try {
dbUtils.createTableIfNotExist(User.class);
} catch (DbException e) {
e.printStackTrace();
}
//添加
dbUtils.save(new User(1, "张三", "男"));
//删除
// 创建一个WhereBuilder(过滤条件)
WhereBuilder wb = WhereBuilder.b("name", "=", "张三");
dbUtils.delete(User.class, wb);
//修改
// 创建一个WhereBuilder(过滤条件)
WhereBuilder wb = WhereBuilder.b("name", "=", "张三");
dbUtils.update(new User(2, "张三", "女"), wb, null);
//查询
List<User> user = dbUtils.findAll(User.class);
// 创建一个WhereBuilder(过滤条件)
WhereBuilder whereBuilder=WhereBuilder.b("name", "==", "张三");
List<User> findAll = dbUtils.findAll(Selector.from(User.class).where(whereBuilder));