JDBC连接SQLServer 2000的问题

Question

HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: An exception occurred processing JSP page /save.jsp at line 1815:    }else
16:    {
17:     Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
18:     Connection connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web","sa","");
19:     String sql="insert into guestbook(content,author,email,tel) values(?,?,?,?)";
20:     PreparedStatement ps=connection.prepareStatement(sql);
21:     ps.setString(1,con);
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:510)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:401)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause javax.servlet.ServletException: java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.save_jsp._jspService(save_jsp.java:106)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause java.sql.SQLException: No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web
java.sql.DriverManager.getConnection(DriverManager.java:602)
java.sql.DriverManager.getConnection(DriverManager.java:185)
org.apache.jsp.save_jsp._jspService(save_jsp.java:71)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:377)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:313)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:260)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.24 logs.
--------------------------------------------------------------------------------
这个问题怎办。。是不是驱动没导入正确。还是什么原因？

Answer 1

No suitable driver found for jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web
就是说你的驱动有问题

Answer 2

数据库没密码
[code=Java Connection connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web","sa","");][/code]

Answer 3

jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web","sa","");这段代码有问题  自己好好看看!

Answer 4

17: Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
18: Connection connection=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=web","sa","");
这两句有问题

Answer 5

jdbc驱动包放入tomcat的common/lib下了没有