先导依赖
<!-- 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}