![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e276. Cancelling Updates to an Updatable Result SetThe effects of callingResult.updateXXX() methods can be cancelled by
calling cancelRowUpdates() . However, updates cannot be cancelled
after updateRow() has been called.
try { // Create an updatable result set Statement stmt = connection.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table"); // Move cursor to the row to update resultSet.first(); // Update the value of column col_string on that row resultSet.updateString("col_string", "new data"); // Discard the update to the row resultSet.cancelRowUpdates(); } catch (SQLException e) { }
e273. Creating an Updatable Result Set e274. Determining If a Result Set Is Updatable e275. Updating a Row in a Database Table Using an Updatable Result Set e277. Inserting a Row into a Database Table Using an Updatable Result Set e278. Deleting a Row from a Database Table Using an Updatable Result Set e279. Refreshing a Row in an Updatable Result Set © 2002 Addison-Wesley. |