事务

在使用java执行sql语句的时候, 每次在连接关闭的时候都会执行事务的提交, 因此对于同一个事务中的多个操作, 需要将其放到同一个连接当中

    void transactionTestv2() throws Exception {
        Connection connection = JDBCUtils.getConnection();
//        取消自动提交
        connection.setAutoCommit(false);
        String sql = "update user_table set balance = balance - 100 where user = ?";
        PreparedStatement preparedStatement = connection.prepareStatement(sql);
        preparedStatement.setObject(1, "AA");
        preparedStatement.execute();
        preparedStatement.close();

        String sql1 = "update user_table set balance = balance + 100 where user = ?";
        PreparedStatement preparedStatement1 = connection.prepareStatement(sql1);
        preparedStatement1.setObject(1, "BB");
        preparedStatement1.execute();
        preparedStatement1.close();

        connection.commit();
        connection.setAutoCommit(true);
        connection.close();
    }