示例

public class ClassA { public void makeStream (DataSource ds) { try { Connection connection = ds.getConnection(); connection.getTransactionIsolation(); //do something... connection.close(); } catch (SQLException sqle) { //stream leaked... } } }

解决方案

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

public class ClassA { public void makeStream (DataSource ds) { Connection connection = null; try { connection = ds.getConnection(); connection.getTransactionIsolation(); //do something... } catch (SQLException sqle) { //do something... } finally { if (connection != null) { try { connection.close(); } catch(SQLException sqle) { //do something... } } } } }