JDBC执行事务

package com.haoran.lesson4;

import com.haoran.lesson2.utils.jdbcUtils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class transaction {
    public static void main(String[] args) {
        Connection conn=null;
        PreparedStatement pst=null;
        ResultSet rs=null;

        try {
            conn=jdbcUtils.getConnection();
            conn.setAutoCommit(false);//关闭数据库自动提交功能=开启事务

            String sql1="update account set money=money-200 where name='xiaoli'";
            pst = conn.prepareStatement(sql1);
            pst.executeUpdate();

            //int x=1/0;该处出现错误，则事务不会允许，因为事务的acid

            String sql2="update account set money=money+200 where name='xiaowang'";
            pst = conn.prepareStatement(sql2);
            pst.executeUpdate();
            //事务执行完毕；

            conn.commit();
            System.out.println("执行成功");

        } catch (SQLException e) {
            try {
                conn.rollback();//如果失败则回滚事务
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
            e.printStackTrace();
        }finally {
            jdbcUtils.release(conn,pst,rs);
        }

    }
}