java动态生成excel打包下载

    @SuppressWarnings("unchecked")  
    public String batchExport() throws DBException{  
          
        @SuppressWarnings("unused")  
        List chkList = this.checkValueToList();//获取复选框的值  
        List srcfile=new ArrayList();  
          
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMddHHSS");  
        String path = sdf.format(new Date());  
          
        String serverPath = request.getSession().getServletContext().getRealPath("/");  
        //在服务器端创建文件夹  
        File file = new File(serverPath+path);  
        if(!file.exists()){  
            file.mkdir();  
        }  
  
        for (int i = 0; i < chkList.size(); i++ ){  
            String t[] = chkList.get(i).split("\|");  
            LhjcOrgSelfQuery lhjcunioncheckquery = new LhjcOrgSelfQuery();  
            lhjcunioncheckquery.setChnoticeId(t[0]);  
            lhjcunioncheckquery.setOrgId(t[1]);  
            lhjcunioncheckquery.setSelfChTempId(t[2]);  
            List> reportViews=commonService.getObjectPages("ExportLhjcunioncheckresultReportView", lhjcunioncheckquery);  
            String orgName = (String)commonService.get2Object("getUnioncheckOrgName", t[1]);  
            //生成excel的名字  
            String templateName = nyear+"深圳市党政机关信息安全检查结果-"+(orgName==null?"未知单位":orgName);  
              
              
            String[] headArray = new String[]{"编码","检查项名称","   检查内容   ","考核类型","   检查结果   ","   备注   ","权重","得分"};  
              
              
            String[] fieldArray = new String[]{"CHECKITEMCODE","CHITEMNAME","CHCONTENT","REPORTTYPE","QUESTDESC","CHITEMDESC","REPORTWEIGHT","UNIONSCORE"};  
              
            ExportUtils exportUtils = new ExportUtils();  
            exportUtils.setTitle(templateName);  
            exportUtils.setHead(templateName);  
            exportUtils.setHeadArray(headArray);  
            exportUtils.setFieldArray(fieldArray);  
            try {  
                HttpServletResponse response = ServletActionContext.getResponse();  
                  
                SimpleDateFormat sfm = new SimpleDateFormat("yyyy-MM-dd");  
                String filename = templateName + "_" + sfm.format(new Date());  
                  
                String encodedfileName = new String(filename.getBytes(), "GBK");  
                //将生成的多个excel放到服务器的指定的文件夹中  
                FileOutputStream out = new FileOutputStream(serverPath+path+""+encodedfileName+".xls");  
                  
                if(fileType.indexOf(",") != -1){  
                    fileType = StringUtils.substringBefore(fileType, ",");  
                }  
                response.setHeader("Content-Disposition", " filename="" + encodedfileName + "." + fileType + """);  
                  
                //导出excel  
                if ("xls".equals(fileType) || "xlsx".equals(fileType)) {  
                    exportUtils.exportExcel(reportViews,fileType,out);  
                } else if("doc".equals(fileType) || "docx".equals(fileType)){  
                    exportUtils.exportWord(reportViews, fileType, out);  
                } else if("pdf".equals(fileType)){  
                    exportUtils.exportPdf(reportViews, out);  
                }   
                  
                srcfile.add(new File(serverPath+path+""+encodedfileName+".xls"));  
                  
            } catch (Exception e) {  
                e.printStackTrace();  
            }   
        }  
        //将服务器上存放Excel的文件夹打成zip包  
        File zipfile = new File(serverPath+path+".zip");  
        this.zipFiles(srcfile, zipfile);  
        //弹出下载框供用户下载  
        this.downFile(ServletActionContext.getResponse(),serverPath, path+".zip");  
        return null;  
    }  
  
  
      
    public void zipFiles(List srcfile, File zipfile) {    
        byte[] buf = new byte[1024];    
        try {    
            // Create the ZIP file    
            ZipOutputStream out = new ZipOutputStream(new FileOutputStream(zipfile));    
            // Compress the files    
            for (int i = 0; i < srcfile.size(); i++) {    
                File file = srcfile.get(i);    
                FileInputStream in = new FileInputStream(file);    
                // Add ZIP entry to output stream.    
                out.putNextEntry(new ZipEntry(file.getName()));    
                // Transfer bytes from the file to the ZIP file    
                int len;    
                while ((len = in.read(buf)) > 0) {    
                    out.write(buf, 0, len);    
                }    
                // Complete the entry    
                out.closeEntry();    
                in.close();    
            }    
            // Complete the ZIP file    
            out.close();   
        } catch (IOException e) {    
           e.printStackTrace();  
        }    
    }    
  
  
    public void downFile(HttpServletResponse response,String serverPath, String str) {    
        try {    
            String path = serverPath + str;    
            File file = new File(path);    
            if (file.exists()) {    
                InputStream ins = new FileInputStream(path);    
                BufferedInputStream bins = new BufferedInputStream(ins);// 放到缓冲流里面    
                OutputStream outs = response.getOutputStream();// 获取文件输出IO流    
                BufferedOutputStream bouts = new BufferedOutputStream(outs);    
                response.setContentType("application/x-download");// 设置response内容的类型    
                response.setHeader(    
                        "Content-disposition",    
                        "attachment;filename="    
                                + URLEncoder.encode(str, "GBK"));// 设置头部信息    
                int bytesRead = 0;    
                byte[] buffer = new byte[8192];    
                 //开始向网络传输文件流    
                while ((bytesRead = bins.read(buffer, 0, 8192)) != -1) {    
                   bouts.write(buffer, 0, bytesRead);    
               }    
               bouts.flush();// 这里一定要调用flush()方法    
                ins.close();    
                bins.close();    
                outs.close();    
                bouts.close();    
            } else {    
                response.sendRedirect("../error.jsp");    
            }    
        } catch (IOException e) {    
            e.printStackTrace();  
        }    
    }