基于java线程池和EasyExcel实现异步导出

基于java线程池和EasyExcel实现异步导出

1.controller层

@GetMapping("export")
public void exportExcel(HttpServletResponse response) throws IOException, InterruptedException {
   
    exportService.exportExcel(response);
}

2. service

    public void exportExcel(HttpServletResponse response) throws IOException, InterruptedException {
   
        //设置响应头
        setExportHeader(response);
        //查询总数
        Long count = salariesMapper.selectCount(null);
        //每页查询条数
        Long pageSize = 40000L;