[eclipse安装教程]eclipseÁ¬½Óoracle 11gÊý¾Ý¿âͼÎĽ̳Ì

【www.quanqiunao.cn--java】

Eclipse ÊÇÒ»¸ö¿ª·ÅÔ´´úÂëµÄ¡¢»ùÓÚJavaµÄ¿ÉÀ©Õ¹¿ª·¢Æ½Ì¨¡£Eclipse ¸½´øÁËÒ»¸ö±ê×¼µÄ²å¼þ¼¯£¬°üÀ¨Java¿ª·¢¹¤¾ß£¨Java Development Kit£¬JDK£©¡£

1.Ê×ÏÈÏȽ¨Á¢Ò»¸öÏîÄ¿DB£¬ÓÒ¼üµã»÷DB,Ñ¡ÔñBuild Path-->Configure Build Path½øÈë

ͨ¹ýAdd External JARs..Ñ¡ÔñD:\orcl\app\hr\product\11.2.0\dbhome_1\owb\wf\libϵÄojdbc14.jar£¬µã»÷ok¡£

2.±àдConnectOracle.javaÎļþ

package com.wuy;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class ConnectOracle {

 private Connection con;
 private String user="scott";
 //private String user = "sys as sysdba";
 private String password="18233188050";
 private String className="oracle.jdbc.driver.OracleDriver";
 //private String url="jdbc:oracle:oci@localhost:1158:orcl";Õâ¸öurl¿ÉÄÜÎÞЧ
 private String url = "jdbc:oracle:thin:@hr-PC:1521:orcl";hr-PCºÍ1521ºÜ¹Ø¼ü,Ò²¾ÍÊÇÕìÌý´®ÀïÓÐûÓÐÕâ¸ö£¬ÔÚ
D:\orcl\app\hr\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.oraÕâ¸öÎļþÀïÓÐûÓУ¬Ò»¶¨Òª¸ù¾Ýtnsnames.oraÕâ¸öÎļþÀ´ÅäÖÃurl·¾¶£¬·ñÔò»á³ö´í£¡£¡£¡

 public ConnectOracle(){
  try{
   Class.forName(className);
   System.out.println("¼ÓÔØÊý¾Ý¿âÇý¶¯³É¹¦£¡");
  }catch(ClassNotFoundException e){
   System.out.println("¼ÓÔØÊý¾Ý¿âÇý¶¯Ê§°Ü£¡");
   e.printStackTrace();
  }
 }

 /**´´½¨Êý¾Ý¿âÁ¬½Ó*/
 public Connection getCon(){
  try {
   con=DriverManager.getConnection(url,user,password);
   System.out.println("´´½¨Êý¾Ý¿âÁ¬½Ó³É¹¦£¡");
  } catch (SQLException e) {
   System.out.print(con);
   System.out.println("´´½¨Êý¾Ý¿âÁ¬½Óʧ°Ü£¡");
   con=null;
   e.printStackTrace();
  }
  return con;
 } 

 public void closed(){
  try{
   if(con!=null){
    con.close();
   }
  }catch(SQLException e){
   System.out.println("¹Ø±Õcon¶ÔÏóʧ°Ü£¡");
   e.printStackTrace();
  }
 }

 public static void main(String[] args)
 {
  ConnectOracle c=new ConnectOracle();
  c.getCon();
  c.closed();
 }
}

3.ÔËÐнá¹û£º

本文来源：http://www.quanqiunao.cn/bianchengkaifa/19351/