String url="jdbc:oracle:thin:127.0.0.1:1521:DEMO";
Connection conn=DriverManager.getConnection(url,"system","system");我 SID是DEMO 密码 用户 都是 system DEBUG的时候走到CONN就跳到错误去了 帮忙解决下我找不到问题
Connection conn=DriverManager.getConnection(url,"system","system");我 SID是DEMO 密码 用户 都是 system DEBUG的时候走到CONN就跳到错误去了 帮忙解决下我找不到问题
jdbc:oracle:thin:@127.0.0.1:1521:DEMO
少了一个@!!!
你能不能把你的所有的连库代码贴出来
我记得好像是这样的吧?具体的不是很清楚了
String url="jdbc:oracle:thin:@127.0.0.1:1521:DEMO";
Connection conn=DriverManager.getConnection(url,"system","system"); 上面的都写
把class12.jar包导入,
好好看看,哪少东西了
import java.sql.*;public class oracletest{
public oracletest() {
}
public static String main(){
try
{
try{
Class.forName("oracle.jdbc.driver.OracleDriver");
}
catch(java.lang.ClassNotFoundException e)
{
System.err.print(e.getMessage());
}
//String url="jdbc:oracle:thin:@Server:1521:DEMO";
String url="jdbc:oracle:thin:@10.200.37.57:1521:DEMO";
Connection conn=DriverManager.getConnection(url,"system","system");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select count(*) from T_CAD");
while(rs.next())
{
System.out.println(rs.getString(1));
return "ok";
}
conn.close();
}
catch(SQLException ex)
{
while(ex!=null)
{System.out.println(ex.getSQLState());
}
}
return "OK";}
}
1---String url="jdbc:oracle:thin:@10.200.37.57:1521:DEMO";
2---String url="jdbc:oracle:thin:@127.0.0.1:1521:DEMO";
3---String url="jdbc:oracle:thin:@localhost:1521:DEMO"; 只有第一句不报错 2 3 都是错的
detailMessage= "I/O例外です。: The Network Adapter could not establish the connection"
为什么呢
即便是有,也应该确定是用system/system这样的用户名及口令登陆创建的吗?
我也导入了 classes12.jar 结果还是这个错误!