![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e266. Determining If a Database Supports Scrollable Result SetsA scrollable result set allows the cursor to be moved to any row in the result set. This capability is useful for GUI tools that browse result sets.There are two types of scrollable result sets. An insensitive scrollable result set is one where the values captured in the result set never change, even if changes are made to the table from which the data was retrieved. A sensitive scrollable result set is one where the current values in the table are reflected in the result set. So if a change is made to a row in the table, the result set will show the new data when the cursor is moved to that row. try { DatabaseMetaData dmd = connection.getMetaData(); if (dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE)) { // Insensitive scrollable result sets are supported } if (dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE)) { // Sensitive scrollable result sets are supported } if (!dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_INSENSITIVE) && !dmd.supportsResultSetType(ResultSet.TYPE_SCROLL_SENSITIVE)) { // Updatable result sets are not supported } } catch (SQLException e) { }
e268. Determining If a Result Set Is Scrollable e269. Moving the Cursor in a Scrollable Result Set e270. Getting the Cursor Position in a Scrollable Result Set e271. Getting the Number of Rows in a Table Using a Scrollable Result Set © 2002 Addison-Wesley. |