Java代码打包多份Excel生成Zip文档进行下载

向右看齐 2022-01-06 04:49 942阅读 0赞

我们开发过程中会遇到需要下载多份Excel文件的情况,我们实现一份份下载是没有任何问题的,但是要同时实现多份下载的时候其实也可以,分别给与不同的下载按钮和请求方法也能实现,但是如果有几百个按钮就不现实了,所以再按照之前的方法区实现就实现不了了,那么我们可以转换思维,将这一份或者多份的Excel,Word的文档,先放置在一个临时目录中,我们将该临时目录打包成Zip文档进行下载即可!  
**需求如下(可多选,单选,每次以Zip的形式下载):**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpaHVhaXlhbg_size_16_color_FFFFFF_t_70]

Java代码

/**
         * 导出账单---20190610版后(以压缩文件向浏览器发起下载请求)
         *
         * @param checkedId 账单类型 1:总账单表,2:财务报表,3:中通对账表
         * @param phone     手机号
         * @param siteCode  网点编号
         * @param month     账单月份
         * @param packageId 套餐ID
         * @author huaiyan
         */
        @RequestMapping(value = EXPORT_PHONE_BILLS, method = {RequestMethod.GET, RequestMethod.POST})
        public void downMoreExcelToZip(String checkedId, String phone, String siteCode, String month, Integer packageId) {
            try {
                //1:总账单表,2:财务报表,3:中通对账表
                String useName = getLoginUser().getUsername();
                logger.info("PhoneBillController.downExcel info={}", useName + "开始请求导出账单...");
                String thisMonth = month + "-01 00:00:00";
    
                String fileName;
                //创建临时存储目录,例如今天是:2019-06-08 那么临时目录就是 D://data//geenk//0608//2019
    //            String path = SettingHelper.getSettingVal(SystemSettingEnums.ZIP_PATH, String.class) + "\\" + new SimpleDateFormat("MMdd\\yyyy\\").format(new Date());
                String path = SettingHelper.getSettingVal(SystemSettingEnums.ZIP_PATH, String.class) + "/" + "bill" + "/";
                //声明一个集合，用来存放多个Excel文件路径及名称
                logger.info("PhoneBillController.downExcel info={}", "创建临时目录:" + path);
                List<File> srcFile = new ArrayList<>();
                // 得到路径下的文件，如果不存在创建文件夹
                File file = new File(path);
                if (!file.exists()) {
                    boolean mkdir = file.mkdirs();
                    if (!mkdir) {
                        logger.info("PhoneBillController.downExcel info={}", "创建(临时目录)文件夹失败...");
                        logger.info("PhoneBillController.downExcel info={}", "导出账单方法被动结束...");
                        return;
                    }
                }
                //对账单类型进行处理...
                List<Integer> toListInt = CheckBoxUtils.stringToListInt(checkedId);
                final boolean flag = null != toListInt && toListInt.size() > 0;
                if (flag) {
                    int size = toListInt.size();
                    logger.info("PhoneBillController.downExcel info={}", "本次请求需要导出的账单类型有:" + toListInt.toString() + "(1:总账单表,2:财务报表,3:中通对账表)");
                    for (int i = 0; i < size; i++) {
                        Integer UsingID = toListInt.get(i);
                        //说明是总账单表(总数据)
                        if (UserExChangStatusEnums.STAYCHECK.getValue() == UsingID) {
                            logger.info("PhoneBillController.downExcel info={}", useName + ":开始查询总账单表数据...");
                            //说明是总账单表(总数据)
                            fileName = month + "总账单表";
                            List<Map<String, Object>> list = phoneBillService.queryTotalPhoneBills(null, thisMonth, phone, null, null, null, null);
                            final boolean flags = null != list && list.size() > 0;
                            if (flags) {
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "本次对总账单查询数据共有:" + list.size() + "条!");
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "开始对数据进行正常显示处理....");
    
                                for (Map<String, Object> map : list) {
                                    //对数据进行处理
                                    Integer isSee = (Integer) map.get("is_see");
                                    //前台是否可见: is_see
                                    if (StringUtil.isEmpty(isSee)) {
                                        map.put("is_see", "暂未开通");
                                        continue;
                                    }
                                    if (UserExChangStatusEnums.STAYUPLOAD.getValue() == isSee) {
                                        map.put("is_see", "否");
                                        continue;
                                    } else if (UserExChangStatusEnums.STAYCHECK.getValue() == isSee) {
                                        map.put("is_see", "是");
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "对前台是否可见处理完毕....");
    
                                for (Map<String, Object> map : list) {
                                    //手机号状态: status
                                    Integer status = (Integer) map.get("status");
                                    if (StringUtil.isEmpty(status)) {
                                        map.put("status", "未知");
                                        continue;
                                    } else if (UserExChangStatusEnums.STAYUPLOAD.getValue() == status) {
                                        map.put("status", "流通中");
                                        continue;
                                    } else if (UserExChangStatusEnums.STAYCHECK.getValue() == status) {
                                        map.put("status", "已下单");
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "对手机号的状态显示处理完毕...");
    
                                for (Map<String, Object> map : list) {
                                    Integer isBreaks = (Integer) map.get("is_breaks");
                                    if (StringUtil.isEmpty(isBreaks) || UserExChangStatusEnums.STAYUPLOAD.getValue() == isBreaks) {
                                        map.put("is_breaks", "否");
                                        continue;
                                    } else if (UserExChangStatusEnums.STAYCHECK.getValue() == isBreaks) {
                                        map.put("is_breaks", "是");
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "是否以旧换新显示处理完毕...");
    
                                for (Map<String, Object> map : list) {
                                    Object equipmentInvoice = map.get("equipment_invoice");
                                    if (!StringUtil.isEmpty(equipmentInvoice) && (boolean) equipmentInvoice) {
                                        map.put("equipment_invoice", "已开");
                                        continue;
                                    }
                                    if (!StringUtil.isEmpty(equipmentInvoice) && !(boolean) equipmentInvoice) {
                                        map.put("equipment_invoice", "未开");
                                        continue;
                                    }
    
                                    if (StringUtil.isEmpty(equipmentInvoice)) {
                                        map.put("equipment_invoice", "字段为空");
                                        continue;
                                    }
    
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "开票状态显示处理完毕...");
    
                                for (Map<String, Object> map : list) {
                                    Integer billsType = (Integer) map.get("bills_type");
                                    if (!StringUtil.isEmpty(billsType) && UserExChangStatusEnums.ALREADYCKECK.getValue() == billsType) {
                                        map.put("bills_type", "支出");
                                        continue;
                                    } else {
                                        map.put("bills_type", "收入");
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "账单类型显示处理完毕...");
    
                                for (Map<String, Object> map : list) {
                                    if (StringUtil.isEmpty(map.get("contract_time"))) {
                                        map.put("contract_time", 0);
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "履约月数显示处理完毕...");
                                for (Map<String, Object> map : list) {
                                    if (StringUtil.isEmpty(map.get("flow_cost"))) {
                                        map.put("flow_cost", BigDecimal.ZERO);
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "流量费显示处理完毕...");
                                for (Map<String, Object> map : list) {
                                    if (StringUtil.isEmpty(map.get("out_call_num"))) {
                                        map.put("out_call_num", 0);
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "套餐外通话数显示处理完毕...");
                                for (Map<String, Object> map : list) {
                                    if (StringUtil.isEmpty(map.get("out_message_num"))) {
                                        map.put("out_message_num", 0);
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "套餐外短信数显示处理完毕...");
                                for (Map<String, Object> map : list) {
                                    if (StringUtil.isEmpty(map.get("out_flow_num"))) {
                                        map.put("out_flow_num", 0);
                                        continue;
                                    }
                                }
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "套餐外流量数显示处理完毕...");
    
                                for (Map<String, Object> map : list) {
                                    Object mon = map.get("month");
                                    if (!StringUtil.isEmpty(mon)) {
                                        Date date = (Date) mon;
                                        map.put("month", DateHelper.date(date, DateHelper.DATE_FORMAT_YEAR));
    
                                    }
                                    Object mobileStartTime = map.get("mobile_start_time");
                                    if (!StringUtil.isEmpty(mobileStartTime)) {
                                        Date mobileStartTime1 = (Date) mobileStartTime;
                                        map.put("mobile_start_time", DateHelper.date(mobileStartTime1, DateHelper.DATE_FORMAT_YEAR));
                                    }
                                    Object mobileEndTime = map.get("mobile_end_time");
                                    if (!StringUtil.isEmpty(mobileEndTime)) {
                                        Date mobileEndTime1 = (Date) mobileEndTime;
                                        map.put("mobile_end_time", DateHelper.date(mobileEndTime1, DateHelper.DATE_FORMAT_YEAR));
                                    }
                                    Object importTime = map.get("import_time");
                                    if (!StringUtil.isEmpty(importTime)) {
                                        Date importTime1 = (Date) importTime;
                                        map.put("import_time", DateHelper.date(importTime1, DateHelper.DEFAULT_DATE_FORMAT));
                                    }
                                    Object ztoStartTime = map.get("zto_start_time");
                                    if (!StringUtil.isEmpty(ztoStartTime)) {
                                        Date ztoStartTime1 = (Date) ztoStartTime;
                                        map.put("zto_start_time", DateHelper.date(ztoStartTime1, DateHelper.DATE_FORMAT_YEAR));
                                    }
                                    Object ztoEndTime = map.get("zto_end_time");
                                    if (!StringUtil.isEmpty(ztoEndTime)) {
                                        Date ztoEndTime1 = (Date) ztoEndTime;
                                        map.put("zto_end_time", DateHelper.date(ztoEndTime1, DateHelper.DATE_FORMAT_YEAR));
                                    }
    //                                Object exchangOpenTime = map.get("exchang_open_time");
    //                                if (!StringUtil.isEmpty(exchangOpenTime)) {
    //                                    Date exchangOpenTime1 = (Date) exchangOpenTime;
    //                                    map.put("exchang_open_time", DateHelper.date(exchangOpenTime1, DateHelper.DEFAULT_DATE_FORMAT));
    //
    //                                }
                                    Object posTime = map.get("pos_time");
                                    if (!StringUtil.isEmpty(posTime)) {
                                        Date posTime1 = (Date) posTime;
                                        map.put("pos_time", DateHelper.date(posTime1, DateHelper.DEFAULT_DATE_FORMAT));
                                    }
    
                                    Object updateTime = map.get("update_time");
                                    if (!StringUtil.isEmpty(updateTime)) {
                                        Date updateTime1 = (Date) updateTime;
                                        map.put("update_time", DateHelper.date(updateTime1, DateHelper.DEFAULT_DATE_FORMAT));
                                    }
                                    Object openT = map.get("open_time");
                                    if (!StringUtil.isEmpty(openT)) {
                                        Date openTime = (Date) openT;
                                        map.put("open_time", DateHelper.date(openTime, DateHelper.DEFAULT_DATE_FORMAT));
                                    }
                                    Object exchangeTi = map.get("orl_change_new_time");
                                    if (!StringUtil.isEmpty(exchangeTi)) {
                                        Date exchangeTime = (Date) exchangeTi;
                                        map.put("orl_change_new_time", DateHelper.date(exchangeTime, DateHelper.DEFAULT_DATE_FORMAT));
                                    }
                                }
                            } else {
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "本次对总账单查询不到符合要求的数据...");
                            }
                            logger.info("PhoneBillController.downMoreExcelToZip info={}", "将处理好的数据转存为Excel文件...");
                            //总账单数据列名
                            String[] columnsName = {"网点名称", "网点编号", "手机号", "实名人姓名", "省份", "城市", "所属", "运营商", "开户商", "合约期", "账单月份", "履约月数", "以旧换新时间", "换的原号开户时间", "开户时间", "POS券时间",
                                    "移动合约开始", "移动合约结束", "中通履约开始时间", "中通履约结束时间", "移动合约月资费", "移动月实际资费", "套餐外通话数", "通话费", "套餐外短信数", "短信费", "套餐外流量数", "流量费",
                                    "套餐外其他说明", "其他费用", "小计", "移动合计", "商品合约套餐名", "商品合约金额", "商品合约实际月资费", "小号收费", "极客合计", "余额", "调账", "本月结余", "极客本月应收",
                                    "备注", "硬件费", "电信费", "开票状态", "极客账户余额", "运营商本月应收"};
                            //总账单数据map中的key
                            String[] keys = {"site_name", "site_code", "phone_number", "real_name", "province", "city", "company", "operators", "open_account", "contract", "month", "contract_time", "orl_change_new_time", "open_time_before", "open_time", "pos_time",
                                    "mobile_start_time", "mobile_end_time", "zto_start_time", "zto_end_time", "mobile_contract_fee", "mobile_actual_fee", "out_call_num", "call_cost", "out_message_num", "message_cost", "out_flow_num", "flow_cost",
                                    "out_other_num", "other_cost", "small_plan", "total_fee", "goods_package", "package_amount", "actual_package_amount", "geenk_small_fee", "geenk_total_fee", "balance", "modify_amount", "balance_this_month", "deal_this_month",
                                    "notes", "equipment_fee", "telecom_fee", "equipment_invoice", "mobile_balance", "mobile_current_deal"};
    
    
                            if (exchangSaveFile(fileName, path, srcFile, list, columnsName, keys)) {
                                logger.info("PhoneBillController.downExcel info={}", "数据正常转存为:" + fileName + ".xls");
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "总数据报表导出账单方法执行结束....");
                                continue;
                            }
                        }
                        //说明是财务报表--麻烦
                        if (UserExChangStatusEnums.ALREADYCKECK.getValue() == toListInt.get(i)) {
                            logger.info("PhoneBillController.downExcel info={}", useName + ":请求导出财务报表...");
                            //说明是财务报表
                            fileName = month + "财务报表";
                            logger.info("PhoneBillController.downMoreExcelToZip info={}", "开始查询财务报表详细数据一...");
                            List<Map<String, Object>> financeList = phoneBillService.queryFinanceSum(THIS_OPEN_TIME, THAT_OPEN_TIME, EQUIPMENT_FEE,
                                    DOUBLE_OPEN_TIME, thisMonth, phone, siteCode, packageId);
                            final boolean sta = null != financeList && financeList.size() > 0;
                            if (sta) {
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "财务详细表共查询出:" + financeList.size() + "条数据!");
                            } else {
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "财务详细表查询不到数据...");
                            }
                            logger.info("PhoneBillController.downMoreExcelToZip info={}", "对财务详细表进行数据生成sheet1...");
                            //列名
                            String[] columnName = {"网点编号", "网点名称", "手机号", "上期优惠剩余", "应收总费用", "类别", "硬件费", "开票说明",
                                    "当月电信费用额", "应收中通", "优惠剩余", "备注"};
                            //map中的key
                            String[] key = {"site_code", "site_name", "phone_number", "balance", "geenk_total_fee", "category", "equipment_fee", "open_invoice",
                                    "telecom_fee", "deal_this_month", "balance_this_month", "notes"};
    
                            for (Map<String, Object> map : financeList) {
                                if (StringUtil.isEmpty(map.get("balance"))) {
                                    map.put("balance", BigDecimal.ZERO);
                                }
                                if (StringUtil.isEmpty(map.get("equipment_fee"))) {
                                    map.put("equipment_fee", BigDecimal.ZERO);
                                }
                                if (StringUtil.isEmpty(map.get("telecom_fee"))) {
                                    map.put("telecom_fee", BigDecimal.ZERO);
                                }
                                if (StringUtil.isEmpty(map.get("balance_this_month"))) {
                                    map.put("balance_this_month", BigDecimal.ZERO);
                                }
                            }
                            Workbook workBook = ExcelUtil.createWorkBook(financeList, key, columnName);
                            logger.info("PhoneBillController.downMoreExcelToZip info={}", "开始对财务详细表进行总数据生成sheet2...");
                            List<Map<String, Object>> mapList = phoneBillService.queryAllSell(thisMonth);
                            Map<String, Object> map = mapList.get(0);
                            String example = month + " 账单说明文档(仅供参考)";
                            InputStream inputStream = null;
                            ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
                            if (StringUtil.isEmpty(map)) {
                                String[] col = {"全部数量", "历史数量", "新开户数量", "本月总费用", "上期余额", "本月结余", "本月应收", "开票24个月数量", "开票24个月数量总金额", "开票22个月数量", "开票22个月数量总金额", "硬件票金额", "电信票金额"};
                                String[] keyY = {"byMonth", "billsByMonth", "newByMonth", "geenk_total_fee", "balance", "balance_this_month", "deal_this_month", "24num", "24fee", "22num", "22fee", "equipment_fee", "telecom_fee"};
                                ExcelUtil.insertMoreSheet(workBook, "账单详细表", "账单总表", keyY, col, mapList).write(outputStream);
                            } else {
                                //自己创建的财务说明模板
                                ExcelUtil.financeWorkBook(workBook, "财务详细报表", "财务总表说明", map, example).write(outputStream);
                            }
                            outputStream.flush();
                            byte[] outPut = outputStream.toByteArray();
                            int length = outPut.length;
                            inputStream = new ByteArrayInputStream(outPut, 0, length);
                            ZipUtils.execute(path + "\\" + fileName + ".xls", inputStream);
                            //将文件放进list
                            srcFile.add(new File(path + "\\" + fileName + ".xls"));
                            logger.info("PhoneBillController.downMoreExcelToZip info={}", "财务报表导出账单方法执行结束....");
                            continue;
                        }
    
                        if (UserExChangStatusEnums.ALREADYACCEPT.getValue() == toListInt.get(i)) {
                            logger.info("PhoneBillController.downExcel info={}", useName + ":开始导出中通对账表...");
                            //说明是中通对账表
                            fileName = month + "中通对账表";
                            List<Map<String, Object>> ztoList = phoneBillService.queryZtoFinance(thisMonth, phone, null);
                            //列名
                            String[] column = {"网点编号", "网点名称", "手机号", "实名人", "开户时间", "合约剩余时间/月", "套餐规格", "极客实际月费", "通话费", "短信费", "流量费", "其他费用",
                                    "小计", "小号费", "合计", "余额", "调账", "本月结余", "本月应付", "备注"};
                            //map中的key
                            String[] key = {"site_code", "site_name", "phone_number", "real_name", "open_time", "leftTime", "market_price", "actual_package_amount", "call_cost", "message_cost", "flow_cost", "other_cost",
                                    "small_plan", "geenk_small_fee", "geenk_total_fee", "balance", "modify_amount", "balance_this_month", "deal_this_month", "note"};
    
                            logger.info("PhoneBillController.downMoreExcelToZip info={}", "开始处理中通对账数据...");
                            for (Map<String, Object> map : ztoList) {
                                Object openTime = map.get("open_time");
                                if (!StringUtil.isEmpty(openTime)) {
                                    Date openTime1 = (Date) openTime;
                                    map.put("open_time", DateHelper.date(openTime1, DateHelper.DEFAULT_DATE_FORMAT));
                                }
    
                            }
                            if (exchangSaveFile(fileName, path, srcFile, ztoList, column, key)) {
                                logger.info("PhoneBillController.downExcel info={}", "数据正常转存为:中通对账表.xls文件正常");
                                logger.info("PhoneBillController.downMoreExcelToZip info={}", "中通导出账单方法执行结束....");
                                continue;
                            }
                            if (exchangSaveFile(fileName, path, srcFile, ztoList, column, key)) {
                                logger.info("PhoneBillController.downExcel info={}", "数据正常转存为:中通对账表.xls文件正常");
                                continue;
                            }
    
                        }
    
                    }
    
                }
                // 将服务器上存放Excel的文件夹打成zip包
                File zipFile = new File(path + month + "账单" + "PreWork.zip");
                // 实现将多个excel打包成zip文件
                ZipUtils.zipFiles(srcFile, zipFile);
                //下载
                //实现将压缩包写入流中，下载到本地，并删除临时文件中的压缩包及文件
                ZipUtils.downFile(response, path, month + "账单" + "PreWork.zip");
                logger.info("PhoneBillController.downMoreExcelToZip info={}", "账单已按条件查询并成功导出....");
    
            } catch (Exception e) {
                logger.error(e.getMessage(), e);
                logger.info("PhoneBillController.downMoreExcelToZip info={}", "导出账单发送异常...");
            }
        }
     /**
         * 获取当前时间的上个月月份
         */
        public String getLastMonth() throws Exception {
            Date date = new Date();
            Calendar c = Calendar.getInstance();
            c.setTime(date);
            c.add(Calendar.MONTH, -1);
            String lastDate = c.get(Calendar.YEAR) + "-" + (c.get(Calendar.MONTH) + 1);
            return lastDate;
        }
    
        /**
         * 获取传入月份的下一个月
         */
        public String getNextMonth(String date) throws Exception {
            DateFormat df = new SimpleDateFormat("yyyy-MM");
            Calendar ct = Calendar.getInstance();
            ct.setTime(df.parse(date));
            ct.add(Calendar.MONTH, +1);
            return df.format(ct.getTime());
        }
    
        /**
         * 将数据写入到Excel中
         *
         * @param fileName   文件名
         * @param path       文件所在路径
         * @param srcFile    压缩文件
         * @param list       数据
         * @param columnName 列名
         * @param key        对应的列名的KEY
         * @return
         * @author huaiyan
         */
        private boolean exchangSaveFile(String fileName, String path, List<File> srcFile, List<Map<String, Object>> list, String[] columnName, String[] key) {
            try {
    
                InputStream inputStream = null;
                ByteArrayOutputStream outputStream = new ByteArrayOutputStream();
                ExcelUtil.createWorkBook(list, key, columnName).write(outputStream);
                outputStream.flush();
                byte[] outPut = outputStream.toByteArray();
                int length = outPut.length;
                inputStream = new ByteArrayInputStream(outPut, 0, length);
                ZipUtils.execute(path + "/" + fileName + ".xls", inputStream);
                //将文件放进list
                srcFile.add(new File(path + "/" + fileName + ".xls"));
                return true;
    
            } catch (IOException e) {
                e.printStackTrace();
            }
            return false;
        }

工具类

package com.geenk.market.common.util;
    
    
    import org.slf4j.Logger;
    import org.slf4j.LoggerFactory;
    
    import javax.servlet.http.HttpServletResponse;
    import java.io.*;
    import java.net.URLEncoder;
    import java.util.List;
    import java.util.zip.ZipEntry;
    import java.util.zip.ZipOutputStream;
    
    /**
     * @author huaiyan
     * @Description 将一份或者多份Excel打包成ZIP向浏览器发送下载请求
     * @create 2019-06-06 16:37
     * @Copyright 该版权归属于杭州极客科技有限公司所有, 未经允许不得用于任何商业用途, 违者将承担法律责任!
     */
    
    public class ZipUtils {
    
        public static final Logger logger = LoggerFactory.getLogger(ZipUtils.class);
    
        /**
         * 将多个Excel打包成zip文件
         *
         * @param srcFile 该路径下的所有需要打成Zip的文件
         * @param zipFile 压缩的Zip文件
         * @author huaiyan
         */
        public static void zipFiles(List<File> srcFile, File zipFile) {
            byte[] buf = new byte[1024];
            try {
                // 创建压缩文件 Create the ZIP file
                ZipOutputStream out = new ZipOutputStream(new FileOutputStream(zipFile));
                // 打包该文件夹下的所有文件 Compress the files
                int size = srcFile.size();
                logger.info("ZipUtils.zipFiles info={}","该临时目录下共有:"+size+"文件!");
                int num =1;
                for (int i = 0; i < size; i++) {
                    logger.info("ZipUtils.zipFiles info={}","开始压缩第:"+num+"文件...");
                    File file = srcFile.get(i);
                    FileInputStream in = new FileInputStream(file);
                    // 将Zip文件添加到输出流中 Add ZIP entry to output stream.
                    out.putNextEntry(new ZipEntry(file.getName()));
                    // 将输出流安装字节流的形式读取到Zip压缩文件中 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();
                    num++;
                }
                logger.info("ZipUtils.zipFiles info={}","第"+size+"个文件压缩成功..全部文件压缩完成!");
                // Complete the ZIP file
                out.close();
            } catch (IOException e) {
                logger.info("ZipUtils.zipFiles info={}","压缩文件出现异常...");
                logger.error(e.getMessage(), e);
            }
        }
    
        /**
         * 将数据流写入到文件中
         *
         * @param filename    为单个excel的路径和excel的名称，
         * @param inputStream inputStream就是获取的list数据流
         * @return
         * @author huaiyan
         */
        public static int execute(String filename, InputStream inputStream) {
            logger.info("ZipUtils.execute info={}","开始进行数据解析(转存数据流到文件中)...");
            int success = 1;
            FileOutputStream outStream = null;
            try {
                File blobFile = new File(filename);
                outStream = new FileOutputStream(blobFile);
                byte[] buffer = new byte[2048];
                while ((inputStream.read(buffer)) != -1) {
                    outStream.write(buffer);
                }
                outStream.flush();
            } catch (Exception e) {
                logger.error(e.getMessage(), e);
                success = 0;
            } finally {
                if (outStream != null) {
                    try {
                        outStream.close();
                    } catch (IOException e) {
                        e.printStackTrace();
                    }
                }
                logger.info("ZipUtils.execute info={}","解析数据(数据转成文件)完成...");
                return success;
            }
        }
    
        /**
         * 删除目录下所有的文件;
         *
         * @param file 服务器目录地址 例如:
         * @author huaiyan
         */
        public static boolean deleteExcelPath(File file) {
            logger.info("ZipUtils.deleteExcelPath info={}","开始删除临时目录中的文件...");
            if (file.isDirectory()) {
                logger.info("ZipUtils.deleteExcelPath info={}","该文件属于文件夹,优先删除文件夹下的文件");
                String[] children = file.list();
                int length = children.length;
                //递归删除目录中的子目录下
                int number= 1;
                for (int i = 0; i < length; i++) {
                    boolean success = deleteExcelPath(new File(file, children[i]));
                    if (!success) {
                        return false;
                    }
                    System.out.println("临时目录及文件删除成功...");
                    logger.info("ZipUtils.deleteExcelPath info={}","删除第"+number+"文件");
                    number++;
                }
            }
            // 目录此时为空，可以删除
            return file.delete();
    
    //        String[] files = null;
    //        if (file != null) {
    //            files = file.list();
    //        }
    //
    //        if (file.isDirectory()) {
    //            for (int i = 0; i < files.length; i++) {
    //                boolean flag = deleteExcelPath(new File(file, files[i]));
    //                if (flag) {
    //                    System.out.println("删除成功!");
    //                } else {
    //                    System.out.println("删除失败!");
    //                }
    //            }
    //        }
    //        return file.delete();
        }
    
    
        /**
         *  将Zip文件向浏览器发起是否下载请求
         * @param response 响应
         * @param serverPath 服务器路径
         * @param str Zip文件名
         * @author huaiyan
         */
        public static void downFile(HttpServletResponse response, String serverPath, String str) {
    
            try {
    
                String path = serverPath +"//"+ str;
                logger.info("ZipUtils.downFile info={}","临时文件目录为:"+path);
                File file = new File(path);
                logger.info("ZipUtils.downFile info={}","判断file.exists():"+true+"的话,将发起下载请求...");
                if (file.exists()) {
                    logger.info("ZipUtils.downFile info={}","开始向浏览器发起下载请求...");
                    InputStream ins = new FileInputStream(path);
                    // 放到缓冲流里面
                    BufferedInputStream bins = new BufferedInputStream(ins);
                    // 获取文件输出IO流
                    OutputStream outs = response.getOutputStream();
                    BufferedOutputStream bouts = new BufferedOutputStream(outs);
                    // 设置response内容的类型
                    response.setContentType("application/octet-stream");
                    // 设置头部信息
                    response.setHeader(
                            "Content-disposition",
                            "attachment;filename="
                                    + URLEncoder.encode(str, "UTF-8"));
                    int bytesRead = 0;
                    byte[] buffer = new byte[1024];
                    //开始向网络传输文件流
                    while ((bytesRead = bins.read(buffer)) != -1) {
                        bouts.write(buffer);
    
                    }
                    // 这里一定要调用flush()方法
                    bouts.flush();
                    response.flushBuffer();
                    ins.close();
                    bins.close();
                    outs.close();
                    bouts.close();
                } else {
                    logger.info("ZipUtils.downFile info={}","判断file.exists():"+false);
                    response.sendRedirect("/admin/login");
                }
            } catch (IOException e) {
                logger.info("ZipUtils.downFile info={}","向浏览器发起下载请求异常...");
                logger.error(e.getMessage(), e);
            } finally {
                logger.info("ZipUtils.downFile info={}","下载请求发出以后,执行删除临时目录及文件...");
                File files = new File(serverPath);
                //删除临时目录
                deleteExcelPath(files);
                logger.info("ZipUtils.downFile info={}","临时目录删除功能结束!");
            }
        }
    
    
        public static void main(String[] args) {
    //        String path = "D:\\data\\geenk/2019/0606/PreWork.zip";
    //        path = path.replaceAll("\\\\", "/");
            File file = new File("D:/data/geenk/2019/0606/PreWork.zip");
            System.out.println(file.getName());
    
        }
    }

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3lpaHVhaXlhbg_size_16_color_FFFFFF_t_70]: /images/20211228/0606d02745384b8b8ace40e5faa41152.png