本文共 1621 字，大约阅读时间需要 5 分钟。

ACID???????????????????????????????????????????????????????????????????????????????????????????

??????

???????????????????????????????????

• ???Dirty Read????????????????????????
• ??????Non-Repeatable Read??????????????????????????????
• ??????Ghost Read??????????????????????????????

Java??????

???????Java??????????

public class TestTransaction {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            conn = JdbcUtils.getConnection();
            conn.setAutoCommit(false); // ????
            String sql1 = "update account set money = money - 100 where name = 'A'";
            ps = conn.prepareStatement(sql1);
            ps.executeUpdate();
            // ????
            int x = 1 / 0; // ????
            String sql2 = "update account set money = money + 100 where name = 'B'";
            ps = conn.prepareStatement(sql2);
            ps.executeUpdate();
            conn.commit(); // ??????
            System.out.println("???");
        } catch (SQLException e) {
            try {
                conn.rollback(); // ???????
            } catch (SQLException e1) {
                e1.printStackTrace();
            }
            e.printStackTrace();
        } finally {
            JdbcUtils.release(conn, ps, rs);
        }
    }
}

????

??????????????????????????????????????rollback()????????