:: com :: sun :: star :: sdbc ::
|
interface XResultSetUpdate |
|
- Description
- provides the possiblity to write changes made on a result set back to
database.
|
Methods' Summary |
insertRow |
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.
|
updateRow |
updates the underlying database with the new contents of the
current row. Cannot be called when on the insert row.
|
deleteRow |
deletes the current row from the result set and the underlying
database. Cannot be called when on the insert row.
|
cancelRowUpdates |
cancels the updates made to a row.
|
moveToInsertRow |
moves the cursor to the insert row. The current cursor position is
remembered while the cursor is positioned on the insert row.
|
moveToCurrentRow |
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.
|
Methods' Details |
insertRow
- Description
- 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.
- Throws
- SQLException
if a database access error occurs.
|
|
updateRow
- Description
- updates the underlying database with the new contents of the
current row. Cannot be called when on the insert row.
- Throws
- SQLException
if a database access error occurs.
|
|
deleteRow
- Description
- deletes the current row from the result set and the underlying
database. Cannot be called when on the insert row.
- Throws
- SQLException
if a database access error occurs.
|
|
cancelRowUpdates
- Description
- cancels the updates made to a row.
This method may be called after calling an
updateXXX
method(s) and before calling
XResultSetUpdate::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.
- Throws
- SQLException
if a database access error occurs.
|
|
moveToInsertRow
- Description
- 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
XResultSetUpdate::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.
- Throws
- SQLException
if a database access error occurs.
|
|
moveToCurrentRow
- Description
- 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.
- Throws
- SQLException
if a database access error occurs.
|
|
Top of Page
Copyright © 2013, The Apache Software Foundation, Licensed under the Apache License, Version 2.0. Apache, the Apache feather logo, Apache OpenOffice and OpenOffice.org are trademarks of The Apache Software Foundation. Other names may be trademarks of their respective owners.