首先,在pom文件中添加依赖项:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.7</version>
</dependency>
然后controller层:
/**
* 分页查询用户
*/
@GetMapping("/page")
public Result<PageResult> page(@RequestParam Integer pageNum,@RequestParam Integer pageSize){
PageResult pageResult = userService.page(pageNum,pageSize);
return Result.success(pageResult);
}
service层:
/**
* 分页查询用户
* @return
*/
PageResult page(Integer pageNum,Integer pageSize);
serviceImpl层:
@Override
public PageResult page(Integer pageNum,Integer pageSize) {
PageHelper.startPage(pageNum,pageSize);
Page<User> page = userMapper.pageQuery(pageNum,pageSize);
return new PageResult(page.getTotal(),page.getResult());
}
mapper层:
/**
* 分页查询
* @param pageNum
* @param pageSize
* @return
*/
@Select("select * from sys_user")
Page<User> pageQuery(Integer pageNum, Integer pageSize);