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 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 Type Method Description voidadd(java.util.Map values)Adds a new row to this result setvoideachRow(Closure closure)Call the closure once for each row in the result set.java.lang.ObjectgetAt(int index)Supports integer-based subscript operators for accessing at numbered columns starting at zero.java.lang.ObjectgetAt(java.lang.String columnName)Gets the value of the designated column in the current row as anObject.voidputAt(int index, java.lang.Object newValue)Supports integer based subscript operators for updating the values of numbered columns starting at zero.voidputAt(java.lang.String columnName, java.lang.Object newValue)Updates 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- 
getAtjava.lang.Object getAt(int index) throws java.sql.SQLExceptionSupports 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
 
- 
getAtjava.lang.Object getAt(java.lang.String columnName)Gets 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
 
- 
putAtvoid putAt(int index, java.lang.Object newValue) throws java.sql.SQLExceptionSupports 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
 
- 
putAtvoid putAt(java.lang.String columnName, java.lang.Object newValue)Updates 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
 
- 
addvoid add(java.util.Map values) throws java.sql.SQLExceptionAdds a new row to this result set- Parameters:
- values- the new values to add
- Throws:
- java.sql.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:
- java.sql.SQLException- if a database error occurs
 
 
-