Example Depot

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) { }