jsp调试错误 请各位大虾帮忙 急急急急急急急急!
我是一个刚学习jsp的。
错误提试是:
HTTP Status 500 -
--------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: db/dateconnection
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:867)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:800)
org.apache.jsp.MyJsp_jsp._jspService(MyJsp_jsp.java:159)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause
java.lang.NoClassDefFoundError: db/dateconnection
org.apache.jsp.MyJsp_jsp._jspService(MyJsp_jsp.java:75)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:133)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:311)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:301)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:248)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
note The full stack trace of the root cause is available in the Tomcat logs.
--------------------------------------------
Apache Tomcat/5.0.19
jsp原文件是:
<%@ page language= "java " import= "java.util.* " pageEncoding= "UTF-8 "%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+ ":// "+request.getServerName()+ ": "+request.getServerPort()+path+ "/ ";
%>
<jsp:useBean id= "tt " class= "bb.dateconnection " scope= "request " />
<%
java.sql.ResultSet trs=tt.show();
// while(rs.next())
// {
// out.print(rs.getString(0));
// }
%>
<html>
<head>
<base href= " <%=basePath%> ">
<title> My JSP 'MyJsp.jsp ' starting page </title>
</head>
<body>
<P> <BR> 欢迎进入平平留言中心: </P>
<P> 输入条件: </P>
<form name=form2 action= "MyJsp.jsp " method= "post ">
<TABLE border= "0 " width= "200px ">
<tr>
<td width= "20% "> 姓名:
<td width= "40% "> <INPUT type= "text " name= "name " /> </td>
<td width= "20% "> 姓别: </td>
<td width= "20% "> <INPUT type= "text " name= "sex " /> </td>
</tr>
</TABLE>
<P> <INPUT type= "submit " name= "submit " value= "提交 "/> </P>
</form>
<P> 显示结果: </P> <P>
</P> </P>
<!-- <FORM name= "form2 " action= "MyJsp " method= "POST ">
-->
<TABLE border= "1 " width= "200px ">
<TR>
<TD width= "5% " align= "center " rowspan= "1 "> 编号: </TD>
<TD width= "10% " align= "center "> 姓名: </TD>
<TD width= "10% " align= "center "> 性别: </TD>
<TD width= "20% " align= "center "> 标题: </TD>
<TD width= "55% " align= "center "> 内容: </TD>
</TR>
<%
while(trs.next())
{
%>
<TR>
<TD > <%=new String(trs.getString(0).getBytes( "GBK "), "ISO8859_1 ")%> </TD>
<TD > <%=new String(trs.getString(1).getBytes( "GBK "), "ISO8859_1 ")%> </TD>
<TD > <%=new String(trs.getString(2).getBytes( "GBK "), "ISO8859_1 ")%> </TD>
<TD > <%=new String(trs.getString(3).getBytes( "GBK "), "ISO8859_1 ")%> </TD>
<TD > <%=new String(trs.getString(4).getBytes( "GBK "), "ISO8859_1 ")%> </TD>
</TR>
<%}%>
</TABLE>
<P> </P> <P> </P> </P>
<!-- </FORM> -->
</body>
</html>
java文件是:
package bb;
import java.sql.*;
import java.util.*;
import java.lang.*;
public class dateconnection
{
public dateconnection(){}
public boolean conn()
{
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
return true;
}catch(Exception e)
{
// out.println( "加载数据库驱动程序失败,请检查数据库驱动 ");
return false;
}
}
public ResultSet show()
{
conn();
String url= "jdbc:odbc:Driver={SQL Server};Server=localhost;uid=sa;pwd=;Database=notebook ";
String user= "sa ";
String password= " ";
try
{ Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery( "select * from notebook ");
while(rs.next())
{
return rs;
}
}
catch(SQLException ee)
{
return null;
}
return null;
}
}
请问这是什么错误。怎么样解决????
[解决办法]
把bb.dateconnection这个类import进来
注意名字,大小写要注意。
是bb.dateconnection
还是bb.Dateconnection
或者bb.DateConnection
???
[解决办法]
除了楼上说的问题,还有查询的结果不要以ResultSet的形式返回来,用Vector接收
[解决办法]
给大家推荐个
好的技术群 大家一起学习啊
32141736
我的异常网推荐解决方案:The server encountered an internal error () that prevented it from fulfilling this request.,http://www.myexception.cn/java-web/317.html