mabatis + pagehelper 实现分页分页

原理是pagehelper 内部有一个拦截器，在执行SQL语句之前，会为其拼接limit，以此来达到分页的目的。

        
        
            com.github.pagehelper
            pagehelper-spring-boot-starter
            1.3.1
        
        
        
            org.springframework.boot
            spring-boot-starter-data-jdbc
        

        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.2.0
        

配置

spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/test_mybatis?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai


  main:
    allow-circular-references: true
#mybatis配置
#mapper-locations: classpath:mapper/UserMapper.xml指定加载这个文件
mybatis:
  # 配置mapper的扫描，找到所有的mapper.xml映射文件
  mapperLocations: classpath:mapper
    protected TableDataInfo getDataTable(PageInfo pageInfo) {
        TableDataInfo rspData = new TableDataInfo();
        rspData.setCode(1);
        rspData.setMsg("查询成功");
        rspData.setData(pageInfo.getList());;
        rspData.setTotal(pageInfo.getTotal());
        rspData.setLastPage(pageInfo.isIsLastPage());
        return rspData;
    }

    @GetMapping("pageMember")
    public TableDataInfo pageMember(){
        PageHelper.startPage(1, 10);//这句代码一定要放在查询sql的上面，不然不会分页。
        List members=  memberService.find();
        TableDataInfo dataTable = getDataTable(new PageInfo(members));
        return dataTable;
    }

}

package com.angen.springboot_test2.util;

import java.io.Serializable;
import java.util.List;


public class TableDataInfo implements Serializable {
    private static final long serialVersionUID = 1L;

    
    private long total;

    
    private List rows;

    
    private int code;

    
    private String msg;
    
    private List data;

    private boolean lastPage;

    public List getData() {
        return data;
    }

    public void setData(List data) {
        this.data = data;
    }

    public boolean getLastPage() {
        return lastPage;
    }

    public void setLastPage(boolean lastPage) {
        this.lastPage = lastPage;
    }

    
    public TableDataInfo() {
    }

    
    public TableDataInfo(List list, int total) {
        this.rows = list;
        this.total = total;
    }

    public long getTotal() {
        return total;
    }

    public void setTotal(long total) {
        this.total = total;
    }

    public List getRows() {
        return rows;
    }

    public void setRows(List rows) {
        this.rows = rows;
    }

    public int getCode() {
        return code;
    }

    public void setCode(int code) {
        this.code = code;
    }

    public String getMsg() {
        return msg;
    }

    public void setMsg(String msg) {
        this.msg = msg;
    }
}

其他代码照常写