Java与Oracle实现事务（JDBC事务）实例详解

import java.sql.*;

public class TransactionTest{

public static void main(String[] args) throws SQLException {
 try {
     Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection cOnn= DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","TransactionTest","123456");
  
        //将事务模式设置为手动提交事务：
        conn.setAutoCommit(false);
  
        //设置事务的隔离级别。
        conn.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
        
 //运行插入操作
        String sqlInsert = "insert into t_user(userName,userPassword) values(&＃63;,&＃63;
)";        
        pstmt = conn.prepareStatement(sqlInsert);
        pstmt.setString(1, "danny");
        pstmt.setString(2, "123");
        pstmt.executeUpdate();
  
 //运行改动操作
        String sqlUpdate = "update t_user set userPassword=&＃63; where userName = &＃63;";
        pstmt = conn.prepareStatement(sqlUpdate);
        pstmt.setString(1, "123456");
        pstmt.setString(2, "danny");        
        pstmt.executeUpdate();
  
        //提交事务
        conn.commit();
  
      } catch (Exception e) {        
        // 若事务发生异常，回滚事务
        conn.rollback();
      }finally{        
        if (pstmt!=null) {
          pstmt.close();
        }
        if (conn!=null) {
          conn.close();
        }
      }
}
}