Springboot+mybatis使用PageHelper分页插件

1.在application.yml中添加配置

pagehelper:
  helperDialect: oracle
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

2.在pom文件中添加依赖

<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper-spring-boot-starter</artifactId>
    <version>1.2.11</version>
</dependency>

3.编写代码

public PageInfo<CmsEnt> getCmsBycolunm(DataPage page) {
        String account = UserUtil.getUser().getUserName();
        String columnId = (page.getColumnId()).split("-")[1];
        PageHelper.startPage(page.getPageNo(), page.getPageSize(), true);
        List<CmsEnt> list= this.sqlSessionTemplate.selectList(getSqlName(SQL_ID_FIND_CMS_LIST),columnId);
        PageInfo<CmsEnt> pageInfo = new PageInfo<CmsEnt>(list);
　　　　　return pageInfo ;
}

注意在sql查询之前写上PageHelper.startPage(page.getPageNo(), page.getPageSize(), true);开启分页功能，即可实现分页。