自定义线程池+异步编排实现数据导出

原创

已于 2023-06-23 19:56:57 修改 · 597 阅读

3 ·

CC 4.0 BY-SA版权

文章标签：

#java #servlet #开发语言

于 2023-03-23 17:16:18 首次发布

文章展示了如何在Java中使用EasyExcel库进行异步Excel文件导出，配置了基于CPU核心数的线程池，并对可能出现的`CannotcallsendError()aftertheresponsehasbeencommitted`异常进行了分析，该异常源于多次响应同一个HTTP请求。

依赖

     <!-- easyexcel -->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.2.1</version>
        </dependency>

线程池

private static final int CPU_COUNT = Runtime.getRuntime().availableProcessors();
    private final Integer corePoolSize =Math.max(2, Math.min(CPU_COUNT - 1, 4));

    private final Integer maxPoolSize = CPU_COUNT * 2 + 1;

    private static final Integer KEEP_ALIVE_TIME = 30;


    @Bean(name = "asyncExecutor")
    @Primary
    public ThreadPoolTaskExecutor asyncServiceExecutor() {
   
   
        ThreadPoolTaskExecutor executor = new ThreadPoolTaskExecutor();
        //配置核心线程数
        executor.setCorePoolSize(corePoolSize);
        //配置最大线程数
        executor.setMaxPoolSize(maxPoolSize);
        //配置队列大小
        int queueCapacity = 1000;
        executor.setQueueCapacity(queueCapacity);
        executor.setKeepAliveSeconds(KEEP_ALIVE_TIME);
        //配置线程池中的线程的名称前缀
        executor.setThreadNamePrefix("asyncExecutor-");
        executor.setRejectedExecutionHandler(new ThreadPoolExecutor.CallerRunsPolicy())