5.2. Local Transactions

// Set auto commit to false and start a transaction
connection.setAutoCommit(false);

try 
{
    // Execute multiple updates
    Statement statement = connection.createStatement();
    statement.executeUpdate("INSERT INTO Accounts (ID, Name) VALUES (10, 'Mike'™)");
    statement.executeUpdate("INSERT INTO Accounts (ID, Name) VALUES (15, 'John'™)");
    statement.close();

    // Commit the transaction
    connection.commit();
} 
catch(SQLException e) 
{
    // If an error occurs, rollback the transaction
    connection.rollback();
}

// Set auto commit to false and start a transaction
connection.setAutoCommit(false);

try 
{
    // Execute multiple updates
    Statement statement = connection.createStatement();
    statement.executeUpdate("INSERT INTO Accounts (ID, Name) VALUES (10, 'Mike'™)");
    statement.executeUpdate("INSERT INTO Accounts (ID, Name) VALUES (15, 'John'™)");
    statement.close();

    // Commit the transaction
    connection.commit();
} 
catch(SQLException e) 
{
    // If an error occurs, rollback the transaction
    connection.rollback();
}