springboot pageHelper实现分页

pom.xml 节点 dependencies 下添加 pagehelper 依赖

 
            com.github.pagehelper
            pagehelper-spring-boot-starter
            1.3.1
        

Mapper层

支持通过Mapper接口参数来传递分页参数，默认值false，分页插件会从查询方法的参数值中，自动根据上面 params
配置的字段中取值，查找到合适的值时就会自动分页。

List queryTableSchema(@Param("tableSchema") String tableSchema);

service层
**

调用 PageHelper.startPage(pageNum,pageSize);
参数含义：pageNum:当前页 pageSize:每页的数量

**

 PageInfo queryTableSchema(Tables tables);

  @Override
    public PageInfo queryTableSchema(Tables tables) {
        PageHelper.startPage(tables.getPageNum(), tables.getPageSize());
        List tablesVOS = dictMapper.queryTableSchema(tables.getTableSchema());
        PageInfo pageInfo = new PageInfo<>(tablesVOS);
        return pageInfo;
    }

controller层

@PostMapping(value = "/queryTablesList")
    public AjaxResult queryTablesList(@RequestBody Tables tablesDTO) {
        return AjaxResult.success(dictService.queryTableSchema(tablesDTO));
    }

postman测试接口：

测试结果截图：

AjaxResult是自定义的业务响应层代码逻辑，附代码逻辑如下：

public class AjaxResult extends HashMap {
    private static final long serialVersionUID = 1L;

    
    public static final String CODE_TAG = "code";

    
    public static final String MSG_TAG = "msg";

    
    public static final String DATA_TAG = "data";

    
    public AjaxResult() {
    }

    
    public AjaxResult(int code, String msg) {
        super.put(CODE_TAG, code);
        super.put(MSG_TAG, msg);
    }

    
    public AjaxResult(int code, String msg, Object data) {
        super.put(CODE_TAG, code);
        super.put(MSG_TAG, msg);
        if (StringUtils.isNotNull(data)) {
            super.put(DATA_TAG, data);
        }
    }

    
    @Override
    public AjaxResult put(String key, Object value) {
        super.put(key, value);
        return this;
    }

    
    public static AjaxResult success() {
        return AjaxResult.success("操作成功");
    }

    
    public static AjaxResult success(Object data) {
        return AjaxResult.success("操作成功", data);
    }

    
    public static AjaxResult success(String msg) {
        return AjaxResult.success(msg, null);
    }

    
    public static AjaxResult success(String msg, Object data) {
        return new AjaxResult(HttpStatus.SUCCESS, msg, data);
    }

    
    public static AjaxResult error() {
        return AjaxResult.error("操作失败");
    }

    
    public static AjaxResult error(String msg) {
        return AjaxResult.error(msg, null);
    }

    
    public static AjaxResult error(String msg, Object data) {
        return new AjaxResult(HttpStatus.ERROR, msg, data);
    }

    
    public static AjaxResult error(int code, String msg) {
        return new AjaxResult(code, msg, null);
    }
}