servlet连接sql server2000出错

import javax.servlet.http.*;
import javax.swing.JOptionPane;import java.sql.*;
public class Loginc1 extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L;
//req用来获得客户端（浏览器）的信息
//res用来向客户端（浏览器）发信息
Connection ct;
Statement sm;
ResultSet rs;
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
try {
//接受用户名的密码
String u=req.getParameter("usrename");
String p=req.getParameter("passnd");

//初始化
//1.加载驱动
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");

//加载驱动这句有问题

//2.得到连接(127.0.0.1数据库所在IP，1433表示sql server的默认端口,是sql server2000的默认端口)
ct=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=spdb1","sa","ctlovexx");
//3.创建
sm= ct.createStatement();

//4.执行(如果是增加，删除，修改使用executeUpdate(),如果是查询executeQuery())
rs=sm.executeQuery("select * from users where username='"+u+"'");
//

while(rs.next())
{
//说明用户存在
String dbpasswd=rs.getString(1);
JOptionPane.showMessageDialog(null,dbpasswd);
if(dbpasswd.equals(p))
{
//合法

//将验证成功的信息写入session
//1.得到session
HttpSession hs=req.getSession(true);
//修改session的存在时间
hs.setMaxInactiveInterval(20);//按秒计

hs.setAttribute("pass", "OK");

//跳转到hello
res.sendRedirect("hello?usrename="+u+"&passnd="+p);
}
}
//用户名不存在
//跳转
res.sendRedirect("login");//写你要到的servlet的哪个url
}catch (Exception e) {
// TODO: handle exceptio
e.printStackTrace();
}finally
{
try {
if(rs!=null)
{rs.close();
rs=null;
}

sm.close();
ct.close();
} catch (Exception e) {
e.printStackTrace();
}
}
}

public void doPost(HttpServletRequest req,HttpServletResponse res)
{
this.doGet(req, res);
}}import javax.servlet.http.*;
import java.io.*;
public class Login extends HttpServlet{
/**
*
*/
private static final long serialVersionUID = 1L; //req用来获得客户端（浏览器）的信息
//res用来向客户端（浏览器）发信息
public void doGet(HttpServletRequest req,HttpServletResponse res)
{
try {
//中文乱码编译
res.setContentType("text/html;charset=gbk");
PrintWriter pWriter=res.getWriter();
//返回登录界面
pWriter.println("<html>");
pWriter.println("<body>");
pWriter.println("<h1>登录界面</h1>");
pWriter.println("<form action=loginc1 method=post>");
pWriter.println("用户名：<input type=text name=usrename><br>");
pWriter.println("密码：<input type=password name=passnd><br>");
pWriter.println("<input type=submit value=loing><br>");
pWriter.println("</form>");
pWriter.println("</body>");
pWriter.println("</html>");
} catch (Exception e) {

e.printStackTrace();

}
}

public void doPost(HttpServletRequest req,HttpServletResponse res)
{
this.doGet(req, res);
}
}报错：
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1645)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1491)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:169)
at com.ct.Loginc1.doGet(Loginc1.java:28)
at com.ct.Loginc1.doPost(Loginc1.java:90)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)
java.lang.NullPointerException
at com.ct.Loginc1.doGet(Loginc1.java:77)
at com.ct.Loginc1.doPost(Loginc1.java:90)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:619)

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

sql2000对应的jar包没有放进去吧。
错误提示的第一句就告诉你了：java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
没有找到SQLServerDriver这个类啊，你肯定是没有导入sql server的驱动包。
明显的SqlServer驱动找不到呀！
jar包已经放进去了，在那个项目里面重写一个类就能调用到数据库，但是一用到这个上面就不行了
jdbc:sqlserver://localhost:1433;DatabaseName=spdb1","sa","ctlovexx";
试试感觉上面写的有误
2000需要3个jar文件。不过不明白学校的老师为什么总喜欢让学java的学生用sql_server哪？