导出CSV数据中文乱码和文件名乱码

最新推荐文章于 2024-04-12 15:47:42 发布

空闻大师

最新推荐文章于 2024-04-12 15:47:42 发布

阅读量2.2k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/lirui874125/article/details/9117983

版权

java 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

 public void exportKeyWords(HttpServletRequest request,HttpServletResponse response) {
        try {
            PrintWriter out = null;
            response.setContentType("text/html");

            //设置编码格式为gbk

            response.setCharacterEncoding("GBK");
            Integer userId=Integer.parseInt(request.getParameter("userID"));
            boolean isMultipart = ServletFileUpload.isMultipartContent(request);
            SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
            List<Object[]> objs = new ArrayList<Object[]>();
                objs.add(new Object[]{"关键字ID","关键字","URL"});
                IdentityService identityService = (IdentityService)super.appContext.getBean("identityService");

                List values=identityService.exportKeyWords(userId);
                for (int i=0;i<values.size();i++){
                    Map map = (Map) values.get(i);
                   objs.add(new Object[] {map.get("keyID").toString(),map.get("keyword").toString(),map.get("url").toString()});
                }
            if (objs != null && objs.size() != 0) {
                response.setContentType("application/csv;charset=GBK");

                 //文件名转换

                String keys=new String("关键字".getBytes("GBK"), "ISO8859-1" );
                response.setHeader("Content-Disposition","inline; filename="+keys+"("+simpleDateFormat.format(new Date())+").csv");
                try {
                    out = response.getWriter();
                    StringBuffer sb = new StringBuffer();
                    boolean isrow = true;
                    for (Object[] orders : objs) {
                        for (Object str : orders) {
                            if (!isrow) {
                                sb.append(",");
                            }
                            sb.append(str == null || str.equals(0) ? "" : str);
                            isrow = false;
                        }
                        isrow = true;
                        sb.append("\n");
                    }
                    out.write(sb.toString());
                    out.flush();
                } catch (Exception e) {
                } finally {
                    out.close();
                }
            }

        } catch (Exception e) {
            e.printStackTrace();
            try {
                response.getWriter().write(
                        "{success:false,msg:'" + e.getMessage() + "!'}");
            } catch (IOException e1) {
                e1.printStackTrace();
            }
        }
    }