SQLServer - 数据库连接问题?请大虾们指点一下
写了一个测试连接类,如下:
package org.myweb.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Test {
static Connection con = null;
static Statement st = null;
static ResultSet rs = null;
public static Connection getCon() {
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String pwd = "admin";
try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(url, user, pwd);
} catch (Exception e) {
e.printStackTrace();
}
return con;
}
public static void getEmp() {
con = getCon();
String sql = "select fname,lname from employee";
try {
st = con.createStatement();
rs = st.executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getInt("fname") + " "
+ rs.getString("lname"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
try {
if (con != null)
con.close();
if (st != null)
st.close();
} catch (Exception e1) {
e1.printStackTrace();
}
}
}
public static void main(String args[]) {
getEmp();
}
}
运行后老是出现这样的错误:
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(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at org.myweb.dao.Test.getCon(Test.java:23)
at org.myweb.dao.Test.getEmp(Test.java:31)
at org.myweb.dao.Test.main(Test.java:55)
Exception in thread "main" java.lang.NullPointerException
at org.myweb.dao.Test.getEmp(Test.java:34)
at org.myweb.dao.Test.main(Test.java:55)
到底是什么原因呢?