我做了兩次sql的查詢，結果會現下列的錯誤訊息(應該是說ResultSet is closed)，如果再將網頁重新整理一次，錯誤訊息就會不見，正常的執行網頁，我找了好久，還是不知道哪裡有問題，請大家指導一下~非常感謝哦~    以下是部份內容:

第一次查詢:
rs=stmt.executeQuery("SELECT * FROM NewsContent");
rs.beforeFirst();
if(!rs.next()) 
{    }
else
{
  rs.beforeFirst();
  while(rs.next())
  {
    String ID=rs.getString("ID").trim();
    int Limit_EndYear=Integer.parseInt(rs.getString("Limit_EndYear").trim()); 
    int Limit_EndMonth=Integer.parseInt(rs.getString("Limit_EndMonth").trim()); 
    int Limit_EndDay=Integer.parseInt(rs.getString("Limit_EndDay").trim());                         
    
  if(CheckTime( Limit_EndYear,Limit_EndMonth,Limit_EndDay )==0  ) 
  {
    String str_delete="DELETE * FROM NewsContent WHERE ID=" ID;
    stmt.executeUpdate(str_delete);
  }
  else          
  {          
  }          
  }    }
之後又做第二次查詢:
rs=stmt.executeQuery("SELECT * FROM NewsContent ORDER BY ID DESC");
rs.beforeFirst();
if(rs.next())
{
%>
  
    
      
        最新消息:"><%= rs.getString("subject") %>
        
    
  
<%
}    

會出現下列的錯誤訊息: type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception javax.servlet.ServletException: ResultSet is closed org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:862) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:795) org.apache.jsp.index_jsp._jspService(index_jsp.java:331) 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.sql.SQLException: ResultSet is closed sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(Unknown Source) sun.jdbc.odbc.JdbcOdbcResultSet.next(Unknown Source) org.apache.jsp.index_jsp._jspService(index_jsp.java:183) 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.

我知道了哪裡有問題了~ResultSet一次只會開啟一個，令兩個stmt就可以解決了~