JDBC Questions and Answers

How to update a resultset programmatically?

a. create a scrollable and updatable ResultSet object.
Statement stmt = con.createStatement
(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
ResultSet uprs = stmt.executeQuery(“SELECT COLUMN_1,
COLUMN_2 FROM TABLE_NAME”);

b. move the cursor to the specific position and use related method to update data and then, call updateRow() method.
uprs.last();
uprs.updateFloat(“COLUMN_2”, 25.55);//update last row’s data
uprs.updateRow();//don’t miss this method, otherwise,
// the data will be lost.