一个简单的导出CSV文件的方法

分3步：
1， 查找对象列表
2， 组织字符串
3， 输出文件

代码片段：

  //1， 查找对象列表
List callLogList = reportCallService.getCallLogList(fromDate, endDate);

//组织字符串,注意添加换行符
StringBuffer bf = new StringBuffer();

LocalCallLog cl = new LocalCallLog();
bf.append("Calllog ID").append(",").append("Src No").append(",")
.append("Dest No")
.append("\n");

for (Iterator it = callLogList.iterator(); it.hasNext();) {
cl = (LocalCallLog) it.next();
bf.append(cl.getCallLogId()).append(",").append(cl.getSrcNum())
.append(",").append(cl.getDestNum()).append("\n");
}
//输出文件
response.setContentType("application/x-download");

// String now = new SimpleDateFormat("h:mm a").format(new Date());
// now.replace(" ", "");
// String filenamedisplay = URLEncoder.encode("CallReport"+now
// +".csv","UTF-8");
String filenamedisplay = URLEncoder.encode("CallReport.csv", "UTF-8");
response.addHeader("Content-Disposition", "attachment;filename="
+ filenamedisplay);
PrintWriter pw = response.getWriter();
pw.write(bf.toString());

return null;
}

转载于:https://www.cnblogs.com/frankliiu-java/archive/2010/02/21/1670562.html