allEq
官方文档:
allEq(Map<R, V> params)
allEq(Map<R, V> params, boolean null2IsNull)
allEq(boolean condition, Map<R, V> params, boolean null2IsNull)
个别参数说明:
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 = '老王'
验证boolean null2IsNull:
@Test
public void allEq() {
QueryWrapper<TCourse> queryWrapper = new QueryWrapper<>();
Map<String,String> params = new HashMap<>();
params.put("name",null);
**queryWrapper.allEq(params);**
List<TCourse> list = itCourseService.list(queryWrapper);
for(TCourse tCourse:list){
System.out.println(tCourse);
}
}
boolean null2IsNull = true 结果:
TCourse(id=13, name=null)
boolean null2IsNull = false`在这里插入代码片` 结果:
TCourse(id=2, name=math)
TCourse(id=3, name=英语)
TCourse(id=4, name=物理)
TCourse(id=5, name=政治)
TCourse(id=6, name=化学)
TCourse(id=7, name=生物)
TCourse(id=8, name=history)
TCourse(id=9, name=劳动)
TCourse(id=10, name=体育)
TCourse(id=11, name=music)
TCourse(id=12, name=美术)
TCourse(id=13, name=null)
allEq(BiPredicate<R, V> filter, Map<R, V> params)
allEq(BiPredicate<R, V> filter, Map<R, V> params, boolean null2IsNull)
allEq(boolean condition, BiPredicate<R, V> filter, Map<R, V> params, boolean null2IsNull)
个别参数说明:
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 = '老王'
验证BiPredicate<R, V> filter
@Test
public void allEqBiPredicate() {
QueryWrapper<TCourse> queryWrapper = new QueryWrapper<>();
Map<String,String> params = new HashMap<>();
params.put("name","英语");
params.put("id","4");
queryWrapper.allEq((k,v)->k.equals("id"),params);
List<TCourse> list = itCourseService.list(queryWrapper);
for(TCourse tCourse:list){
System.out.println(tCourse);
}
}
结果:
TCourse(id=4, name=物理)
filter:过滤条件:key为“id”的条件被加入到筛选条件中
相当于:
allEq((k,v)->k.equals("id"),params)---->id = "4"
allEq(params)---->id = "4" and name = "英语"
eq,ne,gt,ge,lt,le
值得一提的是,除了可以比较数字大小外,还可以比较字母
@Test
public void le(){
QueryWrapper<TCourse> queryWrapper = new QueryWrapper<>();
queryWrapper.le("name","w");
List<TCourse> list = itCourseService.list(queryWrapper);
for(TCourse tCourse:list){
System.out.println(tCourse);
}
}
结果:
TCourse(id=2, name=math)
TCourse(id=8, name=history)
TCourse(id=11, name=music)
between 和 notBetween
@Test
public void between(){
QueryWrapper<TCourse> queryWrapper = new QueryWrapper<>();
queryWrapper.between("name","a","z");
List<TCourse> list = itCourseService.list(queryWrapper);
for(TCourse tCourse:list){
System.out.println(tCourse);
}
}
TCourse(id=2, name=math)
TCourse(id=8, name=history)
TCourse(id=11, name=music)
@Test
public void notBetween(