If you want to edit the result set data and have the changes automatically reflected in the database, create an updatable result set. Updatable result sets don’t have to be scrollable, but if you present data to a user for editing, you usually want to allow scrolling as well.
To obtain updatable result sets, create a statement as follows:
Statement stat = conn.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
The result sets returned by a call to
executeQuery are then updatable.
Not all queries return updatable result sets. If your query is a join ...