jsp 导出成CSV文件,中文乱码问题!
格式是UTF-8,
用editplus打正常,但是excel打就是了!!
怎么解?
- Java code
os = response.getOutputStream(); String title = "送,,,接收,息,接收,接收"+"\r\n"; os.write(title.getBytes("UTF-8")); QueryBean qb = (QueryBean) request .getAttribute(GlobalConstNaming.QUERY_BEAN_NAME); ResultBean resultBean = null; resultBean=statReportMag.thrdinfo(qb,jobid,date); List result = (List)resultBean.getTotalResult(); for(int i=0;i<result.size();i++) { StatSendthrdbean bean = (StatSendthrdbean)result.get(i); String s = bean.getJobid(); s = s + ","; s = s + bean.getDate(); s = s + ","; s = s + (bean.getContent()==null?" ":bean.getContent()); s = s + ","; s = s + (bean.getRecvmobile()==null? " " : bean.getRecvmobile()); s = s + ","; s = s + (bean.getMsgid()==null ? " " : bean.getMsgid()); s = s + ","; s = s + (bean.getRecvdate()==null? " " : bean.getRecvdate()); s = s + ","; s = s + (bean.getStatus()==null ? " " : bean.getStatus()); s = s + "\r\n"; os.write(s.getBytes("UTF-8")); }
奸