1、引入 PageHelper 相关 jar 包
<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>
2、sqlConfig.xml 配置插件属性
<plugins>
<plugin interceptor="com.github.pagehelper.PageHelper">
<property name="dialect" value="mysql"/>
</plugin>
</plugins>
3、测试类
public class TestPageHelperUtil {
private SqlSessionFactory sqlSessionFactory;
private IUserMapper userMapper;
@Before
public void before() throws IOException {
String path = "SqlConfig.xml";
InputStream inputStream = Resources.getResourceAsStream(path);
sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
SqlSession session = sqlSessionFactory.openSession();
userMapper = session.getMapper(IUserMapper.class);
}
@Test
public void pageHelperTest(){
PageHelper.startPage(1,1);
List<UserInfo> userInfoList = userMapper.findAll();
for(UserInfo userInfo:userInfoList){
System.out.println(userInfo);
}
PageInfo<UserInfo> pageInfo = new PageInfo<>(userInfoList);
System.out.println("总条数:" + pageInfo.getTotal());
System.out.println("总页数:" + pageInfo.getPages());
System.out.println("当前页:" + pageInfo.getPageNum());
System.out.println("每页显示的条数:" + pageInfo.getPageSize());
}
}