分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;
}
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;
}