©2020-2024 ioDraw All rights reserved,
Privacy Policy
1，导入依赖
<!--mybatis-plus--> <dependency><groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId> </dependency> <!-- velocity
模板引擎, Mybatis Plus 代码生成器需要 --> <dependency>
<groupId>org.apache.velocity</groupId>
<artifactId>velocity-engine-core</artifactId> </dependency>
设置mybatisplus的分页插件
@Configuration @EnableTransactionManagement //开启事务
@MapperScan("com.acm.gulimall.product.dao") public class MyBatisConfig {
//引入分页插件 @Bean public PaginationInterceptor paginationInterceptor() {
PaginationInterceptor paginationInterceptor = new PaginationInterceptor(); //
设置请求的页面大于最大页后操作， true调回到首页，false 继续请求 默认false
paginationInterceptor.setOverflow(true); // 设置最大单页限制数量，默认 500 条，-1 不受限制
paginationInterceptor.setLimit(1000); return paginationInterceptor; } }
二，使用mybatisplus进行分页查询数据库数据
//测试分页查询所有讲师 @ApiOperation(value = "分页查询所有讲师")
@GetMapping("/pageTeacher/{page}/{limit}") public R
pageListTeacher(@ApiParam(name = "page",value = "当前页码",required = true)
@PathVariable Long page, @ApiParam(name = "limit",value = "每页记录数",required =
true) @PathVariable Long limit){ //创建page对象 Page<EduTeacher> pageParam = new
Page<>(page, limit); //调用方法实现条件查询分页 eduTeacherService.page(pageParam,null);
List<EduTeacher> records = pageParam.getRecords();//数据list集合 long total =
pageParam.getTotal();//获取总记录数 return
R.ok().data("total",total).data("rows",records); }
以上就可以实现分页效果了