1.新增mybatis-plus配置文件
import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
@Configuration
public class MybatisPlusConfig {
/**
* mybatis-plus 分页配置
* @return
*/
@Bean
public MybatisPlusInterceptor mybatisPlusInterceptor() {
MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.MYSQL));
return interceptor;
}
}
2.使用
// controller层
@RequestMapping("/queryPageColor")
public ResultData queryPageColor(@RequestParam(name = "page") Integer page, @RequestParam(name = "size") Integer size){
return colorService.queryPageColor(page,size);
}
// service
ResultData queryPageColor(Integer page, Integer size);
// serviceImpl
@Override
public ResultData queryPageColor(Integer currentPage, Integer size) {
QueryWrapper<Color> wrapper = new QueryWrapper<>();
wrapper.orderByAsc("create_time");
Page<Color> page = new Page<>(currentPage, size);
// 使用selectPage
Page<Color> colorPage = colorMapper.selectPage(page, wrapper);
// 获取查询到的值
List<Color> records = colorPage.getRecords();
return ResultData.success(colorPage);
}
3.测试
测试mybatis-plus分页 |
localhost:6399/queryPageColor?page=1&size=1 |
{ "code": 0, "message": "查询成功", "data": { "records": [ { "id": "1", "color": "紫色", "createTime": "2023-11-27 11:09:54", "updateTime": "2023-11-27 11:09:54" } ], "total": 1, "size": 1, "current": 1, "orders": [], "optimizeCountSql": true, "searchCount": true, "maxLimit": null, "countId": null, "pages": 1 } } |