代码如下：
import java.sql.*;
public class TestJDBC {

public static void main(String[] args) throws ClassNotFoundException, SQLException {

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

Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@127.0.0.1:1521:local", "scott", "tiger");
Statement stmt = conn.createStatement();

ResultSet rs = stmt.executeQuery("select * from dept");

while(rs.next()){
System.out.println(rs.getString("deptno"));
}
}

}
报错：java.sql.SQLException: Io 异常: The Network Adapter could not establish the connection

希望能给点宝贵意见

Connection conn = DriverManager.getConnection
("jdbc:oracle:thin:@127.0.0.1:1521:local", "scott", "tiger");是这句出了错

看下端口，用户名和密码对吗，sid对吗

我的连接改动为：conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");但是此句依然存在相同错误

还是建议你把连接oracle这块的代码每一句都分开写，这样那一句出问题，就知道了，我看你的代码，没有发现什么异常情况，你看看是不是你没有价保

Class.forName("oracle.jdbc.driver.OracleDriver").newInstance(); 
String url="jdbc:oracle:thin:@localhost:1521:orcl"; //orcl为数据库的SID 
String user="test"; 
String password="test"; 
Connection conn= DriverManager.getConnection(url,user,password); 

这是9的连接