1.引入jar包
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.3.0</version>
</dependency>
2.在mybatis的核心配置文件mybatis.xml中配置分页插件
3.使用pageHec
public void test03()throws Exception{
Reader reader = Resources.getResourceAsReader("mybatis.xml");
SqlSessionFactory factory=new SqlSessionFactoryBuilder().build(reader);
SqlSession session = factory.openSession();
UserMapper userMapper = session.getMapper(UserMapper.class);
//在查询功能之前使用PageHelper.startPage(int pageNum, int pageSize)开启分页功能
//设置分页属性pageNum:显示第几页 PageSize:每页显示的条数
PageHelper.startPage(3,2);
List<User> list = userMapper.findall();
//把查询的结果封装到PageInfo类中
PageInfo<User> pageInfo=new PageInfo<User>(list);
System.out.println(pageInfo.getTotal());//总条数
System.out.println(pageInfo.getPageNum());//总页数
System.out.println(pageInfo.getList());//当前页码对应的数据
session.commit();
session.close();
}
常用数据