public interface GroovyResultSet extends GroovyObject, 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
Modifier and Type | Method 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. |
getMetaClass, getProperty, invokeMethod, setMetaClass, setProperty
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, updateRef, updateRef, updateRow, updateRowId, updateRowId, updateShort, updateShort, updateSQLXML, updateSQLXML, updateString, updateString, updateTime, updateTime, updateTimestamp, updateTimestamp, wasNull
isWrapperFor, unwrap
Object getAt(int index) throws SQLException
index
- is the number of the column to look at starting at 1SQLException
- if a database error occursObject getAt(String columnName)
Object
.columnName
- the SQL name of the columnMissingPropertyException
- if an SQLException happens while getting the objectvoid putAt(int index, Object newValue) throws SQLException
index
- is the number of the column to look at starting at 1newValue
- the new value for this indexSQLException
- if a database error occursvoid putAt(String columnName, Object newValue)
Object
value.columnName
- the SQL name of the columnnewValue
- the updated valueMissingPropertyException
- if an SQLException happens while setting the new valuevoid add(Map values) throws SQLException
values
- the new values to addSQLException
- if a database error occursvoid eachRow(Closure closure) throws SQLException
closure
- the closure to call for each rowSQLException
- if a database error occurs