1、事务的执行
package jdbc_5_transaction;
import jdbc_2_util.JDBCUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class TransactionTest01 {
public static void main(String[] args) {
Connection conn=null;
try{
conn=JDBCUtils.getConnection();
//取消自动提交
conn.setAutoCommit(false);
String sql1="update user_table set balance =balance-100 where user=?";
update(conn,sql1,"AA");
System.out.println(10/0);
String sql2 = "update user_table set balance = balance + 100 where user = ?";
update(conn,sql2, "BB");
System.out.println("转账成功");
conn.commit();
}catch(Exception e){
e.printStackTrace();
try {
conn.rollback();
} catch (SQLExcept