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();

 

 

posted @ 2012-12-07 17:07  软件小书童  阅读(501)  评论(0)    收藏  举报