![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e275. Updating a Row in a Database Table Using an Updatable Result SetUpdating the current row of an updatable result set involves callingResultSet.updateXXX() methods followed by a call to updateRow() .
See also e273 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) { }
e273. Creating an Updatable Result Set e274. Determining If a Result Set Is Updatable e276. Cancelling Updates to an Updatable Result Set e277. Inserting a Row into a Database Table Using an Updatable Result Set e278. Deleting a Row from a Database Table Using an Updatable Result Set e279. Refreshing a Row in an Updatable Result Set © 2002 Addison-Wesley. |