1、导出相关jar
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
2、application.properties中添加配置(不是必须)
#pagehelper配置
pagehelper.helperDialect: mysql
pagehelper.reasonable: true
pagehelper.supportMethodsArguments: true
pagehelper.params: count=countSql
3、Controller层
Page<Map> list = reportsService.getTableData(obj);
PageInfo<Map> pageInfo = new PageInfo<>(list);
4、Service层
PageHelper.startPage(page, size);
Page<Map> list = reportsMapper.getTableData(exceSQL);