Struts2中CSV文件的导出
public String downCSVFile(){ List<Orders> ordersList= this.ordersDAO.findAllOrders( this.companyCode, this.dateFrom, this.dateTo ); HttpServletResponse response = ServletActionContext.getResponse(); PrintWriter out; if( ordersList != null && ordersList.size() > 0 ){ try { response.setContentType("application/csv"); response.setHeader("Content-Disposition", "inline; filename=result.csv"); out = new PrintWriter(new OutputStreamWriter(response.getOutputStream(), "UTF-8")); for( Orders orders : ordersList ){ StringBuffer sb = ordersConvertToStringBuffer(orders); out.print(sb); } out.flush(); out.close(); } catch (UnsupportedEncodingException e) { // TODO Auto-generated catch block e.printStackTrace(); } catch (IOException e) { // TODO Auto-generated catch block e.printStackTrace(); } } return null; }
这是最关健的代码:
HttpServletResponse response = ServletActionContext.getResponse(); PrintWriter out; response.setContentType("application/csv"); response.setHeader("Content-Disposition", "inline; filename=result.csv"); out = new PrintWriter(new OutputStreamWriter(response.getOutputStream(), "UTF-8")); out.print(sb); out.flush(); out.close();
浙公网安备 33010602011771号