![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e273. Creating an Updatable Result SetAn updatable result set allows modification to data in a table through the result set. If the database does not support updatable result sets, the result sets returned fromexecuteQuery() will be
read-only. To get updatable results, the Statement object used to
create the result sets must have the concurrency type
ResultSet.CONCUR_UPDATABLE .
The query of an updatable result set must specify the primary
key as one of the selected columns and select from only one table.
For some drivers, ` See also e272 Determining If a Database Supports Updatable Result Sets. try { // Create a statement that will return updatable result sets Statement stmt = connection.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE); // Primary key col_string must be specified so that the result set is updatable ResultSet resultSet = stmt.executeQuery("SELECT col_string FROM my_table"); } catch (SQLException e) { }
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 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. |