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(?,?)";                pstmt = conn.prepareStatement(sqlInsert);        pstmt.setString(1, "danny");        pstmt.setString(2, "123");        pstmt.executeUpdate();   //运行改动操作        String sqlUpdate = "update t_user set userPassword=? where userName = ?";        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();        }      }}}