Spring Boot +MyBatis用PageHelper 实现一行代码分页

分手后的思念是犯贱 2022-01-26 23:17 228阅读 0赞

先看使用方法：

public PageResult<List<PolymerizationRowVO>> getPolyRow(
              @RequestParam(value = "pageNum", defaultValue = "1", required = false) Integer pageNum,
                @RequestParam(value = "pageSize", defaultValue = "10", required = false) Integer pageSize) {
          
            PageHelper.startPage(pageNum, pageSize);
    
            PageInfo<PolymerizationRowVO> pageInfo = new PageInfo<>(
                    polymerizationMapper.findPolyRowByCityCodeAndPeriod());
    
    
            return PageResult.success(pageInfo.getList(), pageInfo.getTotal(),pageNum,pageSize);

效果：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plcm92cHA_size_16_color_FFFFFF_t_70][]

关键代码：**PageHelper.startPage(pageNum,pageSize)**

pageNum表示第几页，pageSize表示每页多少行数据，用**PageHelper.startPage**实现自动分页，不用在其他地方如MyBatis sql加代码，实现后在pageInfo中有了，然后再用PageResult接参。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plcm92cHA_size_16_color_FFFFFF_t_70 1][]

PageResult.success方法：

public static <T> PageResult<List<T>> success(List<T> data, long recordsTotal,long pageNum,long pageSize) {
    
            PageResult<List<T>> result = new PageResult<>();
            result.setStatus(ResultStatus.SUCCESS.index);
            result.setMessage(ResultStatus.SUCCESS.name);
            result.setData(data);
            result.setRecordsTotal(recordsTotal);
            result.setPageNum(pageNum);
            result.setPageSize(pageSize);
            return result;
        }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plcm92cHA_size_16_color_FFFFFF_t_70]: /images/20220127/5ad42d7dbd4844218a7df73c3e41845d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3plcm92cHA_size_16_color_FFFFFF_t_70 1]: /images/20220127/1178d4796df844229ae9255b918c6c99.png