Method query

subprojects/groovy-sql/src/main/java/groovy/sql/Sql.java:1286–1301

Performs the given SQL query, which should return a single ResultSet object. The given closure is called with the ResultSet as its argument. Example usages: sql.query("select from PERSON where firstname like 'S%'") { ResultSet rs -> while (rs.next()) p

(String sql, @ClosureParams(value=SimpleType.class, options="java.sql.ResultSet") Closure closure)

     * @throws SQLException if a database access error occurs
     */
    public void query(String sql, @ClosureParams(value=SimpleType.class, options="java.sql.ResultSet") Closure closure) throws SQLException {
        Connection connection = createConnection();
        Statement statement = null;
        ResultSet results = null;
        try {
            statement = getStatement(connection, sql);
            results = statement.executeQuery(sql);
            closure.call(results);
            cleanup(statement);
        } catch (SQLException e) {
            LOG.warning("Failed to execute: " + sql + " because: " + e.getMessage());
            throw e;
        } finally {
            closeResources(connection, statement, results);
        }
    }

    /**
     * Performs the given SQL query, which should return a single