方法一: pagehelper
方法二: mybatis-plus分页
方法三: pagehelper-spring-boot-starter
1.添加依赖
<!--分页查询-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.5</version>
</dependency>
2.代码编写
@ApiOperation("分页查询")
@GetMapping("/page/pageNum/{pageNum}/pageSize/{pageSize}")
public PageInfo<UserDto> pagehelper(@PathVariable int pageNum, @PathVariable int pageSize) {
PageInfo<UserDto> pageInfo = userService.page(pageNum, pageSize);
return pageInfo ;
}
PageInfo<UserDto> page(int pageNum, int pageSize);
@Override
public PageInfo<UserDto> page(int pageNum, int pageSize) {
PageHelper.startPage(pageNum, pageSize);
List<UserDto> userDtoList = selectAll();
PageInfo<UserDto> pageInfo = new PageInfo<>(userDtoList);
return pageInfo;
}