您必须将名为oracle.net.tns_admin的属性设置为指向包含tnsnames.ora文件的文件夹的位置.然后在数据库URL中的@符号后面指定该文件中的条目.检查下面的例子.您可以在此处找到更多信息：

Data sources and URLs – Oracle Documentation

import java.sql.*;

public class Main {

public static void main(String[] args) throws Exception {

System.setProperty("oracle.net.tns_admin", "C:/app/product/11.2.0/client_1/NETWORK/ADMIN");

String dbURL = "jdbc:oracle:thin:@ENTRY_FROM_TNSNAMES";

Class.forName ("oracle.jdbc.OracleDriver");

Connection conn = null;

Statement stmt = null;

try {

conn = DriverManager.getConnection(dbURL, "your_user_name", "your_password");

System.out.println("Connection established");

stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("SELECT dummy FROM dual");

if (rs.next()) {

System.out.println(rs.getString(1));

}

} catch (Exception e) {

e.printStackTrace();

}

finally {

if (stmt != null) try { stmt.close(); } catch (Exception e) {}

if (conn != null) try { conn.close(); } catch (Exception e) {}

}

}

}

tnsnames.ora文件中的示例条目：

my_net_service_name=

(DESCRIPTION=

(ADDRESS=(some address here))

(CONNECT_DATA=

(SID=some_SID_name)))

其中my_net_service_name字符串是您必须从我的Java示例中为ENTRY_FROM_TNSNAMES包含的内容.