The Java Developers Almanac 1.4


Order this book from Amazon.

   
Home > List of Packages > java.sql  [73 examples] > Updatable Result Sets  [8 examples]

e275. Updating a Row in a Database Table Using an Updatable Result Set

Updating the current row of an updatable result set involves calling ResultSet.updateXXX() methods followed by a call to updateRow().

See also e273 Creating an Updatable Result Set.

    try {
        // Create an updatable result set
        Statement stmt = connection.createStatement(
            ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
        ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table");
    
        // Move cursor to the row to update
        resultSet.first();
    
        // Update the value of column col_string on that row
        resultSet.updateString("col_string", "new data");
    
        // Update the row; if auto-commit is enabled, update is committed
        resultSet.updateRow();
    } catch (SQLException e) {
    }

 Related Examples
e272. Determining If a Database Supports Updatable Result Sets
e273. Creating an Updatable Result Set
e274. Determining If a Result Set Is Updatable
e276. Cancelling Updates to an Updatable Result Set
e277. Inserting a Row into a Database Table Using an Updatable Result Set
e278. Deleting a Row from a Database Table Using an Updatable Result Set
e279. Refreshing a Row in an Updatable 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    Scrollable Result Sets    Tables   


© 2002 Addison-Wesley.