![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e277. Inserting a Row into a Database Table Using an Updatable Result SetAn updatable result supports a row called the insert row. It is a buffer for holding the values of a new row. After the fields in the insert row are filled, the new row can be inserted into the database usingResult.insertRow() .
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 "insert row" resultSet.moveToInsertRow(); // Set values for the new row. resultSet.updateString("col_string", "new data"); // Insert the row resultSet.insertRow(); } catch (SQLException e) { }
e273. Creating an Updatable Result Set e274. Determining If a Result Set Is Updatable e275. Updating a Row in a Database Table Using an Updatable Result Set e276. Cancelling Updates to 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. |