Interface XResultSetUpdate

Devguide

Index

Methods' Summary

Attributes' Summary

Methods' Details

Attributes' Details

:: 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

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.

API

SDK

Tips ‘n’ Tricks

Miscellaneous