Introduction of Mybatis Pagination Methods

最新推荐文章于 2024-10-17 19:11:48 发布

BananaCode

最新推荐文章于 2024-10-17 19:11:48 发布

阅读量202

点赞数

文章标签： java spring 开发语言

本文链接：https://blog.csdn.net/chengducoder/article/details/126192167

版权

本文介绍了在日常开发中常用的分页设计，讲解了Mybatis框架内的两种分页方法：RowBounds和PageHelper。RowBounds类能自动进行分页，但获取总页数等信息较为不便。PageHelper插件则更方便，不仅自动处理分页，还能提供详细的页面信息。

摘要由CSDN通过智能技术生成

Pagination is commonly used in daily development design. Today's tutorial will introduce two methods to help us achieve pagination in Mybatis.

One: RowBounds method inside Mybatis.

There is a default Class in Mybatis package called RowBounds that can help us paginate our pages automatically.

public class RowBounds {
    public static final int NO_ROW_OFFSET = 0;
    public static final int NO_ROW_LIMIT = 2147483647;
    public static final RowBounds DEFAULT = new RowBounds();
    private final int offset;
    private final int limit;

    public RowBounds() {
        this.offset = 0;
        this.limit = 2147483647;
    }

    public RowBounds(int offset, int limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public int getOffset() {
        return this.offset;
    }

    public int getLimit() {
        return this.limit;
    }
}

Here is the RowBounds c