GroovyResultSet

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

groovy.sql
Class GroovyResultSet

java.lang.Object
  groovy.lang.GroovyObjectSupport
      groovy.sql.GroovyResultSet

All Implemented Interfaces:: GroovyObject, java.sql.ResultSet

public class GroovyResultSet
extends GroovyObjectSupport
implements java.sql.ResultSet

Represents an extent of objects

Version:: $Revision: 1.5 $
Author:: James Strachan, Ivan Ganza

Field Summary
`private java.sql.ResultSet`	`resultSet`
`private boolean`	`updated`

Fields inherited from class groovy.lang.GroovyObjectSupport

Fields inherited from interface java.sql.ResultSet

CLOSE_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

Constructor Summary
`GroovyResultSet(java.sql.ResultSet resultSet)`

Method Summary
`boolean`	`absolute(int row)` Moves the cursor to the given row number in this `ResultSet` object.
`void`	`add(java.util.Map values)` Adds a new row to this result set
`void`	`afterLast()` Moves the cursor to the end of this `ResultSet` object, just after the last row.
`void`	`beforeFirst()` Moves the cursor to the front of this `ResultSet` object, just before the first row.
`void`	`cancelRowUpdates()` Cancels the updates made to the current row in this `ResultSet` object.
`void`	`clearWarnings()` Clears all warnings reported on this `ResultSet` object.
`void`	`close()` Releases this `ResultSet` object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.
`void`	`deleteRow()` Deletes the current row from this `ResultSet` object and from the underlying database.
`int`	`findColumn(java.lang.String columnName)` Maps the given `ResultSet` column name to its `ResultSet` column index.
`boolean`	`first()` Moves the cursor to the first row in this `ResultSet` object.
`java.sql.Array`	`getArray(int i)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`java.sql.Array`	`getArray(java.lang.String colName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Array` object in the Java programming language.
`java.io.InputStream`	`getAsciiStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`java.io.InputStream`	`getAsciiStream(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of ASCII characters.
`java.lang.Object`	`getAt(int index)` Supports integer based subscript operators for accessing at numbered columns starting at zero.
`java.math.BigDecimal`	`getBigDecimal(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`java.math.BigDecimal`	`getBigDecimal(int columnIndex, int scale)` Deprecated.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`java.math.BigDecimal`	`getBigDecimal(java.lang.String columnName, int scale)` Deprecated.
`java.io.InputStream`	`getBinaryStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a binary stream of uninterpreted bytes.
`java.io.InputStream`	`getBinaryStream(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a stream of uninterpreted `byte`s.
`java.sql.Blob`	`getBlob(int i)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`java.sql.Blob`	`getBlob(java.lang.String colName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Blob` object in the Java programming language.
`boolean`	`getBoolean(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`boolean`	`getBoolean(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `boolean` in the Java programming language.
`byte`	`getByte(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`byte`	`getByte(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`byte[]`	`getBytes(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`byte[]`	`getBytes(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` array in the Java programming language.
`java.io.Reader`	`getCharacterStream(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`java.io.Reader`	`getCharacterStream(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.io.Reader` object.
`java.sql.Clob`	`getClob(int i)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`java.sql.Clob`	`getClob(java.lang.String colName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Clob` object in the Java programming language.
`int`	`getConcurrency()` Retrieves the concurrency mode of this `ResultSet` object.
`java.lang.String`	`getCursorName()` Retrieves the name of the SQL cursor used by this `ResultSet` object.
`java.sql.Date`	`getDate(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`java.sql.Date`	`getDate(int columnIndex, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`java.sql.Date`	`getDate(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`java.sql.Date`	`getDate(java.lang.String columnName, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` object in the Java programming language.
`double`	`getDouble(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`double`	`getDouble(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `double` in the Java programming language.
`int`	`getFetchDirection()` Retrieves the fetch direction for this `ResultSet` object.
`int`	`getFetchSize()` Retrieves the fetch size for this `ResultSet` object.
`float`	`getFloat(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`float`	`getFloat(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `float` in the Java programming language.
`int`	`getInt(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`int`	`getInt(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`long`	`getLong(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`long`	`getLong(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`java.sql.ResultSetMetaData`	`getMetaData()` Retrieves the number, types and properties of this `ResultSet` object's columns.
`java.lang.Object`	`getObject(int columnIndex)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`java.lang.Object`	`getObject(int i, java.util.Map map)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`java.lang.Object`	`getObject(java.lang.String columnName)` Gets the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`java.lang.Object`	`getObject(java.lang.String colName, java.util.Map map)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Object` in the Java programming language.
`java.lang.Object`	`getProperty(java.lang.String property)`
`java.sql.Ref`	`getRef(int i)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`java.sql.Ref`	`getRef(java.lang.String colName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Ref` object in the Java programming language.
`int`	`getRow()` Retrieves the current row number.
`short`	`getShort(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`short`	`getShort(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`java.sql.Statement`	`getStatement()` Retrieves the `Statement` object that produced this `ResultSet` object.
`java.lang.String`	`getString(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`java.lang.String`	`getString(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`java.sql.Time`	`getTime(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`java.sql.Time`	`getTime(int columnIndex, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`java.sql.Time`	`getTime(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`java.sql.Time`	`getTime(java.lang.String columnName, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` object in the Java programming language.
`java.sql.Timestamp`	`getTimestamp(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`java.sql.Timestamp`	`getTimestamp(int columnIndex, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object.
`java.sql.Timestamp`	`getTimestamp(java.lang.String columnName, java.util.Calendar cal)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` object in the Java programming language.
`int`	`getType()` Retrieves the type of this `ResultSet` object.
`java.io.InputStream`	`getUnicodeStream(int columnIndex)` Deprecated. use `getCharacterStream` in place of `getUnicodeStream`
`java.io.InputStream`	`getUnicodeStream(java.lang.String columnName)` Deprecated. use `getCharacterStream` instead
`java.net.URL`	`getURL(int columnIndex)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
`java.net.URL`	`getURL(java.lang.String columnName)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.net.URL` object in the Java programming language.
`java.sql.SQLWarning`	`getWarnings()` Retrieves the first warning reported by calls on this `ResultSet` object.
`void`	`insertRow()` Inserts the contents of the insert row into this `ResultSet` object and into the database.
`boolean`	`isAfterLast()` Retrieves whether the cursor is after the last row in this `ResultSet` object.
`boolean`	`isBeforeFirst()` Retrieves whether the cursor is before the first row in this `ResultSet` object.
`boolean`	`isFirst()` Retrieves whether the cursor is on the first row of this `ResultSet` object.
`boolean`	`isLast()` Retrieves whether the cursor is on the last row of this `ResultSet` object.
`boolean`	`last()` Moves the cursor to the last row in this `ResultSet` object.
`void`	`moveToCurrentRow()` Moves the cursor to the remembered cursor position, usually the current row.
`void`	`moveToInsertRow()` Moves the cursor to the insert row.
`boolean`	`next()` Moves the cursor down one row from its current position.
`protected int`	`normalizeIndex(int index)` Takes a zero based index and convert it into an SQL based 1 based index.
`boolean`	`previous()` Moves the cursor to the previous row in this `ResultSet` object.
`void`	`putAt(int index, java.lang.Object newValue)` Supports integer based subscript operators for updating the values of numbered columns starting at zero.
`void`	`refreshRow()` Refreshes the current row with its most recent value in the database.
`boolean`	`relative(int rows)` Moves the cursor a relative number of rows, either positive or negative.
`boolean`	`rowDeleted()` Retrieves whether a row has been deleted.
`boolean`	`rowInserted()` Retrieves whether the current row has had an insertion.
`boolean`	`rowUpdated()` Retrieves whether the current row has been updated.
`void`	`setFetchDirection(int direction)` Gives a hint as to the direction in which the rows in this `ResultSet` object will be processed.
`void`	`setFetchSize(int rows)` Gives the JDBC driver a hint as to the number of rows that should be fetched from the database when more rows are needed for this `ResultSet` object.
`void`	`setProperty(java.lang.String property, java.lang.Object newValue)` Sets the given property to the new value
`void`	`updateArray(int columnIndex, java.sql.Array x)` Updates the designated column with a `java.sql.Array` value.
`void`	`updateArray(java.lang.String columnName, java.sql.Array x)` Updates the designated column with a `java.sql.Array` value.
`void`	`updateAsciiStream(int columnIndex, java.io.InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateAsciiStream(java.lang.String columnName, java.io.InputStream x, int length)` Updates the designated column with an ascii stream value.
`void`	`updateBigDecimal(int columnIndex, java.math.BigDecimal x)` Updates the designated column with a `java.math.BigDecimal` value.
`void`	`updateBigDecimal(java.lang.String columnName, java.math.BigDecimal x)` Updates the designated column with a `java.sql.BigDecimal` value.
`void`	`updateBinaryStream(int columnIndex, java.io.InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBinaryStream(java.lang.String columnName, java.io.InputStream x, int length)` Updates the designated column with a binary stream value.
`void`	`updateBlob(int columnIndex, java.sql.Blob x)` Updates the designated column with a `java.sql.Blob` value.
`void`	`updateBlob(java.lang.String columnName, java.sql.Blob x)` Updates the designated column with a `java.sql.Blob` value.
`void`	`updateBoolean(int columnIndex, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateBoolean(java.lang.String columnName, boolean x)` Updates the designated column with a `boolean` value.
`void`	`updateByte(int columnIndex, byte x)` Updates the designated column with a `byte` value.
`void`	`updateByte(java.lang.String columnName, byte x)` Updates the designated column with a `byte` value.
`void`	`updateBytes(int columnIndex, byte[] x)` Updates the designated column with a `byte` array value.
`void`	`updateBytes(java.lang.String columnName, byte[] x)` Updates the designated column with a byte array value.
`void`	`updateCharacterStream(int columnIndex, java.io.Reader x, int length)` Updates the designated column with a character stream value.
`void`	`updateCharacterStream(java.lang.String columnName, java.io.Reader reader, int length)` Updates the designated column with a character stream value.
`void`	`updateClob(int columnIndex, java.sql.Clob x)` Updates the designated column with a `java.sql.Clob` value.
`void`	`updateClob(java.lang.String columnName, java.sql.Clob x)` Updates the designated column with a `java.sql.Clob` value.
`void`	`updateDate(int columnIndex, java.sql.Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(java.lang.String columnName, java.sql.Date x)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDouble(int columnIndex, double x)` Updates the designated column with a `double` value.
`void`	`updateDouble(java.lang.String columnName, double x)` Updates the designated column with a `double` value.
`void`	`updateFloat(int columnIndex, float x)` Updates the designated column with a `float` value.
`void`	`updateFloat(java.lang.String columnName, float x)` Updates the designated column with a `float` value.
`void`	`updateInt(int columnIndex, int x)` Updates the designated column with an `int` value.
`void`	`updateInt(java.lang.String columnName, int x)` Updates the designated column with an `int` value.
`void`	`updateLong(int columnIndex, long x)` Updates the designated column with a `long` value.
`void`	`updateLong(java.lang.String columnName, long x)` Updates the designated column with a `long` value.
`void`	`updateNull(int columnIndex)` Gives a nullable column a null value.
`void`	`updateNull(java.lang.String columnName)` Updates the designated column with a `null` value.
`void`	`updateObject(int columnIndex, java.lang.Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(int columnIndex, java.lang.Object x, int scale)` Updates the designated column with an `Object` value.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x)` Updates the designated column with an `Object` value.
`void`	`updateObject(java.lang.String columnName, java.lang.Object x, int scale)` Updates the designated column with an `Object` value.
`void`	`updateRef(int columnIndex, java.sql.Ref x)` Updates the designated column with a `java.sql.Ref` value.
`void`	`updateRef(java.lang.String columnName, java.sql.Ref x)` Updates the designated column with a `java.sql.Ref` value.
`void`	`updateRow()` Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void`	`updateShort(int columnIndex, short x)` Updates the designated column with a `short` value.
`void`	`updateShort(java.lang.String columnName, short x)` Updates the designated column with a `short` value.
`void`	`updateString(int columnIndex, java.lang.String x)` Updates the designated column with a `String` value.
`void`	`updateString(java.lang.String columnName, java.lang.String x)` Updates the designated column with a `String` value.
`void`	`updateTime(int columnIndex, java.sql.Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTime(java.lang.String columnName, java.sql.Time x)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTimestamp(int columnIndex, java.sql.Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`void`	`updateTimestamp(java.lang.String columnName, java.sql.Timestamp x)` Updates the designated column with a `java.sql.Timestamp` value.
`boolean`	`wasNull()` Reports whether the last column read had a value of SQL `NULL`.

Methods inherited from class groovy.lang.GroovyObjectSupport

getMetaClass, invokeMethod, setMetaClass

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

resultSet

private java.sql.ResultSet resultSet

updated

private boolean updated

Constructor Detail

GroovyResultSet

public GroovyResultSet(java.sql.ResultSet resultSet)

Method Detail

getProperty

public java.lang.Object getProperty(java.lang.String property)

Specified by:: getProperty in interface GroovyObject
Overrides:: getProperty in class GroovyObjectSupport

setProperty

public void setProperty(java.lang.String property,
                        java.lang.Object newValue)

Description copied from interface: GroovyObject

Sets the given property to the new value

Specified by:: setProperty in interface GroovyObject
Overrides:: setProperty in class GroovyObjectSupport

getAt

public java.lang.Object getAt(int index)
                       throws java.sql.SQLException

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.

Parameters:: index - is the number of the column to look at starting at 1
Returns:
Throws:: java.sql.SQLException

putAt

public void putAt(int index,
                  java.lang.Object newValue)
           throws java.sql.SQLException

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.

Parameters:: index - is the number of the column to look at starting at 1
Returns:
Throws:: java.sql.SQLException

add

public void add(java.util.Map values)
         throws java.sql.SQLException

Adds a new row to this result set

Parameters:: values -
Throws:: java.sql.SQLException

normalizeIndex

protected int normalizeIndex(int index)
                      throws java.sql.SQLException

Takes a zero based index and convert it into an SQL based 1 based index. A negative index will count backwards from the last column.

Parameters:: index -
Returns:: a JDBC index
Throws:: java.sql.SQLException - if some exception occurs finding out the column count

public boolean next()
             throws java.sql.SQLException

Moves the cursor down one row from its current position. A ResultSet cursor is initially positioned before the first row; the first call to the method next makes the first row the current row; the second call makes the second row the current row, and so on.

If an input stream is open for the current row, a call to the method next will implicitly close it. A ResultSet object's warning chain is cleared when a new row is read.

Specified by:: next in interface java.sql.ResultSet

Returns:: true if the new current row is valid; false if there are no more rows
Throws:: java.sql.SQLException - if a database access error occurs

close

public void close()
           throws java.sql.SQLException

Releases this ResultSet object's database and JDBC resources immediately instead of waiting for this to happen when it is automatically closed.

Note: A ResultSet object is automatically closed by the Statement object that generated it when that Statement object is closed, re-executed, or is used to retrieve the next result from a sequence of multiple results. A ResultSet object is also automatically closed when it is garbage collected.

Specified by:: close in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs

wasNull

public boolean wasNull()
                throws java.sql.SQLException

Reports whether the last column read had a value of SQL NULL. Note that you must first call one of the getter methods on a column to try to read its value and then call the method wasNull to see if the value read was SQL NULL.

Specified by:: wasNull in interface java.sql.ResultSet

Returns:: true if the last column value read was SQL NULL and false otherwise
Throws:: java.sql.SQLException - if a database access error occurs

getString

public java.lang.String getString(int columnIndex)
                           throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Specified by:: getString in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getBoolean

public boolean getBoolean(int columnIndex)
                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

Specified by:: getBoolean in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is false
Throws:: java.sql.SQLException - if a database access error occurs

getByte

public byte getByte(int columnIndex)
             throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

Specified by:: getByte in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getShort

public short getShort(int columnIndex)
               throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

Specified by:: getShort in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getInt

public int getInt(int columnIndex)
           throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Specified by:: getInt in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getLong

public long getLong(int columnIndex)
             throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

Specified by:: getLong in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getFloat

public float getFloat(int columnIndex)
               throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

Specified by:: getFloat in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getDouble

public double getDouble(int columnIndex)
                 throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

Specified by:: getDouble in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex,
                                          int scale)
                                   throws java.sql.SQLException

Deprecated.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.BigDecimal in the Java programming language.

Specified by:: getBigDecimal in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...; scale - the number of digits to the right of the decimal point
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getBytes

public byte[] getBytes(int columnIndex)
                throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a byte array in the Java programming language. The bytes represent the raw values returned by the driver.

Specified by:: getBytes in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getDate

public java.sql.Date getDate(int columnIndex)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Specified by:: getDate in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getTime

public java.sql.Time getTime(int columnIndex)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Specified by:: getTime in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getTimestamp

public java.sql.Timestamp getTimestamp(int columnIndex)
                                throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object in the Java programming language.

Specified by:: getTimestamp in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getAsciiStream

public java.io.InputStream getAsciiStream(int columnIndex)
                                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method InputStream.available is called whether there is data available or not.

Specified by:: getAsciiStream in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: a Java input stream that delivers the database column value as a stream of one-byte ASCII characters; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getUnicodeStream

public java.io.InputStream getUnicodeStream(int columnIndex)
                                     throws java.sql.SQLException

Deprecated. use getCharacterStream in place of getUnicodeStream

Retrieves the value of the designated column in the current row of this ResultSet object as as a stream of two-byte Unicode characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHARvalues. The JDBC driver will do any necessary conversion from the database format into Unicode.

Specified by:: getUnicodeStream in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: a Java input stream that delivers the database column value as a stream of two-byte Unicode characters; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getBinaryStream

public java.io.InputStream getBinaryStream(int columnIndex)
                                    throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a binary stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

Specified by:: getBinaryStream in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getString

public java.lang.String getString(java.lang.String columnName)
                           throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a String in the Java programming language.

Specified by:: getString in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getBoolean

public boolean getBoolean(java.lang.String columnName)
                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a boolean in the Java programming language.

Specified by:: getBoolean in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is false
Throws:: java.sql.SQLException - if a database access error occurs

getByte

public byte getByte(java.lang.String columnName)
             throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a byte in the Java programming language.

Specified by:: getByte in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getShort

public short getShort(java.lang.String columnName)
               throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a short in the Java programming language.

Specified by:: getShort in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getInt

public int getInt(java.lang.String columnName)
           throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as an int in the Java programming language.

Specified by:: getInt in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getLong

public long getLong(java.lang.String columnName)
             throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a long in the Java programming language.

Specified by:: getLong in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getFloat

public float getFloat(java.lang.String columnName)
               throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a float in the Java programming language.

Specified by:: getFloat in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getDouble

public double getDouble(java.lang.String columnName)
                 throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a double in the Java programming language.

Specified by:: getDouble in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0
Throws:: java.sql.SQLException - if a database access error occurs

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName,
                                          int scale)
                                   throws java.sql.SQLException

Deprecated.

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal in the Java programming language.

Specified by:: getBigDecimal in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column; scale - the number of digits to the right of the decimal point
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getBytes

public byte[] getBytes(java.lang.String columnName)
                throws java.sql.SQLException

Specified by:: getBytes in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getDate

public java.sql.Date getDate(java.lang.String columnName)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Date object in the Java programming language.

Specified by:: getDate in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getTime

public java.sql.Time getTime(java.lang.String columnName)
                      throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Time object in the Java programming language.

Specified by:: getTime in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getTimestamp

public java.sql.Timestamp getTimestamp(java.lang.String columnName)
                                throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.sql.Timestamp object.

Specified by:: getTimestamp in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null
Throws:: java.sql.SQLException - if a database access error occurs

getAsciiStream

public java.io.InputStream getAsciiStream(java.lang.String columnName)
                                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of ASCII characters. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC driver will do any necessary conversion from the database format into ASCII.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Specified by:: getAsciiStream in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: a Java input stream that delivers the database column value as a stream of one-byte ASCII characters. If the value is SQL NULL, the value returned is null.
Throws:: java.sql.SQLException - if a database access error occurs

getUnicodeStream

public java.io.InputStream getUnicodeStream(java.lang.String columnName)
                                     throws java.sql.SQLException

Deprecated. use getCharacterStream instead

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of two-byte Unicode characters. The first byte is the high byte; the second byte is the low byte. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARCHAR values. The JDBC technology-enabled driver will do any necessary conversion from the database format into Unicode.

Specified by:: getUnicodeStream in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: a Java input stream that delivers the database column value as a stream of two-byte Unicode characters. If the value is SQL NULL, the value returned is null.
Throws:: java.sql.SQLException - if a database access error occurs

getBinaryStream

public java.io.InputStream getBinaryStream(java.lang.String columnName)
                                    throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a stream of uninterpreted bytes. The value can then be read in chunks from the stream. This method is particularly suitable for retrieving large LONGVARBINARY values.

Note: All the data in the returned stream must be read prior to getting the value of any other column. The next call to a getter method implicitly closes the stream. Also, a stream may return 0 when the method available is called whether there is data available or not.

Specified by:: getBinaryStream in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: a Java input stream that delivers the database column value as a stream of uninterpreted bytes; if the value is SQL NULL, the result is null
Throws:: java.sql.SQLException - if a database access error occurs

getWarnings

public java.sql.SQLWarning getWarnings()
                                throws java.sql.SQLException

Retrieves the first warning reported by calls on this ResultSet object. Subsequent warnings on this ResultSet object will be chained to the SQLWarning object that this method returns.

The warning chain is automatically cleared each time a new row is read. This method may not be called on a ResultSet object that has been closed; doing so will cause an SQLException to be thrown.

Note: This warning chain only covers warnings caused by ResultSet methods. Any warning caused by Statement methods (such as reading OUT parameters) will be chained on the Statement object.

Specified by:: getWarnings in interface java.sql.ResultSet

Returns:: the first SQLWarning object reported or null if there are none
Throws:: java.sql.SQLException - if a database access error occurs or this method is called on a closed result set

clearWarnings

public void clearWarnings()
                   throws java.sql.SQLException

Clears all warnings reported on this ResultSet object. After this method is called, the method getWarnings returns null until a new warning is reported for this ResultSet object.

Specified by:: clearWarnings in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs

getCursorName

public java.lang.String getCursorName()
                               throws java.sql.SQLException

Retrieves the name of the SQL cursor used by this ResultSet object.

In SQL, a result table is retrieved through a cursor that is named. The current row of a result set can be updated or deleted using a positioned update/delete statement that references the cursor name. To insure that the cursor has the proper isolation level to support update, the cursor's SELECT statement should be of the form SELECT FOR UPDATE. If FOR UPDATE is omitted, the positioned updates may fail.

The JDBC API supports this SQL feature by providing the name of the SQL cursor used by a ResultSet object. The current row of a ResultSet object is also the current row of this SQL cursor.

Note: If positioned update is not supported, a SQLException is thrown.

Specified by:: getCursorName in interface java.sql.ResultSet

Returns:: the SQL name for this ResultSet object's cursor
Throws:: java.sql.SQLException - if a database access error occurs

getMetaData

public java.sql.ResultSetMetaData getMetaData()
                                       throws java.sql.SQLException

Retrieves the number, types and properties of this ResultSet object's columns.

Specified by:: getMetaData in interface java.sql.ResultSet

Returns:: the description of this ResultSet object's columns
Throws:: java.sql.SQLException - if a database access error occurs

getObject

public java.lang.Object getObject(int columnIndex)
                           throws java.sql.SQLException

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

This method will return the value of the given column as a Java object. The type of the Java object will be the default Java object type corresponding to the column's SQL type, following the mapping for built-in types specified in the JDBC specification. If the value is an SQL NULL, the driver returns a Java null.

This method may also be used to read database-specific abstract data types. In the JDBC 2.0 API, the behavior of method getObject is extended to materialize data of SQL user-defined types. When a column contains a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).

Specified by:: getObject in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: a java.lang.Object holding the column value
Throws:: java.sql.SQLException - if a database access error occurs

getObject

public java.lang.Object getObject(java.lang.String columnName)
                           throws java.sql.SQLException

Gets the value of the designated column in the current row of this ResultSet object as an Object in the Java programming language.

This method may also be used to read database-specific abstract data types.

In the JDBC 2.0 API, the behavior of the method getObject is extended to materialize data of SQL user-defined types. When a column contains a structured or distinct value, the behavior of this method is as if it were a call to: getObject(columnIndex, this.getStatement().getConnection().getTypeMap()).

Specified by:: getObject in interface java.sql.ResultSet

Parameters:: columnName - the SQL name of the column
Returns:: a java.lang.Object holding the column value
Throws:: java.sql.SQLException - if a database access error occurs

findColumn

public int findColumn(java.lang.String columnName)
               throws java.sql.SQLException

Maps the given ResultSet column name to its ResultSet column index.

Specified by:: findColumn in interface java.sql.ResultSet

Parameters:: columnName - the name of the column
Returns:: the column index of the given column name
Throws:: java.sql.SQLException - if the ResultSet object does not contain columnName or a database access error occurs

getCharacterStream

public java.io.Reader getCharacterStream(int columnIndex)
                                  throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

Specified by:: getCharacterStream in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

getCharacterStream

public java.io.Reader getCharacterStream(java.lang.String columnName)
                                  throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.io.Reader object.

Specified by:: getCharacterStream in interface java.sql.ResultSet

Parameters:: columnName - the name of the column
Returns:: a java.io.Reader object that contains the column value; if the value is SQL NULL, the value returned is null in the Java programming language
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

getBigDecimal

public java.math.BigDecimal getBigDecimal(int columnIndex)
                                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

Specified by:: getBigDecimal in interface java.sql.ResultSet

Parameters:: columnIndex - the first column is 1, the second is 2, ...
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

getBigDecimal

public java.math.BigDecimal getBigDecimal(java.lang.String columnName)
                                   throws java.sql.SQLException

Retrieves the value of the designated column in the current row of this ResultSet object as a java.math.BigDecimal with full precision.

Specified by:: getBigDecimal in interface java.sql.ResultSet

Parameters:: columnName - the column name
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

isBeforeFirst

public boolean isBeforeFirst()
                      throws java.sql.SQLException

Retrieves whether the cursor is before the first row in this ResultSet object.

Specified by:: isBeforeFirst in interface java.sql.ResultSet

Returns:: true if the cursor is before the first row; false if the cursor is at any other position or the result set contains no rows
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

isAfterLast

public boolean isAfterLast()
                    throws java.sql.SQLException

Retrieves whether the cursor is after the last row in this ResultSet object.

Specified by:: isAfterLast in interface java.sql.ResultSet

Returns:: true if the cursor is after the last row; false if the cursor is at any other position or the result set contains no rows
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

isFirst

public boolean isFirst()
                throws java.sql.SQLException

Retrieves whether the cursor is on the first row of this ResultSet object.

Specified by:: isFirst in interface java.sql.ResultSet

Returns:: true if the cursor is on the first row; false otherwise
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

isLast

public boolean isLast()
               throws java.sql.SQLException

Retrieves whether the cursor is on the last row of this ResultSet object. Note: Calling the method isLast may be expensive because the JDBC driver might need to fetch ahead one row in order to determine whether the current row is the last row in the result set.

Specified by:: isLast in interface java.sql.ResultSet

Returns:: true if the cursor is on the last row; false otherwise
Throws:: java.sql.SQLException - if a database access error occurs
Since:: 1.2

beforeFirst

public void beforeFirst()
                 throws java.sql.SQLException

Moves the cursor to the front of this ResultSet object, just before the first row. This method has no effect if the result set contains no rows.

Specified by:: beforeFirst in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

afterLast

public void afterLast()
               throws java.sql.SQLException

Moves the cursor to the end of this ResultSet object, just after the last row. This method has no effect if the result set contains no rows.

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

Specified by:: afterLast in interface java.sql.ResultSet

Throws:: java.sql.SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY
Since:: 1.2

groovy.sql Class GroovyResultSet

resultSet

updated

GroovyResultSet

getProperty

setProperty

getAt

putAt

add

normalizeIndex

next

close

wasNull

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getString

getBoolean

getByte

getShort

getInt

getLong

getFloat

getDouble

getBigDecimal

getBytes

getDate

getTime

getTimestamp

getAsciiStream

getUnicodeStream

getBinaryStream

getWarnings

clearWarnings

getCursorName

getMetaData

getObject

getObject

findColumn

getCharacterStream

getCharacterStream

getBigDecimal

getBigDecimal

isBeforeFirst

isAfterLast

isFirst

isLast

beforeFirst

afterLast

groovy.sql
Class GroovyResultSet