做一个和csdn差不多的论坛 可是碰到关于“流已被关闭“的问题

代码太长，分段贴出：
<%@page import="connectionpool.*" %>
<%@page import="java.sql.*" %>
<%@page import="java.io.*" %>
<%@ page language="java" contentType="text/html;charset=gb2312" %> <%
//建立连接
DBConnectionManager connMgr = DBConnectionManager.getInstance();
java.sql.Connection mycon=connMgr.getConnection("bfnet");
Statement stm=mycon.createStatement();
%>
<jsp:include page="/bbs/top.jsp" flush="true" />
<html>
<head>
<title>交流论坛</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="/style.css" type="text/css">
</head>
<body bgcolor="#FFFFFF" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<center>  <br>
  <table width="760" border="0" cellspacing="0" cellpadding="0">
    <tr> 
      <td  class=td1> 
        <table border=0 cellpadding=0 cellspacing=0 width=150>
          <tr> 
            <td><img height=25 src="/bbs/images/jspd_zjmz_zj.gif" 
                  width=150></td>
          </tr>
          <tr> 
            <td height=110 class="td1"> 
              <jsp:include page="/bbs/denglu.jsp" flush="true" />
            </td>
          </tr>
        </table>
        <table border=0 cellpadding=0 cellspacing=0 width=150>
          <tr> 
            <td><img height=25 src="/bbs/images/jspd_zjmz_hot2.gif" 
                  width=150></td>
          </tr>
          <tr> 
            <td height=5></td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19> Visual C++ </td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19> Delphi </td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19> Visual Basic 
            </td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19> Java </td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19> C/C++ </td>
          </tr>
          <tr> 
            <td>&nbsp;</td>
          </tr>
        </table>
        <table border=0 cellpadding=0 cellspacing=0 width=150>
          <tbody> 
          <tr> 
            <td><img height=25 src="/bbs/images/jspd_zjmz_hotl_my.gif" 
                  width=150></td>
          </tr>
          <tr> 
            <td height=5></td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>我的问题</td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>我参与的问题</td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>我的收藏夹</td>
          </tr>
          <tr> 
            <td height=10></td>
          </tr>
          </tbody> 
        </table>
        <table border=0 cellpadding=0 cellspacing=0 width=150>
          <tbody> 
          <tr> 
            <td><img height=25 src="/bbs/images/jspd_zjmz_nc.gif" 
                  width=150></td>
          </tr>
          <tr> 
            <td height=5></td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>使用帮助</td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>在线名单</td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>修改注册信息</td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>我要投诉</td>
          </tr>
          <tr> 
            <td><img height=15 src="/bbs/images/1d.gif" width=19>用户行为准则</td>
          </tr>
          <tr> 
            <td height=10></td>
          </tr>
          </tbody> 
        </table>
      </td>
      <td width="600" valign="top"> 
        <table width="600" border="0" cellspacing="0" cellpadding="0">
          <tr> 
            <TD align=right height=20 width="100"></TD>
            <TD align=right bgColor=#ff8d62 colSpan=2 width="500"> <FONT color=#ffffff>刷新&nbsp;|&nbsp; 
              </FONT> <FONT color=#ffffff>搜索&nbsp;|&nbsp; </FONT> <FONT color=#ffffff>发表新文章&nbsp;|&nbsp; 
              </FONT> <FONT color=#ffffff>精华区&nbsp;|&nbsp; </FONT> <FONT color=#ffffff>我的文章&nbsp;|&nbsp; 
              </FONT> <FONT color=#ffffff>我参与的文章&nbsp;|&nbsp; </FONT> <FONT color=#ffffff>我的收藏夹&nbsp;&nbsp;</FONT> 
            </TD>
          </tr>
        </table>
        <table width="600" border="0" cellspacing="0" cellpadding="0">
          <tr>
            <td>
              <table width="601" border="0" cellspacing="0" cellpadding="0">
                <tr> 
                  <td colspan="4" height="20"></td>
                </tr>
<%
try{
//bfstd  bfs=new bfstd();
//String wzid = request.getParameter("wzid");
//String grid = (String)session.getAttribute("grid");
String wzid="12";
String grid = "huyuefox";
String sql="select DP_SYS.F_get_bkmc_by_bkid(bkid) bkmc,wzid,grid,wzbt,to_char(rq,'yyyy.mm.dd') rq ,nr,hfl from bfnet.lt_wz where wzid='"+wzid+"' order by rq ";
ResultSet  rs=stm.executeQuery(sql);
while(rs.next()){
  String bkmc=rs.getString("bkmc");
  String wzbt=rs.getString("wzbt");
  String rq=rs.getString("rq");
  String nr=rs.getString("nr");
  String hfl=rs.getString("hfl");  
%>
                <tr> 
                  <td width="15"></td>
                  <td width="100" align="center">主　　题：</td>
                  <td width="470"><%=wzbt%></td>
                  <td width="16"></td>
                </tr>
                <tr> 
                  <td width="15"></td>
                  <td width="100" align="center">作　　者：</td>
                  <td width="470"><%=grid%></td>
                  <td width="16"></td>
                </tr>
                <tr> 
                  <td width="15"></td>
                  <td width="100" align="center">所属论坛：</td>
                  <td width="470"><%=bkmc%></td>
                  <td width="16"></td>
                </tr>
                <tr> 
                  <td width="15"></td>
                  <td width="100" align="center">发布时间：</td>
                  <td width="470"><%=rq%></td>
                  <td width="16"></td>
                </tr>
                <tr> 
                  <td colspan="4" class="td2">&nbsp;</td>
                </tr>
                <tr> 
                  <td colspan="4" height="10"></td>
                </tr>
                <tr> 
                  <td width="15"></td>
                  <td colspan="2"><%=nr%></td>
                  <td width="16"></td>
                </tr>                <tr> 
                  <td colspan="4" height="15"></td>
                </tr>
              </table>
            </td>
          </tr>
<%}%>

解决方案 »

  1.   

    紧接着上面的代码：
    <% 
    String sql1 = "select grid,wzid,hfid,nr, to_char(rq,'yyyy.mm.dd') rq  from lt_wzhf where wzid='"+wzid+"' and flag ='0'";
    ResultSet  rs1=stm.executeQuery(sql1);
    while(rs1.next()){
      String hfid=rs1.getString("hfid");
      String grid1=rs1.getString("grid");
      String rq1=rs1.getString("rq");
      String nr1=rs1.getString("nr");
      String flag1=rs1.getString("flag");
    %>
              <tr>
                <td>
                  <table width="600" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td colspan="3" class="td2"> 
                        <table width="600" border="0" cellspacing="0" cellpadding="0">
                          <tr bgcolor="#00FFFF"> 
                            <td width="15" ></td>
                            <td width="370" ><b>回复人：
                            <%=grid1%>
                            （大骨头）</b></td>
                            <td width="200" ><%=rq1%></td>
                            <td width="15" ></td>
                          </tr>
                        </table>
                      </td>
                    </tr>
                    <tr> 
                      <td colspan="3" height="10"></td>
                    </tr>
                    <tr> 
                      <td width="15"></td>
                      <td width="570"><%=nr1%></td>
                      <td width="15"></td>
                    </tr>
                    <tr> 
                      <td colspan="3" height="15"></td>
                    </tr>
                  </table>
                </td>
              </tr>
    <%
      }
     }
     catch (Exception fe2){
       out.println(fe2.getMessage());
    }
      stm.close();     
    %>
      
       
         <tr>
                <td>
                 <form name="form1" method="post" action="">
                    <table width="600" border="0" cellspacing="0" cellpadding="0">
                      <tr> 
                        <td colspan="5" class="td2" height="20">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td colspan="5" height="20"></td>
                      </tr>
                      <tr> 
                        <td width="15"></td>
                        <td colspan="4"> 
                          <textarea name="textarea" rows="10" cols="80"></textarea>
                        </td>
                      </tr>
                      <tr> 
                        <td width="15"></td>
                        <td width="100" align="center"> 
                          <input type="submit" name="Submit6" value="回 复">
                        </td>
                        <td width="85" align="center"> 
                          <input type="reset" name="Submit22" value="重 写">
                        </td>
                        <td width="272"></td>
                        <td width="128"></td>
                      </tr>
                      <tr> 
                        <td colspan="5" height="10"></td>
                      </tr>
                      <tr> 
                        <td width="15"></td>
                        <td colspan="4"><font color="#FF0000">在这里发贴，表示您接受了本论坛的 
                          用户行为准则。<br>
                          请您对您的言行负责，并遵守中华人民共和国有关法律、法规,尊重网上道德。 </font></td>
                      </tr>
                      <tr> 
                        <td colspan="5" height="10"></td>
                      </tr>
                      <tr> 
                        <td width="15"></td>
                        <td width="100" align="right"> 
                          <input type="submit" name="Submit42" value="推荐给朋友">
                        </td>
                        <td width="85"> 
                          <input type="submit" name="Submit52" value="将帖子提前">
                        </td>
                        <td width="272"> 
                          <input type="submit" name="Submit32" value="加入我的收藏夹">
                        </td>
                        <td width="128"></td>
                      </tr>
                      <tr> 
                        <td colspan="5"></td>
                      </tr>
                    </table>
                 </form>
                </td>
              </tr>
            </table>
        <table width="600" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td class="td2" colspan="2">&nbsp;</td>
              </tr>
              <tr> 
                <td align="right" width="537"></td>
                <td align="center" width="63" height="20" bgcolor="#006699"><font color=yellow>关闭窗口</font></td>
              </tr>
            </table>
            <br>
          </td>
        </tr>
      </table>
      <br>
      <jsp:include page="/public/bottom.jsp" flush="true" />
    </center>
    </body>
    </html>
      

  2.   

    是不是rs rs1关闭有问题？
      

  3.   

    scarab(没有尾巴的鲨鱼)：
    不是rs的问题，rs关不关闭报的错都一样。是不是Statement得问题。
      

  4.   

    那样，你把同数据库的连接放到一个BEAN里
    在同数据库连接处多捕捉异常看看错误到底在哪儿
      

  5.   

    开始时我是把数据库的连接放到一个类似BEAN的package里的。可是bean中的连接建完就关了，等调用第二个rs时，就抱“流以被关闭”的错
    数据库连接的方法如下：  public ResultSet getResultBySelect (String selectstring)
        throws SQLException
      {
        ResultSet rs=null;
        DBConnectionManager connMgr = DBConnectionManager.getInstance();
        Connection conn=connMgr.getConnection("bfnet");
        try
        {
          Statement stm=conn.createStatement();
          String strSQL= new String(selectstring.getBytes("ISO8859_1"));
          rs=stm.executeQuery(strSQL);
          connMgr.freeConnection("bfnet",conn);
        }
        catch (UnsupportedEncodingException fe)
        {
          connMgr.freeConnection("bfnet",conn);
          return rs;
        }
        return rs;
      }
      

  6.   

    public ResultSet getResultBySelect (String selectstring)
        throws SQLException
      {
        public boolean result;
        ResultSet rs=null;
        DBConnectionManager connMgr = DBConnectionManager.getInstance();
        Connection conn=connMgr.getConnection("bfnet");
        try
        {
          Statement stm=conn.createStatement();
          String strSQL= new String(selectstring.getBytes("ISO8859_1"));
          rs=stm.executeQuery(strSQL);
    //      connMgr.freeConnection("bfnet",conn);
        }
        catch (UnsupportedEncodingException fe)
        {
          connMgr.freeConnection("bfnet",conn);
             System.out.println("error");
             result = false;
    //      return rs;
        }
        result = true;
        return rs;
      }
      

  7.   

    scarab(没有尾巴的鲨鱼) :
    你上面修改的bean中不把连接关闭，那这个连接是不是永远不能释放？
      

  8.   

    我在tomcat+oracle8上也碰到过类似的问题当用
    rs.getString(2);
    rs.getString(1);
    就会出“流已被关闭“这样的错误结果集的读取顺序不能调转你检查一下代码有没有这样的情况吧
    rs.getString(1);
    rs.getString(2);
      

  9.   

    直接做两个独立的bean，然后分别调用，
    就不会有这个问题了，楼上的也对
      

  10.   

    lun2001(小伦)和offsider(飘扬过海) 的方法都可以，问题已经解决。
    感谢
    lun2001(小伦)、offsider(飘扬过海)、xmvigour(微电)、和鲨鱼。
    结分！