JDBC处理事务

Transaction，一组操作同时成功或者失败，就是一个事务

---

• 银行转账是事务最经典的一个例子，从这个里面我们可以理解事务有何作用，下面我们用代码来解决一下这个问题
• 具体需求: A向B转账1000，成功后，A账户减1000，B账户加1000；如果失败则各自账户不变

String driverName = "oracle.jdbc.driver.OracleDriver";
String url = "jdbc:oracle:thin:@localhost:1521:orcl";
String user = "scott";
String password = "tiger";
Connection conn = null;
Statement stmt = null;
preparedStatement pstmt = null;
Class.forName(driverName);
conn = DriverManager(url,user,password);
stmt = conn.createStatement();
//jdbc默认自动提交或回滚事务，这里要关闭自动处理事务，只要是在execute前设置就可以了
conn.setAutoCommit(false);
String sql1 = "update t_bankaccount set money = money-1000 where uName = 'A' ";
String sql2 = "update t_bankaccount set money = money+1000
where uName = 'B' ";
stmt.executeUpdate(sql1);
stmt.executeUpdate(sql2);
//下面注释的代码使用preparedStatement()实现事务
//String sql = "update t_bankaccount set money = money-? where uName = ?";
//conn.setAutoCommit(false);
//pstmt = conn.preparedStatement(sql);
//pstmt.setInt(1,1000);
//pstmt.setString(2,"A");
//pstmt.executeUpdate();
//pstmt.setInt(1,-1000);
//pstmt.setString(2,"B");
//pstmt.executeUpdate();
conn.commit();//当前面执行成功，手动提交事务
//然后在捕获的SQL异常里面加上自动回滚
conn.rollback();
//关闭资源
stmt.close();
//pstmt.close();
conn.close();