大家帮帮忙，看看这个页面有什么问题，怎么会出现后面那样的错误？

<%@ page contentType="text/html; charset=gb2312" language="java"  %>
<%@ include file="include.inc" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head><LINK 
href="jjytt.css" type=text/css rel=stylesheet><body>
<% String deptid=request.getParameter("deptid");
   ResultSet rst=stmt.executeQuery("select a.bed_no,c.name,c.sex,b.patient_id,b.admission_date_time,b.doctor_in_charge,b.prepayments,b.total_costs,c.charge_type from bed_rec a,pats_in_hospital b,pat_master_index c where (a.dept_code = b.dept_code(+) ) and ( a.bed_no = b.bed_no(+) ) and (b.patient_id = c.patient_id(+) ) and a.dept_code='"+deptid+"'");
%>
<table width="739" height="129" border="0">
  <% 
    while(rst.next())
{
       out.println("<tr>");
   int i;
   for(i=1;i<=5;i++)
   {
          out.println("<td width='104'><table width='107' border='1' cellpadding='0' cellspacing='0' bordercolor='#FF99FF'><tr>");          out.println("<td width='35'>"+rst.getString(1)+"</td>");
          out.println("<td width='59'>"+rst.getString(2)+"</td></tr>");   
          out.println("<tr><td>性别</td><td>"+rst.getString(3)+"</td></tr>");
          out.println("<tr><td>ID号</td><td>"+rst.getString(4)+"</td></tr>");
          out.println("<tr><td>入院</td><td>"+rst.getDate(5)+"</td></tr>");
          out.println("<tr><td>医生</td><td>"+rst.getString(6)+"</td></tr>");
          out.println("<tr><td>预交</td><td>"+rst.getFloat(7)+"</td></tr>");
          out.println("<tr><td>费用</td><td>"+rst.getFloat(8)+"</td></tr>");
          out.println("<tr><td>费别</td><td>"+rst.getString(9)+"</td></tr>");
          out.println("</table></td>");
  if(rst.next()) break;
}
       out.println("</tr>");
 }
%>
</table>
</body>
</html>

解决方案 »

  1.   

    错误信息：
    HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: ORA-00933: SQL ??????? org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
    org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
    org.apache.jsp.main_jsp._jspService(main_jsp.java:114)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    root cause java.sql.SQLException: ORA-00933: SQL ??????? oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
    oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:1597)
    oracle.jdbc.oci8.OCIDBAccess.parseExecuteDescribe(OCIDBAccess.java:798)
    oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1674)
    oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1870)
    oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:538)
    org.apache.jsp.main_jsp._jspService(main_jsp.java:77)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
    --------------------------------------------------------------------------------Apache Tomcat/5.0.28
      

  2.   

    把你的sql语句在后台print出来瞧瞧,一切都搞定.应该就是sql语句的问题
      

  3.   

    这个问题已经解决，deptid传过来的值多加了一层引号。
      

  4.   

    大家看看下面的提示是怎么回事儿？
    type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:372)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    root cause java.lang.NullPointerException
    org.apache.jsp.main_jsp.trans(main_jsp.java:21)
    org.apache.jsp.main_jsp._jspService(main_jsp.java:126)
    org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
    org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
    org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
    note The full stack trace of the root cause is available in the Apache Tomcat/5.0.28 logs.
    --------------------------------------------------------------------------------Apache Tomcat/5.0.28
      

  5.   

    空指针错误，很常见的,
    org.apache.jsp.main_jsp.trans(main_jsp.java:21)
    org.apache.jsp.main_jsp._jspService(main_jsp.java:126)
    打印一下这两个地方