分页查询的详细实现步骤

---

分页查询的详细实现步骤

---

Controller

/**
     * 分页查询
     * @param
     * @return
     */
    @ApiOperation(value = "分页查询")
    @PostMapping("pageBook")
    @LogAction(module = "李渊斌", method = "分页查询", logType = LogTypeEnum.SELECT, operatorType = OperatorTypeEnum.WEB)
    public ResponseVo pageBook(PageQuery pageQuery){
        CommonPage<StudentAo> commonPage = liTestService.pageBook(pageQuery);
        return ResponseVo.response(ResponseEnum.SUCCESS, commonPage);
    }

Service接口

 //分页
    CommonPage<StudentAo> pageBook(PageQuery pageQuery);

ServiceImpl实现类

/**
     * 分页查询
     * @param pageQuery
     * @return
     */
    @Override
    public CommonPage<StudentAo> pageBook(PageQuery pageQuery) {
        IPage<StudentAo> page = new Page<>(pageQuery.getCurrent(),pageQuery.getPageSize());
        page = baseMapper.getPageBook(page, pageQuery);
        return  CommonPageUtils.assemblyPage(page);
        }

Mapper接口

//分页查询
    IPage<StudentAo> getPageBook(IPage<StudentAo> page, @Param("pageQuery") PageQuery pageQuery);

Mapper.xml

<select id="getPageBook" resultType="java.util.Map">
        select <include refid="selectVo"/>  from test
    </select>