急!Eclipse连接数据库一直连不上,配置好像也没问题,各位大哥帮帮忙
测试代码如下:
public class Test {
private static String dbdriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private static String dburl = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=SCRS";
private static String dbuser = "sa";
private static String dbpassword = "";
private static Connection con;
public static void main(String[] args) throws SQLException {
// try {
try {
try {
Class.forName(dbdriver).newInstance();
} catch (InstantiationException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
} catch (IllegalAccessException e2) {
// TODO Auto-generated catch block
e2.printStackTrace();
}
} catch (ClassNotFoundException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
con = DriverManager.getConnection(dburl, dbuser, dbpassword);
System.out.println("数据库连接成功");
// }catch(SQLException e) {
// System.err.println(e);
// }
// test.
}
}
===========
执行到con = DriverManager.getConnection(dburl, dbuser, dbpassword);出错
java.sql.SQLException: [Microsoft][SQLServer JDBC Driver]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.microsoft.jdbc.sqlserver.tds.TDSConnection.<init>(Unknown Source)
at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:512)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at com.cwd.struts.action.Test.main(Test.java:49)
Exception in thread "main"
驱动我是加了的,而且Class.ForName也正常!