记录太多，导致内存溢出

[zhenai]

String sql = "";
//java
Db javaDb = new Db(0);
if (javaDb.connect(0)) { //ok 网络正常
// sql = "select count(1) as num from userCourse";//402536
// sql = "select count(1) as num from USERBATCHGRADE";//406285
sql = "select * from userCourse ";//where rownum<20000
javaDb.query(sql);
int i=1;
try {
while (javaDb.getNext()) {
if(i%10000==0) System.out.println(i);i++;
//当到16W多条时报：java.lang.OutOfMemoryError
}
}
catch (Exception e) {}
finally {
javaDb.close();
}
}
else
JOptionPane.showMessageDialog(null, "网络不正常,连接java失败");

System.out.println("操作结束" );


请问有经验的朋友们，这有什么解决办法吗？!
谢谢!!!!

[liuyi8903]

这个可能与你的java后台输出有关系.与数据库无任何关系的.