mybatis中Pagehelper插件实现数据分页
在pom.xml中导入分页依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>4.1.6</version>
</dependency>
mybatis配置文件src/main/resource目录下mybatis-config.xml中写入插件配置
<plugins>
<plugin interceptor="com.github.pagehelper.PageHelper">
<property name="dialect" value="mysql"/>
</plugin>
</plugins>
测试类中直接使用即可
@Test
public void selectAllTest(){
SqlSession session = sessionFactory.openSession();
PageHelper.startPage(1,5);
List<User> users = session.selectList("org.example.mapper.UserMapper.selectAll");
users.stream().forEach(System.out::println);
session.close();
}