下载文件中文乱码不同浏览器不同编码

/**
     * 运行参数下载
     *
     * @param xtbh     系统编号
     * @param response
     * @throws Exception
     */
    @Override
    public void exportCsxxExcel(String xtbh, HttpServletRequest request, HttpServletResponse response) throws Exception {
        ArrayList<Csxx> resultList = new ArrayList<>();
        //得请求头中的User-Agent
        String agent = request.getHeader("User-Agent");
        HashMap<String, Object> csflMap = new HashMap<>();
        logger.info("下载运行参数系统编号为 : " + xtbh);
        //todo 目前测试  固定的
        csflMap.put("xtbh", xtbh);
        csflMap.put("scbj", 0);
        List<Csfl> csflList = csflService.query(csflMap);
        if (csflList == null) {
            throw new RuntimeException("参数分类为空");
        }
        HashMap<String, Object> csxxMap = new HashMap<>();
        csxxMap.put("scbj", 0);
        List<Csxx> csxxList = csxxMapper.query(csxxMap);
        if (csxxList == null) {
            throw new RuntimeException("参数信息为空");
        }
        for (Csfl fl : csflList) {
            for (Csxx cs : csxxList) {
                if (fl.getBh().equals(cs.getCsflbh())) {
                    Csxx csxx = new Csxx();
                    csxx.setFlmc(fl.getFlmc());
                    csxx.setCsdm(cs.getCsdm());
                    csxx.setCsz(cs.getCsz());
                    csxx.setSm(cs.getSm());
                    resultList.add(csxx);
                }
            }
        }
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMdd");
        String date = dateFormat.format(new Date());
        String fileName = "运行参数" + date + ".xlsx";
        logger.info("文件名为 : " + fileName);
        ExportParams params = new ExportParams();
        params.setTitle("运行参数列表");
        params.setSheetName("运行参数sheet");
        Workbook workbook = ExcelExportUtil.exportExcel(params, Csxx.class, resultList);

        response.setCharacterEncoding("UTF-8");
        //response.setContentType("application/msexcel");
        logger.info("用户浏览器 : " + agent);

        // 根据不同的客户端进行不同的编码
        String filenameEncoder = "";
        if (agent.contains("MSIE")) {
            // IE浏览器
            filenameEncoder = URLEncoder.encode(fileName, "utf-8");
            filenameEncoder = filenameEncoder.replace("+", " ");
        } else if (agent.contains("Firefox")) {
            // 火狐浏览器
            BASE64Encoder base64Encoder = new BASE64Encoder();
            filenameEncoder = "=?utf-8?B?" + base64Encoder.encode(fileName.getBytes("utf-8")) + "?=";
        } else {
            // 其它浏览器
            filenameEncoder = URLEncoder.encode(fileName, "utf-8");
        }

        response.setHeader("content-disposition", "attachment;filename=" + URLEncoder.encode(fileName, "utf-8"));
        response.addHeader("Access-Control-Allow-Origin", "*");
        OutputStream out = null;
        try {
            //写出
            out = response.getOutputStream();
            workbook.write(out);
        } catch (Exception e) {
            logger.error("写入模板异常:", e);
        } finally {
            out.close();
        }

    }
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值