pagehelper: helperDialect: oracle reasonable: true supportMethodsArguments: true params: count=countSql
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.2.11</version> </dependency>
public PageInfo<CmsEnt> getCmsBycolunm(DataPage page) { String account = UserUtil.getUser().getUserName(); String columnId = (page.getColumnId()).split("-")[1]; PageHelper.startPage(page.getPageNo(), page.getPageSize(), true); List<CmsEnt> list= this.sqlSessionTemplate.selectList(getSqlName(SQL_ID_FIND_CMS_LIST),columnId); PageInfo<CmsEnt> pageInfo = new PageInfo<CmsEnt>(list); return pageInfo ; }
注意在sql查询之前写上PageHelper.startPage(page.getPageNo(), page.getPageSize(), true);开启分页功能,即可实现分页。
Springboot+mybatis使用PageHelper分页插件
原文:https://www.cnblogs.com/LH-up-blogs/p/15102296.html