mybatisy PageHelper分页

1.加入pom.xml依赖

  <!--PageHalper依赖-->
        <dependency>
            <groupId>com.github.pagehelper</groupId>
            <artifactId>pagehelper</artifactId>
            <version>5.1.10</version>
        </dependency>

2.mybatis主配置文件插件

<!--配置插件-->
    <plugins>
        <plugin interceptor="com.github.pagehelper.PageInterceptor"/>
    </plugins>

.java代码

  @Test
    public void selectPageHelper() {
        SqlSession sqlSession = MyBatisUntils.getSqlSession();
        StudentDao mapper = sqlSession.getMapper(StudentDao.class);
        PageHelper.startPage(1,2);
        List<Student> students = mapper.selectPageHelper();

        for (Student student : students) {
            System.out.println(student);
        }
    }

mapper文件代码

</select>
    <select id="selectPageHelper" resultType="com.bjpowernode.domain.Student">
        select * from student order by id

    </select>