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");
  
        //將事務(wù)模式設(shè)置為手動(dòng)提交事務(wù)：
        conn.setAutoCommit(false);
  
        //設(shè)置事務(wù)的隔離級(jí)別。
        conn.setTransactionIsolation(Connection.TRANSACTION_REPEATABLE_READ);
        
 //運(yùn)行插入操作
        String sqlInsert = "insert into t_user(userName,userPassword) values(?,?
)";        
        pstmt = conn.prepareStatement(sqlInsert);
        pstmt.setString(1, "danny");
        pstmt.setString(2, "123");
        pstmt.executeUpdate();
  
 //運(yùn)行改動(dòng)操作
        String sqlUpdate = "update t_user set userPassword=? where userName = ?";
        pstmt = conn.prepareStatement(sqlUpdate);
        pstmt.setString(1, "123456");
        pstmt.setString(2, "danny");        
        pstmt.executeUpdate();
  
        //提交事務(wù)
        conn.commit();
  
      } catch (Exception e) {        
        // 若事務(wù)發(fā)生異常，回滾事務(wù)
        conn.rollback();
      }finally{        
        if (pstmt!=null) {
          pstmt.close();
        }
        if (conn!=null) {
          conn.close();
        }
      }
}
}