PageHelper根据页数数据分页显示

发表于2021-04-10更新于2021-05-23字数统计153阅读时长1分
>返回顶部<

引入依赖

1
2
3
4
5
6
<!-- pagehelper -->
<dependency>
	<groupId>com.github.pagehelper</groupId>
	<artifactId>pagehelper-spring-boot-starter</artifactId>
	<version>1.2.5</version>
</dependency>

配置文件

1
2
3
4
5
pagehelper:
  helperDialect: mysql
  reasonable: true
  supportMethodsArguments: true
  params: count=countSql

实例代码

1
2
3
4
5
6
//startNum=1, pageSize=5
//页数为第一页 每页大小为5
PageHelper.startPage(startNum, pageSize);
List<Book> list = bookService.findAllBooks();
PageInfo pageInfo = new PageInfo(list, pageSize);
return new ApiResponse(200, "请求成功", pageInfo);