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();}

常用数据