JSP 网页的500错误

Question

type Exception report

message

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 /BookSort.jsp at line 50

47: <td width="182" height="31">
48: <%rs_Type.first();
49: do{ //此处必须用do...while，否则会少一条记录
50: String Type=rs_Type.getString("Type");
51: %>
52: <table width="100%" height="22" border="0" cellpadding="0" cellspacing="0" class="tableBorder_B1">
53: <tr>

Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

javax.servlet.ServletException: java.sql.SQLException: Illegal operation on empty result set.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:850)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:779)
org.apache.jsp.BookSort_jsp._jspService(BookSort_jsp.java:240)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

root cause

java.sql.SQLException: Illegal operation on empty result set.
com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:680)
com.mysql.jdbc.ResultSet.getStringInternal(ResultSet.java:4761)
com.mysql.jdbc.ResultSet.getString(ResultSet.java:4739)
com.mysql.jdbc.ResultSet.getString(ResultSet.java:4755)
org.apache.jsp.BookSort_jsp._jspService(BookSort_jsp.java:126)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

note The full stack trace of the root cause is available in the Apache Tomcat/6.0.14 logs.
各位大虾，偶是菜菜，刚学jsp，现在正在看别人做的一个管理系统呢，帮忙解决问题的同时，也给小弟点建议吧！先谢了！

Answer 1

java.sql.SQLException: Illegal operation on empty result set.
是指结果集是空的，所以50行的rs_Type是没有，自然是获取不到值了
建议这里在jsp页面上价格判断，数据是否为空

Answer 2

问题很清楚~就是50行有错误~
根据java.sql.SQLException: Illegal operation on empty result set.
信息~说明你的结果集是空的~
所以50行的String Type=rs_Type.getString("Type");
自然是获取不到值了~

Answer 3

详细信息：建议百度一下：逗逗搜兔吧！