| java.lang.Object
 com.internetcds.jdbc.tds.ResultSet_base
com.internetcds.jdbc.tds.ResultSet_2_0
| Field Summary | |
| int | CONCUR_READ_ONLY
JDBC 2.0
The concurrency mode for a ResultSet object
that may NOT be updated. | | int | CONCUR_UPDATABLE
JDBC 2.0
The concurrency mode for a ResultSet object
that may be updated. | | int | FETCH_FORWARD
JDBC 2.0
The rows in a result set will be processed in a forward direction;
first-to-last. | | int | FETCH_REVERSE
JDBC 2.0
The rows in a result set will be processed in a reverse direction;
last-to-first. | | int | FETCH_UNKNOWN
JDBC 2.0
The order in which rows in a result set will be processed is unknown. | | int | TYPE_FORWARD_ONLY
JDBC 2.0
The type for a ResultSet object whose cursor may
move only forward. | | int | TYPE_SCROLL_INSENSITIVE
JDBC 2.0
The type for a ResultSet object that is scrollable
but generally not sensitive to changes made by others. | | int | TYPE_SCROLL_SENSITIVE
JDBC 2.0
The type for a ResultSet object that is scrollable
and generally sensitive to changes made by others. | | final public static String | cvsVersion
|
| Method Summary | |
| public boolean | absolute(int row)
JDBC 2.0
Moves the cursor to the given row number in the result set.
If the row number is positive, the cursor moves to
the given row number with respect to the
beginning of the result set. | | public void | afterLast()
JDBC 2.0
Moves the cursor to the end of the result set, just after the last
row. | | public void | beforeFirst()
JDBC 2.0
Moves the cursor to the front of the result set, just before the
first row. | | public void | cancelRowUpdates()
JDBC 2.0
Cancels the updates made to a row.
This method may be called after calling an
updateXXX method(s) and before calling updateRow to rollback
the updates made to a row. | | public void | deleteRow()
JDBC 2.0
Deletes the current row from the result set and the underlying
database. | | public boolean | first()
JDBC 2.0
Moves the cursor to the first row in the result set. | | public Array | getArray(int i)
JDBC 2.0
Gets an SQL ARRAY value from the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... | | public Array | getArray(String colName)
JDBC 2.0
Gets an SQL ARRAY value in the current row of this ResultSet object. | | public BigDecimal | getBigDecimal(int columnIndex)
JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Parameters:
columnIndex - the first column is 1, the second is 2, ... | | public BigDecimal | getBigDecimal(String columnName)
JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision. | | public Blob | getBlob(int i)
JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... | | public Blob | getBlob(String colName)
JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object. | | public java.io.Reader | getCharacterStream(int columnIndex)
JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader. | | public java.io.Reader | getCharacterStream(String columnName)
JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader. | | public Clob | getClob(int i)
JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... | | public Clob | getClob(String colName)
JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object. | | public int | getConcurrency()
JDBC 2.0
Returns the concurrency mode of this result set. | | public java.sql.Date | getDate(int columnIndex, Calendar cal)
JDBC 2.0
Gets the value of a column in the current row as a
java.sql.Date object. | | public java.sql.Date | getDate(String columnName, Calendar cal)
Gets the value of a column in the current row as a
java.sql.Date object. | | public int | getFetchDirection()
JDBC 2.0
Returns the fetch direction for this result set. | | public int | getFetchSize()
JDBC 2.0
Returns the fetch size for this result set. | | public int | getHoldability()
| | public Reader | getNCharacterStream(int columnIndex)
| | public Reader | getNCharacterStream(String columnLabel)
| | public NClob | getNClob(int columnIndex)
| | public NClob | getNClob(String columnLabel)
| | public String | getNString(int columnIndex)
| | public String | getNString(String columnLabel)
| | public Object | getObject(int i, java.util.Map map)
JDBC 2.0
Returns the value of a column in the current row as a Java object. | | public Object | getObject(String colName, java.util.Map map)
JDBC 2.0
Returns the value in the specified column as a Java object. | | public Ref | getRef(int i)
JDBC 2.0
Gets a REF(<structured-type>) column value from the current row.
Parameters:
i - the first column is 1, the second is 2, ... | | public Ref | getRef(String colName)
JDBC 2.0
Gets a REF(<structured-type>) column value from the current row. | | public int | getRow()
JDBC 2.0
Retrieves the current row number. | | public RowId | getRowId(int columnIndex)
| | public RowId | getRowId(String columnLabel)
| | public SQLXML | getSQLXML(int columnIndex)
| | public SQLXML | getSQLXML(String columnLabel)
| | public java.sql.Statement | getStatement()
JDBC 2.0
Returns the Statement that produced this ResultSet object. | | public java.sql.Time | getTime(int columnIndex, Calendar cal)
Gets the value of a column in the current row as a
java.sql.Time object. | | public java.sql.Time | getTime(String columnName, Calendar cal)
Gets the value of a column in the current row as a java.sql.Time
object. | | public java.sql.Timestamp | getTimestamp(int columnIndex, Calendar cal)
Gets the value of a column in the current row as a java.sql.Timestamp
object. | | public java.sql.Timestamp | getTimestamp(String columnName, Calendar cal)
Gets the value of a column in the current row as a
java.sql.Timestamp object. | | public int | getType()
JDBC 2.0
Returns the type of this result set. | | public URL | getURL(int columnIndex)
| | public URL | getURL(String columnName)
| | public void | insertRow()
JDBC 2.0
Inserts the contents of the insert row into the result set and
the database. | | public boolean | isAfterLast()
JDBC 2.0
Indicates whether the cursor is after the last row in the result
set. | | public boolean | isBeforeFirst()
JDBC 2.0
Indicates whether the cursor is before the first row in the result
set. | | public boolean | isClosed()
| | public boolean | isFirst()
JDBC 2.0
Indicates whether the cursor is on the first row of the result set. | | public boolean | isLast()
JDBC 2.0
Indicates whether the cursor is on the last row of the result set. | | public boolean | isWrapperFor(Class iface)
| | public boolean | last()
JDBC 2.0
Moves the cursor to the last row in the result set. | | public void | moveToCurrentRow()
JDBC 2.0
Moves the cursor to the remembered cursor position, usually the
current row. | | public void | moveToInsertRow()
JDBC 2.0
Moves the cursor to the insert row. | | public boolean | previous()
JDBC 2.0
Moves the cursor to the previous row in the result set. | | public void | refreshRow()
JDBC 2.0
Refreshes the current row with its most recent value in
the database. | | public boolean | relative(int rows)
JDBC 2.0
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. | | public boolean | rowDeleted()
JDBC 2.0
Indicates whether a row has been deleted. | | public boolean | rowInserted()
JDBC 2.0
Indicates whether the current row has had an insertion. | | public boolean | rowUpdated()
JDBC 2.0
Indicates whether the current row has been updated. | | public void | setFetchDirection(int direction)
JDBC 2.0
Gives a hint as to the direction in which the rows in this result set
will be processed. | | public void | setFetchSize(int rows)
JDBC 2.0
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 result
set. | | public T | unwrap(Class<T> iface)
| | public void | updateArray(int columnIndex, Array x)
| | public void | updateArray(String columnName, Array x)
| | public void | updateAsciiStream(int columnIndex, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with an ascii stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateAsciiStream(String columnName, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with an ascii stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateAsciiStream(int columnIndex, InputStream x)
| | public void | updateAsciiStream(String columnLabel, InputStream x)
| | public void | updateAsciiStream(int columnIndex, InputStream x, long length)
| | public void | updateAsciiStream(String columnLabel, InputStream x, long length)
| | public void | updateBigDecimal(int columnIndex, BigDecimal x)
JDBC 2.0
Updates a column with a BigDecimal value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBigDecimal(String columnName, BigDecimal x)
JDBC 2.0
Updates a column with a BigDecimal value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBinaryStream(int columnIndex, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with a binary stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBinaryStream(String columnName, java.io.InputStream x, int length)
JDBC 2.0
Updates a column with a binary stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBinaryStream(int columnIndex, InputStream x)
| | public void | updateBinaryStream(String columnLabel, InputStream x)
| | public void | updateBinaryStream(int columnIndex, InputStream x, long length)
| | public void | updateBinaryStream(String columnLabel, InputStream x, long length)
| | public void | updateBlob(int columnIndex, Blob x)
| | public void | updateBlob(String columnName, Blob x)
| | public void | updateBlob(int columnIndex, InputStream inputStream)
| | public void | updateBlob(String columnLabel, InputStream inputStream)
| | public void | updateBlob(int columnIndex, InputStream inputStream, long length)
| | public void | updateBlob(String columnLabel, InputStream inputStream, long length)
| | public void | updateBoolean(int columnIndex, boolean x)
JDBC 2.0
Updates a column with a boolean value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBoolean(String columnName, boolean x)
JDBC 2.0
Updates a column with a boolean value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateByte(int columnIndex, byte x)
JDBC 2.0
Updates a column with a byte value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateByte(String columnName, byte x)
JDBC 2.0
Updates a column with a byte value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBytes(int columnIndex, byte x)
JDBC 2.0
Updates a column with a byte array value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateBytes(String columnName, byte x)
JDBC 2.0
Updates a column with a byte array value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateCharacterStream(int columnIndex, java.io.Reader x, int length)
JDBC 2.0
Updates a column with a character stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateCharacterStream(String columnName, java.io.Reader reader, int length)
JDBC 2.0
Updates a column with a character stream value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateCharacterStream(int columnIndex, Reader x)
| | public void | updateCharacterStream(String columnLabel, Reader reader)
| | public void | updateCharacterStream(int columnIndex, Reader x, long length)
| | public void | updateCharacterStream(String columnLabel, Reader reader, long length)
| | public void | updateClob(int columnIndex, Clob x)
| | public void | updateClob(String columnName, Clob x)
| | public void | updateClob(int columnIndex, Reader reader)
| | public void | updateClob(String columnLabel, Reader reader)
| | public void | updateClob(int columnIndex, Reader reader, long length)
| | public void | updateClob(String columnLabel, Reader reader, long length)
| | public void | updateDate(int columnIndex, java.sql.Date x)
JDBC 2.0
Updates a column with a Date value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateDate(String columnName, java.sql.Date x)
JDBC 2.0
Updates a column with a Date value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateDouble(int columnIndex, double x)
JDBC 2.0
Updates a column with a Double value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateDouble(String columnName, double x)
JDBC 2.0
Updates a column with a double value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateFloat(int columnIndex, float x)
JDBC 2.0
Updates a column with a float value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateFloat(String columnName, float x)
JDBC 2.0
Updates a column with a float value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateInt(int columnIndex, int x)
JDBC 2.0
Updates a column with an integer value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateInt(String columnName, int x)
JDBC 2.0
Updates a column with an integer value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateLong(int columnIndex, long x)
JDBC 2.0
Updates a column with a long value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateLong(String columnName, long x)
JDBC 2.0
Updates a column with a long value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateNCharacterStream(int columnIndex, Reader x)
| | public void | updateNCharacterStream(String columnLabel, Reader reader)
| | public void | updateNCharacterStream(int columnIndex, Reader x, long length)
| | public void | updateNCharacterStream(String columnLabel, Reader reader, long length)
| | public void | updateNClob(int columnIndex, NClob nClob)
| | public void | updateNClob(String columnLabel, NClob nClob)
| | public void | updateNClob(int columnIndex, Reader reader)
| | public void | updateNClob(String columnLabel, Reader reader)
| | public void | updateNClob(int columnIndex, Reader reader, long length)
| | public void | updateNClob(String columnLabel, Reader reader, long length)
| | public void | updateNString(int columnIndex, String nString)
| | public void | updateNString(String columnLabel, String nString)
| | public void | updateNull(int columnIndex)
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. | | public void | updateNull(String columnName)
JDBC 2.0
Updates a column with a null value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(int columnIndex, Object x, int scale)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(int columnIndex, Object x)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(String columnName, Object x, int scale)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateObject(String columnName, Object x)
JDBC 2.0
Updates a column with an Object value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateRef(int columnIndex, Ref x)
| | public void | updateRef(String columnName, Ref x)
| | public void | updateRow()
JDBC 2.0
Updates the underlying database with the new contents of the
current row. | | public void | updateRowId(int columnIndex, RowId x)
| | public void | updateRowId(String columnLabel, RowId x)
| | public void | updateSQLXML(int columnIndex, SQLXML xmlObject)
| | public void | updateSQLXML(String columnLabel, SQLXML xmlObject)
| | public void | updateShort(int columnIndex, short x)
JDBC 2.0
Updates a column with a short value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateShort(String columnName, short x)
JDBC 2.0
Updates a column with a short value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateString(int columnIndex, String x)
JDBC 2.0
Updates a column with a String value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateString(String columnName, String x)
JDBC 2.0
Updates a column with a String value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTime(int columnIndex, java.sql.Time x)
JDBC 2.0
Updates a column with a Time value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTime(String columnName, java.sql.Time x)
JDBC 2.0
Updates a column with a Time value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTimestamp(int columnIndex, java.sql.Timestamp x)
JDBC 2.0
Updates a column with a Timestamp value.
The updateXXX methods are used to update column values in the
current row, or the insert row. | | public void | updateTimestamp(String columnName, java.sql.Timestamp x)
JDBC 2.0
Updates a column with a Timestamp value.
The updateXXX methods are used to update column values in the
current row, or the insert row. |
| CONCUR_READ_ONLY | | int CONCUR_READ_ONLY(Code) | | JDBC 2.0
The concurrency mode for a ResultSet object
that may NOT be updated.
|
| CONCUR_UPDATABLE | | int CONCUR_UPDATABLE(Code) | | JDBC 2.0
The concurrency mode for a ResultSet object
that may be updated.
|
| FETCH_FORWARD | | int FETCH_FORWARD(Code) | | JDBC 2.0
The rows in a result set will be processed in a forward direction;
first-to-last.
|
| FETCH_REVERSE | | int FETCH_REVERSE(Code) | | JDBC 2.0
The rows in a result set will be processed in a reverse direction;
last-to-first.
|
| FETCH_UNKNOWN | | int FETCH_UNKNOWN(Code) | | JDBC 2.0
The order in which rows in a result set will be processed is unknown.
|
| TYPE_FORWARD_ONLY | | int TYPE_FORWARD_ONLY(Code) | | JDBC 2.0
The type for a ResultSet object whose cursor may
move only forward.
|
| TYPE_SCROLL_INSENSITIVE | | int TYPE_SCROLL_INSENSITIVE(Code) | | JDBC 2.0
The type for a ResultSet object that is scrollable
but generally not sensitive to changes made by others.
|
| TYPE_SCROLL_SENSITIVE | | int TYPE_SCROLL_SENSITIVE(Code) | | JDBC 2.0
The type for a ResultSet object that is scrollable
and generally sensitive to changes made by others.
|
| absolute | | public boolean absolute(int row) throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the given row number in the result set.
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
absolute(-1) positions the
cursor on the last row, absolute(-2) indicates 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/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().
true if the cursor is on the result set; false otherwise
exception:
SQLException - if a database access error occurs or row is 0, or result set type is TYPE_FORWARD_ONLY. |
| afterLast | | public void afterLast() throws SQLException(Code) | | JDBC 2.0
Moves the cursor 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 the result set type is TYPE_FORWARD_ONLY |
| beforeFirst | | public void beforeFirst() throws SQLException(Code) | | JDBC 2.0
Moves the cursor 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 the result set type is TYPE_FORWARD_ONLY |
| cancelRowUpdates | | public void cancelRowUpdates() throws SQLException(Code) | | JDBC 2.0
Cancels the updates made to a row.
This 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 ifcalled when on the insert row |
| deleteRow | | public void deleteRow() throws SQLException(Code) | | JDBC 2.0
Deletes 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 ifcalled when on the insert row. |
| first | | public boolean first() throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the first row in the result set.
true if the cursor is on a valid row; false ifthere are no rows in the result set
exception:
SQLException - if a database access error occurs or the result set type is TYPE_FORWARD_ONLY |
| getArray | | public Array getArray(int i) throws SQLException(Code) | | JDBC 2.0
Gets an SQL ARRAY value from the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... an Array object representing the SQL ARRAY value inthe specified column |
| getArray | | public Array getArray(String colName) throws SQLException(Code) | | JDBC 2.0
Gets an SQL ARRAY value in the current row of this ResultSet object.
Parameters:
colName - the name of the column from which to retrieve the value an Array object representing the SQL ARRAY value inthe specified column |
| getBigDecimal | | public BigDecimal getBigDecimal(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Parameters:
columnIndex - the first column is 1, the second is 2, ... the column value (full precision); if the value is SQL NULL, the result is null
exception:
SQLException - if a database access error occurs |
| getBigDecimal | | public BigDecimal getBigDecimal(String columnName) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.math.BigDecimal
object with full precision.
Parameters:
columnName - the column name the column value (full precision); if the value is SQL NULL, the result is null
exception:
SQLException - if a database access error occurs |
| getBlob | | public Blob getBlob(int i) throws SQLException(Code) | | JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... a Blob object representing the SQL BLOB value inthe specified column |
| getBlob | | public Blob getBlob(String colName) throws SQLException(Code) | | JDBC 2.0
Gets a BLOB value in the current row of this ResultSet object.
Parameters:
colName - the name of the column from which to retrieve the value a Blob object representing the SQL BLOB value inthe specified column |
| getCharacterStream | | public java.io.Reader getCharacterStream(int columnIndex) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader.
Parameters:
columnIndex - the first column is 1, the second is 2, ... |
| getCharacterStream | | public java.io.Reader getCharacterStream(String columnName) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a java.io.Reader.
Parameters:
columnName - the name of the column the value in the specified column as a java.io.Reader |
| getClob | | public Clob getClob(int i) throws SQLException(Code) | | JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object.
Parameters:
i - the first column is 1, the second is 2, ... a Clob object representing the SQL CLOB value inthe specified column |
| getClob | | public Clob getClob(String colName) throws SQLException(Code) | | JDBC 2.0
Gets a CLOB value in the current row of this ResultSet object.
Parameters:
colName - the name of the column from which to retrieve the value a Clob object representing the SQL CLOB value inthe specified column |
| getConcurrency | | public int getConcurrency() throws SQLException(Code) | | JDBC 2.0
Returns the concurrency mode of this result set. The concurrency
used is determined by the statement that created the result set.
the concurrency type, CONCUR_READ_ONLY or CONCUR_UPDATABLE
exception:
SQLException - if a database access error occurs |
| getDate | | public java.sql.Date getDate(int columnIndex, Calendar cal) throws SQLException(Code) | | JDBC 2.0
Gets the value of a column in the current row as a
java.sql.Date object. This method uses the given calendar to
construct an appropriate millisecond value for the Date if the
underlying database does not store timezone information.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
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 |
| getDate | | public java.sql.Date getDate(String columnName, Calendar cal) throws SQLException(Code) | | Gets the value of a column in the current row as a
java.sql.Date object. This method uses the given calendar to
construct an appropriate millisecond value for the Date, if the
underlying database does not store timezone information.
Parameters:
columnName - the SQL name of the column from which to retrieve the value
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 |
| getFetchDirection | | public int getFetchDirection() throws SQLException(Code) | | JDBC 2.0
Returns the fetch direction for this result set.
the current fetch direction for this result set
exception:
SQLException - if a database access error occurs |
| getFetchSize | | public int getFetchSize() throws SQLException(Code) | | JDBC 2.0
Returns the fetch size for this result set.
the current fetch size for this result set
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 a column in the current row as a Java object.
This method uses the given Map object
for the custom mapping of the
SQL structured or distinct type that is being retrieved.
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 |
| getObject | | public Object getObject(String colName, java.util.Map map) throws SQLException(Code) | | JDBC 2.0
Returns the value in the specified column as a Java object.
This method uses the specified Map object for
custom mapping if appropriate.
Parameters:
colName - the name of the column from which to retrieve the value
Parameters:
map - the mapping from SQL type names to Java classes an object representing the SQL value in the specified column |
| getRef | | public Ref getRef(int i) throws SQLException(Code) | | JDBC 2.0
Gets a REF(<structured-type>) column value from the current row.
Parameters:
i - the first column is 1, the second is 2, ... a Ref object representing an SQL REF value |
| getRef | | public Ref getRef(String colName) throws SQLException(Code) | | JDBC 2.0
Gets a REF(<structured-type>) column value from the current row.
Parameters:
colName - the column name a Ref object representing the SQL REF value inthe specified column |
| getRow | | public int getRow() throws SQLException(Code) | | JDBC 2.0
Retrieves the current row number. The first row is number 1, the
second number 2, and so on.
the current row number; 0 if there is no current row
exception:
SQLException - if a database access error occurs |
| getStatement | | public java.sql.Statement getStatement() throws SQLException(Code) | | JDBC 2.0
Returns the Statement that produced this ResultSet object.
If the result set was generated some other way, such as by a
DatabaseMetaData method, this method returns null.
the Statment that produced the result set ornull if the result set was produced some other way
exception:
SQLException - if a database access error occurs |
| getTime | | public java.sql.Time getTime(int columnIndex, Calendar cal) throws SQLException(Code) | | Gets the value of a column in the current row as a
java.sql.Time object. This method uses the given calendar to
construct an appropriate millisecond value for the Time if the
underlying database does not 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) | | Gets the value of a column in the current row as a java.sql.Time
object. This method uses the given calendar to construct an
appropriate millisecond
value for the Time if the underlying database does not store
timezone information.
Parameters:
columnName - 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 java.sql.Timestamp getTimestamp(int columnIndex, Calendar cal) throws SQLException(Code) | | Gets the value of a column in the current row as a java.sql.Timestamp
object. This method uses the given calendar to construct an
appropriate millisecond value for the Timestamp if the underlying
database does not store timezone information.
Parameters:
columnIndex - the first column is 1, the second is 2, ...
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 |
| getTimestamp | | public java.sql.Timestamp getTimestamp(String columnName, Calendar cal) throws SQLException(Code) | | Gets the value of a column in the current row as a
java.sql.Timestamp object. This method uses the given calendar
to construct an appropriate millisecond value for the Timestamp
if the underlying database does not store timezone information.
Parameters:
columnName - 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
Returns the type of this result set. The type is determined by
the statement that created the result set.
TYPE_FORWARD_ONLY, TYPE_SCROLL_INSENSITIVE, orTYPE_SCROLL_SENSITIVE
exception:
SQLException - if a database access error occurs |
| insertRow | | public void insertRow() throws SQLException(Code) | | JDBC 2.0
Inserts 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 when not on the insert row, or if not all of non-nullable columns inthe insert row have been given a value |
| isAfterLast | | public boolean isAfterLast() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is after the last row in the result
set.
true if the cursor is after the last row, false otherwise. Returnsfalse when the result set contains no rows.
exception:
SQLException - if a database access error occurs |
| isBeforeFirst | | public boolean isBeforeFirst() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is before the first row in the result
set.
true if the cursor is before the first row, false otherwise. Returnsfalse when the result set contains no rows.
exception:
SQLException - if a database access error occurs |
| isFirst | | public boolean isFirst() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is on the first row of the result set.
true if the cursor is on the first row, false otherwise.
exception:
SQLException - if a database access error occurs |
| isLast | | public boolean isLast() throws SQLException(Code) | | JDBC 2.0
Indicates whether the cursor is on the last row of the result set.
Note: Calling the method isLast may be expensive
because the JDBC driver
might need to fetch ahead one row in order to determine
whether the current row is the last row in the result set.
true if the cursor is 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 the cursor to the last row in the result set.
true if the cursor is on a valid row;false if there are no rows in the result set
exception:
SQLException - if a database access error occurs or theresult set type is TYPE_FORWARD_ONLY. |
| moveToCurrentRow | | public void moveToCurrentRow() throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the remembered cursor position, usually the
current row. This method has no effect if the cursor is not on the insert
row.
exception:
SQLException - if a database access error occursor the result set is not updatable |
| moveToInsertRow | | public void moveToInsertRow() throws SQLException(Code) | | JDBC 2.0
Moves the cursor 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.
The method updateXXX must be called before a
getXXX method can be called on a column value.
exception:
SQLException - if a database access error occursor the result set is not updatable |
| previous | | public boolean previous() throws SQLException(Code) | | JDBC 2.0
Moves the cursor to the previous row in the result set.
Note: previous() is not the same as
relative(-1) because it
makes sense to callprevious() when there is no current row.
true if the cursor is on a valid row; false if it is off the result set
exception:
SQLException - if a database access error occurs or theresult set type is TYPE_FORWARD_ONLY |
| refreshRow | | public void refreshRow() throws SQLException(Code) | | JDBC 2.0
Refreshes the current row with its most recent 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 the method refreshRow frequently
will likely slow performance.
exception:
SQLException - if a database access error occurs or ifcalled when on the insert row |
| relative | | public boolean relative(int rows) throws SQLException(Code) | | JDBC 2.0
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 relative(1)
is different from calling next()
because 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.
true if the cursor is on a row; false otherwise
exception:
SQLException - if a database access error occurs, thereis no current row, or the result set type is TYPE_FORWARD_ONLY |
| rowDeleted | | public boolean rowDeleted() throws SQLException(Code) | | JDBC 2.0
Indicates 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 the result set can detect deletions.
true if a row was deleted and deletions are detected
exception:
SQLException - if a database access error occurs
See Also: DatabaseMetaData.deletesAreDetected |
| rowInserted | | public boolean rowInserted() throws SQLException(Code) | | JDBC 2.0
Indicates whether the current row has had an insertion. The value returned
depends on whether or not the result set can detect visible inserts.
true if a row has had an insertion and insertions are detected
exception:
SQLException - if a database access error occurs
See Also: DatabaseMetaData.insertsAreDetected |
| rowUpdated | | public boolean rowUpdated() throws SQLException(Code) | | JDBC 2.0
Indicates whether 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 the owner oranother, 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
Gives 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.
exception:
SQLException - if a database access error occurs orthe result set type is TYPE_FORWARD_ONLY and the fetch direction is not FETCH_FORWARD. |
| setFetchSize | | public void setFetchSize(int rows) throws SQLException(Code) | | JDBC 2.0
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 result
set. 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
that created the result set. The fetch size may be changed at any
time.
Parameters:
rows - the number of rows to fetch
exception:
SQLException - if a database access error occurs or thecondition 0 <= rows <= this.getMaxRows() is not satisfied. |
| updateAsciiStream | | public void updateAsciiStream(int columnIndex, java.io.InputStream x, int length) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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 |
| updateBoolean | | public void updateBoolean(int columnIndex, boolean x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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:
x - the new column value
Parameters:
length - of the stream
exception:
SQLException - if a database access error occurs |
| updateCharacterStream | | public void updateCharacterStream(int columnIndex, Reader x, long length) throws SQLException(Code) | | |
| updateDate | | public void updateDate(int columnIndex, java.sql.Date x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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 |
| updateNCharacterStream | | public void updateNCharacterStream(int columnIndex, Reader x, long length) throws SQLException(Code) | | |
| 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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 |
| updateRow | | public void updateRow() throws SQLException(Code) | | JDBC 2.0
Updates 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 orif called when on the insert row |
| updateShort | | public void updateShort(int columnIndex, short x) throws SQLException(Code) | | JDBC 2.0
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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
Updates 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 |
|
|