JAVA ZIP打包和POI导出

/** * 导出Excel功能 * @param sql 获取数据要执行的SQL语句 * @param params SQL语句的参数 * @param column Excel表头，如果有扩展属性的话，可定义为：户号,户名,营业区域$ALL_BS_INFO * @param excelRowsLimit 没个Excel单元格的条数 * @param httpServletRequest  * @return 改Excel的下载地址 * @throws Exception */public String expExcel(String sql, List params, String[] column,int excelRowsLimit, HttpServletRequest httpServletRequest)throws Exception {DBTool dbTool = null;String downloadUrl = "";Record[] rds = null;Record record = null;ZipOutputStream out =  null;try {dbTool = new DBTool();rds = dbTool.executeQuery(sql, params);//System.out.println("L:  "+rds.length);int genExcelRowsLimit = excelRowsLimit <= 0 ? ServiceLocator.getInstance().getWebAppConfig().getGenExcelRowsLimit(): excelRowsLimit;String path = ServiceLocator.getInstance().getWebAppConfig().getExcelTempDirectory();String zipPath = httpServletRequest.getSession().getId()+ System.currentTimeMillis() + ".zip";downloadUrl = "http://" + httpServletRequest.getServerName() + ":"+ httpServletRequest.getServerPort()+ httpServletRequest.getContextPath()+ "/GetTempFileServlet?fileName=" + zipPath;if (path == null) {path = httpServletRequest.getSession().getServletContext().getRealPath("download");downloadUrl = "http://" + httpServletRequest.getServerName()+ ":" + httpServletRequest.getServerPort()+ httpServletRequest.getContextPath() + "/download"+ "/" + zipPath;}//System.out.println(path+System.getProperty("file.separator")+zipPath);File file = new File(path+System.getProperty("file.separator")+zipPath);if(!file.exists()){file.createNewFile();}out = new ZipOutputStream(new FileOutputStream(file));DropBeanMap dbm = DropBeanMap.getInstance();int fileCount = rds.length % genExcelRowsLimit == 0 ? rds.length/genExcelRowsLimit : rds.length / genExcelRowsLimit + 1;//System.out.println("fileCount "+fileCount);for (int i = 0; i < fileCount; i++) {int temp = i * genExcelRowsLimit;HSSFWorkbook wb = new HSSFWorkbook();HSSFSheet hs = wb.createSheet();HSSFCellStyle style = wb.createCellStyle();style.setBorderBottom(HSSFCellStyle.BORDER_THIN);style.setBorderLeft(HSSFCellStyle.BORDER_THIN);style.setBorderRight(HSSFCellStyle.BORDER_THIN);style.setBorderTop(HSSFCellStyle.BORDER_THIN);style.setFillForegroundColor(HSSFColor.LIGHT_GREEN.index);style.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);HSSFFont font = wb.createFont();font.setFontHeightInPoints((short) 11);style.setFont(font);HSSFCellStyle style1 = wb.createCellStyle();style1.setBorderBottom(HSSFCellStyle.BORDER_THIN);style1.setBorderLeft(HSSFCellStyle.BORDER_THIN);style1.setBorderRight(HSSFCellStyle.BORDER_THIN);style1.setBorderTop(HSSFCellStyle.BORDER_THIN);style1.setFillForegroundColor(HSSFColor.ORANGE.index);style1.setFillPattern(HSSFCellStyle.SOLID_FOREGROUND);HSSFFont font1 = wb.createFont();font1.setFontHeightInPoints((short) 15);font1.setBoldweight((short) 700);style1.setFont(font);HSSFCellStyle style2 = wb.createCellStyle();style2.setWrapText(true); // 设置自动换行HSSFRow hr = hs.createRow(0);for (int j = 0; j < column.length; j++) {// 设置表头String value = "";if (column[j].indexOf("$") < 0) {value = column[j];} else {value = column[j].substring(0, column[j].indexOf("$"));}int len = value.length();hs.setColumnWidth((short) j, (short) (len * 1600));HSSFCell hc = hr.createCell((short) j);hc.setEncoding(HSSFCell.ENCODING_UTF_16);hc.setCellStyle(style1);hc.setCellValue(value);}int eachCount =  genExcelRowsLimit;if(i==(fileCount-1) && rds.length % genExcelRowsLimit != 0 ){eachCount = rds.length % genExcelRowsLimit-1;}//System.out.println("i: "+i+" eachCount: "+eachCount);for (int j = 0; j < eachCount; j++) {hr = hs.createRow(j + 1);//System.out.println("temp + j: "+(temp + j));record = rds[temp + j];for (int r = 0; r < column.length; r++) {String dropName = "";String value = record.getString(r + 1) == null ? "": record.getString(r + 1).toString();value = value.replaceAll(";alt", "'");if (column[r].indexOf("$") >= 0) {dropName = column[r].substring(column[r].indexOf("$") + 1, column[r].length());value = dbm.getDropLabel(dropName, value);}hr.setHeight((short) 500);HSSFCell hc = hr.createCell((short) r);hc.setCellStyle(style);hc.setEncoding(HSSFCell.ENCODING_UTF_16);hc.setCellValue(value);hc.setCellStyle(style2);}}out.putNextEntry(new ZipEntry(i+".xls"));wb.write(out);}out.close();} catch (Exception e) {e.printStackTrace();throw new highsoft.framework.exceptions.BaseRunException("导出excel出错！", e);} finally {if (dbTool != null) {dbTool.closeConnection();dbTool = null;}if(null != out){      try{      out.flush();      out.close();      out = null;      }      catch(IOException e){}; }}return downloadUrl;}/**  * 遍历目录并添加文件.  * @param jos - JAR 输出流  * @param file - 目录文件名  * @param pathName - ZIP中的目录名  * @throws IOException  * @throws FileNotFoundException  */ private static void recurseFiles(ZipOutputStream jos, File file,String pathName) throws IOException, FileNotFoundException {byte buf[] = new byte[1024];if (file.isDirectory()) {pathName = pathName + file.getName() + "/";jos.putNextEntry(new ZipEntry(pathName));String fileNames[] = file.list();if (fileNames != null) {for (int i = 0; i < fileNames.length; i++)recurseFiles(jos, new File(file, fileNames[i]), pathName);}} else {ZipEntry jarEntry = new ZipEntry(pathName + file.getName());// System.out.println(pathName + " " + file.getName());FileInputStream fin = new FileInputStream(file);BufferedInputStream in = new BufferedInputStream(fin);jos.putNextEntry(jarEntry);int len;while ((len = in.read(buf)) >= 0)jos.write(buf, 0, len);in.close();jos.closeEntry();}}  /** * 创建 ZIP/JAR 文件. *  * @param directory - *            要添加的目录 * @param zipFile - *            保存的 ZIP 文件名 * @param zipFolderName - *            ZIP 中的路径名 * @param level - *            压缩级别(0~9) * @throws IOException * @throws FileNotFoundException */ public static void makeDirectoryToZip(File directory, File zipFile,String zipFolderName, int level) throws IOException,FileNotFoundException {level = (level < 0 || level > 9)? 7 : level;if (zipFolderName == null) {zipFolderName = "";}ZipOutputStream jos = new ZipOutputStream(new FileOutputStream(zipFile));jos.setLevel(level);String fileNames[] = directory.list();if (fileNames != null) {for (int i = 0; i < fileNames.length; i++)recurseFiles(jos, new File(directory, fileNames[i]),zipFolderName);}jos.close();}