ITeye博客

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

thinkact · 2008-12-25 10:56 · Java · Markdown

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

评论(0)

暂无评论。

评论功能维护中,当前仅展示历史评论。