autocommitdemo.java

软通公司培训的课件和习题里面有答案。。。

package com.ten.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class AutoCommitDemo {


	private Connection conn = null ;
	private Statement stmt = null ;
	private ResultSet rs = null ;
	
	private String url = "jdbc:oracle:thin:@127.0.0.1:1521:stan" ;
	private String username = "stan";
	private String password = "stan";
	private String sql = "" ;
	
	public AutoCommitDemo(){
		try{
			// 1 注册，加载Oacle驱动程序
			DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
			// 2 建立连接
			conn = DriverManager.getConnection(url,username,password);
			conn.setAutoCommit(false);
		}catch(SQLException e){
			e.printStackTrace();
		}
	}
	
	public void updateEmpSalery(){
		
		sql = " update emp set sal=sal+1 where empno = 7369" ;
		String sql1 = "update emp set sal=sal+1 where empnoa = 7369";

		
		try {
			stmt = conn.createStatement();
			
			stmt.execute(sql);
			stmt.execute(sql1);
			
			conn.commit();
			
		} catch (SQLException e) {
			 
			e.printStackTrace();
			try {
				conn.rollback();
			} catch (SQLException e1) {
				 
				e1.printStackTrace();
			}
		}	
	}
	
	public void closeConn(){
		try{
			if(rs!=null){
				this.conn.close();
			}	
			if(stmt!=null){
				this.stmt.close();
			}
			if(conn!=null){
				this.conn.close();
			}
		}catch(SQLException e){
			e.printStackTrace();
		}

	}
	
	
	public static void main(String[] args) {
		AutoCommitDemo ps = new AutoCommitDemo();
		ps.updateEmpSalery();
		ps.closeConn();
	}


}