mybatis-plus下如何使用分页.开盒即用

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     } }