Question

java连接sqlserver数据库问题？

java连接sqlserver数据库问题？报错提示，代码，包的导入分别如图
为什么会连接不上呢，哪位大佬解答一下？





Answer 1

你连接字符串写错了，我给你一个我原来写的，我使用的是SQL2005数据库
import java.sql.*;
public class BaseDAO {
private static final String DRIVER = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
private static final String CONNECTION = "jdbc:sqlserver://localhost:1433;databaseName=Employee";
private static final String NAME = "sa";
private static final String PWD = "sasa";
public static Connection GetConnection() {
Connection con = null;
try {
Class.forName(DRIVER);
con = DriverManager.getConnection(CONNECTION, NAME, PWD);
} catch (Exception e) {
// TODO: handle exception
e.printStackTrace();
}
return con;
}
public static void close(ResultSet rs, PreparedStatement ps, Connection con) {
try {
if (null != rs) {
rs.close();
}
if (null != ps) {
ps.close();
}
if (null != con) {
con.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
}

追问

2008

Answer 2

缺少SqlServer驱动包

追问

怎么说

我不是导入了jdbc.jar包么

Answer 3

Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
conn=DriverManager.getConnection("jdbc:sqlserver://127.0.0.1;DatabaseName=jdbc_db","sa","666686");