Mybatis-plus :分页带条件查询
StudentController
@ApiOperation("分页带条件查询学生信息")
@GetMapping("/getStudentByOpr/{pageNo}/{pageSize}")
public Result getStudentByOpr(
@ApiParam("页码数") @PathVariable("pageNo") Integer pageNo,
@ApiParam("页大小") @PathVariable("pageSize") Integer pageSize,
@ApiParam("查询条件")Student student
){
//分页信息封装Page对象
Page<Student> page = new Page<>(pageNo,pageSize);
//进行查询
IPage<Student> studentIPage = studentService.getStudentByOpr(page,student);
//封装Result返回
return Result.ok(studentIPage);
}
StudentServiceImpl
@Override
public IPage<Student> getStudentByOpr(Page<Student> page, Student student) {
QueryWrapper<Student> queryWrapper = new QueryWrapper<>();
//判断要模糊查询的数据是否为空,在放进条件控制器queryWrapper
if(!StringUtils.isBlank(student.getName())){
queryWrapper.like("name",student.getName());
}
if(!StringUtils.isBlank(student.getClazzName())){
queryWrapper.like("clazz_name",student.getClazzName());
}
//降序查询
queryWrapper.orderByDesc("id");
Page<Student> StudentPage = baseMapper.selectPage(page, queryWrapper);
return StudentPage;
}
下一篇:
三分钟带你学会修改VS的默认对齐数
