1)建立JDeveloper工作区与项目 2)建立TestConnection.java文件 //取得Oracle9i数据库连接信息 import java.sql.*; public class TestConnection { public static void main(String args[]) throws SQLException { //注册Oracle JDBC驱动程序 DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); //建立新数据库连接 Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:myoracle","scott","tiger"); //取得连接数据 DatabaseMetaData md=conn.getMetaData(); System.out.println("数据库版本"); System.out.println("--------------------------"); System.out.println(md.getDatabaseProductVersion()); System.out.println(); System.out.println("驱动程序名称与版本"); System.out.println("---------------------------"); System.out.println(md.getDriverName()+" "+md.getDriverVersion()); //关闭数据库连接 conn.close(); } } 3)编译会出现编译错误cannot access class oracle.jdbc.driver.oracleDriver. 4)设置项目的函数库:Project->Project Setting,在Libraries节点选择JDeveloper Runtime和Oracle JDBC两个库。 5)执行结果 Waiting for profiler UI on port 18988 Profiler UI connected ... 数据库版本 -------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production 驱动程序名称与版本 --------------------------- Oracle JDBC driver 9.0.1.5.0 |