springboot+mybatisplus如何分页

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

2.mapper继承基础的basemapper

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

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

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

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

@Configuration
public class MybatisPlusConfig {

    /**
     * 实现 IPage分页功能 写了此 分页才生效
     */
    @Bean
    public PaginationInterceptor paginationInterceptor() {
        return new PaginationInterceptor();
    }

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

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

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

Page<FileDownRecord> page = new Page<>(fileDownRecord.getPageNum(), fileDownRecord.getPageSize());
        QueryWrapper<FileDownRecord> 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<FileDownRecord> downRecordIPage= baseInfoService.page(page,queryWrapper);
        return downRecordIPage;