导入依赖
<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.2.1</version>
</dependency>
<!--在mybatis配置文件中 配置mybatis插件 -->
<plugins>
<plugin interceptor="com.github.pagehelper.PageInterceptor">
<!-- 配置mysql方言 -->
<property name="helperDialect" value="mysql" />
<!-- 设置为true时,如果pageSize=0就会查询出全部的结果 -->
<property name="pageSizeZero" value="true" />
<!-- 3.3.0版本可用,分页参数合理化,默认false禁用 -->
<!-- 启用合理化时,如果pageNum<1会查询第一页,如果pageNum>pages会查询最后一页 -->
<!-- 禁用合理化时,如果pageNum<1或pageNum>pages会返回空数据 -->
<property name="reasonable" value="true" />
</plugin>
</plugins>
// 测试分页插件的使用
@Test
public void test06(){
SqlSession session = factory.openSession(true);
StudentDao mapper = session.getMapper(StudentDao.class);
PageHelper.startPage(5, 3);
List<Student> all = mapper.findAll();
PageInfo<Student> pageInfo = new PageInfo<>(all);
//获取分页的相关数据
System.out.println(pageInfo);
//获取总条数
long total = pageInfo.getTotal();
System.out.println(total);
//获取当前页的显示数据
List<Student> list = pageInfo.getList();
list.forEach(student-> System.out.println(student));
}