JDBC的资源释放

1.1.1 JDBC资源释放

JDBC程序执行结束后，将与数据库进行交互的对象释放掉，通常是ResultSet,Statement,Connection。

这几个对象中尤其是Connection对象是非常稀有的。这个对象一定要做到尽量晚创建，尽早释放掉。

l 将资源释放的代码写入到finally的代码块中。

l 资源释放的代码应该写的标准：

[AppleScript] 纯文本查看 复制代码

?

01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

if(rs !=null){                                 try {                                         rs.close();                                 } catch (SQLException e) {                                         e.printStackTrace();                                 }                                                                   rs = null;                         }                                                   if(statement !=null){                                 try {                                         statement.close();                                 } catch (SQLException e) {                                         e.printStackTrace();                                 }                                                                   statement = null;                         }                                                                             if(conn !=null){                                 try {                                         conn.close();                                 } catch (SQLException e) {                                         e.printStackTrace();                                 }                                                                   conn = null;                         }