public class CSVUtil { /** * exportCSV * @param response * @param list 是装有字符串的 * @param csvName */ public static void exportCSV( HttpServletResponse response,List list,String csvName){ try{ response.reset(); response.setContentType("application/csv;charset=GBK"); response.setHeader("Content-Disposition", "inline; filename=\"" + toUtf8String(csvName) + ".csv" ); ServletOutputStream sos = response.getOutputStream(); for(int i=0;i<list.size();i++) { String str = (String)list.get(i); sos.println(str); } sos.close(); sos.flush(); }catch(Exception ex ){ ex.printStackTrace(); } } // toUtf8String()对中文进行转换 // 下载为中文名不会出现乱码 private static String toUtf8String(String s) { StringBuffer sb = new StringBuffer(); for (int i = 0; i < s.length(); i++) { char c = s.charAt(i); if (c >= 0 && c <= 255) { sb.append(c); } else { byte[] b; try { b = Character.toString(c).getBytes("utf-8"); } catch (Exception ex) { System.out.println(ex); b = new byte[0]; } for (int j = 0; j < b.length; j++) { int k = b[j]; if (k < 0) k += 256; sb.append("%" + Integer.toHexString(k).toUpperCase()); } } } return sb.toString(); }}
action中代码
public ActionForward csvDown(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) { String startTime = request.getParameter("startTimeLog") + " 00:00:00"; String endTime = request.getParameter("endTimeLog") + " 23:59:59"; SatLoginfoManager mgr = (SatLoginfoManager) getBean("satLoginfoManager"); List dataList = mgr.selectbytime(startTime, endTime); //csv信息设置 String csvName = "系统日志" + StringUtils.dateToString(new Date(),"yyyy-MM-dd"); List csvLsit = new ArrayList(); StringBuffer temp = new StringBuffer(); temp.append("\"操作人员\",\"时间\",\"事项名称\",\"申请人\",\"操作类型\",\"备注\""); csvLsit.add(temp.toString()); for(int i=0; i< dataList.size(); i++) { SatLoginfo satLoginfo = (SatLoginfo)dataList.get(i); temp.delete(0, temp.length()); temp.append("\"" + satLoginfo.getUserid() + "\","); temp.append("\"" + satLoginfo.getTime() + "\","); temp.append("\"" + satLoginfo.getItemname() + "\","); temp.append("\"" + NulltoSapce(satLoginfo.getOwner()) + "\","); temp.append("\"" + satLoginfo.getOpeatype() + "\","); temp.append("\"" + NulltoSapce(satLoginfo.getOther()) + "\""); csvLsit.add(temp.toString()); } CSVUtil.exportCSV(response,csvLsit,csvName); return null; } private String NulltoSapce(String str){ if(str == null) { str = ""; } return str; }
