java - 静态代码分析注释

Question

我已使用静态代码分析器扫描了我的代码，并收到未发布的资源:数据库错误。我正在关闭所有数据库连接，下面是我的代码的快照。

public String methodInDAO(Bean bean) throws SQLException ,Exception
{

    Session session = null;
    Connection connection = null;
    ResultSet resultSet1 = null;
    CallableStatement callableStatement = null;

    try {
         connection = dataSource.getConnection();
         callableStatement = connection.prepareCall(query);
         resultSet1 = callableStatement.execute();
        //code operations
   } finally {
        if(null != callableStatement)
            callableStatement.close();

        resultSet1 = null;
        callableStatement = null;

        if(null != connection)
            connection.close();

        if (null != session)
            session.close();

    }

    return returnOutput;
}

所有抛出的异常都在服务层处理。谁能建议哪里没有发布数据源？

Answer 1

如果您的 JDBC 驱动程序支持 JDBC 4.1 ，您可以使用try-with-resources .

try (connection = dataSource.getConnection();
     callableStatement = connection.prepareCall(query)) {
  results = callableStatement.execute();
  // code operations
}

The ability to use a try-with-resources statement to automatically close resources of type Connection, ResultSet, and Statement

已添加到 JDBC 4.1。