中老年女装冬季服装:哪位大哥帮我看下这是怎么回事!HTTP Status 500 -

来源:百度文库 编辑:查人人中国名人网 时间:2024/04/19 12:49:29
源代码:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
String RL = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=学院管理";
String user ="lijian";
String password = "123";
String sqlStr = "select * from 人员表";
out.print(sqlStr);

try{ //这里的异常处理语句是必需的.否则不能通过编译!
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
out.print( "类实例化成功!" );
Connection con = DriverManager.getConnection(RL,user,password);
out.print( "创建连接对像成功!" );

Statement st = con.createStatement();
out.print( "创建Statement成功!" );

ResultSet rs = st.executeQuery( sqlStr );
out.print( "操作数据表成功!" );
out.print( "---how i love you--!\n" );
out.print("query seccess!");
//中间有段代码省略了,是按照格式输出查询结果!因百度要求在3000字节内
}
catch(Exception err){}
%>
</body>
</html>
错误提示:e Exception reportmessage

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.index_jsp._jspService(index_jsp.java:82)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1332)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:150)
org.apache.jasper.servlet.JasperLoader.loadClass(JasperLoader.java:71)
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
java.lang.Class.forName0(Native Method)
java.lang.Class.forName(Class.java:164)
org.apache.jsp.index_jsp._jspService(index_jsp.java:48)
org.apache.jasper.runtime.HttpJspBase.servic
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.9 logs.
运行平台:
netbeans 5.0
备注:请您帮忙,在此先道谢谢了!

你的JDBC四类驱程没有被tomcat发现,因此就产生了以上错误
请注意把你的JDBC驱程放到webapp的WEB-INF\lib下面,或者直接放到tomcat的common\lib下面

如果没有驱程,可以去微软下载