在 pom.xml 中单独添加如下依赖:
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.2</version>
</dependency>
然后配置PageHelper插件相关属性
//分页插件,插件无非是设置mybatis的拦截器
PageHelper pageHelper = new PageHelper();
Properties properties = new Properties();
properties.setProperty("reasonable", "true");
properties.setProperty("supportMethodsArguments", "true");
properties.setProperty("returnPageInfo", "check");
properties.setProperty("params", "count=countSql");
pageHelper.setProperties(properties);
//添加插件
bean.setPlugins(new Interceptor[]{pageHelper});
配置信息可写在application.properties配置文件里
pagehelper.dialect=com.github.pagehelper.dialect.helper.MySqlDialect
pagehelper.row-bounds-with-count=true
pagehelper.reasonable=true
pagehelper.support-methods-arguments=true
pagehelper.params=count=countSql
调用方式
public PageInfo queryAffairs(int pageNum, int pageSize) {
PageHelper.startPage(pageNum,pageSize);
List<Affair> list=affairMapper.queryAffairs();
PageInfo<Affair> page=new PageInfo(list);
return page;
}