在一个JSP里面执行两个SQL语句出现对象已关闭错误。在线等。麻烦大家了

================================================================代码段========================================================================
<%@ include file="conn.jsp"%>
<%@ page contentType="text/html;charset=gb2312"%> 
<%request.setCharacterEncoding("gb2312");
//String read_id=request.getParameter("id");
String read_id="xohuan";
String sql="select * from info where id='"+read_id+"'"; 
ResultSet read_list=stmt.executeQuery(sql);  
read_list.next(); Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql1="select * from reg where id='"+read_id+"'"; 
ResultSet cs=stmt.executeQuery(sql1);  
cs.next();
%><!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=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
-->
</style></head><body>
<table width="900" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td width="150" height="110" bgcolor="#0033CC">&nbsp;</td>
    <td colspan="5" bgcolor="#990066">&nbsp;</td>
  </tr>
  <tr>
    <td height="20" bgcolor="#00EE33"><div align="center" ><a href="index.jsp" class="STYLE3">首   页</a></div></td>
    <td width="150" bgcolor="#009933"><div align="center" ><a href="reg.jsp"class="STYLE3">帐户注册</a></div></td>
    <td width="150" bgcolor="#00CC33"><div align="center" ><a href="list.jsp" class="STYLE3">会员列表</a></div></td>
    <td width="150" bgcolor="#00DD33"><div align="center" ><a href="edit.jsp" class="STYLE3">资料修改</a></div></td>
    <td width="150" bgcolor="#00FF33"><div align="center" class="STYLE3">我的帐户</div></td>
    <td width="150" bgcolor="#99FF66"><div align="center" class="STYLE3">帐户管理</div></td>
  </tr>
</table>
<table width="900" height="3" border="1" align="center" cellspacing="0" bordercolor="#00CC33" >
  <tr>
    <td height="1">&nbsp;</td>
  </tr>
</table><table width="900" border="1" align="center" bordercolor="#00CC33" cellspacing="0">
  <tr>
    <td colspan="5"><div align="center">您现在查看的是会员
        <%out.println(read_id);%>
    的详细资料</div></td>
  </tr>
  <tr>
    <td width="228" rowspan="6">&nbsp;</td>
    <td colspan="4"><div align="center">基本资料</div></td>
  </tr>
  <tr>
    <td width="82">姓名：</td>
    <td width="185">&nbsp;<%=read_list.getString("name")%></td>
    <td width="185">性别：</td>
    <td width="186">&nbsp;<%=read_list.getString("sex")%></td>
  </tr>
  <tr>
    <td>生日：</td>
    <td>&nbsp;<%=read_list.getString("sr")%></td>
    <td>籍贯：</td>
    <td>&nbsp;<%=read_list.getString("jg")%></td>
  </tr>
  <tr>
    <td colspan="4"><div align="center">网上踪影</div></td>
  </tr>
  <tr>
    <td height="42">网名：</td>
    <td>&nbsp;<%=read_list.getString("ename")%></td>
    <td>QQ：</td>
    <td>&nbsp;<%=read_list.getString("qq")%></td>
  </tr>
  <tr>
    <td height="29">博客地址：</td>
    <td>&nbsp;<%=read_list.getString("blog")%></td>
    <td>登录次数：</td>    <td>&nbsp;<%=cs.getInt("dl")%></td>
  </tr>
  <tr>
    <td>&nbsp;</td>
    <td colspan="4"><div align="right">共有<%=cs.getInt("gz")%>看过该网友的页面</div></td>
<%
cs.close();
stmt1.close();
%>
  </tr>
  <tr>
    <td>&nbsp;<%=read_list.getString("ename")%></td>
    <td colspan="2">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td height="17">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td height="17">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td height="17">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
  </tr>
  <tr>
    <td height="17">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
    <td colspan="2">&nbsp;</td>
  </tr>
</table>
</body>
</html>
<%
read_list.close();
cs.close();
stmt.close();
stmt1.close();
conn.close();
%>
===========================================================以下是错误提示=============================================================================
HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
org.apache.jsp.friends.read_jsp._jspService(read_jsp.java:237)
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: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.validateClosedState(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
com.microsoft.jdbc.base.BaseResultSet.getString(Unknown Source)
org.apache.jsp.friends.read_jsp._jspService(read_jsp.java:142)
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.

解决方案 »

  1.   

    此回复为自动发出,仅用于显示而已，并无任何其他特殊作用
    楼主【xohuan】截止到2008-06-25 12:31:26的历史汇总数据(不包括此帖)：
    发帖数:0                  发帖分:0                  
    结贴数:0                  结贴分:0                  
    未结数:0                  未结分:0                  
    结贴率:-------------------结分率:-------------------
    如何结贴请参考这里：http://topic.csdn.net/u/20080501/09/ef7ba1b3-6466-49f6-9d92-36fe6d471dd1.html
      

  2.   

    简单看到个问题
    Statement stmt1=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
    String sql1="select * from reg where id='"+read_id+"'"; 
    ResultSet cs=stmt.executeQuery(sql1);  
    cs.next(); 
    %> 
      

  3.   

    应该是楼主笔误了吧
    stmt-〉stmt1
      

  4.   

      <td colspan="4"> <div align="right">共有 <%=cs.getInt("gz")%>看过该网友的页面 </div> </td> 
    <% 
    cs.close(); 
    stmt1.close(); 
    %> 
      </tr> <% 
    read_list.close(); 
    cs.close(); 
    stmt.close(); 
    stmt1.close(); 
    conn.close(); 
    %> 
    把后面的cs.close(); stmt1.close(); 去掉,前面已关闭了没认真看,不知道对不对