`

struts2 导出cvs文件

 
阅读更多
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();

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics