引入依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency>
配置application.yml
pagehelper:
helperDialect: mysql # 根据数据库配置
reasonable: true
supportMethodsArguments: true
params: count=countSql
使用
PageHelper.startPage(pageNo, pageSize);
List<User> list = userDao.find();// 返回pageSize条数据
PageInfo<User> page = new PageInfo<User>(list);
int total = page.getTotal();// 总条数