jdbc操作和开启事务

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(); } }

 

上一篇:PHP简单连接操作数据库


下一篇:Lindrom 实践 | Spark 对接 Lindorm Phoenix 5.x 轻客户端