MyBatis Pagination with PageHelper

In MyBatis, it is common to use PageHelper for pagination. PageHelper is a pagination plugin based on MyBatis interceptor, making it easy to perform database pagination queries. With PageHelper, you can easily add the parameters page and pageSize to the query statement to achieve pagination functionality.

The steps for performing pagination operations using PageHelper are as follows:

1. Configure the PageHelper plugin in the MyBatis configuration file.

<plugins>
    <plugin interceptor="com.github.pagehelper.PageInterceptor">
        <property name="reasonable" value="true"/>
    </plugin>
</plugins>

1. Perform paging queries in Java code using PageHelper.

PageHelper.startPage(pageNum, pageSize);
List<User> userList = userDao.getUserList();

1. Retrieve pagination information.

PageInfo<User> pageInfo = new PageInfo<>(userList);
int total = (int) pageInfo.getTotal(); // 总记录数
int pages = pageInfo.getPages(); // 总页数

By following the above steps, it is possible to achieve pagination in MyBatis. PageHelper will automatically add the “limit offset” statement to the query, enabling database pagination functionality.