JDBC访问sql server2000
小弟第一次使用sql server2000,还请高手帮忙:
我自己写了一个ConnectionFactory如下:
public class ConnectionFactory {
public static Connection getConnection(String driver,String dburl,String user,String passwd){
Connection con = null;
try{
Class.forName(driver);
System.out.println( "类实例化成功!" );
con = DriverManager.getConnection(dburl,user,passwd);
System.out.println( "创建连接对像成功!" );
}catch(Exception e){
e.printStackTrace();
}
return con;
}
在另一个函数中用下面的语句调用:
con = ConnectionFactory.getConnection("com.microsoft.jdbc.sqlserver.SQLServerDriver",
"jdbc:microsoft:sqlserver://localhost;DatabaseName=hosp",
"aaa","aaa");
运行结果如下:
类实例化成功!
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.
at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
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(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at util.ConnectionFactory.getConnection(ConnectionFactory.java:15)
at biz.HospBiz.getUsers(HospBiz.java:23)
at test.HospTest.main(HospTest.java:15)
Exception in thread "main" java.lang.NullPointerException
at biz.HospBiz.getUsers(HospBiz.java:26)
at test.HospTest.main(HospTest.java:15)
我个人认为可能是用户名和密码的问题。sql server2000 的用户名和密码应该怎么设定呢?
端口应该已经打开。