Mybaits分页插件PageHelper的使用-优快云博客

本文介绍了如何在Java项目中引入PageHelper插件进行分页查询。首先，详细列出了需要添加的PageHelper和jsqlparser依赖；接着，展示了在sqlConfig.xml中配置插件属性的过程，特别是设置dialect为mysql；最后，提供了一个测试类，演示了如何使用PageHelper进行分页查询，并打印出分页信息，包括总条数、总页数、当前页和每页显示的条数。

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