![]() |
The Java Developers Almanac 1.4Order this book from Amazon. |
e269. Moving the Cursor in a Scrollable Result SetThis example demonstrates the various methods for moving the cursor in a scrollable result set.try { // Create a scrollable result set Statement stmt = connection.createStatement( ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY); ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table"); // Move cursor forward while (resultSet.next()) { // Get data at cursor String s = resultSet.getString(1); } // Move cursor backward while (resultSet.previous()) { // Get data at cursor String s = resultSet.getString(1); } // Move cursor to the first row resultSet.first(); // Move cursor to the last row resultSet.last(); // Move cursor to the end, after the last row resultSet.afterLast(); // Move cursor to the beginning, before the first row. // cursor position is 0. resultSet.beforeFirst(); // Move cursor to the second row resultSet.absolute(2); // Move cursor to the last row resultSet.absolute(-1); // Move cursor to the second last row resultSet.absolute(-2); // Move cursor down 5 rows from the current row. If this moves // cursor beyond the last row, cursor is put after the last row resultSet.relative(5); // Move cursor up 3 rows from the current row. If this moves // cursor beyond the first row, cursor is put before the first row resultSet.relative(-3); } catch (SQLException e) { }
e267. Creating a Scrollable Result Set e268. Determining If a Result Set Is Scrollable 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. |