Mybatis的分页插件pagehelper

先导依赖

<!-- https://mvnrepository.com/artifact/com.github.pagehelper/pagehelper -->
<dependency>
    <groupId>com.github.pagehelper</groupId>
    <artifactId>pagehelper</artifactId>
    <version>5.2.0</version>
</dependency>

然后去mabatis的配置文件里去让他生效

<plugins>
    <plugin interceptor="com.github.pagehelper.PageInterceptor"></plugin>
</plugins>

去MyBatis里面去配置的时候,一定要注意顺序,不然会报错

SQL语句

<!--查询所有数据-->
    <select id="selectAll" resultType="com.linanjun.entity.Student1113">
        select
            stu_id, name, sex, age, address, course_id
        from student1113
    </select>

测试用例

//查询所有
    @Test
    public void testSelectAll() {
        SqlSession session = null;
        try {
            session = MybatisUtil.createSession();
//            PageHelper.startPage(第几页,每页的数据)
            PageHelper.startPage(1,3);
            Page<Student1113> students =( Page) session.selectList("Student1113Dao.selectAll");
            System.out.println("总页数"+students.getPages());
            System.out.println("总记录数"+students.getTotal());
            for (Student1113 student : students) {
                System.out.println("查询的数据==>"+student);
            }
        } catch (Exception e) {
            System.out.println("异常");
            e.printStackTrace();
        } finally {
            MybatisUtil.closeSession(session);
        }
    }

控制台输出:

总页数3
总记录数7
查询的数据==>Student1113{stuId=1, name='栾云平', sex='男', age=20, address='一队', courseId=1}
查询的数据==>Student1113{stuId=2, name='岳云鹏', sex='男', age=17, address='二队', courseId=1}
查询的数据==>Student1113{stuId=3, name='烧饼', sex='男', age=18, address='五队', courseId=3}