[Java] Interface GroovyResultSet

groovy.lang.GroovyObject

All Superinterfaces:: GroovyObject

public interface GroovyResultSet
extends GroovyObject, ResultSet

Represents an extent of objects

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
	`public void`	`add(Map values)` Adds a new row to this result set
	`public void`	`eachRow(Closure closure)` Call the closure once for each row in the result set.
	`public Object`	`getAt(int index)` Supports integer-based subscript operators for accessing at numbered columns starting at zero.
	`public Object`	`getAt(String columnName)` Gets the value of the designated column in the current row as an `Object`.
	`public void`	`putAt(int index, Object newValue)` Supports integer based subscript operators for updating the values of numbered columns starting at zero.
	`public 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`	updateBytes, updateBytes, getObject, getObject, getObject, getObject, getObject, getObject, getBoolean, getBoolean, getByte, getByte, getShort, getShort, getInt, getInt, getLong, getLong, getFloat, getFloat, getDouble, getDouble, getBytes, getBytes, last, next, first, close, getType, getRef, getRef, previous, getArray, getArray, getTime, getTime, getTime, getTime, getTimestamp, getTimestamp, getTimestamp, getTimestamp, getURL, getURL, getString, getString, getDate, getDate, getDate, getDate, updateTime, updateTime, relative, isClosed, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, wasNull, getMetaData, insertRow, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, updateNCharacterStream, getNCharacterStream, getNCharacterStream, isFirst, getAsciiStream, getAsciiStream, getUnicodeStream, getUnicodeStream, getBlob, getBlob, updateBoolean, updateBoolean, updateInt, updateInt, updateSQLXML, updateSQLXML, getBinaryStream, getBinaryStream, clearWarnings, getWarnings, beforeFirst, moveToInsertRow, getRowId, getRowId, updateDate, updateDate, updateRowId, updateRowId, getNString, getNString, getCharacterStream, getCharacterStream, getStatement, rowUpdated, setFetchSize, getFetchSize, afterLast, rowInserted, updateShort, updateShort, getFetchDirection, rowDeleted, updateLong, updateLong, updateDouble, updateDouble, updateBigDecimal, updateBigDecimal, updateTimestamp, updateTimestamp, getCursorName, findColumn, updateFloat, updateFloat, updateString, updateString, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateAsciiStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, updateBinaryStream, refreshRow, setFetchDirection, updateNull, updateNull, updateRef, updateRef, moveToCurrentRow, updateArray, updateArray, getHoldability, updateClob, updateClob, updateClob, updateClob, updateClob, updateClob, isAfterLast, getConcurrency, updateRow, cancelRowUpdates, getClob, getClob, updateByte, updateByte, updateNString, updateNString, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, updateBlob, isBeforeFirst, isLast, getRow, deleteRow, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, updateNClob, getNClob, getNClob, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, updateObject, getSQLXML, getSQLXML, absolute, unwrap, isWrapperFor

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

© 2003-2020 The Apache Software Foundation
Licensed under the Apache license.
https://docs.groovy-lang.org/3.0.7/html/gapi/groovy/sql/GroovyResultSet.html