Java的JDBC的事务
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JDBC11 {
public static void main(String[] args) throws SQLException {
Connection con = DriverManager.getConnection("jdbc:mysql:///hsp_db02", "root", "011012");
con.setAutoCommit(false);
String sql1 = "update account set balance=balance-? where id=?";
String sql2 = "update account set balance=balance+? where id=?";
PreparedStatement p1 = con.prepareStatement(sql1);
PreparedStatement p2 = con.prepareStatement(sql2);
p1.setDouble(1, 500);
p1.setDouble(2, 1);
p2.setDouble(1, 500);
p2.setDouble(2, 2);
p1.executeUpdate();
p2.executeUpdate();
con.commit();
p1.close();
p2.close();
con.close();
if (con != null) {
con.rollback();
}
}
}