使用easypoi集成SpringMVC进行大数据导出

蔚落 2022-02-24 03:23 683阅读 0赞

# （一）导包 #

> 导入easypoi的包，注意：要去掉poi的包，有冲突

<dependency>
          <groupId>cn.afterturn</groupId>
          <artifactId>easypoi-base</artifactId>
          <version>3.2.0</version>
        </dependency>
        <dependency>
          <groupId>cn.afterturn</groupId>
          <artifactId>easypoi-web</artifactId>
          <version>3.2.0</version>
        </dependency>
        <dependency>
          <groupId>cn.afterturn</groupId>
          <artifactId>easypoi-annotation</artifactId>
          <version>3.2.0</version>
        </dependency>

# （二）新建domain #

//这里使用了jpa
    
    我这里做测试，就简单建了
    @Entity
    @Table(name = "bigdata")
    public class BigData extends BaseDomain{
        @Excel(name = "名称",width = 15) 
        private String name;
    
        public String getName() {
            return name;
        }
    
        public void setName(String name) {
            this.name = name;
        }
    }

# （三）新建ExcelExportServer #

> 要使用easypoi的大数据导出，需要实现IExcelExportServer接口

public class MyExcelExportServer implements IExcelExportServer {
        @Autowired
        private IBigDataService bigDataService;
    
    
        @Override
        public List<Object> selectListForExcelExport(Object o, int i) {
            //i是页码，自动传入，进行分页查询
            List list = bigDataService.queryLimit(i);
            System.out.println("----------"+i);
            return list;
        }
    }

# （四）applicationContext-mvc.xml配置 #

//固定写法
    <context:component-scan base-package="cn.afterturn.easypoi.handler.inter"/>
    
    //实现IExcelExportServer接口的类
    <bean class="cn.pj.aisell.common.MyExcelExportServer"/>

# （五）controller代码 #

> 注意：这里有一个坑，发现不能有title，不然会报错，我已经注释了

//大数据导出`
        @RequestMapping("/bigdata")
        public void downloadByPoiBaseView(ModelMap map, HttpServletRequest request,
                                          HttpServletResponse response) {
    //        ExportParams params = new ExportParams("2412312", "测试", ExcelType.XSSF);
            long start = new Date().getTime();
            ExportParams params = new ExportParams();
    //        params.setFreezeCol(2);
            map.put(BigExcelConstants.CLASS, BigData.class);
            map.put(BigExcelConstants.PARAMS, params);
            map.put(BigExcelConstants.FILE_NAME, "lala");
            //就是我们的查询参数,会带到接口中,供接口查询使用
            map.put(BigExcelConstants.DATA_PARAMS, new HashMap<String,String>());
            map.put(BigExcelConstants.DATA_INTER,excelExportServer );
            PoiBaseView.render(map, request, response, BigExcelConstants.EASYPOI_BIG_EXCEL_VIEW);
            long end = new Date().getTime();
            System.out.println("总共用时:"+(end-start));
        }