mybatis plus条件构造器
条件构造器分别是QueryWrapper和UpdateWrapper,二者都继承于AbstractWrapper,并且分别有自己的lambda表达式形式,这里更推荐使用lambda表达式形式(LambdaQueryWrapper、LambdaUpdateWrapper),因为这样可以保证字段的正确性,防止字段拼写错误造成异常。
AbstractWrapper中封装了许多函数来实现sql中的条件查询
下面将主要记录lambda形式的使用尝试
public AjaxResult testStudentOne(){
LambdaQueryWrapper<Student> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.ne(Student::getAge,"18")
.ne(Student::getSex,"女")
.between(Student::getAge,"18","22")
.like(Student::getName,"张");
List<Student> list = studentService.list(queryWrapper);
return AjaxResult.success(list);
}
该方法查询的是年龄不为18,性别不为女,年龄在18到22之间,模糊查询名字里有张的数据
public AjaxResult testStudentTwo(){
LambdaQueryWrapper<Student> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.ge(Student::getAge,"18")
.le(Student::getAge,"22");
List<Student> list = studentService.list(queryWrapper);
return AjaxResult.success(list);
}
该方法查询的是年龄大于等于18,小于等于22的数据
public AjaxResult testStudentThree(){
LambdaQueryWrapper<Student> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.notBetween(Student::getAge,"20","22")
.notLike(Student::getName,"王")
.isNotNull(Student::getName);
List<Student> list = studentService.list(queryWrapper);
return AjaxResult.success(list);
}
该方法查询的是年龄不在20到22之间,名字里不含王,且名字不为空的数据
public AjaxResult testStudentFour(){
List<Integer> integerList = new ArrayList<>();
integerList.add(20);
integerList.add(21);
LambdaQueryWrapper<Student> queryWrapper = new LambdaQueryWrapper<>();
queryWrapper.in(Student::getAge,integerList)
.groupBy(Student::getSex)
.orderByAsc(Student::getAge);
List<Student> list = studentService.list(queryWrapper);
return AjaxResult.success(list);
}
该方法查询的是年龄在{20,21}中,按性别分组且按年龄升序排序的数据
以上代码AjaxResult是对传输数据的封装,无须考虑,Student就是一个实体类按实际环境更改即可