一、引入meaven依赖
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper</artifactId>
<version>5.1.10</version>
</dependency>
二、在mybatis配置文件的<environments>前面加入配置插件
<plugins>
<plugin interceptor = "com.github.pagehelper.PageInterceptor" />
</plugins>
<environments>
........
三、使用pagehelper分页
interface StudentDao{
List<Student> select();
}
<select id="select" resultType = "com.demo.domain.Student">
select * from student order by id
</select>
PageHelper.startPage(1,3);
List<Student> students = dao.select();
参数说明:PageHelper.startPage(pageNum,PageSize);
pageNum:第几页,索引从1开始
PageSize:一页中拿多少行数据