springboot项目中pagehelper分页插件的使用
1.首先,我们需要在 pom.xml 文件中添加分页插件依赖包。
<!-- pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.5</version>
</dependency>
2.然后在 application.yml 配置文件中添加分页插件有关的配置。
# pagehelper
pagehelper:
helperDialect: mysql
reasonable: true
supportMethodsArguments: true
params: count=countSql
3.service调用分页插件分页
/**
* 调用分页插件完成分页
* @param pageQuery
* @return
*/
private PageInfo<SysUser> getPageInfo(PageRequest pageRequest) {
int pageNum = pageRequest.getPageNum();
int pageSize = pageRequest.getPageSize();
PageHelper.startPage(pageNum, pageSize);
List<SysUser> sysMenus = sysUserMapper.selectPage();
return new PageInfo<SysUser>(sysMenus);
}
### PageInfo<CiNoCommitCodeUserStatisticVo> voPageInfo = new PageInfo<>(list);
分页信息在pageInfo对象中!!!