GroovyResultSet (groovy 2.4.4 API)

groovy.sql.GroovyResultSet

All Superinterfaces:

AutoCloseable, Wrapper, GroovyObject

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional information regarding copyright ownership. The ASF licenses this file to you under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

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	Name 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.

Inherited Methods Summary

Inherited Methods
Methods inherited from class	Name
`interface GroovyObject`	`getMetaClass, getProperty, invokeMethod, setMetaClass, setProperty`
`interface ResultSet`	getMetaData, insertRow, updateTime, updateTime, getBigDecimal, getBigDecimal, getBigDecimal, getBigDecimal, last, updateBytes, updateBytes, absolute, afterLast, beforeFirst, cancelRowUpdates, clearWarnings, deleteRow, findColumn, getAsciiStream, getAsciiStream, getBinaryStream, getBinaryStream, getBlob, getBlob, getCharacterStream, getCharacterStream, getClob, getClob, getConcurrency, getCursorName, getFetchDirection, getFetchSize, getHoldability, getNCharacterStream, getNCharacterStream, getNClob, getNClob, getNString, getNString, getRow, getRowId, getRowId, getSQLXML, getSQLXML, getStatement, getUnicodeStream, getUnicodeStream, getWarnings, isAfterLast, isBeforeFirst, isFirst, isLast, moveToCurrentRow, moveToInsertRow, refreshRow, 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, 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, updateSQLXML, updateSQLXML, updateShort, updateShort, updateString, updateString, updateTimestamp, updateTimestamp, wasNull, getTimestamp, getTimestamp, getTimestamp, getTimestamp, first, relative, isClosed, getObject, getObject, getObject, getObject, getObject, getObject, getBoolean, getBoolean, getByte, getByte, getShort, getShort, getInt, getInt, getLong, getLong, getFloat, getFloat, getDouble, getDouble, getBytes, getBytes, getArray, getArray, next, getURL, getURL, close, getType, previous, getRef, getRef, getString, getString, getDate, getDate, getDate, getDate, getTime, getTime, getTime, getTime, isWrapperFor, unwrap
`class Object`	`wait, wait, wait, equals, toString, hashCode, getClass, notify, notifyAll`

- 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

Summary:
Method

| Detail:
Method

[Java] Interface GroovyResultSet

Methods Summary

Inherited Methods Summary

Method Detail

public void add(Map values)

public void eachRow(Closure closure)

public Object getAt(int index)

public Object getAt(String columnName)

public void putAt(int index, Object newValue)

public void putAt(String columnName, Object newValue)