[Java] Interface GroovyResultSet
- groovy.lang.GroovyObject
- All Superinterfaces:
- GroovyObject
Represents an extent of objects
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
Type Params | Return 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
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/2.5.14/html/gapi/groovy/sql/GroovyResultSet.html