PageHelper分页插件
引入依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>3.7.5</version>
</dependency>
<dependency>
<groupId>com.github.jsqlparser</groupId>
<artifactId>jsqlparser</artifactId>
<version>0.9.1</version>
</dependency>
核心mybatis-config.xml 配置
<plugins>
<plugin interceptor="com.github.pagehelper.PageHelper">
<property name="dialect" value="mysql"/>
<property name="rowBoundsWithCount" value="true"/>
</plugin>
</plugins>
使用
@Test
public void queryAll(){
//实现分页 参数1:当前页(从1开始) 参数2:显示多少条
PageHelper.startPage(2, 2);
//你只管查询所有,如何分页交给 PageHelper.startPage(2, 2);完成
List<User> users = this.userMapper.queryAll();
for (User user : users) {
System.out.println(user);
}
//获取更多的分页信息
PageInfo<User> pageInfo = new PageInfo<User>(users);
System.out.println("总条数:"+pageInfo.getTotal());
System.out.println("当前页:"+pageInfo.getPageNum());
System.out.println("当前页显示的条数:"+pageInfo.getPageSize());
System.out.println("总页码:"+pageInfo.getPages());
System.out.println("最后一页:"+pageInfo.getLastPage());
System.out.println("结果集:"+pageInfo.getList());
System.out.println("上一页:"+pageInfo.getPrePage());
System.out.println("下一页:"+pageInfo.getNextPage());
}