Springboot中mybatis分页插件pagehelper

1导入依赖

    <dependency>
        <groupId>com.github.pagehelper</groupId>
        <artifactId>pagehelper</artifactId>
        <version>5.0.0</version>
    </dependency>
    <dependency>
        <groupId>com.github.pagehelper</groupId>
        <artifactId>pagehelper-spring-boot-autoconfigure</artifactId>
        <version>1.2.3</version>
    </dependency>
    <dependency>
        <groupId>com.github.pagehelper</groupId>
        <artifactId>pagehelper-spring-boot-starter</artifactId>
        <version>1.2.3</version>
    </dependency>

2配置application.properties
#分页插件
pagehelper.helperDialect=mysql
pagehelper.reasonable=true
pagehelper.supportMethodsArguments=true
pagehelper.params=count=countSql

3创建接收前端参数的对象
@Data
public class Page {

private int page = 1;//当前页码
private int size = 20;//每页数量

}

4创建util
/**

• 分页信息封装到统一的接口
  */
  public class PageUtils {

  public static PageResult getPageResult(Page page, PageInfo<?> pageInfo) {
  PageResult pageResult = new PageResult();
  pageResult.setPage(pageInfo.getPageNum());
  pageResult.setSize(pageInfo.getPageSize());
  pageResult.setTotal(pageInfo.getTotal());
  pageResult.setTotal_pages(pageInfo.getPages());
  pageResult.setList(pageInfo.getList());
  return pageResult;
  }

  public static void startPage(Page page) {
  int pageNum = page.getPage();
  int pageSize = page.getSize();
  PageHelper.startPage(pageNum, pageSize);
  }
  }

5使用
在查询数据库之前执行 PageUtils.startPage(page);
public PageInfo selectDemo(Demo demo){
List demos= demoDao.selectDemo(“查询条件”);
return new PageInfo(demos);
}

注意: 可自己重新封装返回前端