package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ThreeJdbc {

   public static void main(String[] args) {
       // TODO Auto-generated method stub
       Connection con = null;
       Statement stmt = null;
       ResultSet rs = null;
       int cnt;
       StringBuffer str =new StringBuffer();
       try
       {
           con = DriverManager.getConnection("jdbc:oracle:oci:@local","scott", "oracle");
           stmt = con.createStatement();
           rs = stmt.executeQuery("select * from t");
//           cnt = stmt.executeQuery("delete from t");
//           System.out.print(cnt);
           while(rs.next()){
               str = str.append(rs.getInt(1)).append(" : ").append(rs.getString(2)).append("\n");
           }
           System.out.println(str);
       }
       catch(Exception e){
           e.printStackTrace();
       }
       finally{
           try {
           if (rs != null) rs.close();
           if (stmt != null) stmt.close();
           if(con != null) con.close();
       }catch(Exception e) {e.printStackTrace();}
       }
   }

}

註釋： 1）local 是tnsname
          2) oci 需要本地安裝oracle 客戶端，因為會呼叫$ORACLE_HOME/bin/ocijdbc11.dll   的dll控制元件（注意32位還是64位）
          3）仍然需要安裝ojdbc6.jar 驅動

java oci 連線

相關文章