How to perform pagination queries in MyBatis?

There are two ways to implement pagination in MyBatis.

1. Utilize pagination plugins: MyBatis offers various pagination plugins, such as PageHelper, which make it easy to perform paginated queries. By using PageHelper, you can call the PageHelper.startPage method before the query statement to set pagination parameters, and then call the PageHelper.endPage method after the query statement to retrieve paginated results.

The example code is as follows:

PageHelper.startPage(pageNum, pageSize);
List<User> userList = userMapper.getUserList();
PageInfo<User> pageInfo = new PageInfo<>(userList);

1. To implement pagination in SQL queries, you can use the “limit” and “offset” keywords to limit the number of results and specify the starting point of the query.

The example code is shown below:

<select id="getUserList" parameterType="map" resultType="User">
    select * from user
    limit #{offset}, #{pageSize}
</select>

In Java code, passing the parameters offset and pageSize allows for pagination in the query.