MyBatis中PageHelper插件使用

1.pom.xml引入依赖

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

2.mybatis-config.xml配置分页插件

<plugins>
    <plugin interceptor="com.github.pagehelper.PageInterceptor">
        <property name="helperDialect" value="mysql"/>
    </plugin>
</plugins>

3.编写接口

//查询全部，测试分页插件
    List<Employee> queryListPageHelper();

4.编写mapper配置文件

    <!--查询全部，测试分页插件-->
    <select id="queryListPageHelper" resultType="employee">
        select * from t_emp
    </select>

5.编写测试代码

package com.suchuanlin.test;

import com.github.pagehelper.Page;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.suchuanlin.mapper.EmployeeMapper;
import com.suchuanlin.pojo.Employee;
import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.junit.jupiter.api.AfterEach;
import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;

public class MyBatisDynamicSQL {

    private SqlSession sqlSession;

    @BeforeEach
    public void before() throws IOException {
        InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
        sqlSession = sqlSessionFactory.openSession(true);
    }

    @AfterEach
    public void clean(){
        sqlSession.close();
    }


    //查询全部，测试分页插件
    @Test
    public void testQueryListPageHelper(){
        EmployeeMapper mapper = sqlSession.getMapper(EmployeeMapper.class);
        //调用前，先设置分页数据（当前是第几页，每页显示多少条数据）
        PageHelper.startPage(1, 5);
        //TODO:注意不能将两条查询语句装到一个分页区
        List<Employee> employeeList = mapper.queryListPageHelper();
        //将查询到的数据封装到一个PageInfo的分页实体类中（一共有多少页，一共有多少条数据等等）
        PageInfo<Employee> pageInfo = new PageInfo<>(employeeList);
        /*pageInfo获取分页的数据
            1.当前页的数据
            2.获取数据总条数
            3.获取总页数*/

        //当前页的数据
        List<Employee> employeeList1 = pageInfo.getList();
        //总页数
        int pages = pageInfo.getPages();
        //数据总条数
        long total = pageInfo.getTotal();
        //当前页码
        int pageNum = pageInfo.getPageNum();
        //每页显示数据条数
        int pageSize = pageInfo.getPageSize();

        System.out.println("数据列表：" + employeeList1);
        System.out.println("总页数：" + pages);
        System.out.println("数据总条数：" + total);
        System.out.println("当前页码：" + pageNum);
        System.out.println("每页显示数据条数：" + pageSize);
    }

}

6.输出结果

Opening JDBC Connection
Created connection 1091781053.
==>  Preparing: SELECT count(0) FROM t_emp
==> Parameters: 
<==    Columns: count(0)
<==        Row: 30
<==      Total: 1
==>  Preparing: select * from t_emp LIMIT ?
==> Parameters: 5(Integer)
<==    Columns: emp_id, emp_name, emp_salary
<==        Row: 5, 张三, 199.0
<==        Row: 6, 李四, 1899.99
<==        Row: 7, 李四, 1899.99
<==        Row: 8, 王五, 2000.0
<==        Row: 9, 赵六, 1888.88
<==      Total: 5
数据列表：Page{count=true, pageNum=1, pageSize=5, startRow=0, endRow=5, total=30, pages=6, reasonable=false, pageSizeZero=false}[Employee(empId=5, empName=张三, empSalary=199.0), Employee(empId=6, empName=李四, empSalary=1899.99), Employee(empId=7, empName=李四, empSalary=1899.99), Employee(empId=8, empName=王五, empSalary=2000.0), Employee(empId=9, empName=赵六, empSalary=1888.88)]
总页数：6
数据总条数：30
当前页码：1
每页显示数据条数：5
Closing JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@411341bd]