package com.model.tools;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JdbcTest {
//169.254.127.81 171.113.92.194
private static String username="scott";
private static String password="tiger";
private static String url="jdbc:oracle:thin:@192.168.1.104:1521:orcl";
private static String driver="oracle.jdbc.driver.OracleDriver";

private static Connection cn=null;
private  static PreparedStatement ps=null;
private  static ResultSet rs=null;
[size=16px][size=14px][/size][/size]
public  static void main(String[]args){

try {
   Class.forName(driver);
   cn=DriverManager.getConnection("jdbc:oracle:thin:@171.113.92.194:1521:orcl", "scott", "tiger");
    ps=cn.prepareStatement("select*from emp");
        rs=ps.executeQuery();
        while(rs.next()){
System.out.println(rs.getString("ename"));
}
} catch (Exception e) {

e.printStackTrace();
}finally{
if(rs!=null)
try {
rs.close();
} catch (SQLException e) {

e.printStackTrace();
}
if(ps!=null)
try {
ps.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(cn!=null)
try {
cn.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.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(DriverManager.java:579)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.model.tools.JdbcTest.main(JdbcTest.java:22)
oraclejava