package com.aaa.demo1;

 import com.aaa.demo.JdbcUtils;

 import java.sql.Connection;

 import java.sql.PreparedStatement;

 import java.sql.SQLException;

 public class DemoTranscation {

     public static void main(String[] args) {

         Connection conn = null;

         PreparedStatement ps = null;

 //        1 获取链接

         try {

             conn = JdbcUtils.getConnectio();

             //2 开启事物

            conn.setAutoCommit(false);

 //        3 获取PreparedStatement

             ps = conn.prepareStatement("UPDATE count SET money = money-? WHERE cname =?");

 //        4 使用PreparedStatement 两次更新操作

             ps.setDouble(1, 500);

             ps.setString(2, "樱花落");

             ps.executeUpdate();

             System.out.println(111 / 0);

             ps = conn.prepareStatement("UPDATE count SET money = money+? WHERE cname =?");

             ps.setDouble(1, 500);

             ps.setString(2, "洛天依");

             ps.executeUpdate();

             //提交事物

            // System.out.println("转账成功");

             //conn.commit();

         } catch (Exception e) {

             //事物回滚

             try {

                 conn.rollback();

             } catch (SQLException e1) {

                 e1.printStackTrace();

             }

             System.out.println("转账失败");

         } finally {

             //关资源

             JdbcUtils.close( conn,ps);

         }

     }

 }