e276. cancelling updates to an updatable result set.txt

这里面包含了一百多个JAVA源文件

The effects of calling Result.updateXXX() methods can be cancelled by calling cancelRowUpdates(). However, updates cannot be cancelled after updateRow() has been called. 
    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");
    
        // Discard the update to the row
        resultSet.cancelRowUpdates();
    } catch (SQLException e) {
    }