Java连接Oracle

package com.sp;

import java.sql.*;

 

//方法1，使用jdbc_odbc桥连接方式

public class TestOra {

    /**

     * @param args

     */

    public static void main(String[] args) {

       // TODO Auto-generated method stub

       try{

           //1.加载驱动

           Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

           //2.得到连接

           Connection ct = DriverManager.getConnection("jdbc:odbc:testsp","scott","tiger");

          

           //............

           Statement sm = ct.createStatement();

           ResultSet rs = sm.executeQuery("select * from emp");

          

           while(rs.next()){

              //用户名

              System.out.println("username:"+rs.getString(2));

           }

       }catch(Exception e){

           e.printStackTrace();

       }

    }

}

 

---

package com.sp;

import java.sql.*;

 

//方法2，使用JDBC连接oracle（和方法1很类似）

public class TestOra2 {

    /**

     * @param args

     */

    public static void main(String[] args) {

       // TODO Auto-generated method stub

       try{

           //1.加载驱动

           Class.forName("oracle.jdbc.driver.OdbcDriver");//要记住

           //2.得到连接

           Connection ct = DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:myora1","scott","tiger");

           //............

           Statement sm = ct.createStatement();

          

           ResultSet rs = sm.executeQuery("select * from emp");

          

           while(rs.next()){

              //用户名

              System.out.println("username:"+rs.getString(2));

           }

       }catch(Exception e){

           e.printStackTrace();

       }

    }

}