Java导出csv格式，百万数据

[尘同学]

我遇到的问题是：导出csv格式的报内存溢出错误，数据量小没问题，7万左右会出现问题，，看百度上说可以：导入csv格式的时候，写缓冲区什么的，可我不是很明白怎么写，没搜到想要的答案，所以想请大家帮忙了，谢谢了啊
下面是我的代码
public class ExportUtil {

/**
* 导出成CSV TXT resultData中每个是一行数据。
*
* @param out
* @param colTitleList
* 标题
* @param resultData
* 数据。
* @throws Exception
* String title,String[] rowName,List<Object[]> dataList
*/
public static void writeCSV(HttpServletResponse response, String title,
String[] colTitleList, List<Object[]> resultData) throws Exception {
System.out.println("writeCSV 方法进入 ");
DateFormat sdf2 = new SimpleDateFormat("yyyy-MM");
String dates = sdf2.format(new Date());
title = dates +title;

String downloadFileName = new String(title.getBytes("gbk"), "iso8859-1");
response.reset();
response.setHeader("Content-Disposition", "attachment;filename="
+ downloadFileName + ".csv");// 指定下载的文件名
response.setContentType("application/vnd.ms-excel");
response.setHeader("Pragma", "no-cache");
response.setHeader("Cache-Control", "no-cache");
response.setDateHeader("Expires", 0);
OutputStream output = response.getOutputStream();

if (resultData == null)
resultData = new ArrayList();
PrintWriter pw = null;
pw = new PrintWriter(new OutputStreamWriter(new BufferedOutputStream(
output, 1024), "GBK"));

if (colTitleList != null) {// 写标题
for (int i = 0; i < colTitleList.length; i++) {
String outValue = String.valueOf(colTitleList[i]);
pw.print(outValue);
if (i != colTitleList.length - 1)
pw.print(",");
}
pw.println();
}

for (int i = 0; i < resultData.size(); i++) {
/* ArrayList rowData = (ArrayList)resultData.get(i); */
Object[] rowData = resultData.get(i);// 遍历每个对象
for (int j = 0; j < rowData.length; j++) {
String value = null;
if (!"".equals(rowData[j]) && rowData[j] != null) {
value = rowData[j].toString();
pw.print("\"" + value.replace("\"", "\"\"") + "\"");
}

if (j != rowData.length - 1)
pw.print(",");
}
pw.println();
}
pw.close();
output.close();
}
}

[tianfang]

把需求描述清楚，是导出到文件，还是http输出？ 看代码象是http输出，但要写在doGet，doPost方法中

[尘同学]

PrintWriter pw = null; pw = new PrintWriter(new OutputStreamWriter(new BufferedOutputStream( output, 1024), "GBK")); 我后来变成了 PrintWriter pw = null; pw = new PrintWriter(new OutputStreamWriter(new BufferedOutputStream( output,1024), "GBK"),true);//这里的ture表示流会自动刷新，在后面可以不用使用flush()方法 然后可以了，谢谢你的回答，谢谢了

[snowwhite211]

楼主请问导出一百万CSV数据没问题吗