Learn Java

Updating a CachedRowSet object is similar to updating a ResultSet object, but because the rowset is not connected to its data source while it is being updated, it must take an additional step to effect changes in its underlying data source. After calling the method updateRow or insertRow, a CachedRowSet object must also call the method acceptChanges to have updates written to the data source. The following example, in which the cursor is on a row in the CachedRowSet object crs, shows the code required to update two column values in the current row and also update the RowSet object's underlying data source.     crs.updateShort(3, 58);     crs.updateInt(4, 150000);     crs.updateRow();     crs.acceptChanges(); The next example demonstrates moving to the insert row, building a new row on the insert row, inserting it into the rowset, and then calling the method acceptChanges to add the new row to the underlying data source. Note that as with the getter methods, the updater methods may take either a column index or a column name to designate the column being acted upon.     crs.moveToInsertRow();     crs.updateString("Name", "Shakespeare");     crs.updateInt("ID", 10098347);     crs.updateShort("Age", 58);     crs.updateInt("Sal", 150000);     crs.insertRow();     crs.moveToCurrentRow();     crs.acceptChanges(); NOTE: Where the insertRow() method inserts the contents of a CachedRowSet object's insert row is implementation-defined. The reference implementation for the CachedRowSet interface inserts a new row immediately following the current row, but it could be implemented to insert new rows in any number of other places.Another thing to note about these examples is how they use the method acceptChanges. It is this method that propagates changes in a CachedRowSet object back to the underlying data source, calling on the RowSet object's writer internally to write changes to the data source. To do this, the writer has to incur the expense of establishing a connection with that data source. The preceding two code fragments call the method acceptChanges immediately after calling updateRow or insertRow. However, when there are multiple rows being changed, it is more efficient to call acceptChanges after all calls to updateRow and insertRow have been made. If acceptChanges is called only once, only one connection needs to be established.
Previous Next
Java

Topic: JDBC

Explain method Updating a CachedRowSet Object?

Browse random answers:

Quick Links:

Java

Topic: JDBC

Explain method Updating a CachedRowSet Object?

Browse random answers:

BE THE FIRST TO KNOW

Quick Links:
