用idea提交事务

要么都成功要么都失败

ACID原则：原子性要么要么、一致性总数不变、隔离性多进程互不干扰、持久性一旦提交不可逆

提交事务练习

/*测试事务
成功则提交，失败则回滚
 */

import com.xy.MySQL.myMethods.JDBCUtils;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

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

        try{
            //连接数据库
            conn = JDBCUtils.getConnection();//连接到jdbctest数据库

            //关闭数据库的自动提交功能,会自动开启事务
            conn.setAutoCommit(false);//因为会自动开启事务，所以不用像SQL语句那样再写开启事务语句

            //执行业务
            String sql1 = "UPDATE account SET money = money-100 WHERE name='A'";
            pst = conn.prepareStatement(sql1);
            pst.executeUpdate();

            String sql2 = "update account set money = money+100 where name='B'";
            pst = conn.prepareStatement(sql2);
            pst.executeUpdate();

            //业务完毕，提交事务
            conn.commit();
            System.out.println("转账成功");
            conn.setAutoCommit(true);//开启自动提交

        } catch (SQLException e){
            try{
                System.out.println("转账失败");
                conn.rollback();//如果失败则回滚业务
            }catch(SQLException e1){
                e1.printStackTrace();
            }
            e.printStackTrace();
        } finally {
            JDBCUtils.release(conn,pst,rs);
        }
    }
}

运行结果

如上图所示，事务提交成功

接下来再试验一下提交失败回滚

在两个sql之间加一条必定失败的语句，如 int i = 1/0;

/*测试事务
成功则提交，失败则回滚
 */

import com.xy.MySQL.myMethods.JDBCUtils;

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

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

        try {
            conn = JDBCUtils.getConnection();

            conn.setAutoCommit(false);
            //关闭自动提交 也就是开启事务

            String sql1 = "update account set money=money-100 where name ='A'";
            st=conn.prepareStatement(sql1);
            st.executeUpdate(sql1);

            int i=1/0;  //万能报错

            String sql2 = "update account set money=money+100 where name ='B'";
            st=conn.prepareStatement(sql2);
            st.executeUpdate(sql2);

            //事务提交

            conn.commit();
            System.out.println("转账成功");
            conn.setAutoCommit(true);
        } catch (SQLException throwables) {
            //如果失败自动回滚
            try {
                System.out.println("转账失败");
                conn.rollback();
            } catch (SQLException e) {
                e.printStackTrace();
            }

            throwables.printStackTrace();
        }finally {
            JDBCUtils.release(conn,st,rs);
        }
    }
}