在 pom.xml 中单独添加如下依赖:
<dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper</artifactId> <version>4.1.3</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});这个是在java代码里配的
因为当前工程是用SpringBoot搭的,可直接集成
<dependency> <groupId>org.mybatis.spring.boot</groupId> <artifactId>mybatis-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>tk.mybatis</groupId> <artifactId>mapper-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency> <dependency> <groupId>com.github.pagehelper</groupId> <artifactId>pagehelper-spring-boot-starter</artifactId> <version>1.1.1</version> </dependency>配置信息可写在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; }PageInfo本身封装了很多的分页信息: