1、 ge(大于等于)、 gt(大于)、 le、 lt、 isNull、 isNotNull
queryWrapper
.isNull("name")
.ge("age", 12)
.isNotNull("email");
2、 eq(equal)、 ne(not equal)
queryWrapper.eq("name", "Tom");
3、 between、 notBetween
queryWrapper.between("age", 20, 30);
4、 allEq
Map<String, Object> map = new HashMap<>();
map.put("id", 2);
map.put("name", "Jack");
map.put("age", 20);
queryWrapper.allEq(map);
5、 like、 notLike、 likeLeft、 likeRight
queryWrapper
.notLike("name", "e")
.likeRight("email", "t");
6、 in、 notIn、 inSql、 notinSql、 exists、 notExists
//queryWrapper.in("id", 1, 2, 3);
queryWrapper.inSql("id", "select id from user where id < 3");
7、 or、 and
userUpdateWrapper
.like("name", "h") //like "%h%"
.or()
.between("age", 20, 30);
UPDATE user SET name=?, age=?, update_time=? WHERE deleted=0 AND name LIKE ? OR age
BETWEEN ? AND ?
8、嵌套or、嵌套and
wrapper.like("name","l").or(i->i.eq("name","lzw").eq("age",10));
SELECT id,name,age,email,create_time,update_time,version
FROM user
WHERE (name LIKE ‘%l%’ OR ( (name = ‘lzw’ AND age = 10) ));
9、 orderBy、 orderByDesc、 orderByAsc
queryWrapper.orderByDesc("id");
10、 last
queryWrapper.last("limit 1");
11、 指定要查询的列
queryWrapper.select("id", "name", "age");
12、 set、 setSql
userUpdateWrapper
.like("name", "h")
.set("name", "老李头")//除了可以查询还可以使用set设置修改的字段
.setSql(" email = '123@qq.com'");//可以有子查询
UPDATE user SET age=?, update_time=?, name=?, email = ‘123@qq.com’ WHERE deleted=0 AND
name LIKE ?