Updating a Row in a Database Table Using an Updatable Result Set
Updating the current row of an updatable result set involves calling
ResultSet.updateXXX() methods followed by a call to updateRow().
See also Creating an Updatable Result Set.
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");
// Update the row; if auto-commit is enabled, update is committed
resultSet.updateRow();
} catch (SQLException e) {
}
This does usually not work. You have to name the columns explicitely in the select, otherwise (when using select * ) you get a non-updatable result set.