jsp 连接sql server 2000

需要导入三个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了
}

public class DBdriver{
// 指定驱动程序
private static String driver = "net.sourceforge.jtds.jdbc.Drive