08 - mybatis - 分页插件

pageHelp插件

1 导包

<dependency>
   <groupId>com.github.pagehelper</groupId>
   <artifactId>pagehelper</artifactId>
   <version>5.1.4</version>
</dependency>

2 在核心配置文件中加入拦截器

<configuration>
   ...
   --配置分页拦截
   <plugins>
       <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
   </plugins>
   ...
</configuration>   

3 在需要分页的地方使用

@Test
public void selectPageHelp() throws IOException {
   InputStream stream = Resources.getResourceAsStream("mybatis.xml");
   SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(stream);
   SqlSession sqlSession = sessionFactory.openSession(true);
   UserDao mapper = sqlSession.getMapper(UserDao.class);
   
   PageHelper.startPage(1,3);
   List<User> list = mapper.list();
   
   PageInfo<User> pageInfo = new PageInfo<>(list);
   
   System.out.println(pageInfo.getList());
   sqlSession.close();
}