The Java Developers Almanac 1.4


Order this book from Amazon.

   
Home > List of Packages > java.sql  [73 examples] > Scrollable Result Sets  [6 examples]

e269. Moving the Cursor in a Scrollable Result Set

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

 Related Examples
e266. Determining If a Database Supports Scrollable Result Sets
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

See also: Batching    Connections    Database Meta Data    Deleting Data    Drivers    Importing and Exporting    Inserting and Updating Data    Oracle OBJECTs    Oracle VARRAYs    Procedures and Functions    Retrieving Data    Tables    Updatable Result Sets   


© 2002 Addison-Wesley.