看到这里,你应该已经引入Mybatis并搭建好了环境:引入Mybatis
接下来步骤如下:
1.引入pageHelper依赖
<!--mapper-->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>1.1.4</version>
</dependency>
<!--pagehelper-->
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.9</version>
</dependency>
2.配置pagehelper
#pagehelper配置
pagehelper.helper-dialect=mysql
pagehelper.page-size-zero=true #当pagesize 为 0 时 查询所有
3.使用
@RequestMapping("/getAllStudentBeanByPage")
public List<StudentBean> getAllStudentBeanByPage(int index,int pagesize){
PageHelper.startPage(index, pagesize);
List<StudentBean> list = studentService.findAllStudent();
PageInfo pageInfo = new PageInfo(list);
System.out.println("总行数:"+pageInfo.getTotal());
System.out.println("总页数:"+pageInfo.getPages());
return list;
}