我用IPCONFIG来查出我的IP地址是192.168.1.102但是我用这个IP地址来怎么也不能连接要怎么查IP?是不是用这个IPCONFIG查出来的IP这个是我的程序importjava.sql.*;publicclassTestJDBC{...
我用IPCONFIG 来查出我的IP地址是 192.168.1.102 但是我用这个IP地址来 怎么也不能连接 要怎么 查IP? 是不是用这个IPCONFIG查出来的IP
这个是我的程序
import java.sql.*;
public class TestJDBC {
public static void main(String[] args) throws Exception {
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.1.102:1521:demo", "scott", "tiger");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from dept");
while(rs.next()){
System.out.println(rs.getString("deptno"));
System.out.println(rs.getString("deptno"));
}
rs.close();
stmt.close();
conn.close();
}
}
抛出的错误是
Exception in thread "main" java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:273)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:318)
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:343)
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:147)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:31)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:545)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at TestJDBC.main(TestJDBC.java:7)
还有是在我在E:\oracle\product\10.1.0\db_1\install\portlist.ini
里面看到内容是
Ultra Search HTTP 端口号 =5620
Enterprise Manager Agent Port =
iSQL*Plus HTTP 端口号 =5560
Enterprise Manager Console HTTP Port (demo) = 5500
Enterprise Manager Agent Port (demo) = 1830
我程序里面的端口号错了没有??
展开