jsp读数据库的问题急

AI牛 2003-12-11 02:44:00

我用Jbuilder9 +jb自带的tomcat+ms sqlserver2000 运行如下Jsp代码，报错了，哪位高手指点一二，不胜感激！

<%@ page contentType="text/html; charset=GBK" %>
<%@ page errorPage="Myjsp_error.jsp" %>
<%@ page import="java.sql.*"%>
<%@ page language="java"%>
<html>
<head>
<title> samsung anycall</title>
</head>
<body>
<body bgcolor=green>
<center>


<hr>
 
<%
Class.forName("com.microsoft.jdbc.sqlserver.sqlserverdriver");

Connection conn = DriverManager.getConnection("jdbc:microsoft:sqlserver://180.9.0.126:8080"
+ ";DatabaseName=Northwind;SelectMethod=cursor", "sa", "");

%>
load the jdbc drivers successfully!
<%
Statement stm=conn.createStatement();
ResultSet rs=stm.executeQuery("select * from employees");
%>
<table bgcolor=white border=2>
<tr color=silver>
<td>EmployeeID</td>
<td>LastName</td>
<td>FirstName</td>
<td>title</td>
<td>titleofcounters</td>
<td>birthdate</td>
<td>HireDate</td>
<td>Address</td>
<td>City</td>
<td>Regin</td>
<td>PostalCode</td>
<td>country</td>
<td>HomePhone</td>
<td>Extention</td>
<td>Photo</td>
<td>Notes</td>
<td>ReportsTo</td>
<td>PhotoPath</td>
</tr>
<%
while(rs.next())
{
%>
<tr>
<td><%=rs.getString("EmployeeID")%></td>
<td><%=rs.getString("LastName")%></td>
<td><%=rs.getString("FirstName")%></td>
<td><%=rs.getString("Title")%></td>
<td><%=rs.getString("TitleofCounters")%></td>
<td><%=rs.getString("BirthDate")%></td>
<td><%=rs.getString("HireDate")%></td>
<td><%=rs.getString("Address")%></td>
<td><%=rs.getString("City")%></td>
<td><%=rs.getString("Regin")%></td>
<td><%=rs.getString("PostalCode")%></td>
<td><%=rs.getString("Country")%></td>
<td><%=rs.getString("HomePhone")%></td>
<td><%=rs.getString("Extention")%></td>
<td><%=rs.getString("Photo")%></td>
<td><%=rs.getString("Notes")%></td>
<td><%=rs.getString("ReportsTo")%></td>
<td><%=rs.getString("PhotoPath")%></td>
</tr>
<%

}
rs.close();
stm.close();
conn.close();
%>
</table>
</center>
</body>
</html>

报错如下：
An error occured in the bean. Error Message is: com.microsoft.jdbc.sqlserver.sqlserverdriverStack Trace is : java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.sqlserverdriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1443)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1289)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:197)
at org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:131)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at org.apache.jsp.Myjsp_jsp._jspService(Myjsp_jsp.java:59)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:210)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:594)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:392)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:565)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:619)
at java.lang.Thread.run(Thread.java:53
怎么办啊？

...全文