Cancelling Updates to an Updatable Result Set : ResultSet Updatable « Database « Java Tutorial

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class Main {
  public static void main(String[] argv) throws Exception {
    String driverName = "com.jnetdirect.jsql.JSQLDriver";

    String serverName = "";
    String portNumber = "1433";
    String mydatabase = serverName + ":" + portNumber;
    String url = "jdbc:JSQLConnect://" + mydatabase;
    String username = "username";
    String password = "password";

    Connection connection = DriverManager.getConnection(url, username, password);
    Statement stmt = connection.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
    ResultSet resultSet = stmt.executeQuery("SELECT * FROM my_table");

    // Move cursor to the row to update

    // Update the value of column col_string on that row
    resultSet.updateString("col_string", "new data");

    // Discard the update to the row


20.12.ResultSet Updatable
20.12.1.Determine if a Database Supports Updatable ResultSets
20.12.2.Create an Updatable ResultSet
20.12.3.Determine if a ResultSet is Updatable
20.12.4.Update a Row in a Database Table Using an Updatable Result Set
20.12.5.Cancel Updates to an Updatable ResultSet
20.12.6.Insert a Row into a Database Table Using an Updatable ResultSet
20.12.7.Delete a Row from a Database Table Using an Updatable ResultSet
20.12.8.Refresh a Row in an Updatable ResultSet
20.12.9.Cancelling Updates to an Updatable Result Set