| java.lang.Object org.continuent.sequoia.driver.DriverResultSet
DriverResultSet | public class DriverResultSet implements java.sql.ResultSet,java.io.Serializable,java.lang.Cloneable(Code) | | A ResultSet provides access to a table of data generated by
executing a Statement. The table rows are retrieved in sequence. Within a row
its column values can be accessed in any order.
A ResultSet maintains a cursor pointing to its current row of
data. Initially the cursor is positioned before the first row. The 'next'
method moves the cursor to the next row.
The getXXX methods retrieve column values for the current row.
You can retrieve values either using the index number of the column, or by
using the name of the column. In general using the column index will be more
efficient. Columns are numbered from 1.
For maximum portability, ResultSet columns within each row
should be read in left-to-right order and each column should be read only
once.
For the getXXX methods, the JDBC driver attempts to convert
the underlying data to the specified Java type and returns a suitable Java
value. See the JDBC specification for allowable mappings from SQL types to
Java types with the ResultSet getXXX methods.
Column names used as input to getXXX methods are case
insenstive. When performing a getXXX using a column name, if
several columns have the same name, then the value of the first matching
column will be returned. The column name option is designed to be used when
column names are used in the SQL Query. For columns that are NOT explicitly
named in the query, it is best to use column numbers. If column names were
used there is no way for the programmer to guarentee that they actually refer
to the intended columns.
A ResultSet is automatically closed by the
Statement that generated it when that Statement
is closed, re-executed, or is used to retrieve the next result from a
sequence of multiple results.
The number, types and properties of a ResultSet's columns are provided by the
ResultSetMetaData object returned by the
getMetaData method.
See Also: java.sql.ResultSetMetaData See Also: java.sql.ResultSet author: Mark Matthews author: Emmanuel Cecchet author: Alexander Laamanen author: author: Nicolas Modrzyk author: Jean-Bernard van Zuylen author: author: Marc Herbert author: Edward Archibald author: Stephane Giron version: 1.0 |
Method Summary | |
public boolean | absolute(int row) JDBC 2.0
Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the beginning
of the result set. | public void | afterLast() JDBC 2.0
Moves to the end of the result set, just after the last row. | public void | beforeFirst() JDBC 2.0
Moves to the front of the result set, just before the first row. | public void | cancelRowUpdates() JDBC 2.0 The cancelRowUpdates() method may be called after calling an
updateXXX() method(s) and before calling updateRow() to rollback the
updates made to a row. | public void | clearWarnings() | public void | close() Closes the remote ResultSet if the ResultSet was streamed else just closes
the ResultSet locally. | public void | deleteRow() JDBC 2.0 Delete the current row from the result set and the underlying
database. | protected void | finalize() Tells the controller we don't need this ResultSet anymore (ie. | public int | findColumn(String columnName) | public boolean | first() JDBC 2.0
Moves to the first row in the result set. | public java.sql.Array | getArray(int columnIndex) JDBC 2.0 Gets an array column.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public java.sql.Array | getArray(String colName) JDBC 2.0 Get an array column. | public InputStream | getAsciiStream(int columnIndex) A column value can be retrieved as a stream of ASCII characters and then
read in chunks from the stream. | public InputStream | getAsciiStream(String columnName) | public BigDecimal | getBigDecimal(int columnIndex, int scale) | public BigDecimal | getBigDecimal(String columnName, int scale) | public BigDecimal | getBigDecimal(int columnIndex) JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public BigDecimal | getBigDecimal(String columnName) | public InputStream | getBinaryStream(int columnIndex) A column value can also be retrieved as a binary strea. | public InputStream | getBinaryStream(String columnName) | public java.sql.Blob | getBlob(int columnIndex) JDBC 2.0 Gets a BLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public java.sql.Blob | getBlob(String colName) JDBC 2.0 Get a BLOB column. | public boolean | getBoolean(int columnIndex) Get the value of a column in the current row as a Java boolean
Parameters: columnIndex - the first column is 1, the second is 2... | public boolean | getBoolean(String columnName) | public byte | getByte(String columnName) | public byte | getByte(int columnIndex) Get the value of a column in the current row as a Java byte.
Parameters: columnIndex - the first column is 1, the second is 2,... | public byte[] | getBytes(int columnIndex) Get the value of a column in the current row as a Java byte array.
Be warned If the blob is huge, then you may run out of memory.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public byte[] | getBytes(String columnName) | public java.io.Reader | getCharacterStream(int columnIndex) | public java.io.Reader | getCharacterStream(String columnName) | public java.sql.Clob | getClob(int columnIndex) JDBC 2.0 Gets a CLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... | public java.sql.Clob | getClob(String colName) JDBC 2.0 Get a CLOB column. | public int | getConcurrency() JDBC 2.0 Return the concurrency of this result set. | public String | getCursorName() | public java.sql.Date | getDate(int columnIndex) Get the value of a column in the current row as a java.sql.Date object
Parameters: columnIndex - the first column is 1, the second is 2... | public java.sql.Date | getDate(String columnName) | public java.sql.Date | getDate(int columnIndex, Calendar cal) JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object. | public java.sql.Date | getDate(String columnName, Calendar cal) Get the value of a column in the current row as a java.sql.Date object. | public double | getDouble(int columnIndex) Get the value of a column in the current row as a Java double.
Parameters: columnIndex - the first column is 1, the second is 2,... | public double | getDouble(String columnName) | public int | getFetchDirection() JDBC 2.0 Return the fetch direction for this result set. | public int | getFetchSize() JDBC 2.0 Return the fetch size for this result set. | public float | getFloat(int columnIndex) Get the value of a column in the current row as a Java float.
Parameters: columnIndex - the first column is 1, the second is 2,... | public float | getFloat(String columnName) | public int | getInt(int columnIndex) Get the value of a column in the current row as a Java int.
Parameters: columnIndex - the first column is 1, the second is 2,... | public int | getInt(String columnName) | public long | getLong(int columnIndex) Get the value of a column in the current row as a Java long.
Parameters: columnIndex - the first column is 1, the second is 2,... | public long | getLong(String columnName) | public java.sql.ResultSetMetaData | getMetaData() | public Object | getObject(int columnIndex) Get the value of a column in the current row as a Java object
This method will return the value of the given column as a Java object. | public Object | getObject(String columnName) Get the value of a column in the current row as a Java object
This method will return the value of the given column as a Java object. | public Object | getObject(int i, java.util.Map map) JDBC 2.0 Returns the value of column as a Java object. | public Object | getObject(String colName, java.util.Map map) JDBC 2.0 Returns the value of column as a Java object. | public java.sql.Ref | getRef(int i) JDBC 2.0 Get a REF(<structured-type>) column.
Parameters: i - the first column is 1, the second is 2, ... | public java.sql.Ref | getRef(String colName) JDBC 2.0 Get a REF(<structured-type>) column. | public int | getRow() JDBC 2.0
Determine the current row number. | public short | getShort(int columnIndex) Get the value of a column in the current row as a Java short.
Parameters: columnIndex - the first column is 1, the second is 2,... | public short | getShort(String columnName) | public java.sql.Statement | getStatement() JDBC 2.0 Return the Statement that produced the
ResultSet . | SQLWarning | getStatementWarnings() | public String | getString(int columnIndex) Get the value of a column in the current row as a Java String
Parameters: columnIndex - the first column is 1, the second is 2... | public String | getString(String columnName) The following routines simply convert the columnName into a columnIndex and
then call the appropriate routine above. | public Time | getTime(int columnIndex) Get the value of a column in the current row as a java.sql.Time object
Parameters: columnIndex - the first column is 1, the second is 2... | public Time | getTime(String columnName) | public java.sql.Time | getTime(int columnIndex, Calendar cal) Get the value of a column in the current row as a java.sql.Time object. | public java.sql.Time | getTime(String columnName, Calendar cal) Get the value of a column in the current row as a java.sql.Time object. | public Timestamp | getTimestamp(int columnIndex) Get the value of a column in the current row as a java.sql.Timestamp object
Parameters: columnIndex - the first column is 1, the second is 2... | public Timestamp | getTimestamp(String columnName) | public java.sql.Timestamp | getTimestamp(int columnIndex, Calendar cal) Get the value of a column in the current row as a java.sql.Timestamp
object. | public java.sql.Timestamp | getTimestamp(String columnName, Calendar cal) Get the value of a column in the current row as a java.sql.Timestamp
object. | public int | getType() JDBC 2.0 Return the type of this result set. | public 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.
Parameters: columnIndex - the index of the column 1 is the first, 2 is thesecond,... | public java.net.URL | getURL(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. | public InputStream | getUnicodeStream(int columnIndex) A column value can also be retrieved as a stream of Unicode characters. | public InputStream | getUnicodeStream(String columnName) | public java.sql.SQLWarning | getWarnings() The first warning reported by calls on this ResultSet is returned.
Subsequent ResultSet warnings will be chained to this java.sql.SQLWarning.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by ResultSet
methods. | public void | insertRow() JDBC 2.0 Insert the contents of the insert row into the result set and the
database. | public boolean | isAfterLast() JDBC 2.0
Determine if the cursor is after the last row in the result set.
true if after the last row, false otherwise. | public boolean | isBeforeFirst() JDBC 2.0.
Determine if the cursor is before the first row in the result set.
true if before the first row, false otherwise. | public boolean | isFirst() JDBC 2.0
Determine if the cursor is on the first row of the result set. | public boolean | isLast() JDBC 2.0
Determine if the cursor is on the last row of the result set. | public boolean | last() JDBC 2.0
Moves to the last row in the result set. | public void | moveToCurrentRow() JDBC 2.0 Move the cursor to the remembered cursor position, usually the
current row. | public void | moveToInsertRow() JDBC 2.0 Move to the insert row. | public boolean | next() A ResultSet is initially positioned before its first row, the first call to
next makes the first row the current row; the second call makes the second
row the current row, etc. | public boolean | prev() The prev method is not part of JDBC, but because of the architecture of
this driver it is possible to move both forward and backward within the
result set. | public boolean | previous() JDBC 2.0
Moves to the previous row in the result set. | public void | refreshRow() JDBC 2.0 Refresh the value of the current row with its current value in the
database. | public boolean | relative(int rows) JDBC 2.0
Moves a relative number of rows, either positive or negative. | public boolean | rowDeleted() JDBC 2.0 Determine if this row has been deleted. | public boolean | rowInserted() JDBC 2.0 Determine if the current row has been inserted. | public boolean | rowUpdated() JDBC 2.0 Determine if the current row has been updated. | public void | setFetchDirection(int direction) JDBC 2.0 Give a hint as to the direction in which the rows in this result
set will be processed. | public void | setFetchSize(int rows) | public void | setHasMoreData(boolean hasMore) Set the hasMoreData boolean (is there more data to fetch from the
controller). | protected void | setStatement(Statement stmt) Set the statement. | void | setStatementWarnings(SQLWarning sqlw) | public String | toString() | public void | updateArray(int columnIndex, java.sql.Array x) Updates the designated column with a java.sql.Array value.
The updater methods are used to update column values in the current row or
the insert row. | public void | updateArray(String columnName, java.sql.Array x) Updates the designated column with a java.sql.Array value.
The updater methods are used to update column values in the current row or
the insert row. | public void | updateAsciiStream(int columnIndex, java.io.InputStream x, int length) JDBC 2.0 Update a column with an ascii stream value. | public void | updateAsciiStream(String columnName, java.io.InputStream x, int length) JDBC 2.0 Update a column with an ascii stream value. | public void | updateBigDecimal(int columnIndex, BigDecimal x) JDBC 2.0 Update a column with a BigDecimal value. | public void | updateBigDecimal(String columnName, BigDecimal x) JDBC 2.0 Update a column with a BigDecimal value. | public void | updateBinaryStream(int columnIndex, java.io.InputStream x, int length) JDBC 2.0 Update a column with a binary stream value. | public void | updateBinaryStream(String columnName, java.io.InputStream x, int length) JDBC 2.0 Update a column with a binary stream value. | public void | updateBlob(int columnIndex, java.sql.Blob x) Updates the designated column with a java.sql.Blob value.
The updater methods are used to update column values in the current row or
the insert row. | public void | updateBlob(String columnName, java.sql.Blob x) Updates the designated column with a java.sql.Blob value.
The updater methods are used to update column values in the current row or
the insert row. | public void | updateBoolean(int columnIndex, boolean x) JDBC 2.0 Update a column with a boolean value. | public void | updateBoolean(String columnName, boolean x) JDBC 2.0 Update a column with a boolean value. | public void | updateByte(int columnIndex, byte x) JDBC 2.0 Update a column with a byte value. | public void | updateByte(String columnName, byte x) JDBC 2.0 Update a column with a byte value. | public void | updateBytes(int columnIndex, byte[] x) JDBC 2.0 Update a column with a byte array value. | public void | updateBytes(String columnName, byte[] x) JDBC 2.0 Update a column with a byte array value. | public void | updateCharacterStream(int columnIndex, java.io.Reader x, int length) JDBC 2.0 Update a column with a character stream value. | public void | updateCharacterStream(String columnName, java.io.Reader reader, int length) JDBC 2.0 Update a column with a character stream value. | public void | updateClob(int columnIndex, java.sql.Clob x) Updates the designated column with a java.sql.Clob value.
The updater methods are used to update column values in the current row or
the insert row. | public void | updateClob(String columnName, java.sql.Clob x) Updates the designated column with a java.sql.Clob value.
The updater methods are used to update column values in the current row or
the insert row. | public void | updateDate(int columnIndex, java.sql.Date x) JDBC 2.0 Update a column with a Date value. | public void | updateDate(String columnName, java.sql.Date x) JDBC 2.0 Update a column with a Date value. | public void | updateDouble(int columnIndex, double x) JDBC 2.0 Update a column with a Double value. | public void | updateDouble(String columnName, double x) JDBC 2.0 Update a column with a double value. | public void | updateFloat(int columnIndex, float x) JDBC 2.0 Update a column with a float value. | public void | updateFloat(String columnName, float x) JDBC 2.0 Update a column with a float value. | public void | updateInt(int columnIndex, int x) JDBC 2.0 Update a column with an integer value. | public void | updateInt(String columnName, int x) JDBC 2.0 Update a column with an integer value. | public void | updateLong(int columnIndex, long x) JDBC 2.0 Update a column with a long value. | public void | updateLong(String columnName, long x) JDBC 2.0 Update a column with a long value. | public void | updateNull(int columnIndex) JDBC 2.0 Give a nullable column a null value. | public void | updateNull(String columnName) JDBC 2.0 Update a column with a null value. | public void | updateObject(int columnIndex, Object x, int scale) JDBC 2.0 Update a column with an Object value. | public void | updateObject(int columnIndex, Object x) JDBC 2.0 Update a column with an Object value. | public void | updateObject(String columnName, Object x, int scale) JDBC 2.0 Update a column with an Object value. | public void | updateObject(String columnName, Object x) JDBC 2.0 Update a column with an Object value. | public void | updateRef(int columnIndex, java.sql.Ref x) Updates the designated column with a java.sql.Ref value. | public void | updateRef(String columnName, java.sql.Ref x) Updates the designated column with a java.sql.Ref value. | public void | updateRow() JDBC 2.0 Update the underlying database with the new contents of the
current row. | public void | updateShort(int columnIndex, short x) JDBC 2.0 Update a column with a short value. | public void | updateShort(String columnName, short x) JDBC 2.0 Update a column with a short value. | public void | updateString(int columnIndex, String x) JDBC 2.0 Update a column with a String value. | public void | updateString(String columnName, String x) JDBC 2.0 Update a column with a String value. | public void | updateTime(int columnIndex, java.sql.Time x) JDBC 2.0 Update a column with a Time value. | public void | updateTime(String columnName, java.sql.Time x) JDBC 2.0 Update a column with a Time value. | public void | updateTimestamp(int columnIndex, java.sql.Timestamp x) JDBC 2.0 Update a column with a Timestamp value. | public void | updateTimestamp(String columnName, java.sql.Timestamp x) JDBC 2.0 Update a column with a Timestamp value. | public boolean | wasNull() A column may have the value of SQL NULL; wasNull() reports whether the last
column read had this special value. |
currentRow | protected int currentRow(Code) | | Cursor to current row
|
fetchDirection | protected int fetchDirection(Code) | | The fetch direction (not used yet)
|
fetchSize | protected int fetchSize(Code) | | The fetch size
|
lowerNameToIndex | protected transient Hashtable lowerNameToIndex(Code) | | column name -> index in ResultSet data array
|
nbOfColumns | protected int nbOfColumns(Code) | | Number of columns
|
nbOfRows | protected int nbOfRows(Code) | | Number of rows
|
owningStatement | protected transient Statement owningStatement(Code) | | Statement corresponding to this ResultSet, if any (not for metadata)
|
resultSetConcurrency | protected int resultSetConcurrency(Code) | | Concurrency for this ResultSet
|
resultSetType | protected int resultSetType(Code) | | Type of ResultSet
|
sensitiveNameToIndex | protected transient Hashtable sensitiveNameToIndex(Code) | | case sensitive column name -> index in ResultSet data array
|
statementWarnings | protected SQLWarning statementWarnings(Code) | | warnings associated to the statement that created us
|
wasNullFlag | protected boolean wasNullFlag(Code) | | for wasNull()
|
DriverResultSet | DriverResultSet(Connection conn, boolean empty)(Code) | | Creates a new empty DriverResultSet object
Parameters: empty - MUST be true |
DriverResultSet | public DriverResultSet(Connection conn, ArrayList fromData, Field fromField)(Code) | | Creates a new DriverResultSet object with given data
(currently only supports one column, because it is used only to support
generated keys on batch update, when alwaysGetGeneratedKeys is set to true)
Parameters: conn - Parameters: fromData - List of objects to be inserted in this resultset Parameters: fromField - Metadata for this colum |
absolute | public boolean absolute(int row) throws SQLException(Code) | | JDBC 2.0
Move to an absolute row number in the result set.
If row is positive, moves to an absolute row with respect to the beginning
of the result set. The first row is row 1, the second is row 2, etc.
If row is negative, moves to an absolute row position with respect to the
end of result set. For example, calling absolute(-1) positions the cursor
on the last row, absolute(-2) indicates the next-to-last row, etc.
An attempt to position the cursor beyond the first/last row in the result
set, leaves the cursor before/after the first/last row, respectively.
Note: Calling absolute(1) is the same as calling first(). Calling
absolute(-1) is the same as calling last().
Parameters: row - the row to move to true if on the result set, false if off. exception: SQLException - if a database-access error occurs, or row is 0, orresult set type is TYPE_FORWARD_ONLY. |
afterLast | public void afterLast() throws SQLException(Code) | | JDBC 2.0
Moves to the end of the result set, just after the last row. Has no effect
if the result set contains no rows.
exception: SQLException - if a database-access error occurs, or result settype is TYPE_FORWARD_ONLY. |
beforeFirst | public void beforeFirst() throws SQLException(Code) | | JDBC 2.0
Moves to the front of the result set, just before the first row. Has no
effect if the result set contains no rows.
exception: SQLException - if a database-access error occurs, or result settype is TYPE_FORWARD_ONLY |
cancelRowUpdates | public void cancelRowUpdates() throws SQLException(Code) | | JDBC 2.0 The cancelRowUpdates() method may be called after calling an
updateXXX() method(s) and before calling updateRow() to rollback the
updates made to a row. If no updates have been made or updateRow() has
already been called, then this method has no effect.
exception: SQLException - if a database-access error occurs, or if calledwhen on the insert row. |
clearWarnings | public void clearWarnings() throws SQLException(Code) | | After this call, getWarnings returns null until a new warning is reported
for this ResultSet
exception: SQLException - if a database access error occurs |
close | public void close() throws SQLException(Code) | | Closes the remote ResultSet if the ResultSet was streamed else just closes
the ResultSet locally.
exception: SQLException - if a database access error occurs |
deleteRow | public void deleteRow() throws SQLException(Code) | | JDBC 2.0 Delete the current row from the result set and the underlying
database. Cannot be called when on the insert row.
exception: SQLException - if a database-access error occurs, or if calledwhen on the insert row. |
findColumn | public int findColumn(String columnName) throws SQLException(Code) | | Map a ResultSet column name to a ResultSet
column index
Parameters: columnName - the name of the column the column index exception: SQLException - if a database access error occurs |
first | public boolean first() throws SQLException(Code) | | JDBC 2.0
Moves to the first row in the result set.
true if on a valid row, false if no rows in theresult set. exception: SQLException - if a database-access error occurs, or result settype is TYPE_FORWARD_ONLY. |
getArray | public java.sql.Array getArray(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Gets an array column.
Parameters: columnIndex - the first column is 1, the second is 2, ... an object representing an SQL array exception: SQLException - if a database-access error occurs. |
getAsciiStream | public InputStream getAsciiStream(int columnIndex) throws SQLException(Code) | | A column value can be retrieved as a stream of ASCII characters and then
read in chunks from the stream. This method is particulary 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 get method
implicitly closes the stream. Also, a stream may return 0 for available()
whether there is data available or not.
Parameters: columnIndex - the first column is 1, the second is 2, ... a Java InputStream that delivers the database column value as astream of one byte ASCII characters. If the value is SQL NULL thenthe result is null exception: SQLException - if a database access error occurs See Also: DriverResultSet.getBinaryStream(int) |
getBigDecimal | public BigDecimal getBigDecimal(int columnIndex, int scale) throws SQLException(Code) | | Get the value of a column in the current row as a java.lang.BigDecimal
object
Parameters: columnIndex - the first column is 1, the second is 2... Parameters: scale - the number of digits to the right of the decimal the column value; if the value is SQL NULL, null exception: SQLException - if a database access error occurs |
getBigDecimal | public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Get the value of a column in the current row as a
java.math.BigDecimal object.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value (full precision); if the value is SQL NULL, theresult is null exception: SQLException - if a database-access error occurs. |
getBlob | public java.sql.Blob getBlob(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Gets a BLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... an object representing a BLOB exception: SQLException - if a database-access error occurs. |
getBoolean | public boolean getBoolean(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java boolean
Parameters: columnIndex - the first column is 1, the second is 2... the column value, false for SQL NULL exception: SQLException - if a database access error occurs |
getByte | public byte getByte(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte.
Parameters: columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL exception: SQLException - if a database access error occurs |
getBytes | public byte[] getBytes(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java byte array.
Be warned If the blob is huge, then you may run out of memory.
Parameters: columnIndex - the first column is 1, the second is 2, ... the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database access error occurs |
getClob | public java.sql.Clob getClob(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Gets a CLOB column.
Parameters: columnIndex - the first column is 1, the second is 2, ... an object representing a CLOB exception: SQLException - if a database-access error occurs. |
getConcurrency | public int getConcurrency() throws SQLException(Code) | | JDBC 2.0 Return the concurrency of this result set. The concurrency used is
determined by the statement that created the result set.
CONCUR_READ_ONLY or CONCUR_UPDATABLE exception: SQLException - if a database-access error occurs |
getDate | public java.sql.Date getDate(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object
Parameters: columnIndex - the first column is 1, the second is 2... the column value; null if SQL NULL exception: SQLException - if a database access error occurs |
getDate | public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException(Code) | | JDBC 2.0 Get the value of a column in the current row as a java.sql.Date
object. Use the calendar to construct an appropriate millisecond value for
the Date, if the underlying database doesn't store timezone information.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: cal - the calendar to use in constructing the date (ignored) the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getDate | public java.sql.Date getDate(String columnName, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Date object. Use
the calendar to construct an appropriate millisecond value for the Date, if
the underlying database doesn't store timezone information.
Parameters: columnName - is the SQL name of the column Parameters: cal - the calendar to use in constructing the date the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getDouble | public double getDouble(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java double.
Parameters: columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL exception: SQLException - if a database access error occurs |
getFetchDirection | public int getFetchDirection() throws SQLException(Code) | | JDBC 2.0 Return the fetch direction for this result set.
the fetch direction exception: SQLException - if a database-access error occurs |
getFetchSize | public int getFetchSize() throws SQLException(Code) | | JDBC 2.0 Return the fetch size for this result set.
the fetch size exception: SQLException - if a database-access error occurs |
getFloat | public float getFloat(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java float.
Parameters: columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL exception: SQLException - if a database access error occurs |
getInt | public int getInt(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java int.
Parameters: columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL exception: SQLException - if a database access error occurs |
getLong | public long getLong(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java long.
Parameters: columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL exception: SQLException - if a database access error occurs |
getMetaData | public java.sql.ResultSetMetaData getMetaData() throws SQLException(Code) | | The numbers, types and properties of a ResultSet 's columns
are provided by the getMetaData method
a description of the ResultSet 's columns exception: SQLException - if a database access error occurs |
getObject | public Object getObject(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java object
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 specified in the JDBC
specification.
This method may also be used to read database specific abstract data types.
Parameters: columnIndex - the first column is 1, the second is 2... a Object holding the column value exception: SQLException - if a database access error occurs |
getObject | public Object getObject(String columnName) throws SQLException(Code) | | Get the value of a column in the current row as a Java object
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 specified in the JDBC
specification.
This method may also be used to read database specific abstract data types.
Parameters: columnName - is the SQL name of the column a Object holding the column value exception: SQLException - if a database access error occurs |
getObject | public Object getObject(int i, java.util.Map map) throws SQLException(Code) | | JDBC 2.0 Returns the value of column as a Java object. Use the map to
determine the class from which to construct data of SQL structured and
distinct types.
Parameters: i - the first column is 1, the second is 2, ... Parameters: map - the mapping from SQL type names to Java classes an object representing the SQL value exception: SQLException - if a database-access error occurs. |
getObject | public Object getObject(String colName, java.util.Map map) throws SQLException(Code) | | JDBC 2.0 Returns the value of column as a Java object. Use the map to
determine the class from which to construct data of SQL structured and
distinct types.
Parameters: colName - the column name Parameters: map - the mapping from SQL type names to Java classes an object representing the SQL value exception: SQLException - if a database-access error occurs. |
getRef | public java.sql.Ref getRef(int i) throws SQLException(Code) | | JDBC 2.0 Get a REF(<structured-type>) column.
Parameters: i - the first column is 1, the second is 2, ... an object representing data of an SQL REF type exception: SQLException - if a database-access error occurs. |
getRef | public java.sql.Ref getRef(String colName) throws SQLException(Code) | | JDBC 2.0 Get a REF(<structured-type>) column.
Parameters: colName - the column name an object representing data of an SQL REF type exception: SQLException - if a database-access error occurs. |
getRow | public int getRow() throws SQLException(Code) | | JDBC 2.0
Determine the current row number. The first row is number 1, the second
number 2, etc.
the current row number, else return 0 if there is no current row exception: SQLException - if a database-access error occurs. |
getShort | public short getShort(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java short.
Parameters: columnIndex - the first column is 1, the second is 2,... the column value; 0 if SQL NULL exception: SQLException - if a database access error occurs |
getStatement | public java.sql.Statement getStatement() throws SQLException(Code) | | JDBC 2.0 Return the Statement that produced the
ResultSet .
the Statement that produced theResultSet , or null if the result was produced someother way. exception: SQLException - if a database-access error occurs |
getString | public String getString(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a Java String
Parameters: columnIndex - the first column is 1, the second is 2... the column value, null for SQL NULL exception: SQLException - if a database access error occurs |
getString | public String getString(String columnName) throws SQLException(Code) | | The following routines simply convert the columnName into a columnIndex and
then call the appropriate routine above.
Parameters: columnName - is the SQL name of the column the column value exception: SQLException - if a database access error occurs |
getTime | public Time getTime(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object
Parameters: columnIndex - the first column is 1, the second is 2... the column value; null if SQL NULL exception: SQLException - if a database access error occurs |
getTime | public java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object. Use
the calendar to construct an appropriate millisecond value for the Time, if
the underlying database doesn't store timezone information.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: cal - the calendar to use in constructing the time the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getTime | public java.sql.Time getTime(String columnName, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Time object. Use
the calendar to construct an appropriate millisecond value for the Time, if
the underlying database doesn't store timezone information.
Parameters: columnName - is the SQL name of the column Parameters: cal - the calendar to use in constructing the time the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getTimestamp | public Timestamp getTimestamp(int columnIndex) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp object
Parameters: columnIndex - the first column is 1, the second is 2... the column value; null if SQL NULL exception: SQLException - if a database access error occurs |
getTimestamp | public java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp
object. Use the calendar to construct an appropriate millisecond value for
the Timestamp, if the underlying database doesn't store timezone
information.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: cal - the calendar to use in constructing the timestamp (ignored) the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getTimestamp | public java.sql.Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException(Code) | | Get the value of a column in the current row as a java.sql.Timestamp
object. Use the calendar to construct an appropriate millisecond value for
the Timestamp, if the underlying database doesn't store timezone
information.
Parameters: columnName - is the SQL name of the column Parameters: cal - the calendar to use in constructing the timestamp the column value; if the value is SQL NULL, the result is null exception: SQLException - if a database-access error occurs. |
getType | public int getType() throws SQLException(Code) | | JDBC 2.0 Return the type of this result set. The type is determined based
on the statement that created the result set.
TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, orTYPE_SCROLL_SENSITIVE exception: SQLException - if a database-access error occurs |
getURL | public java.net.URL getURL(int columnIndex) throws SQLException(Code) | | 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.
Parameters: columnIndex - the index of the column 1 is the first, 2 is thesecond,... the column value as a java.net.URL object; if thevalue is SQL NULL , the value returned isnull in the Java programming language exception: SQLException - if a database access error occurs, or if a URL ismalformed since: JDK 1.4 |
getURL | public java.net.URL getURL(String columnName) throws SQLException(Code) | | 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.
Parameters: columnName - the SQL name of the column the column value as a java.net.URL object; if thevalue is SQL NULL , the value returned isnull in the Java programming language exception: SQLException - if a database access error occurs or if a URL ismalformed since: JDK 1.4 |
getUnicodeStream | public InputStream getUnicodeStream(int columnIndex) throws SQLException(Code) | | A column value can also be retrieved as a stream of Unicode characters. We
implement this as a binary stream.
Parameters: columnIndex - the first column is 1, the second is 2... a Java InputStream that delivers the database column value as astream of two byte Unicode characters. If the value is SQL NULL,then the result is null exception: SQLException - if a database access error occurs See Also: DriverResultSet.getAsciiStream See Also: DriverResultSet.getBinaryStream(int) |
getWarnings | public java.sql.SQLWarning getWarnings() throws SQLException(Code) | | The first warning reported by calls on this ResultSet is returned.
Subsequent ResultSet warnings will be chained to this java.sql.SQLWarning.
The warning chain is automatically cleared each time a new row is read.
Note: This warning chain only covers warnings caused by ResultSet
methods. Any warnings caused by statement methods (such as reading OUT
parameters) will be chained on the Statement object.
the first java.sql.SQLWarning or null; exception: SQLException - if a database access error occurs or this method iscalled on a closed result set |
insertRow | public void insertRow() throws SQLException(Code) | | JDBC 2.0 Insert the contents of the insert row into the result set and the
database. Must be on the insert row when this method is called.
exception: SQLException - if a database-access error occurs, if called whennot on the insert row, or if all non-nullable columns in theinsert row have not been given a value |
isAfterLast | public boolean isAfterLast() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is after the last row in the result set.
true if after the last row, false otherwise. Returns false when the result setcontains no rows. exception: SQLException - if a database-access error occurs. |
isBeforeFirst | public boolean isBeforeFirst() throws SQLException(Code) | | JDBC 2.0.
Determine if the cursor is before the first row in the result set.
true if before the first row, false otherwise. Returns false when the result setcontains no rows. exception: SQLException - if a database-access error occurs. |
isFirst | public boolean isFirst() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is on the first row of the result set.
true if on the first row, false otherwise. exception: SQLException - if a database-access error occurs. |
isLast | public boolean isLast() throws SQLException(Code) | | JDBC 2.0
Determine if the cursor is on the last row of the result set. Note: Calling
isLast() may be expensive since 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.
true if on the last row, false otherwise. exception: SQLException - if a database-access error occurs. |
last | public boolean last() throws SQLException(Code) | | JDBC 2.0
Moves to the last row in the result set.
true if on a valid row, false if no rows in theresult set. exception: SQLException - if a database-access error occurs, or result settype is TYPE_FORWARD_ONLY. |
moveToCurrentRow | public void moveToCurrentRow() throws SQLException(Code) | | JDBC 2.0 Move the cursor to the remembered cursor position, usually the
current row. Has no effect unless the cursor is on the insert row.
exception: SQLException - if a database-access error occurs, or the resultset is not updatable |
moveToInsertRow | public void moveToInsertRow() throws SQLException(Code) | | JDBC 2.0 Move to the insert row. The current cursor position is remembered
while the cursor is positioned on the insert row. The insert row is a
special row associated with an updatable result set. It is essentially a
buffer where a new row may be constructed by calling the updateXXX()
methods prior to inserting the row into the result set. Only the
updateXXX(), getXXX(), and insertRow() methods may be called when the
cursor is on the insert row. All of the columns in a result set must be
given a value each time this method is called before calling insertRow().
UpdateXXX()must be called before getXXX() on a column.
exception: SQLException - if a database-access error occurs, or the resultset is not updatable |
next | public boolean next() throws java.sql.SQLException(Code) | | A ResultSet is initially positioned before its first row, the first call to
next makes the first row the current row; the second call makes the second
row the current row, etc.
If an input stream from the previous row is open, it is implicitly closed.
The ResultSet's warning chain is cleared when a new row is read
true if the new current is valid; false if there are no more rows exception: java.sql.SQLException - if a database access error occurs |
prev | public boolean prev() throws SQLException(Code) | | The prev method is not part of JDBC, but because of the architecture of
this driver it is possible to move both forward and backward within the
result set.
If an input stream from the previous row is open, it is implicitly closed.
The ResultSet's warning chain is cleared when a new row is read
true if the new current is valid; false if there are no more rows exception: SQLException - if a database access error occurs |
previous | public boolean previous() throws SQLException(Code) | | JDBC 2.0
Moves to the previous row in the result set.
Note: previous() is not the same as relative(-1) since it makes sense to
call previous() when there is no current row.
true if on a valid row, false if off the result set. exception: SQLException - if a database-access error occurs, or result settype is TYPE_FORWAR_DONLY. |
refreshRow | public void refreshRow() throws SQLException(Code) | | JDBC 2.0 Refresh the value of the current row with its current value in the
database. Cannot be called when 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
updateXXX(), but before calling updateRow() then the updates made to the
row are lost. Calling refreshRow() frequently will likely slow performance.
exception: SQLException - if a database-access error occurs, or if calledwhen on the insert row. |
relative | public boolean relative(int rows) throws SQLException(Code) | | JDBC 2.0
Moves 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 relative(1) is different than calling next() since is makes
sense to call next() when there is no current row, for example, when the
cursor is positioned before the first row or after the last row of the
result set.
Parameters: rows - the number of rows true if on a row, false otherwise. exception: SQLException - if a database-access error occurs, or there is nocurrent row, or result set type is TYPE_FORWARD_ONLY. |
rowDeleted | public boolean rowDeleted() throws SQLException(Code) | | JDBC 2.0 Determine if this 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 the result set
can detect deletions.
true if deleted and deletes are detected exception: SQLException - if a database-access error occurs See Also: DatabaseMetaData.deletesAreDetected |
rowInserted | public boolean rowInserted() throws SQLException(Code) | | JDBC 2.0 Determine if the current row has been inserted. The value returned
depends on whether or not the result set can detect visible inserts.
true if inserted and inserts are detected exception: SQLException - if a database-access error occurs See Also: DatabaseMetaData.insertsAreDetected |
rowUpdated | public boolean rowUpdated() throws SQLException(Code) | | JDBC 2.0 Determine if the current row has been updated. The value returned
depends on whether or not the result set can detect updates.
true if the row has been visibly updated by theowner or another, and updates are detected exception: SQLException - if a database-access error occurs See Also: DatabaseMetaData.updatesAreDetected |
setFetchDirection | public void setFetchDirection(int direction) throws SQLException(Code) | | JDBC 2.0 Give a hint as to the direction in which the rows in this result
set will be processed. The initial value is determined by the statement
that produced the result set. The fetch direction may be changed at any
time.
Parameters: direction - the fetch direction exception: SQLException - if a database-access error occurs, or the resultset type is TYPE_FORWARD_ONLY and direction is notFETCH_FORWARD. MM.MySQL actually ignores this, because it hasthe whole result set anyway, so the direction is immaterial. |
setHasMoreData | public void setHasMoreData(boolean hasMore)(Code) | | Set the hasMoreData boolean (is there more data to fetch from the
controller). This function is used by the ResultSet streaming feature.
Parameters: hasMore - new value for hasMoreData |
updateArray | public void updateArray(int columnIndex, java.sql.Array x) throws SQLException(Code) | | Updates the designated column with a java.sql.Array 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: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateArray | public void updateArray(String columnName, java.sql.Array x) throws SQLException(Code) | | Updates the designated column with a java.sql.Array 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: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateAsciiStream | public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with an ascii stream value. The updateXXX()
methods are used to update column values in the current row, or the insert
row. The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateAsciiStream | public void updateAsciiStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with an ascii stream value. The updateXXX()
methods are used to update column values in the current row, or the insert
row. The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: length - of the stream exception: SQLException - if a database-access error occurs |
updateBigDecimal | public void updateBigDecimal(int columnIndex, BigDecimal x) throws SQLException(Code) | | JDBC 2.0 Update a column with a BigDecimal value. The updateXXX() methods
are used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBigDecimal | public void updateBigDecimal(String columnName, BigDecimal x) throws SQLException(Code) | | JDBC 2.0 Update a column with a BigDecimal value. The updateXXX() methods
are used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBinaryStream | public void updateBinaryStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a binary stream value. The updateXXX()
methods are used to update column values in the current row, or the insert
row. The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateBinaryStream | public void updateBinaryStream(String columnName, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a binary stream value. The updateXXX()
methods are used to update column values in the current row, or the insert
row. The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: length - of the stream exception: SQLException - if a database-access error occurs |
updateBlob | public void updateBlob(int columnIndex, java.sql.Blob x) throws SQLException(Code) | | Updates the designated column with a java.sql.Blob 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: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateBlob | public void updateBlob(String columnName, java.sql.Blob x) throws SQLException(Code) | | Updates the designated column with a java.sql.Blob 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: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateBoolean | public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code) | | JDBC 2.0 Update a column with a boolean value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBoolean | public void updateBoolean(String columnName, boolean x) throws SQLException(Code) | | JDBC 2.0 Update a column with a boolean value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateByte | public void updateByte(int columnIndex, byte x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateByte | public void updateByte(String columnName, byte x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBytes | public void updateBytes(int columnIndex, byte[] x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte array value. The updateXXX() methods
are used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateBytes | public void updateBytes(String columnName, byte[] x) throws SQLException(Code) | | JDBC 2.0 Update a column with a byte array value. The updateXXX() methods
are used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateCharacterStream | public void updateCharacterStream(int columnIndex, java.io.Reader x, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a character stream value. The updateXXX()
methods are used to update column values in the current row, or the insert
row. The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: length - the length of the stream exception: SQLException - if a database-access error occurs |
updateCharacterStream | public void updateCharacterStream(String columnName, java.io.Reader reader, int length) throws SQLException(Code) | | JDBC 2.0 Update a column with a character stream value. The updateXXX()
methods are used to update column values in the current row, or the insert
row. The updateXXX() methods do not update the underlying database, instead
the updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: reader - the stream Parameters: length - of the stream exception: SQLException - if a database-access error occurs |
updateClob | public void updateClob(int columnIndex, java.sql.Clob x) throws SQLException(Code) | | Updates the designated column with a java.sql.Clob 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: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateClob | public void updateClob(String columnName, java.sql.Clob x) throws SQLException(Code) | | Updates the designated column with a java.sql.Clob 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: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateDate | public void updateDate(int columnIndex, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Date value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateDate | public void updateDate(String columnName, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Date value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateDouble | public void updateDouble(int columnIndex, double x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Double value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateDouble | public void updateDouble(String columnName, double x) throws SQLException(Code) | | JDBC 2.0 Update a column with a double value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateFloat | public void updateFloat(int columnIndex, float x) throws SQLException(Code) | | JDBC 2.0 Update a column with a float value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateFloat | public void updateFloat(String columnName, float x) throws SQLException(Code) | | JDBC 2.0 Update a column with a float value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateInt | public void updateInt(int columnIndex, int x) throws SQLException(Code) | | JDBC 2.0 Update a column with an integer value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateInt | public void updateInt(String columnName, int x) throws SQLException(Code) | | JDBC 2.0 Update a column with an integer value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateLong | public void updateLong(int columnIndex, long x) throws SQLException(Code) | | JDBC 2.0 Update a column with a long value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateLong | public void updateLong(String columnName, long x) throws SQLException(Code) | | JDBC 2.0 Update a column with a long value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateNull | public void updateNull(int columnIndex) throws SQLException(Code) | | JDBC 2.0 Give a nullable column a null value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... exception: SQLException - if a database-access error occurs |
updateNull | public void updateNull(String columnName) throws SQLException(Code) | | JDBC 2.0 Update a column with a null value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(int columnIndex, Object x, int scale) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value Parameters: scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC typesthis is the number of digits after the decimal. For all othertypes this value will be ignored. exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(int columnIndex, Object x) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(String columnName, Object x, int scale) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value Parameters: scale - For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC typesthis is the number of digits after the decimal. For all othertypes this value will be ignored. exception: SQLException - if a database-access error occurs |
updateObject | public void updateObject(String columnName, Object x) throws SQLException(Code) | | JDBC 2.0 Update a column with an Object value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateRef | public void updateRef(int columnIndex, java.sql.Ref x) throws SQLException(Code) | | Updates the designated column with a java.sql.Ref 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: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateRef | public void updateRef(String columnName, java.sql.Ref x) throws SQLException(Code) | | Updates the designated column with a java.sql.Ref 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: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database access error occurs since: JDK 1.4 |
updateRow | public void updateRow() throws SQLException(Code) | | JDBC 2.0 Update the underlying database with the new contents of the
current row. Cannot be called when on the insert row.
exception: SQLException - if a database-access error occurs, or if calledwhen on the insert row |
updateShort | public void updateShort(int columnIndex, short x) throws SQLException(Code) | | JDBC 2.0 Update a column with a short value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateShort | public void updateShort(String columnName, short x) throws SQLException(Code) | | JDBC 2.0 Update a column with a short value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateString | public void updateString(int columnIndex, String x) throws SQLException(Code) | | JDBC 2.0 Update a column with a String value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateString | public void updateString(String columnName, String x) throws SQLException(Code) | | JDBC 2.0 Update a column with a String value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTime | public void updateTime(int columnIndex, java.sql.Time x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Time value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTime | public void updateTime(String columnName, java.sql.Time x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Time value. The updateXXX() methods are
used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTimestamp | public void updateTimestamp(int columnIndex, java.sql.Timestamp x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods
are used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnIndex - the first column is 1, the second is 2, ... Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
updateTimestamp | public void updateTimestamp(String columnName, java.sql.Timestamp x) throws SQLException(Code) | | JDBC 2.0 Update a column with a Timestamp value. The updateXXX() methods
are used to update column values in the current row, or the insert row. The
updateXXX() methods do not update the underlying database, instead the
updateRow() or insertRow() methods are called to update the database.
Parameters: columnName - the name of the column Parameters: x - the new column value exception: SQLException - if a database-access error occurs |
wasNull | public boolean wasNull() throws SQLException(Code) | | A column may have the value of SQL NULL; wasNull() reports whether the last
column read had this special value. Note that you must first call getXXX on
a column to try to read its value and then call wasNull() to find if the
value was SQL NULL
true if the last column read was SQL NULL exception: SQLException - if a database access error occurred |
|
|