Mybatis-plus的分页

最新推荐文章于 2024-06-10 18:54:37 发布

NewBee.Mu

最新推荐文章于 2024-06-10 18:54:37 发布

阅读量429

点赞数

分类专栏：注意事项知识点总结 SQL 文章标签： java 开发语言

本文链接：https://blog.csdn.net/NewBeeMu/article/details/125225532

版权

知识点总结同时被 3 个专栏收录

200 篇文章 3 订阅

订阅专栏

注意事项

69 篇文章 2 订阅

订阅专栏

SQL

16 篇文章 0 订阅

订阅专栏

@Data
public class BasePageParameter {

    @ApiParam("当前页码")
    private Integer pageNumber;
    @ApiParam("页条数")
    private Integer pageSize;

    @ApiParam("模糊搜索条件")
    private String search;

    @ApiModelProperty(hidden = true)
    private Integer current;

    @ApiModelProperty(hidden = true)
    private Integer size;

    public BasePageParameter(Integer pageNumber, Integer pageSize, String search) {
        this.pageNumber = pageNumber == null ? 1 : pageNumber;
        this.pageSize = pageSize == null ? 10 : pageSize;
        if (search != null && !"".equals(search.trim())) {
            this.search = search;
        }
        this.current = (this.pageNumber - 1) * this.pageSize;
        this.size = this.pageSize;
    }
}

这是分页参数，然后在MybatisPlusConfig配置以什么结尾的是分页
然后方法名就用那个后缀，比如我这个就是pagination后缀

/**
 * MybatisPlus 配置
 */
@EnableTransactionManagement
@Configuration
@MapperScan(basePackages = {"xx.xxx.xx.mapper"})
public class MybatisPlusConfig {
    /**
     * mybatis-plus分页插件<br>
     * 文档：http://mp.baomidou.com<br>
     */
    @Bean(name = "pagination")
    public PaginationInterceptor paginationInterceptor() {
        PaginationInterceptor paginationInterceptor = new PaginationInterceptor();
        return paginationInterceptor;
    }

    @Bean
    public ISqlInjector sqlInjector() {
//        return new LogicSqlInjector();
        return new DefaultSqlInjector();
    }
}

然后传参的时候先传分页参数和参数

IPage<UserInfo> selectUserList(BasePageParameter param, UserInfo info);

public IPage<UserInfo> selectUserList(BasePageParameter param, UserInfo info) {
        IPage<UserInfo> page = new Page<>(param.getPageNumber(),param.getPageSize());
        QueryWrapper<UserInfo> wrapper = new QueryWrapper<>();
        wrapper.eq("id",info.getId());
        return this.page(page,wrapper);
    }