eclipse连接oracle出现错误，qiu大神指点.

package com.oracle.jdbclab;
import java.io.IOException;
import java.sql.*;

public class test
{
public static void main(String[] args) throws IOException{
Connection con = null;
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@119.190.136.109:1521:oracle","system","student");
Statement stmt = conn.createStatement();
ResultSet res = stmt.executeQuery("select* from student");
while(res.next()){
System.out.println(res.getString("Sno"));
System.out.println(res.getString("Sname"));
}
}
catch(Exception e){
e.printStackTrace();
}finally{
//关闭连接
try{
if(con!=null) con.close();
}catch(Exception ex){
ex.printStackTrace();
}
}
}
}

提示错误为：
java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:255)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:387)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:414)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at com.oracle.jdbclab.test.main(test.java:11)

这个问题的解决说难也不难，如果你的oracle数据库在本机，请将url改为jdbc:oracle:thin:@localhost:1521:oracle，如果oracle数据库在远程主机，那不知道你自己的机器上有没有安装oracle的客户端，如果安装的有客户端，请修改tnsname.ora文件的内容，这个文件的位置是$ORACLE_HOME\network\admin目录，用记事本打开该文件，添加如下内容：
ORACLE =
　　(DESCRIPTION =
　　(ADDRESS_LIST =
　　(ADDRESS = (PROTOCOL = TCP)(HOST = 119.190.136.109)(PORT = 1521))
　　)
　　(CONNECT_DATA =
　　(SERVICE_NAME = oracle)
　　)
　　)
保存配置完成，保险起见重启下数据库相关服务就可以了

温馨提示：内容为网友见解，仅供参考

当前网址：https://22.t2y.org/zz/isxih0tx2.html