关于导出zip（压缩包）文件，内含有二个子文件，一个是普通的字符串string转xml文件，另一个是excel文件,springboot.代码实现。

关于导出zip（压缩包）文件，内含有二个子文件，一个是普通的字符串string转xml文件，另一个是excel文件,springboot.代码实现。

需求：导出一个共享文档校验结果.zip压缩包，里面有二个子文件，一个是xml文件，一个是excel的xls文件。前者的xml文件简单直接内容string转字节输出流生成一个后缀为xml的子文件流，后者的excel文件则需要将excel文件的字节流转为一个子文件流。

核心代码

     //进行导出下载String zipName = "共享文档校验结果" + Instance().dateToStr(new Date(), CommonConstant.YYYYMMDDHHMMSS) + ".zip";setAttachmentResponseHeader(response, zipName);try(ZipOutputStream out = new OutputStream())){for (BatchExportZipDTO batchExportZipDTO : batchExportZipDTOS) {//导出校验IcQvVerifyXml(), out);//导出校验结果IcQvVerifyDetailVOS(), IcQvVerifyVO(), out);}}catch(Exception e){("共享文档批量导出失败：{}",  ExceptionMessage(e));throw e;}public static void setAttachmentResponseHeader(HttpServletResponse response, String realFileName) throws UnsupportedEncodingException {String percentEncodedFileName = percentEncode(realFileName);StringBuilder contentDispositionValue = new StringBuilder();contentDispositionValue.append("attachment; filename=").append(percentEncodedFileName).append(";").append("filename*=").append("utf-8''").append(percentEncodedFileName);response.setHeader("Content-disposition", String());}public static String percentEncode(String s) throws UnsupportedEncodingException {String encode = de(s, StandardCharsets.String());placeAll("\+", "%20");}

下面的二个方法是对response消息头的处理，将定义的zip名称放入response中

再将处理后的response转为ZipOutputStream输出流out，再通过下面的二个方法在out其中存入二个子目录。

downloadVerifyCdaXml：这个方法也是定义了一个子文件的名称，然后将子名称放入ZipEntryzip条目中，再将条目放入out流中，再往out中写入东西。

    /*** 导出校验Xml* @param icQvVerifyXml icQvVerifyXml* @param out out* @throws Exception Exception*/private void downloadVerifyCdaXml(ICQvVerifyXml icQvVerifyXml, ZipOutputStream out) throws Exception{if (icQvVerifyXml != null){if (StringUtils.VerifyXmlData())){//组装文件名String fileName = VerifyXmlName() + "." + VerifyXmlSuffix();ZipEntry entry = new ZipEntry(fileName);out.putNextEntry(entry);try (InputStream ins = new VerifyXmlData().getBytes(StandardCharsets.UTF_8));BufferedInputStream bis = new BufferedInputStream(ins)) {byte[] buffer = new byte[1024];int i = ad(buffer);while (i != -1) {out.write(buffer, 0, i);out.flush();i = ad(buffer);}}out.closeEntry();}}}

downloadVerifyDetails：最关键在于wb.write(outputStream);将生成的Workbook流写入out中，定于子目录名称什么的和上面一样。最终都是将流写入out中

    /*** 导出校验结果* @param icQvVerifyDetailVOS icQvVerifyDetailVOS* @param icQvVerifyVO icQvVerifyVO* @param out out* @throws Exception Exception*/private void downloadVerifyDetails(List<ICQvVerifyDetailVO> icQvVerifyDetailVOS, ICQvVerifyVO icQvVerifyVO, ZipOutputStream out) throws Exception{if (icQvVerifyDetailVOS.size() > 0){ZipEntry entry = new VerifyXmlName() + "-" + CdaNo() + ".xls");out.putNextEntry(entry);ICQvExcelUtils<ICQvVerifyDetailVO> excelUtil = new ICQvExcelUtils<ICQvVerifyDetailVO>(ICQvVerifyDetailVO.class);excelUtil.init(icQvVerifyDetailVOS, "校验结果列表", Excel.Type.EXPORT);portExcelNotCloseOut(out);out.closeEntry();}}

excelUtil.init是excel工具类的一个生成excel初始化的操作，下面的是手写的也继承excelUilt类的将wb写入out流的方法。

public class ICQvExcelUtils<T> extends ExcelUtil<T> {/*** 导出不关闭流* @param outputStream outputStream*/public void exportExcelNotCloseOut(OutputStream outputStream){try{// 取出一共有多少个sheet.double sheetNo = il(list.size() / sheetSize);for (int index = 0; index <= sheetNo; index++){createSheet(sheetNo, index);// 产生一行Row row = ateRow(0);int column = 0;// 写入各个字段的列头名称for (Object[] os : fields){Excel excel = (Excel) os[1];ateCell(excel, row, column++);}if (Excel.Type.EXPORT.equals(type)){fillExcelData(index, row);addStatisticsRow();}}wb.write(outputStream);}catch (Exception e){("导出Excel异常{}", e.getMessage());}finally{if (wb != null){try{wb.close();}catch (IOException e1){e1.printStackTrace();}}}}}