![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e267. Creating a Scrollable Result SetA scrollable result set allows the cursor to be moved to any row in the result set. This capability is useful for GUI tools for browsing result sets.See also e266 Determining If a Database Supports Scrollable Result Sets. try { // Create an insensitive scrollable result set Statement stmt = connection.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); // Create a sensitive scrollable result set stmt = connection.createStatement( ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY); } 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. |