Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.15

API

SDK

Tips ‘n’ Tricks

Miscellaneous


:: 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
void
insertRow()
raises( SQLException );

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
void
updateRow()
raises( SQLException );

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
void
deleteRow()
raises( SQLException );

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
void
cancelRowUpdates()
raises( SQLException );

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
void
moveToInsertRow()
raises( SQLException );

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
void
moveToCurrentRow()
raises( SQLException );

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

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache, OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. The Apache feather logo is a trademark of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.