JDBC - Transaction

CREATE TABLE account(
   id INT PRIMARY KEY AUTO_INCREMENT,
   name VARCHAR(40),
   money FLOAT   
);
INSERT INTO account(name,money) VALUES(‘aa‘,1000);
INSERT INTO account(name,money) VALUES(‘aa‘,1000);
INSERT INTO account(name,money) VALUES(‘aa‘,1000);

START TRANSACTION;
UPDATE account SET money=money-100 WHERE name=‘aa‘;
UPDATE account SET money=money+100 WHERE name=‘bb‘;
COMMIT;

package com.pp.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import org.junit.Test;
import com.pp.util.JdbcUtil;

public class TransactionDemo {
    @Test
    public void test1() {
        Connection connection = null;
        PreparedStatement pstatement = null;
        try {
            connection = JdbcUtil.getConnection();
            // start transaction
            connection.setAutoCommit(false);
            pstatement = connection
                    .prepareStatement("UPDATE accout SET money=money-100 WHERE name=‘aa‘");
            pstatement.executeUpdate();
            pstatement = connection
                    .prepareStatement("UPDATE accout SET money=money-100 WHERE name=‘aa‘");
            pstatement.executeUpdate();
            // commit
            connection.commit();
        } catch (Exception e) {
            e.printStackTrace();
        } finally {
        }
    }
}