//查
- Parententity = db.findById(Parent.class, parent.getId());
- Parententity = db.findFirst(entity);//通过entity的属性查找
- List<Parent>list = db.findAll(entity);//通过entity的属性查找
- List<Parent>list = db.findAll(Parent.class);//通过类型查找
- ParentParent =db.findFirst(Selector.from(Parent.class).where("name","=","test"));
- //IS NULL
- ParentParent = db.findFirst(Selector.from(Parent.class).where("name","=",null));
- //IS NOT NULL
- ParentParent = db.findFirst(Selector.from(Parent.class).where("name","!=",null));
- //WHERE id<54 AND (age>20 OR age<30) ORDER BY id LIMITpageSize OFFSET pageOffset
- List<Parent>list = db.findAll(Selector.from(Parent.class)
- .where("id","<", 54)
- .and(WhereBuilder.b("age",">", 20).or("age", " < ", 30))
- .orderBy("id")
- .limit(pageSize)
- .offset(pageSize* pageIndex));
- //op为"in"时,最后一个参数必须是数组或Iterable的实现类(例如List等)
- Parenttest = db.findFirst(Selector.from(Parent.class).where("id","in", new int[]{1, 2, 3}));
- //op为"between"时,最后一个参数必须是数组或Iterable的实现类(例如List等)
- Parenttest = db.findFirst(Selector.from(Parent.class).where("id","between", new String[]{"1", "5"}));
- DbModeldbModel =db.findDbModelAll(Selector.from(Parent.class).select("name"));//select("name")只取出name列
- List<DbModel>dbModels =db.findDbModelAll(Selector.from(Parent.class).groupBy("name").select("name","count(name)"));
- ...
- List<DbModel>dbModels = db.findDbModelAll(sql); // 自定义sql查询
- db.execNonQuery(sql)// 执行自定义sql