Question

看看老外怎么正常关闭JDBC的多个Statement

Answer 1

以前用JDBC处理多个Statement的时候，总会因为异常而无法完美的解决Statement正常关闭，今天无意看到老外写了以下一段代码，和大家分享一下：�0�2private PreparedStatement psStmt1; private PreparedStatement psStmt2; private PreparedStatement psStmt3; ........................ ........................ /* 关闭代码 */ public void cleanup() throws SQLException { SQLException exception = null; if (psStmt1 != null) { try { psStmt1.close(); } catch (SQLException e) { exception = e; } finally { psStmt1 = null; } } if (psStmt2 != null) { try { psStmt2.close(); } catch (SQLException e) { if (exception != null) e.setNextException(exception); exception = e; } finally { psStmt2 = null; } } if (psStmt3 != null) { try { psStmt3.close(); } catch (SQLException e) { if (exception != null) e.setNextException(exception); exception = e; } finally { psStmt3 = null; } } if (exception != null) { throw exception; } }�0�2�0�2