ResultSetWrapper (Tentackle API)

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.tentackle.db
Class ResultSetWrapper

java.lang.Object
  org.tentackle.db.ResultSetWrapper

public class ResultSetWrapper
extends Object
extends Object

A wrapper for ResultSets.

Author:: harald

Constructor Summary
`ResultSetWrapper(StatementWrapper stmt, ResultSet rs)` Creates a wrapper for the given result set.

Method Summary
`boolean`	`absolute(int row)` Moves the cursor to the given row number in this `ResultSet` object.
`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`	`close()` Closes the resultset.
`boolean`	`deleteRow()` Deletes the current row from this `ResultSet` object and from the underlying database.
`protected void`	`finalize()` Overridden to close forgotten resultsets.
`int`	`findColumn(String name)` Finds the column index to a string.
`boolean`	`first()` Moves the cursor to the first row in this `ResultSet` object.
`Boolean`	`getABoolean(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Boolean` in the Java programming language.
`Boolean`	`getABoolean(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Boolean` in the Java programming language.
`Byte`	`getAByte(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Byte` in the Java programming language.
`Byte`	`getAByte(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Byte` in the Java programming language.
`Double`	`getADouble(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Double` in the Java programming language.
`Double`	`getADouble(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Double` in the Java programming language.
`Float`	`getAFloat(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Float` in the Java programming language.
`Float`	`getAFloat(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Float` in the Java programming language.
`Long`	`getALong(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Long` in the Java programming language.
`Long`	`getALong(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Long` in the Java programming language.
`Short`	`getAShort(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Short` in the Java programming language.
`Short`	`getAShort(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Short` in the Java programming language.
`BigDecimal`	`getBigDecimal(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`BigDecimal`	`getBigDecimal(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.math.BigDecimal` with full precision.
`Binary`	`getBinary(int pos, int bufSize)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Binary` in the Java programming language.
`Binary`	`getBinary(String name, int bufSize)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Binary` in the Java programming language.
`BMoney`	`getBMoney(int pos, int ppos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `BMoney` with full precision. Notice that BMoney fields use two fields: one for the value and one for the scale (= name + "P")
`BMoney`	`getBMoney(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `BMoney` with full precision. Notice that BMoney fields use two fields: one for the value and one for the scale (= name + "P")
`boolean`	`getBoolean(int pos)` 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(String name)` 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 pos)` 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(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `byte` in the Java programming language.
`char`	`getChar(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `char` in the Java programming language.
`char`	`getChar(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `char` in the Java programming language.
`Character`	`getCharacter(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Character` in the Java programming language.
`Character`	`getCharacter(int pos, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Character` in the Java programming language.
`Character`	`getCharacter(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Character` in the Java programming language.
`Character`	`getCharacter(String name, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `Character` in the Java programming language.
`int`	`getColumnOffset()` Gets the column offset.
`Date`	`getDate(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` in the Java programming language.
`Date`	`getDate(int pos, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` in the Java programming language.
`Date`	`getDate(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` in the Java programming language.
`Date`	`getDate(String name, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Date` in the Java programming language.
`Db`	`getDb()` Gets the db associated to the result set
`DMoney`	`getDMoney(int pos, int ppos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `DMoney` with full precision. Notice that DMoney fields use two fields: one for the value and one for the scale (= name + "P")
`DMoney`	`getDMoney(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `DMoney` with full precision. Notice that DMoney fields use two fields: one for the value and one for the scale (= name + "P")
`double`	`getDouble(int pos)` 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(String name)` 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 pos)` 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(String name)` 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 pos)` 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(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `int` in the Java programming language.
`Integer`	`getInteger(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Integer` in the Java programming language.
`Integer`	`getInteger(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as an `Integer` in the Java programming language.
`long`	`getLong(int pos)` 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(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `long` in the Java programming language.
`int`	`getRow()` Retrieves the current row number.
`short`	`getShort(int pos)` 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(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `short` in the Java programming language.
`String`	`getString(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`String`	`getString(int pos, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`String`	`getString(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`String`	`getString(String name, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `String` in the Java programming language.
`Time`	`getTime(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` in the Java programming language.
`Time`	`getTime(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Time` in the Java programming language.
`Timestamp`	`getTimestamp(int pos)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` in the Java programming language.
`Timestamp`	`getTimestamp(int pos, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` in the Java programming language.
`Timestamp`	`getTimestamp(String name)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` in the Java programming language.
`Timestamp`	`getTimestamp(String name, boolean mapNull)` Retrieves the value of the designated column in the current row of this `ResultSet` object as a `java.sql.Timestamp` in the Java programming language.
`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`	`isClosed()` Determines whether the result set is closed.
`boolean`	`isCloseStatementOnclose()` Gets the statement-on-close flag.
`boolean`	`isCommitOnClose()` Gets the commit-on-close flag.
`boolean`	`last()` Moves the cursor to the last row in this `ResultSet` object.
`boolean`	`next()` Moves the cursor froward one row from its current position.
`boolean`	`previous()` Moves the cursor to the previous row in this `ResultSet` object.
`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`	`setCloseStatementOnclose(boolean closeStatementOnClose)` Set the statement to be closed when result set is closed.
`void`	`setColumnOffset(int columnOffset)` Sets the column offset.
`void`	`setCommitOnClose(boolean commitOnClose)` Set whether to commit() before close() or not. Some dbms (e.g.
`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.
`String`	`toString()` Returns a string representation of the object.
`void`	`updateBinary(int p, Binary b)` Updates the designated column with a `Binary` value.
`void`	`updateBinary(String name, Binary b)` Updates the designated column with a `Binary` value.
`void`	`updateBMoney(int pos, int ppos, BMoney m)` Updates the designated column with a `BMoney` value.
`void`	`updateBMoney(String name, BMoney m)` Updates the designated column with a `BMoney` value.
`void`	`updateBoolean(int p, boolean b)` Updates the designated column with a `boolean` value.
`void`	`updateBoolean(int p, Boolean b)` Updates the designated column with a `Boolean` value.
`void`	`updateBoolean(String name, boolean b)` Updates the designated column with a `boolean` value.
`void`	`updateBoolean(String name, Boolean b)` Updates the designated column with a `Boolean` value.
`void`	`updateByte(int p, byte b)` Updates the designated column with a `byte` value.
`void`	`updateByte(int p, Byte b)` Updates the designated column with a `Byte` value.
`void`	`updateByte(String name, byte b)` Updates the designated column with a `byte` value.
`void`	`updateByte(String name, Byte b)` Updates the designated column with a `Byte` value.
`void`	`updateDate(int p, Date d)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(int p, Date d, boolean mapNull)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(String name, Date d)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDate(String name, Date d, boolean mapNull)` Updates the designated column with a `java.sql.Date` value.
`void`	`updateDMoney(int pos, int ppos, DMoney m)` Updates the designated column with a `DMoney` value.
`void`	`updateDMoney(String name, DMoney m)` Updates the designated column with a `DMoney` value.
`void`	`updateDouble(int p, double d)` Updates the designated column with a `double` value.
`void`	`updateDouble(int p, Double d)` Updates the designated column with a `Double` value.
`void`	`updateDouble(String name, double d)` Updates the designated column with a `double` value.
`void`	`updateDouble(String name, Double d)` Updates the designated column with a `Double` value.
`void`	`updateFloat(int p, float f)` Updates the designated column with a `float` value.
`void`	`updateFloat(int p, Float f)` Updates the designated column with a `Float` value.
`void`	`updateFloat(String name, float f)` Updates the designated column with a `float` value.
`void`	`updateFloat(String name, Float f)` Updates the designated column with a `Float` value.
`void`	`updateInt(int p, int i)` Updates the designated column with an `int` value.
`void`	`updateInt(String name, int i)` Updates the designated column with an `int` value.
`void`	`updateInteger(int p, Integer i)` Updates the designated column with an `Integer` value.
`void`	`updateInteger(String name, Integer i)` Updates the designated column with an `Integer` value.
`void`	`updateLong(int p, long l)` Updates the designated column with a `long` value.
`void`	`updateLong(int p, Long l)` Updates the designated column with a `Long` value.
`void`	`updateLong(String name, long l)` Updates the designated column with a `long` value.
`void`	`updateLong(String name, Long l)` Updates the designated column with a `Long` value.
`void`	`updateNull(int p)` Updates the designated column with a `null` value.
`void`	`updateNull(String name)` Updates the designated column with a `null` value.
`boolean`	`updateRow()` Updates the underlying database with the new contents of the current row of this `ResultSet` object.
`void`	`updateShort(int p, short s)` Updates the designated column with a `short` value.
`void`	`updateShort(int p, Short s)` Updates the designated column with a `Short` value.
`void`	`updateShort(String name, short s)` Updates the designated column with a `short` value.
`void`	`updateShort(String name, Short s)` Updates the designated column with a `Short` value.
`void`	`updateString(int p, String s)` Updates the designated column with a `String` value.
`void`	`updateString(int p, String s, boolean mapNull)` Updates the designated column with a `String` value.
`void`	`updateString(String name, String s)` Updates the designated column with a `String` value.
`void`	`updateString(String name, String s, boolean mapNull)` Updates the designated column with a `String` value.
`void`	`updateTime(int p, Time t)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTime(String name, Time t)` Updates the designated column with a `java.sql.Time` value.
`void`	`updateTimestamp(int p, Timestamp ts)` Updates the designated column with a `java.sql.Timestamp` value.
`void`	`updateTimestamp(int p, Timestamp ts, boolean mapNull)` Updates the designated column with a `java.sql.Timestamp` value.
`void`	`updateTimestamp(String name, Timestamp ts)` Updates the designated column with a `java.sql.Timestamp` value.
`void`	`updateTimestamp(String name, Timestamp ts, boolean mapNull)` 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 java.lang.Object
`clone, equals, getClass, hashCode, notify, notifyAll, wait, wait, wait`

Constructor Detail

ResultSetWrapper

public ResultSetWrapper(StatementWrapper stmt,
                        ResultSet rs)

Creates a wrapper for the given result set.

Parameters:: stmt - is the prepared statement wrapper that created this resultset; rs - the original result-set

Method Detail

getDb

public Db getDb()

Gets the db associated to the result set

Returns:: the db

toString

public String toString()

Description copied from class: java.lang.Object

Returns a string representation of the object. In general, the toString method returns a string that "textually represents" this object. The result should be a concise but informative representation that is easy for a person to read. It is recommended that all subclasses override this method.

The toString method for class Object returns a string consisting of the name of the class of which the object is an instance, the at-sign character `@', and the unsigned hexadecimal representation of the hash code of the object. In other words, this method returns a string equal to the value of:

 getClass().getName() + '@' + Integer.toHexString(hashCode())

Overrides:: toString in class Object

Returns:: a string representation of the object.

close

public void close()

Closes the resultset.

isClosed

public boolean isClosed()

Determines whether the result set is closed.

Returns:: true if closed

finalize

protected void finalize()
                 throws Throwable

Overridden to close forgotten resultsets.

Overrides:: finalize in class Object

Throws:: Throwable - the Exception raised by this method

setCommitOnClose

public void setCommitOnClose(boolean commitOnClose)

Set whether to commit() before close() or not.
Some dbms (e.g. Postgres) cannot use cursors outside of a transaction. In this case a transaction must be started before executeQuery() (see PreparedStatementWrapper and Query). and closed when the resultset (or the cursor) is closed. The default is not to commit on close.

Parameters:: commitOnClose - true if commit on close

isCommitOnClose

public boolean isCommitOnClose()

Gets the commit-on-close flag.

Returns:: true if commit on close

setCloseStatementOnclose

public void setCloseStatementOnclose(boolean closeStatementOnClose)

Set the statement to be closed when result set is closed. By default the statement remains open.

Parameters:: closeStatementOnClose - true if close statement on close

isCloseStatementOnclose

public boolean isCloseStatementOnclose()

Gets the statement-on-close flag.

Returns:: true if close statement on close

setColumnOffset

public void setColumnOffset(int columnOffset)

Sets the column offset. Useful for eager loading or joining in general.

Parameters:: columnOffset - (default is 0)

getColumnOffset

public int getColumnOffset()

Gets the column offset.

Returns:: the current columnOffset

findColumn

public int findColumn(String name)

Finds the column index to a string.

Parameters:: name - the name of the field (column)
Returns:: the index in the result set

setFetchSize

public 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. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. The default value is set by the Statement object that created the result set. The fetch size may be changed at any time.

Parameters:: rows - the number of rows to fetch
See Also:: getFetchSize()

getFetchSize

public int getFetchSize()

Retrieves the fetch size for this ResultSet object.

Returns:: the current fetch size for this ResultSet object
See Also:: setFetchSize(int)

setFetchDirection

public void setFetchDirection(int direction)

Gives a hint as to the direction in which the rows in this ResultSet object will be processed. The initial value is determined by the Statement object that produced this ResultSet object. The fetch direction may be changed at any time.

Parameters:: direction - an int specifying the suggested fetch direction; one of ResultSet.FETCH_FORWARD, ResultSet.FETCH_REVERSE, or ResultSet.FETCH_UNKNOWN
See Also:: StatementWrapper.setFetchDirection(int), getFetchDirection()

getFetchDirection

public int getFetchDirection()

Retrieves the fetch direction for this ResultSet object.

Returns:: the current fetch direction for this ResultSet object
See Also:: setFetchDirection(int)

public boolean next()

Moves the cursor froward 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.

When a call to the next method returns false, the cursor is positioned after the last row. Any invocation of a ResultSet method which requires a current row will result in a SQLException being thrown. If the result set type is TYPE_FORWARD_ONLY, it is vendor specified whether their JDBC driver implementation will return false or throw an SQLException on a subsequent call to next.

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.

Returns:: true if the new current row is valid; false if there are no more rows

public boolean previous()

Moves the cursor to the previous row in this ResultSet object.

When a call to the previous method returns false, the cursor is positioned before the first row. Any invocation of a ResultSet method which requires a current row will result in a SQLException being thrown.

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

Returns:: true if the cursor is now positioned on a valid row; false if the cursor is positioned before the first row

first

public boolean first()

Moves the cursor to the first row in this ResultSet object.

Returns:: true if the cursor is on a valid row; false if there are no rows in the result set

last

public boolean last()

Moves the cursor to the last row in this ResultSet object.

Returns:: true if the cursor is on a valid row; false if there are no rows in the result set

beforeFirst

public void beforeFirst()

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.

afterLast

public void afterLast()

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.

isBeforeFirst

public boolean isBeforeFirst()

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

Note:Support for the isBeforeFirst method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY

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

isAfterLast

public boolean isAfterLast()

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

Note:Support for the isAfterLast method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY

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

getRow

public int getRow()

Retrieves the current row number. The first row is number 1, the second number 2, and so on.

Note:Support for the getRow method is optional for ResultSets with a result set type of TYPE_FORWARD_ONLY

Returns:: the current row number; 0 if there is no current row

absolute

public boolean absolute(int row)

Moves the cursor to the given row number in this ResultSet object.

If the row number is positive, the cursor moves to the given row number with respect to the beginning of the result set. The first row is row 1, the second is row 2, and so on.

If the given row number is negative, the cursor moves to an absolute row position with respect to the end of the result set. For example, calling the method absolute(-1) positions the cursor on the last row; calling the method absolute(-2) moves the cursor to the next-to-last row, and so on.

An attempt to position the cursor beyond the first/last row in the result set leaves the cursor before the first row or after the last row.

Note: Calling absolute(1) is the same as calling first(). Calling absolute(-1) is the same as calling last().

Parameters:: row - the number of the row to which the cursor should move. A positive number indicates the row number counting from the beginning of the result set; a negative number indicates the row number counting from the end of the result set
Returns:: true if the cursor is moved to a position in this ResultSet object; false if the cursor is before the first row or after the last row

relative

public boolean relative(int rows)

Moves the cursor a relative number of rows, either positive or negative. Attempting to move beyond the first/last row in the result set positions the cursor before/after the the first/last row. Calling relative(0) is valid, but does not change the cursor position.

Note: Calling the method relative(1) is identical to calling the method next() and calling the method relative(-1) is identical to calling the method previous().

Parameters:: rows - an int specifying the number of rows to move from the current row; a positive number moves the cursor forward; a negative number moves the cursor backward
Returns:: true if the cursor is on a row; false otherwise

updateRow

public boolean updateRow()

Updates the underlying database with the new contents of the current row of this ResultSet object. This method cannot be called when the cursor is on the insert row.

Returns:: true if updated

deleteRow

public boolean deleteRow()

Deletes the current row from this ResultSet object and from the underlying database. This method cannot be called when the cursor is on the insert row.

Returns:: true if deleted

refreshRow

public void refreshRow()

Refreshes the current row with its most recent value in the database. This method cannot be called when the cursor is on the insert row.

The refreshRow method provides a way for an application to explicitly tell the JDBC driver to refetch a row(s) from the database. An application may want to call refreshRow when caching or prefetching is being done by the JDBC driver to fetch the latest value of a row from the database. The JDBC driver may actually refresh multiple rows at once if the fetch size is greater than one.

All values are refetched subject to the transaction isolation level and cursor sensitivity. If refreshRow is called after calling an updater method, but before calling the method updateRow, then the updates made to the row are lost. Calling the method refreshRow frequently will likely slow performance.

rowUpdated

public boolean rowUpdated()

Retrieves whether the current row has been updated. The value returned depends on whether or not the result set can detect updates.

Note: Support for the rowUpdated method is optional with a result set concurrency of CONCUR_READ_ONLY

Returns:: true if the current row is detected to have been visibly updated by the owner or another; false otherwise

rowInserted

public boolean rowInserted()

Retrieves whether the current row has had an insertion. The value returned depends on whether or not this ResultSet object can detect visible inserts.

Note: Support for the rowInserted method is optional with a result set concurrency of CONCUR_READ_ONLY

Returns:: true if the current row is detected to have been inserted; false otherwise

rowDeleted

public boolean rowDeleted()

Retrieves whether a row has been deleted. A deleted row may leave a visible "hole" in a result set. This method can be used to detect holes in a result set. The value returned depends on whether or not this ResultSet object can detect deletions.

Note: Support for the rowDeleted method is optional with a result set concurrency of CONCUR_READ_ONLY

Returns:: true if the current row is detected to have been deleted by the owner or another; false otherwise

wasNull

public boolean wasNull()

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.

Returns:: true if the last column value read was SQL NULL and false otherwise

getString

public String getString(String name,
                        boolean mapNull)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; mapNull - if empty strings should be treated as null values
Returns:: the column value; if the value is SQL NULL, the value returned is null

getString

public String getString(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null
See Also:: getString(java.lang.String, boolean)

getBoolean

public boolean getBoolean(String name)

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

If the designated column has a datatype of CHAR or VARCHAR and contains a "0" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 0, a value of false is returned. If the designated column has a datatype of CHAR or VARCHAR and contains a "1" or has a datatype of BIT, TINYINT, SMALLINT, INTEGER or BIGINT and contains a 1, a value of true is returned.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is false

getABoolean

public Boolean getABoolean(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getFloat

public float getFloat(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getAFloat

public Float getAFloat(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getDouble

public double getDouble(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getADouble

public Double getADouble(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getBigDecimal

public BigDecimal getBigDecimal(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

getBMoney

public BMoney getBMoney(String name)

Retrieves the value of the designated column in the current row of this ResultSet object as a BMoney with full precision.
Notice that BMoney fields use two fields: one for the value and one for the scale (= name + "P")

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

getDMoney

public DMoney getDMoney(String name)

Retrieves the value of the designated column in the current row of this ResultSet object as a DMoney with full precision.
Notice that DMoney fields use two fields: one for the value and one for the scale (= name + "P")

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

getByte

public byte getByte(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getAByte

public Byte getAByte(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getChar

public char getChar(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL or the empty string, the value returned is 0

getCharacter

public Character getCharacter(String name,
                              boolean mapNull)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.; mapNull - if blanks should be treated as null values
Returns:: the column value; if the value is SQL NULL, the value returned is null. If the value is the empty string the returned value is new Character(0).

getCharacter

public Character getCharacter(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column.
Returns:: the column value; if the value is SQL NULL, the value returned is null. If the value is the empty string the returned value is new Character(0).

getShort

public short getShort(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getAShort

public Short getAShort(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getInt

public int getInt(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getInteger

public Integer getInteger(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getLong

public long getLong(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getALong

public Long getALong(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getDate

public Date getDate(String name,
                    boolean mapNull)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; mapNull - true if 1.1.1970 should be mapped to null
Returns:: the column value; if the value is SQL NULL, the value returned is null

getDate

public Date getDate(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getTimestamp

public Timestamp getTimestamp(String name,
                              boolean mapNull)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; mapNull - true if 1.1.1970 00:00:00.000 should be mapped to null
Returns:: the column value; if the value is SQL NULL, the value returned is null

getTimestamp

public Timestamp getTimestamp(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getTime

public Time getTime(String name)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column
Returns:: the column value; if the value is SQL NULL, the value returned is null

getBinary

public Binary getBinary(String name,
                        int bufSize)

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

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; bufSize - the initial buffersize for the Binary
Returns:: the binary read from db

getString

public String getString(int pos,
                        boolean mapNull)

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

Parameters:: pos - the parameter index in the result set; mapNull - if empty strings should be treated as null values
Returns:: the column value; if the value is SQL NULL, the value returned is null

getString

public String getString(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null
See Also:: getString(java.lang.String, boolean)

getBoolean

public boolean getBoolean(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is false

getABoolean

public Boolean getABoolean(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getFloat

public float getFloat(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getAFloat

public Float getAFloat(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getDouble

public double getDouble(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getADouble

public Double getADouble(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getBigDecimal

public BigDecimal getBigDecimal(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

getBMoney

public BMoney getBMoney(int pos,
                        int ppos)

Parameters:: pos - the parameter index for the amount in the result set; ppos - the parameter index for the scale in the result set
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

getDMoney

public DMoney getDMoney(int pos,
                        int ppos)

Parameters:: pos - the parameter index for the amount in the result set; ppos - the parameter index for the scale in the result set
Returns:: the column value (full precision); if the value is SQL NULL, the value returned is null in the Java programming language.

getByte

public byte getByte(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getAByte

public Byte getAByte(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getChar

public char getChar(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL or the empty string, the value returned is 0

getCharacter

public Character getCharacter(int pos,
                              boolean mapNull)

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

Parameters:: pos - the parameter index in the result set; mapNull - if blanks should be treated as null values
Returns:: the column value; if the value is SQL NULL, the value returned is null. If the value is the empty string the returned value is new Character(0).

getCharacter

public Character getCharacter(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null. If the value is the empty string the returned value is new Character(0).

getShort

public short getShort(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getAShort

public Short getAShort(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getInt

public int getInt(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getInteger

public Integer getInteger(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getLong

public long getLong(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is 0

getALong

public Long getALong(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getDate

public Date getDate(int pos,
                    boolean mapNull)

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

Parameters:: pos - the parameter index in the result set; mapNull - true if 1.1.1970 should be mapped to null
Returns:: the column value; if the value is SQL NULL, the value returned is null

getDate

public Date getDate(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getTimestamp

public Timestamp getTimestamp(int pos,
                              boolean mapNull)

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

Parameters:: pos - the parameter index in the result set; mapNull - true if 1.1.1970 00:00:00.000 should be mapped to null
Returns:: the column value; if the value is SQL NULL, the value returned is null

getTimestamp

public Timestamp getTimestamp(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getTime

public Time getTime(int pos)

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

Parameters:: pos - the parameter index in the result set
Returns:: the column value; if the value is SQL NULL, the value returned is null

getBinary

public Binary getBinary(int pos,
                        int bufSize)

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

Parameters:: pos - the parameter index in the result set; bufSize - the initial buffersize for the Binary
Returns:: the binary read from db

updateNull

public void updateNull(String name)

Updates the designated column with a null value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column

updateString

public void updateString(String name,
                         String s,
                         boolean mapNull)

Updates the designated column with a String value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; s - the new column value; mapNull - true if null values should be mapped to the empty string, else SQL NULL

updateString

public void updateString(String name,
                         String s)

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; s - the new column value

updateBoolean

public void updateBoolean(String name,
                          boolean b)

Updates the designated column with a boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; b - the new column value

updateBoolean

public void updateBoolean(String name,
                          Boolean b)

Updates the designated column with a Boolean value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; b - the new column value, null for SQL NULL

updateByte

public void updateByte(String name,
                       byte b)

Updates the designated column with a byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; b - the new column value

updateByte

public void updateByte(String name,
                       Byte b)

Updates the designated column with a Byte value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; b - the new column value, null for SQL NULL

updateShort

public void updateShort(String name,
                        short s)

Updates the designated column with a short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; s - the new column value

updateShort

public void updateShort(String name,
                        Short s)

Updates the designated column with a Short value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; s - the new column value, null for SQL NULL

updateInt

public void updateInt(String name,
                      int i)

Updates the designated column with an int value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; i - the new column value

updateInteger

public void updateInteger(String name,
                          Integer i)

Updates the designated column with an Integer value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; i - the new column value, null for SQL NULL

updateLong

public void updateLong(String name,
                       long l)

Updates the designated column with a long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; l - the new column value

updateLong

public void updateLong(String name,
                       Long l)

Updates the designated column with a Long value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; l - the new column value, null for SQL NULL

updateFloat

public void updateFloat(String name,
                        float f)

Updates the designated column with a float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; f - the new column value

updateFloat

public void updateFloat(String name,
                        Float f)

Updates the designated column with a Float value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; f - the new column value, null for SQL NULL

updateDouble

public void updateDouble(String name,
                         double d)

Updates the designated column with a double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; d - the new column value

updateDouble

public void updateDouble(String name,
                         Double d)

Updates the designated column with a Double value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; d - the new column value, null for SQL NULL

updateBMoney

public void updateBMoney(String name,
                         BMoney m)

Updates the designated column with a BMoney value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

A BMoney will not be stored as a DECIMAL, but as 2 fields:

a double representing the value
an int representing the scale

This is due to most DBMS can't store arbitrary scaled decimals in a single column, i.e. all values in the column must have the same scale.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; m - the money amount

updateDMoney

public void updateDMoney(String name,
                         DMoney m)

Updates the designated column with a DMoney value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

A BMoney will not be stored as a DECIMAL, but as 2 fields:

a BigDecimal with a scale of 0 representing the value
an int representing the scale

This is due to most DBMS can't store arbitrary scaled decimals in a single column, i.e. all values in the column must have the same scale.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; m - the money amount

updateDate

public void updateDate(String name,
                       Date d,
                       boolean mapNull)

Updates the designated column with a java.sql.Date value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; d - the new column value; mapNull - to map null values to 1.1.1970 (epochal time zero), else SQL NULL

updateDate

public void updateDate(String name,
                       Date d)

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; d - the new column value, null for SQL NULL

updateTimestamp

public void updateTimestamp(String name,
                            Timestamp ts,
                            boolean mapNull)

Updates the designated column with a java.sql.Timestamp value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; ts - the new column value; mapNull - to map null values to 1.1.1970 00:00:00.000 (epochal time zero), else SQL NULL

updateTimestamp

public void updateTimestamp(String name,
                            Timestamp ts)

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; ts - the new column value, null for SQL NULL

updateTime

public void updateTime(String name,
                       Time t)

Updates the designated column with a java.sql.Time value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; t - the new column value, null for SQL NULL

updateBinary

public void updateBinary(String name,
                         Binary b)

Updates the designated column with a Binary value. The updater methods are used to update column values in the current row or the insert row. The updater methods do not update the underlying database; instead the updateRow or insertRow methods are called to update the database.
The implementation translates the Binary into an Inputstream and invokes ResultSet.updateBinaryStream(String, java.io.InputStream, int).

Parameters:: name - the label for the column specified with the SQL AS clause. If the SQL AS clause was not specified, then the label is the name of the column; b - the new column value, null for SQL NULL

updateNull

public void updateNull(int p)

Parameters:: p - the first column is 1, the second is 2, ...

updateString

public void updateString(int p,
                         String s,
                         boolean mapNull)

Parameters:: p - the first column is 1, the second is 2, ...; s - the new column value; mapNull - true if null values should be mapped to the empty string, else SQL NULL

updateString

public void updateString(int p,
                         String s)

Parameters:: p - the first column is 1, the second is 2, ...; s - the new column value

updateBoolean

public void updateBoolean(int p,
                          boolean b)

Parameters:: p - the first column is 1, the second is 2, ...; b - the new column value

updateBoolean

public void updateBoolean(int p,
                          Boolean b)

Parameters:: p - the first column is 1, the second is 2, ...; b - the new column value, null for SQL NULL

updateByte

public void updateByte(int p,
                       byte b)

Parameters:: p - the first column is 1, the second is 2, ...; b - the new column value

updateByte

public void updateByte(int p,
                       Byte b)

Parameters:: p - the first column is 1, the second is 2, ...; b - the new column value, null for SQL NULL

updateShort

public void updateShort(int p,
                        short s)

Parameters:: p - the first column is 1, the second is 2, ...; s - the new column value

updateShort

public void updateShort(int p,
                        Short s)

Parameters:: p - the first column is 1, the second is 2, ...; s - the new column value, null for SQL NULL

updateInt

public void updateInt(int p,
                      int i)

Parameters:: p - the first column is 1, the second is 2, ...; i - the new column value

updateInteger

public void updateInteger(int p,
                          Integer i)

Parameters:: p - the first column is 1, the second is 2, ...; i - the new column value, null for SQL NULL

updateLong

public void updateLong(int p,
                       long l)

Parameters:: p - the first column is 1, the second is 2, ...; l - the new column value

updateLong

public void updateLong(int p,
                       Long l)

Parameters:: p - the first column is 1, the second is 2, ...; l - the new column value, null for SQL NULL

updateFloat

public void updateFloat(int p,
                        float f)

Parameters:: p - the first column is 1, the second is 2, ...; f - the new column value

updateFloat

public void updateFloat(int p,
                        Float f)

Parameters:: p - the first column is 1, the second is 2, ...; f - the new column value, null for SQL NULL

updateDouble

public void updateDouble(int p,
                         double d)

Parameters:: p - the first column is 1, the second is 2, ...; d - the new column value

updateDouble

public void updateDouble(int p,
                         Double d)

Parameters:: p - the first column is 1, the second is 2, ...; d - the new column value, null for SQL NULL

updateBMoney

public void updateBMoney(int pos,
                         int ppos,
                         BMoney m)

A BMoney will not be stored as a DECIMAL, but as 2 fields:

a double representing the value
an int representing the scale

This is due to most DBMS can't store arbitrary scaled decimals in a single column, i.e. all values in the column must have the same scale.

Parameters:: pos - the positional index of the amount; ppos - the positional index of the scale; m - the money amount

updateDMoney

public void updateDMoney(int pos,
                         int ppos,
                         DMoney m)

A BMoney will not be stored as a DECIMAL, but as 2 fields:

a BigDecimal with a scale of 0 representing the value
an int representing the scale

This is due to most DBMS can't store arbitrary scaled decimals in a single column, i.e. all values in the column must have the same scale.

Parameters:: pos - the positional index of the amount; ppos - the positional index of the scale; m - the money amount

updateDate

public void updateDate(int p,
                       Date d,
                       boolean mapNull)

Parameters:: p - the first column is 1, the second is 2, ...; d - the new column value; mapNull - to map null values to 1.1.1970 (epochal time zero), else SQL NULL

updateDate

public void updateDate(int p,
                       Date d)

Parameters:: p - the first column is 1, the second is 2, ...; d - the new column value, null for SQL NULL

updateTimestamp

public void updateTimestamp(int p,
                            Timestamp ts,
                            boolean mapNull)

Parameters:: p - the first column is 1, the second is 2, ...; ts - the new column value; mapNull - to map null values to 1.1.1970 00:00:00.000 (epochal time zero), else SQL NULL

updateTimestamp

public void updateTimestamp(int p,
                            Timestamp ts)

Parameters:: p - the first column is 1, the second is 2, ...; ts - the new column value, null for SQL NULL

updateTime

public void updateTime(int p,
                       Time t)

Parameters:: p - the first column is 1, the second is 2, ...; t - the new column value, null for SQL NULL

updateBinary

public void updateBinary(int p,
                         Binary b)

Parameters:: p - the first column is 1, the second is 2, ...; b - the new column value, null for SQL NULL

Overview

Package

Class

Use

Tree

Deprecated

Index

Help

PREV CLASS NEXT CLASS

FRAMES NO FRAMES

SUMMARY: NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

org.tentackle.db Class ResultSetWrapper

ResultSetWrapper

getDb

toString

close

isClosed

finalize

setCommitOnClose

isCommitOnClose

setCloseStatementOnclose

isCloseStatementOnclose

setColumnOffset

getColumnOffset

findColumn

setFetchSize

getFetchSize

setFetchDirection

getFetchDirection

next

previous

first

last

beforeFirst

afterLast

isBeforeFirst

isAfterLast

getRow

absolute

relative

updateRow

deleteRow

refreshRow

rowUpdated

rowInserted

rowDeleted

wasNull

getString

getString

getBoolean

getABoolean

getFloat

getAFloat

getDouble

getADouble

getBigDecimal

getBMoney

getDMoney

getByte

getAByte

getChar

getCharacter

getCharacter

getShort

getAShort

getInt

getInteger

getLong

getALong

getDate

getDate

getTimestamp

getTimestamp

getTime

getBinary

getString

getString

getBoolean

getABoolean

getFloat

getAFloat

getDouble

getADouble

getBigDecimal

getBMoney

getDMoney

getByte

getAByte

getChar

getCharacter

getCharacter

org.tentackle.db
Class ResultSetWrapper