需要导入三个jar包,到WebRoot/WEB-INF下的lib目录,然后
public class DBdriver {
static String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
static String url =
"jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=数据库名";
public Connection connection;
public DBdriver() {
try {
Class.forName(driver);
connection = DriverManager.getConnection(url, "数据库用户名", "密码");
} catch (Exception ex) {
}
try {
} catch (Exception ex) {
ex.printStackTrace();
}
}
public static void main(String[] args) {
DBdriver dbtest = new DBdriver();
System.out.println(dbtest.connection)
//如果不报错,并且打印的值不是null,就ok了
}