PageHelper分页插件
- pom依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency>
- 在springboot配置文件(applicable.yml)中声明插件
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
- 业务代码中使用
@RequestMapping("getUser")
@ResponseBody
public Object getUser(User user, Integer page, Integer limit) {
PageInfo pageInfo = commentService.getUserList(user, page, limit);
Map<String, Object> data = new HashMap<String, Object>();
data.put("code", 0);
data.put("msg", "");
data.put("count", pageInfo.getTotal());
data.put("data", pageInfo.getList());
return data;
}
@Override
public PageInfo getUserList(User user, Integer page, Integer limit) {
PageHelper.startPage(page, limit);
List<User> list = commentMapper.getUserList(user);
PageInfo pageInfo = new PageInfo(list);
return pageInfo;
}
List<User> getUserList(User user);
<select id="getUserList" resultType="com.system.dto.User">
SELECT * FROM tb_comment
</select>