示例

public class ClassA { private Connection connection; public void makeConnection (DataSource ds) { try { connection = ds.getConnection(); } catch(SQLException sqle) { //perform exception handling } //do something... } }

解决方案

为了避免资源泄漏，请确保对每个 java.sql.Connection 都调用 close()。注意：此规则适用于通过 javax.sql.DataSource 或 java.sql.DriverManager 检索到的 Connection。

public class ClassA { private Connection connection; public void makeConnection (DataSource ds) { try { connection = ds.getConnection(); } catch(SQLException sqle) { //perform exception handling } //do something... try { connection.close(); } catch(SQLException sqle) { //perform exception handling } } }