最基础的多表多条件分页查询

Controller层

 @ApiOperation(value = "根据条件分页查询成绩")
    @PostMapping("condition/{current}/{limit}")
    public R pageQueryCondition(@ApiParam(name = "current", value = "当前页码", required = true)
                                @PathVariable Long current,
                                @ApiParam(name = "limit", value = "每页记录数", required = true)
                                @PathVariable Long limit,
                                @ApiParam(name = "resultQuery", value = "条件查询对象", required = false)
                                @RequestBody ResultQuery resultQuery) {
        //创建page对象
        Page<Result> pageSubject = new Page(current, limit);
        List<ResulstPageVo> resulstPageVos = resultService.pageQuery(current.intValue(), limit.intValue());
        return R.ok().data("total", resulstPageVos.size()).data("records", resulstPageVos);
    }

Service层

 List<ResulstPageVo> pageQuery(Integer current, Integer size);

Service层里的ServiceImpl

 @Override
     public List<ResulstPageVo> pageQuery(Integer current,Integer size) {
       List<ResulstPageVo>  list=  resultMapper.mySelectPage((current-1)*size,size);//要加个三目运算当current小于1时。
       return  list;
    }

Mapper层

List<ResulstPageVo> mySelectPage(Integer current,Integer size);

Mapper层里的xml

<select id="mySelectPage" resultType="com.athuiju.eduservice.entity.vo.ResulstPageVo">
SELECT s.`stu_name`,r.`examDate` FROM `result` r RIGHT JOIN `student` s ON r.`studentNo`=s.`studentid` 
LIMIT #{current},#{size}
</select>