jdbc操作和开启事务





public
static void test(){ //1.数据库驱动类名的字符串 String driver = "com.mysql.jdbc.Driver"; //2.用户名 String username = root; //3.密码 String password = "root"; //4.加载数据库驱动(加载成功后,会把Driver的实例注册到DriverManager中) try{ Class.forName(driver); Connection conn = null; Statemnet stmt = null;
  //5.获取数据库连接 conn
= DriverManager.getConnection();   //6.获取连接对象
    Statement stmt
= conn.createStatement(); //7.开启手动提交事务
  conn.setAutoCommit(
false); //8.执行sql语句
stmt.executeUpdate(
"update student set money=? where id =?",new int[]{8,1})
  stmt.executeUpdate("update student set money=? where id=?",new int[]{12,2}); //9.提交事务
conn.commit(); }
catch(Exception e){ //10.回滚事务
conn.rollback(); } }
原文地址:https://www.cnblogs.com/tranquilityMan/p/14488692.html