package JDBC; import java.sql.*; public class TestOraJdbc { /** * @param args */ public static void main(String[] args) { // TODO Auto-generated method stub try{ //step1.add drives Class.forName("oracle.jdbc.driver.OracleDriver"); //step2.get connection Connection conn=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:DHY","scott","tiger"); //step3.creat statement Statement sm=conn.createStatement(); //step4.result set ResultSet rs=sm.executeQuery("select * from emp"); while(rs.next()){//has next System.out.println("用户名:"+rs.getString(2)); } //step5.close all rs.close(); sm.close(); conn.close(); } catch(Exception e){ e.printStackTrace(); } } } 注: 1.要引入JAR包:classes12.jar(在你的oracle安装路径下,如D:/oracle/ora90/jdbc/lib下就有这个包) 2.无需引入数据源(ODBC)里的数据源连接,直接写你的SID的name,如这里的DHY