Package groovy.sql
Interface GroovyResultSet
- All Superinterfaces:
- AutoCloseable,- GroovyObject,- ResultSet,- Wrapper
Represents an extent of objects
- 
Field SummaryFields inherited from interface java.sql.ResultSetCLOSE_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 SummaryModifier and TypeMethodDescriptionvoidAdds a new row to this result setvoidCall the closure once for each row in the result set.getAt(int index) Supports integer-based subscript operators for accessing at numbered columns starting at zero.Gets the value of the designated column in the current row as anObject.voidSupports integer based subscript operators for updating the values of numbered columns starting at zero.voidUpdates the designated column with anObjectvalue.Methods inherited from interface groovy.lang.GroovyObjectgetMetaClass, getProperty, invokeMethod, setMetaClass, setPropertyMethods inherited from interface java.sql.ResultSetabsolute, 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, wasNullMethods inherited from interface java.sql.WrapperisWrapperFor, unwrap
- 
Method Details- 
getAtSupports 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:
- SQLException- if a database error occurs
 
- 
getAtGets the value of the designated column in the current row as anObject.- Parameters:
- columnName- the SQL name of the column
- Returns:
- the returned column value
- Throws:
- MissingPropertyException- if an SQLException happens while getting the object
 
- 
putAtSupports 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:
- SQLException- if a database error occurs
 
- 
putAtUpdates the designated column with anObjectvalue.- Parameters:
- columnName- the SQL name of the column
- newValue- the updated value
- Throws:
- MissingPropertyException- if an SQLException happens while setting the new value
 
- 
addAdds a new row to this result set- Parameters:
- values- the new values to add
- Throws:
- SQLException- if a database error occurs
 
- 
eachRowCall the closure once for each row in the result set.- Parameters:
- closure- the closure to call for each row
- Throws:
- SQLException- if a database error occurs
 
 
-