Method executeUpdate

subprojects/groovy-sql/src/main/java/groovy/sql/Sql.java:3333–3347

Executes the given SQL update. Resource handling is performed automatically where appropriate. @param sql the SQL to execute @return the number of rows updated or 0 for SQL statements that return nothing @throws SQLException if a database access error occurs

(String sql)

     * @throws SQLException if a database access error occurs
     */
    public int executeUpdate(String sql) throws SQLException {
        Connection connection = createConnection();
        Statement statement = null;
        try {
            statement = getStatement(connection, sql);
            this.updateCount = statement.executeUpdate(sql);
            cleanup(statement);
            return this.updateCount;
        } catch (SQLException e) {
            LOG.warning("Failed to execute: " + sql + " because: " + e.getMessage());
            throw e;
        } finally {
            closeResources(connection, statement);
        }
    }

    /**
     * Executes the given SQL update with parameters.