JAVAsql。SQLException:mysql中结果集结束后出错
我试图从数据库中读取数据,并将ResultSet
存储在ArrayList
中。但是,我在打印arraylist时收到错误java.sql.SQLException: After end of result set
。根据这个link,我已经检查过没有两次调用我的result.next()
。有谁有更好的方法来存储结果集吗?然后我可以在我想要的地方打印出来
Statement stmt=con.createStatement();
ResultSet rsVehicle=stmt.executeQuery("select * from vehicle");
while(rsVehicle.next()) {
vehicleList.add(rsVehicle);
}
System.out.println(vehicleList.size());
for(int i=0;i<vehicleList.size();i++) {
System.out.println(vehicleList.get(i).getInt(1)+" "+vehicleList.get(i).getString(2)+" "+vehicleList.get(i).getString(3)+" "+
vehicleList.get(i).getString(4)+" "+vehicleList.get(i).getString(5)+" "+vehicleList.get(i).getString(6)+" "+
vehicleList.get(i).getString(7)+" "+vehicleList.get(i).getString(8)+" "+vehicleList.get(i).getString(9)+" "+
vehicleList.get(i).getString(10)+" "+vehicleList.get(i).getString(11)+" "+vehicleList.get(i).getString(12)+" "+
vehicleList.get(i).getString(13)+" "+vehicleList.get(i).getString(14)+" "+vehicleList.get(i).getString(15));
}
PreparedStatement ps;
ps =con.prepareStatement("SELECT * from job WHERE date = ?");
ps.setString(1, date);
ResultSet rsJob=ps.executeQuery();
while(rsJob.next()) {
jobList.add(rsJob);
}
System.out.println(jobList.size());
for(int i=0;i<jobList.size();i++) {
System.out.println(jobList.get(i).getInt(1)+" "+jobList.get(i).getString(2)+" "+jobList.get(i).getString(3)+" "+
jobList.get(i).getString(4)+" "+jobList.get(i).getString(5)+" "+jobList.get(i).getString(6)+" "+
jobList.get(i).getString(7)+" "+jobList.get(i).getString(8)+" "+jobList.get(i).getString(9)+" "+
jobList.get(i).getString(10)+" "+jobList.get(i).getString(11)+" "+jobList.get(i).getString(12)+" "+
jobList.get(i).getString(13)+" "+jobList.get(i).getString(14)+" "+jobList.get(i).getString(15));
}
# 1 楼答案
在代码中,将结果集添加到列表中,然后迭代该列表以获取数据,但正确的流程是:
代码应类似于:
注意:如果重新定义类Vehicle的方法
toString
,则可以直接调用System.out.println(vehicle);