在MP中,Wrapper接⼝的实现类关系如下:
可以看到,AbstractWrapper和AbstractChainWrapper是重点实现,接下来我们重点学习
AbstractWrapper以及其⼦类。
1、allEq 1.1、说明说明:
QueryWrapper(LambdaQueryWrapper) 和 UpdateWrapper(LambdaUpdateWrapper) 的⽗类
⽤于⽣成 sql 的 where 条件, entity 属性也⽤于⽣成 sql 的 where 条件注意: entity ⽣成的 where 条件与 使⽤各个 api ⽣成的 where 条件没有任何关联⾏为
allEq(Mapparams) allEq(Map params, boolean null2IsNull) allEq(boolean condition, Map params, boolean null2IsNull)
全部eq(或个别isNull)
个别参数说明:
params : key 为数据库字段名, value 为字段值
null2IsNull : 为true 则在map 的value 为null 时调⽤ isNull ⽅法,为false 时则忽略value 为null 的
例1: allEq({id:1,name:"⽼王",age:null}) ---> id = 1 and name = '⽼王' and age is null
例2: allEq({id:1,name:"⽼王",age:null}, false) ---> id = 1 and name = '⽼王'
allEq(BiPredicatefilter, Map params) allEq(BiPredicate filter, Map params, boolean null2IsNull) allEq(boolean condition, BiPredicate filter, Map params, boolean null2IsNull)
1.2、测试用例个别参数说明:
filter : 过滤函数,是否允许字段传⼊⽐对条件中
params 与 null2IsNull : 同上
例1: allEq((k,v) -> k.indexOf("a") > 0, {id:1,name:"⽼王",age:null}) ---> name = '⽼王' and age is null
例2: allEq((k,v) -> k.indexOf("a") > 0, {id:1,name:"⽼王",age:null},false) ---> name = '⽼王'
@Test
public void testAllEq(){
QueryWrapper queryWrapper = new QueryWrapper<>();
// 构建map
Map map = new HashMap<>();
map.put("name","jack");
map.put("age",null);
// WHERe name = ? AND age IS NULL
// queryWrapper.allEq(map);
// WHERe name = ?
// queryWrapper.allEq(map,false);
// SELECT id,name,age,email AS mail,user_name FROM tb_user
// queryWrapper.allEq(false,map,true);
// WHERe age IS NULL
queryWrapper.allEq((k,v) -> k.equals("name"),map);
List users = userMapper.selectList(queryWrapper);
for (User user : users) {
System.out.println(user);
}
}
2、基本比较操作
eq 等于 = between BETWEEN 值1 AND 值2
ne 不等于 notBetween NOT BETWEEN 值1 AND 值2
gt ⼤于 > in 字段 IN (value.get(0), value.get(1), ...)
ge ⼤于等于 >= notIn 字段 NOT IN (v0, v1, ...)
lt ⼩于 <
le ⼩于等于 <=
测试用例
@Test
public void testWrapper(){
QueryWrapper queryWrapper = new QueryWrapper<>();
// WHERe email = ? AND age >= ? AND name IN (?,?)
queryWrapper.eq("email","zimu@lagou.com")
.ge("age",20)
.in("name","子慕","应颠");
List users = userMapper.selectList(queryWrapper);
for (User user : users) {
System.out.println(user);
}
}
3、模糊查询
- like
- LIKE '%值%'
- 例: like("name", "王") ---> name like '%王%'
- notLike
- NOT LIKE '%值%'
- 例: notLike("name", "王") ---> name not like '%王%'
- likeLeft
- LIKE '%值'
- 例: likeLeft("name", "王") ---> name like '%王'
- likeRight
- LIKE '值%'
- 例: likeRight("name", "王") ---> name like '王%'
测试用例
@Test
public void testWrapperLike(){
QueryWrapper queryWrapper = new QueryWrapper<>();
queryWrapper.like("name","子");
List users = userMapper.selectList(queryWrapper);
for (User user : users) {
System.out.println(user);
}
}
4、排序
- orderBy
- 排序:ORDER BY 字段, ...
- 例: orderBy(true, true, "id", "name") ---> order by id ASC,name ASC
- orderByAsc
- 排序:ORDER BY 字段, ... ASC
- 例: orderByAsc("id", "name") ---> order by id ASC,name ASC
- orderByDesc
- 排序:ORDER BY 字段, ... DESC
- 例: orderByDesc("id", "name") ---> order by id DESC,name DESC
-
or
-
拼接 OR
-
主动调⽤or 表示紧接着下⼀个⽅法不是⽤and 连接!(不调⽤or 则默认为使⽤and 连接)
-
-
and
-
AND 嵌套
-
例: and(i -> i.eq("name", "李⽩").ne("status", "活着")) ---> and (name = '李⽩' and status <> '活着')
-
6、select
在MP查询中,默认查询所有的字段,如果有需要也可以通过select⽅法进行指定字段。
4、5、6测试用例
@Test
public void testWrapper2(){
QueryWrapper queryWrapper = new QueryWrapper<>();
// queryWrapper.orderByDesc("age");
queryWrapper.eq("name","jack").or().eq("age",28).select("name");
List users = userMapper.selectList(queryWrapper);
for (User user : users) {
System.out.println(user);
}
}



