Package groovy.sql

# Interface GroovyResultSet

All Superinterfaces:
  `java.lang.AutoCloseable`, `GroovyObject`, `java.sql.ResultSet`, `java.sql.Wrapper`

    public interface GroovyResultSet
    extends GroovyObject, java.sql.ResultSet

Represents an extent of objects

- ## Field Summary

  ### Fields inherited from interface java.sql.ResultSet

  `CLOSE_CURSORS_AT_COMMIT, CONCUR_READ_ONLY, CONCUR_UPDATABLE, FETCH_FORWARD, FETCH_REVERSE, FETCH_UNKNOWN, HOLD_CURSORS_OVER_COMMIT, TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, TYPE_SCROLL_SENSITIVE`

- ## Method Summary

  Modifier and Type | Method | Description
  --- | --- | ---
  `void` | `add​(java.util.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.
  `java.lang.Object` | `getAt​(int index)` | Supports integer-based subscript operators for accessing at numbered columns starting at zero.
  `java.lang.Object` | `getAt​(java.lang.String columnName)` | Gets the value of the designated column in the current row as an `Object`.
  `void` | `putAt​(int index, java.lang.Object newValue)` | Supports integer based subscript operators for updating the values of numbered columns starting at zero.
  `void` | `putAt​(java.lang.String columnName, java.lang.Object newValue)` | Updates the designated column with an `Object` value.

  ### Methods inherited from interface groovy.lang.GroovyObject

  `getMetaClass, getProperty, invokeMethod, setMetaClass, setProperty`

  ### Methods inherited from interface java.sql.ResultSet

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

  ### Methods inherited from interface java.sql.Wrapper

  `isWrapperFor, unwrap`

- ## Method Details

  - ### getAt

    java.lang.Object getAt​(int index) throws java.sql.SQLException
    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.
    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
    Throws:
      `java.sql.SQLException` - if a database error occurs

  - ### getAt

    java.lang.Object getAt​(java.lang.String columnName)
    Gets the value of the designated column in the current row as an `Object`.
    Parameters:
      `columnName` - the SQL name of the column
    Returns:
      the returned column value
    Throws:
      `MissingPropertyException` - if an SQLException happens while getting the object

  - ### putAt

    void putAt​(int index, java.lang.Object newValue) throws java.sql.SQLException
    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.
    Parameters:
      `index` - is the number of the column to look at starting at 1
      `newValue` - the new value for this index
    Throws:
      `java.sql.SQLException` - if a database error occurs

  - ### putAt

    void putAt​(java.lang.String columnName, java.lang.Object newValue)
    Updates the designated column with an `Object` value.
    Parameters:
      `columnName` - the SQL name of the column
      `newValue` - the updated value
    Throws:
      `MissingPropertyException` - if an SQLException happens while setting the new value

  - ### add

    void add​(java.util.Map values) throws java.sql.SQLException
    Adds a new row to this result set
    Parameters:
      `values` - the new values to add
    Throws:
      `java.sql.SQLException` - if a database error occurs

  - ### eachRow

    void eachRow​(Closure closure) throws java.sql.SQLException
    Call the closure once for each row in the result set.
    Parameters:
      `closure` - the closure to call for each row
    Throws:
      `java.sql.SQLException` - if a database error occurs