:: com :: sun :: star :: sdbc ::
|
interface XResultSetUpdate |
|
- Description
- provides the possibility 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 © 2000, 2013 LibreOffice contributors and/or their affiliates. All rights reserved.
LibreOffice was created by The Document Foundation, based on OpenOffice.org, which is Copyright 2000, 2010 Oracle and/or its affiliates.
The Document Foundation acknowledges all community members, please find more info at our website.
Privacy Policy | Impressum (Legal Info) | Copyright information: The source code of LibreOffice is licensed under the GNU Lesser General Public License (LGPLv3). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.