ojdbc14.jar 或 ojdbc6.jar)$ORACLE_HOME/owb/wf/lib/ojdbc14.jar(或 jdbc/lib/ojdbc6.jar)。package com.wuy;
import java.sql.*;
public class ConnectOracle {
private Connection con;
private String user = "scott";
private String password = "18233188050";
private String className = "oracle.jdbc.driver.OracleDriver";
// Thin 驅動 URL 格式:jdbc:oracle:thin:@::
private String url = "jdbc:oracle:thin:@hr-PC:1521:orcl";
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.println("建立連線失敗!");
e.printStackTrace();
con = null;
}
return con;
}
public void close() {
try { if (con != null) con.close(); }
catch (SQLException e) { e.printStackTrace(); }
}
public static void main(String[] args) {
ConnectOracle c = new ConnectOracle();
c.getCon();
c.close();
}
}
url 中的主機名(hr-PC)、端口(1521)、SID(orcl)必須與 tnsnames.ora 一致。jdbc:oracle:oci@...),需配置 ORACLE_HOME、LD_LIBRARY_PATH,較繁瑣;推薦 Thin 驅動純 Java 無客戶端依賴。Console 輸出:
載入驅動成功! 建立連線成功!