SQLException:Object has closed

最新推荐文章于 2022-06-14 20:42:52 发布

最新推荐文章于 2022-06-14 20:42:52 发布 · 186 阅读

文章标签：

4 篇文章

订阅专栏

本文介绍了一个使用Java进行数据库操作的具体案例，包括记录的查询、价格更新等操作，并针对出现的Object has closed异常进行了初步分析。

String insertRecordSql="select distinct depcity,arrcity,cabin,flightdate from TM_download where id>="+startId; DBConnection con=new DBConnection(); ResultSet record=con.executeQuery(insertRecordSql);
con=null;
con=new DBConnection();
String cabin;
String airline;
String update;//="update TM_download set price=";
try{
while(record.next()){
update="update TM_download set price=";
cabin=record.getString("cabin");
String depcity=record.getString("depcity");
String arrcity=record.getString("arrcity");
java.sql.Date flightdate=record.getDate("flightdate");
airline=depcity+"-"+arrcity;
Float cabinDisCoutF=(Float)cabinDiscount.get(cabin);
Integer airlinePriceInt=(Integer)airlinePrice.get(airline);
int cabinPrice=0;
if(cabinDisCoutF!=null)
cabinPrice=getCommonPrice(airlinePriceInt.intValue(),cabinDisCoutF.floatValue());
else
cabinPrice=getSpecialcabinPrice(cabin,flightdate);
update=update+cabinPrice+" where cabin='"+cabin+"' and depcity='"+depcity+"' and arrcity='"+arrcity+"' and id>="+startId;
con.executeUpdate(update);
System.out.println("calculateCabinPrice sql:"+update);
}
}catch(SQLException sqle){
sqle.printStackTrace();
}finally{
con.close();
}

程序缺少第3行时，整个while循环会执行一次，然后抛出Object has closed 异常。具体原因还要进一步查证