在pom.xml中加依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.4.6</version>
</dependency>
mapper中
List<User> selectAllUsers();
mapper.xml中
<select id="selectAllUsers">
select * from user
</select>
service中
PageInfo<User> findAllUser(int pagenum, int pagesize);
实现类impl
@Override
public PageInfo<User> findAllUser(int pagenum, int pagesize) {
PageHelper.startPage(pagenum,pagesize);
List<User> users = userMapper.selectAllUsers();
//pageinfo是分页查询所有查询结果封装的类,所有的结果都从这个类取
//使用pageinfo包装了查询后的结果,将pageinfo交给页面
PageInfo<User> info = new PageInfo<>(users);
return info;
}
controller
@GetMapping("/user/list")
@ResponseBody
public PageInfo<User> selectAll(int pageNum,int pageSize){
return userService.findAllUser(pageNum,pageSize);
}
测试