How to make updates in Updatable ResultSet?
Using an updatable resultset enable our program to update record in the database from the
ResultSet object. The operation on the
ResultSet object can be update, insert or delete. With this mechanism we can update database without executing an sql command.
In the example below we have a product table with the
price. In the first step after we load the resultset we update the product title of the first record. Then we move to the next record and delete it. At last we insert a new record to database.