Package: groovy.sql

## [Java] Interface GroovyResultSet

- java.lang.AutoCloseable

- All Superinterfaces:
    GroovyObject, Wrapper, AutoCloseable

  Represents an extent of objects

  Authors:
    James Strachan
    Ivan Ganza
    Chris Stevenson

- - Inherited fields
    Fields inherited from class | Fields
    --- | ---
    `interface ResultSet` | `FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE, CONCUR_READ_ONLY, CONCUR_UPDATABLE, HOLD_CURSORS_OVER_COMMIT, CLOSE_CURSORS_AT_COMMIT`

  - ### Methods Summary

    Methods
    Type Params | Return Type | Name and description
    --- | --- | ---
    `` | `void` | `add(Map values)` Adds a new row to this result set
    `` | `void` | `eachRow(Closure closure)` Call the closure once for each row in the result set.
    `` | `Object` | `getAt(int index)` Supports integer-based subscript operators for accessing at numbered columns starting at zero.
    `` | `Object` | `getAt(String columnName)` Gets the value of the designated column in the current row as an `Object`.
    `` | `void` | `putAt(int index, Object newValue)` Supports integer based subscript operators for updating the values of numbered columns starting at zero.
    `` | `void` | `putAt(String columnName, Object newValue)` Updates the designated column with an `Object` value.

  - ### Inherited Methods Summary

    Inherited Methods
    Methods inherited from class | Name
    --- | ---
    `interface GroovyObject` | `getMetaClass, getProperty, invokeMethod, setMetaClass, setProperty`

    `interface ResultSet`

    `wasNull, getMetaData, getWarnings, getAsciiStream, getAsciiStream, getUnicodeStream, getUnicodeStream, getBinaryStream, getBinaryStream, clearWarnings, getCursorName, findColumn, getCharacterStream, getCharacterStream, isBeforeFirst, isAfterLast, isFirst, isLast, beforeFirst, afterLast, getRow, setFetchDirection, getFetchDirection, setFetchSize, getFetchSize, getConcurrency, rowUpdated, rowInserted, rowDeleted, updateNull, updateNull, updateBoolean, updateBoolean, updateByte, updateByte, updateShort, updateShort, updateInt, updateInt, updateLong, updateLong, updateFloat, updateFloat, updateDouble, updateDouble, updateBigDecimal, updateBigDecimal, updateString, updateString, updateDate, updateDate, updateTimestamp, updateTimestamp, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, insertRow, updateRow, deleteRow, refreshRow, cancelRowUpdates, moveToInsertRow, moveToCurrentRow, getStatement, getBlob, getBlob, getClob, getClob, updateRef, updateRef, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, updateArray, updateArray, getRowId, getRowId, updateRowId, updateRowId, getHoldability, updateNString, updateNString, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, getNClob, getNClob, getSQLXML, getSQLXML, updateSQLXML, updateSQLXML, getNString, getNString, getNCharacterStream, getNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateBytes, updateBytes, getBoolean, getBoolean, getByte, getByte, getShort, getShort, getInt, getInt, getLong, getLong, getFloat, getFloat, getDouble, getDouble, getBytes, getBytes, next, last, first, close, getType, getObject, getObject, getObject, getObject, getObject, getObject, getRef, getRef, previous, getArray, getArray, absolute, getTime, getTime, getTime, getTime, getString, getString, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, updateTime, updateTime, getDate, getDate, getDate, getDate, getURL, getURL, getTimestamp, getTimestamp, getTimestamp, getTimestamp, relative, isClosed, isWrapperFor, unwrap`

    `class Object` | `equals, toString, hashCode, getClass, notify, notifyAll, wait, wait, wait`

- - ### Method Detail

    - #### public void add(Map values)

      Adds a new row to this result set

      throws:
        SQLException if a database error occurs
      Parameters:
        `values` - the new values to add

    - #### public void eachRow(Closure closure)

      Call the closure once for each row in the result set.

      throws:
        SQLException if a database error occurs
      Parameters:
        `closure` - the closure to call for each row

    - #### public Object getAt(int index)

      Supports integer-based subscript operators for accessing at numbered columns starting at zero. Negative indices are supported, they will count from the last column backwards.

      throws:
        SQLException if a database error occurs
      Parameters:
        `index` - is the number of the column to look at starting at 1
      Returns:
        the object for this index in the current result set

    - #### public Object getAt(String columnName)

      Gets the value of the designated column in the current row as an `Object`.

      throws:
        groovy.lang.MissingPropertyException if an SQLException happens while getting the object
      Parameters:
        `columnName` - the SQL name of the column
      Returns:
        the returned column value

    - #### public void putAt(int index, Object newValue)

      Supports integer based subscript operators for updating the values of numbered columns starting at zero. Negative indices are supported, they will count from the last column backwards.

      throws:
        SQLException if a database error occurs
      Parameters:
        `index` - is the number of the column to look at starting at 1
        `newValue` - the new value for this index

    - #### public void putAt(String columnName, Object newValue)

      Updates the designated column with an `Object` value.

      throws:
        groovy.lang.MissingPropertyException if an SQLException happens while setting the new value
      Parameters:
        `columnName` - the SQL name of the column
        `newValue` - the updated value