Oracle 事务的应用
来源：互联网 发布：网络普通发票验旧 编辑：程序博客网 时间：2024/05/12 05:30
package com.sw;import java.sql.*;public class TestTrans {/** * 事务举例 * 添加事务，提交事务，回滚 */public static void main(String[] args) {Connection conn = null;Statement stmt = null;try {//声明驱动Class.forName("oracle.jdbc.driver.OracleDriver");//加载连接conn = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:orcl","scott","Oracle1");//加入事物处理conn.setAutoCommit(false);//创建操作对象stmt = conn.createStatement();//从scott用户上减去100stmt.executeUpdate("update emp set sal=sal-100 where ename='SCOTT'");//给smithstmt.executeUpdate("update emp set sal=sal+100 where ename='SMITH'");//提交事务conn.commit();} catch (Exception e) {// 如果发生异常则回滚try {conn.rollback();} catch (SQLException e1) {// TODO Auto-generated catch blocke1.printStackTrace();}e.printStackTrace();}finally{try {stmt.close();conn.close();} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();}}}}
