jdbctest3.java

java与数据库相连接的原程序

package main;

import java.sql.Connection;
import java.sql.DriverManager;

public class JdbcTest3 {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
		String driver="oracle.jdbc.driver.OracleDriver";
		String user="scott";
		String password="tiger";
		String sql="SELECT * FROM  EMP WHERE ENAME=SMITH";		
		try
		{
			//
			oracle.jdbc.driver.OracleDriver orcldriv =new oracle.jdbc.driver.OracleDriver();
			//Class.forName(driver);					
			/*
			 * 保证相应的Driver类已经被加载到 jvm中，并且完成了类的初始化工作就行了，而具体是怎样实现这个功能却是没有讲究的。
			 */
			//获取连接
			Connection conn = DriverManager.getConnection(url, user, password);	
			conn.setAutoCommit(false);
			//执行操作
			sql="INSERT INTO EMP (EMPNO,SAL)VALUES(?,?)";		
			java.sql.PreparedStatement  stmt = conn.prepareStatement(sql);
			stmt.setString(1, "999");
			stmt.setString(2, "4");
			stmt.execute();			
			stmt.close();
			
//			sql="UPDATE PLSQL101_TEST_2 SET NAME=? WHERE GENDER=?";		
//			stmt = conn.prepareStatement(sql);
//			stmt.setString(1, "5555");
//			stmt.setString(2, "3");
//			stmt.execute();			
//			stmt.close();
			
			conn.commit();
		}
		catch(Exception E)
		{
			System.out.println(E);
		}

	}

}