JSp报错 org.apache.jasper.JasperException: An exception occurred processing

<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="ConnDB" scope="page" class="com.netbean.web.ConnDB"/>
<%
ResultSet newsrs=ConnDB.executeQuery("select top 7 * from news ");
ResultSet exemplers=ConnDB.executeQuery("select top 7 * from exemple ");
ResultSet trainrs=ConnDB.executeQuery("select top 7 * from train ");
ResultSet severrs=ConnDB.executeQuery("select top 7 * from sever ");
%>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title></head><body><table width="750" align="center">
<tr>
<td width="244" height="160" valign="top">
<div class="border">
<ul>     
  <%
                          String news=null;
                          int newsid=0;
if(newsrs.next()){
 
                        newsid=newsrs.getInt("Id");
  news=newsrs.getString("Title");
                               %>
  <li><a href="newsshow.jsp?newid=<%=newsid%>"><%=news%></a></li>
                                 <% } else{out.print("no record");}%>
           
       </ul></div></td>
<p>&nbsp;</p>
</body></html>index.jsp文件内容报错:
org.apache.jasper.JasperException: An exception occurred processing JSP page /index.jsp at line 6663:    <%
64:                           String news=null;
65:                           int newsid=0;
66:  if(newsrs.next()){
67:   
68:                         newsid=newsrs.getInt("Id");
69:    news=newsrs.getString("Title");
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:505)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:416)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)这是什么原因啊

解决方案 »

  1.   

    JAVA代码没看出什么问题。将ResultSet newsrs=ConnDB.executeQuery("select top 7 * from news "); 
    ResultSet exemplers=ConnDB.executeQuery("select top 7 * from exemple "); 
    ResultSet trainrs=ConnDB.executeQuery("select top 7 * from train "); 
    ResultSet severrs=ConnDB.executeQuery("select top 7 * from sever "); 放到下面的代码块中试试呢？