- 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;
- 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 异常。具体原因还要进一步查证
分享到:
相关推荐
java.sql.SQLException: 不支持的字符集 (在类路径中添加 orai18n.jar): ZHS16GBK ……
NULL 博文链接:https://listen-raining.iteye.com/blog/1962065
NULL 博文链接:https://zhang-zling.iteye.com/blog/980488
java.sql.SQLException: null, message from server: “Host ‘223.72.41.7’ is not allowed to connect to this MySQL server” 客户端访问时报错: 解决方法: 1,登陆服务器 mysql> use mysql; //用mysql ...
问题是这样的…我在VS2008直接运行打开网页,可以连接... 异常详细信息: System.Data.SqlClient.SqlException: 无法打开登录所请求的数据库 “TakeClass”。登录失败。 用户 ‘2D2727E2578F446\ASPNET’ 登录失败。
本文主要介绍了关于MySQL存储表情报错:java.sql.SQLException: Incorrect string value: ‘\xF0\x9F\x92\xA9\x0D\x0A…’的相关解决方法,分享出供大家参考学习,下面话不多说了,来一起看看详细的介绍: ...
oracle 10g 数据库驱动下载:oracle jdbc dirver
在oracle里面运行一下,解决Exception java.sql.SQLException ORA-00600 内部错误代码
mysql5.6连接驱动jaf,可处理报错java.sql.SQLException: No suitable driver
主要给大家介绍了关于MySQL存储表情时报错:java.sql.SQLException: Incorrect string value: 'xF0x9Fx92xA9x0Dx0A...'的解决方法,文中通过示例代码介绍的非常详细,需要的朋友可以参考借鉴,下面来一起看看吧。
服务器出现java.sql.SQLException No suitable driver found for 的
异常详细信息: System.Data.SqlClient.SqlException: 用户 'sa' 登录失败。该用户与可信 SQL Server 连接无关联。 说明: 执行当前 Web 请求期间,出现未处理的异常。请检查堆栈跟踪信息,以了解有关该错误以及代码中...
java.sql.SQLException: Operation not allowed after ResultSet closed java.sql.SQLException: QueryRunner requires a DataSource to be invoked in this way, or a Connection should be passed in
Q: I am working with ... I am using updateBinaryStream method of resultset to update the BLOB field but it is failing after giving following exception java.sql.SQLException: Internal Error: Unable to
异常错误:java.sql.SQLException: The server time zone value ‘?й???’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTime...
简单实现如何不创建简单JavaBean对象,而仅仅利用反射实现向普通JavaBean中set值和get值
ORA-28001 the password has expired密码过期
mysql-connector-java-1.5.34.jar source 源码;mysql-connector-java-1.5.34.jar source 源码;
oracle ora-各种常见java.sql.SQLException归纳