Java：jdbc事务

public class jdbcCom {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/jdbc?useUnicode=true&characterEncoding=utf-8";

        String username = "root";
        String password = "1340508016";

        Connection connection = null;

        try {
            Class.forName("com.mysql.jdbc.Driver");

            connection = DriverManager.getConnection(url, username, password);

            //通知数据库开启事务，取消自动提交就是开启手动提交
            connection.setAutoCommit(false);

            String sql1 = "update moncard set money =  money-100 where name='B'";

            connection.prepareStatement(sql1).executeUpdate();

            String sql2 = "update moncard set money =  money+100 where name='A'";

            //主动制造错误
            int i = 1/0;
            connection.prepareStatement(sql2).executeUpdate();
            System.out.println("success");

            //主动提交
            connection.commit();


        } catch (Exception e) {
            try {
                connection.rollback();
                System.out.println("false");
            } catch (SQLException ex) {
                ex.printStackTrace();
            }finally {
                try {
                    //最后都要关闭资源
                    connection.close();
                } catch (SQLException ex) {
                    ex.printStackTrace();
                }
            }
        }
    }
}