testcommit.java

来自「JDBC,指定数据库,打开数据库连接 数据库查询、修改、增加或删除等」· Java 代码 · 共 32 行

import java.sql.*;
public class TestCommit{	
    public static void main(String args[]){
		String serverName = "localhost";
		Connection conn =null;
		Statement stmt=null;
		
		try{
		    Class.forName("oracle.jdbc.driver.OracleDriver");
		    String url="jdbc:oracle:thin:@"+serverName+":1521:ora9i";
		    conn=DriverManager.getConnection(url,"scott","tiger");
		    conn.setAutoCommit(false);
		    stmt=conn.createStatement();
			//stmt.executeUpdate("insert into dept values(13,'dirk','new')");
		    stmt.execute("insert into dept values('64','1111','2222')");
			conn.commit();
			
		}catch(Exception e){
		    e.printStackTrace();
		    conn.rollback();
		}
		finally{
			try{
				stmt.close();
				conn.close();
		    }catch(Exception e){
		    e.printStackTrace();
		}
		}
    }
}