springboot+mybatisplus如何分页

1.在service去继承mybatis的基础service

2.mapper继承基础的basemapper

 3.最后在controlller层就可以直接使用分页了

 public IPage getFileList(FileDownRecordDto fileDownRecord) {
        IPage page = new Page<>(fileDownRecord.getPageNum(), fileDownRecord.getPageSize());
        QueryWrapper queryWrapper = new QueryWrapper<>();
        if (StringUtils.isNotBlank(fileDownRecord.getInfono())) {
            queryWrapper.eq("infono",fileDownRecord.getInfono());
        }
        IPage downRecordIPage= baseInfoService.page(page,queryWrapper);
        return downRecordIPage;
    };

4.重要的一点！！！！ 因为我踩了坑

得加入这个分页配置分页才能生效

@Configuration
public class MybatisPlusConfig {

    
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

    
    @Bean
    public ConfigurationCustomizer configurationCustomizer() {
        // 函数式编程
        return (configuration) -> {
            // 使用mybatis-plus 内置的
            configuration.setObjectWrapperFactory(new MybatisMapWrapperFactory());
        };
    }
}

5.补充分页排序功能 好用的很

主要就是page自带的addOrder里面有排序信息设置话不多说直接上代码

Page page = new Page<>(fileDownRecord.getPageNum(), fileDownRecord.getPageSize());
        QueryWrapper queryWrapper = new QueryWrapper<>();
        if (StringUtils.isNotBlank(fileDownRecord.getInfono())) {
            queryWrapper.eq("infono",fileDownRecord.getInfono());
        }
        if(StringUtils.isNotBlank(fileDownRecord.getImportState()))
        {
            queryWrapper.eq("import_state",fileDownRecord.getImportState());
        }
        OrderItem orderItem=new OrderItem();
        orderItem.setColumn(fileDownRecord.getOrderColumn());
        if(fileDownRecord.getAsc()!=null){
            orderItem.setAsc(fileDownRecord.getAsc());
        }
        page.addOrder(orderItem);
        Page downRecordIPage= baseInfoService.page(page,queryWrapper);
        return downRecordIPage;