java连接oracle数据库

1）

oracle的驱动程序为D:/oracle/ora92/jdbc/lib/classes12.jar和D:/oracle/ora92/jdbc/lib/classes12.zip

应该放到C:/Program Files/Java/jdk1.5.0_04/jre/lib/ext中，否则抛出Exception in thread "main" java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver的错误。

2）

Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection
("jdbc:Oracle:thin:@127.0.0.1:1521:SUNXF","sun","sunxf");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select * from sys.sunxf");
while(rs.next()){
System.out.println(rs.getString(1));};