阅读Github项目上发现一款好用的分页插件,先分享出来
pom
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.3</version>
</dependency>
yml
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
Controller
public void loadUsers(Integer limit, Integer offset){
PageHelper.startPage(PageUtil.getPageNo(limit, offset),limit);
List<User> userList = userService.selectUsers();
PageInfo<User> pages = new PageInfo<>(userList);
}
Util
public class PageUtil {
public static Integer getPageNo(Integer limit,Integer offset){
return offset==0 ? 1 : offset / limit + 1;
}
}