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;
    }
经验分享 程序员 微信小程序 职场和发展