Cancelling Updates to an Updatable Result Set
The effects of calling Result.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) {
}
Post a comment