<select id="getUserList" resultType="User">
    SELECT * FROM users
    LIMIT #{offset}, #{pageSize}
</select>
List<User> getUserList(@Param("offset") int offset, @Param("pageSize") int pageSize);

<plugins>
    <plugin interceptor="com.github.pagehelper.PageInterceptor">
        <property name="helperDialect" value="mysql"/>
    </plugin>
</plugins>
然后，在需要分頁的查詢方法中添加分頁參數(shù)：
List<User> getUserList(@Param("pageNum") int pageNum, @Param("pageSize") int pageSize);
PageHelper.startPage(pageNum, pageSize);
List<User> users = userMapper.getUserList(pageNum, pageSize);
這兩種方式都可以實現(xiàn)分頁查詢，你可以根據(jù)實際需求選擇合適的方式。

import java.util.ArrayList;
import java.util.List;
public class PaginationWithArrayExample {
    // 模擬從數(shù)據(jù)庫中獲取數(shù)據(jù)的方法，返回所有數(shù)據(jù)
    public List<String> fetchDataFromDatabase() {
        // 這里假設從數(shù)據(jù)庫中獲取了一些數(shù)據(jù)，實際情況根據(jù)需求修改
        List<String> dataList = new ArrayList<>();
        for (int i = 1; i <= 100; i++) {
            dataList.add("Data " + i);
        }
        return dataList;
    }
    // 根據(jù)頁碼和每頁顯示數(shù)量，從數(shù)據(jù)集中獲取指定頁的數(shù)據(jù)
    public List<String> getDataForPage(List<String> dataList, int pageNumber, int pageSize) {
        int startIndex = (pageNumber - 1) * pageSize;
        int endIndex = Math.min(startIndex + pageSize, dataList.size());
        if (startIndex >= endIndex) {
            return new ArrayList<>(); // 如果起始索引大于等于結(jié)束索引，返回空列表
        }
        return dataList.subList(startIndex, endIndex);
    }
    // 示例用法
    public static void main(String[] args) {
        PaginationWithArrayExample example = new PaginationWithArrayExample();
        List<String> dataList = example.fetchDataFromDatabase(); // 模擬從數(shù)據(jù)庫中獲取數(shù)據(jù)
        int pageNumber = 2; // 第2頁
        int pageSize = 10; // 每頁顯示10條數(shù)據(jù)
        List<String> pageData = example.getDataForPage(dataList, pageNumber, pageSize);
        // 輸出當前頁的數(shù)據(jù)
        System.out.println("Page " + pageNumber + " data:");
        for (String data : pageData) {
            System.out.println(data);
        }
    }
}

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-boot-starter</artifactId>
    <version>latest_version</version>
</dependency>

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.demo.entity.User;
public interface UserMapper extends BaseMapper<User> {
    Page<User> selectUserPage(Page<User> page);
}

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.demo.entity.User;
import com.example.demo.mapper.UserMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class UserService {
    @Autowired
    private UserMapper userMapper;
    public Page<User> getUserPage(int pageNum, int pageSize) {
        Page<User> page = new Page<>(pageNum, pageSize);
        return userMapper.selectUserPage(page);
    }
}

import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.example.demo.entity.User;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class UserController {
    @Autowired
    private UserService userService;
    @GetMapping("/users")
    public Page<User> getUserPage(@RequestParam(defaultValue = "1") int pageNum,
                                  @RequestParam(defaultValue = "10") int pageSize) {
        return userService.getUserPage(pageNum, pageSize);
    }
}

假設你有一個 UserDao 接口，其中定義了獲取用戶列表的方法：
public interface UserDao {
    List<User> getUserList();
}
接下來，我們創(chuàng)建一個攔截器來實現(xiàn)分頁功能：
import org.apache.ibatis.executor.Executor;
import org.apache.ibatis.mapping.BoundSql;
import org.apache.ibatis.mapping.MappedStatement;
import org.apache.ibatis.plugin.*;
import org.apache.ibatis.session.ResultHandler;
import org.apache.ibatis.session.RowBounds;
import java.util.Properties;
@Intercepts(@Signature(type = Executor.class, method = "query", args = {MappedStatement.class, Object.class, RowBounds.class, ResultHandler.class}))
public class PaginationInterceptor implements Interceptor {
    @Override
    public Object intercept(Invocation invocation) throws Throwable {
        Object[] args = invocation.getArgs();
        MappedStatement mappedStatement = (MappedStatement) args[0];
        Object parameter = args[1];
        RowBounds rowBounds = (RowBounds) args[2];
        // 判斷是否需要進行分頁
        if (rowBounds != RowBounds.DEFAULT) {
            BoundSql boundSql = mappedStatement.getBoundSql(parameter);
            String sql = boundSql.getSql();
            // 自己實現(xiàn)分頁邏輯，這里簡單起見，直接拼接 LIMIT
            sql += " LIMIT " + rowBounds.getOffset() + ", " + rowBounds.getLimit();
            BoundSql newBoundSql = new BoundSql(mappedStatement.getConfiguration(), sql, boundSql.getParameterMappings(), boundSql.getParameterObject());
            MappedStatement newMappedStatement = copyFromMappedStatement(mappedStatement, new BoundSqlSqlSource(newBoundSql));
            args[0] = newMappedStatement;
            args[2] = RowBounds.DEFAULT;
        }
        return invocation.proceed();
    }
    private MappedStatement copyFromMappedStatement(MappedStatement ms, BoundSqlSqlSource newSqlSource) {
        MappedStatement.Builder builder = new MappedStatement.Builder(ms.getConfiguration(), ms.getId(), newSqlSource, ms.getSqlCommandType());
        builder.resource(ms.getResource());
        builder.fetchSize(ms.getFetchSize());
        builder.statementType(ms.getStatementType());
        builder.keyGenerator(ms.getKeyGenerator());
        builder.keyProperty(ms.getKeyProperty());
        builder.timeout(ms.getTimeout());
        builder.parameterMap(ms.getParameterMap());
        builder.resultMaps(ms.getResultMaps());
        builder.cache(ms.getCache());
        builder.flushCacheRequired(ms.isFlushCacheRequired());
        builder.useCache(ms.isUseCache());
        return builder.build();
    }
    @Override
    public Object plugin(Object target) {
        return Plugin.wrap(target, this);
    }
    @Override
    public void setProperties(Properties properties) {
        // 這里可以接收配置參數(shù)，但我們這里不需要配置參數(shù)
    }
    private static class BoundSqlSqlSource implements org.apache.ibatis.mapping.SqlSource {
        private final BoundSql boundSql;
        public BoundSqlSqlSource(BoundSql boundSql) {
            this.boundSql = boundSql;
        }
        @Override
        public BoundSql getBoundSql(Object parameterObject) {
            return boundSql;
        }
    }
}
然后，在你的 MyBatis 配置文件中配置該攔截器：
<plugins>
    <plugin interceptor="your.package.name.PaginationInterceptor"/>
</plugins>
最后，在業(yè)務代碼中使用分頁功能：
import org.apache.ibatis.session.RowBounds;
public class UserService {
    private final UserDao userDao;
    public UserService(UserDao userDao) {
        this.userDao = userDao;
    }
    public List<User> getUsersByPage(int pageNum, int pageSize) {
        // 計算 offset
        int offset = (pageNum - 1) * pageSize;
        // 使用 RowBounds 進行分頁
        RowBounds rowBounds = new RowBounds(offset, pageSize);
        return userDao.getUserList(rowBounds);
    }
}