多线程分页查询数据

原创

已于 2024-09-25 10:37:53 修改 · 567 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#java #spring

于 2024-08-27 09:54:00 首次发布

1.配置多线程

private @NotNull List<Map<String, Object>> getData(SysRule rule) throws InterruptedException, ExecutionException {

        int pageSize = 200; // 每页查询的数量
        int threadPoolSize = Runtime.getRuntime().availableProcessors(); // 根据CPU核心数确定线程池大小
        PageQueryExecutor executor = new PageQueryExecutor(threadPoolSize);

        int currentPage = 1;
        boolean hasMorePages = true;

        List<Map<String, Object>> data = new ArrayList<>();
        while (hasMorePages) {

            log.info("当前页数：" + currentPage);
            List<PageQueryTask> tasks = new ArrayList<>();
            for (int i = 0; i < threadPoolSize; i++) {
                tasks.add(new PageQueryTask(rule.getValue(), pageSize, currentPage));
                currentPage++;
            }

            List<Future<List<Map<String, Object>>>> futures = executor.executeQueries(tasks);

            f