"java.sql.SQLException: ResultSet is closed"错误？？

[tcpc2003]

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*"%>
<%
//String DBDriver="COM.ibm.db2.jdbc.net.DB2Driver";
String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
String DBurl="jdbc:odbc:tyt";
String user="66";
String password="66";
String sql="",sql2="";
String procname="";
String logtime_start="";
String logtime_end="";
Statement stm=null;
Connection conn=null;
ResultSet rs=null,rs2=null;
try
{
Class.forName(DBDriver).newInstance();
conn=DriverManager.getConnection(DBurl,user,password);
stm=conn.createStatement();
}
catch(Exception e)
{
out.println(e.getMessage());
}
sql="select remark,process_name,log_time from wh.dp_log where remark like '%yy%' order by log_time ";
rs=stm.executeQuery(sql);
while(rs.next())
{
while(rs.getString(1).indexOf("uu")==0)
rs.next();
procname=rs.getString(2);
logtime_start=rs.getString(3);

sql2="select log_time from WH.DP_LOG where process_name='"+procname+"' and log_time>'"+logtime_start+"' and remark like '%tt%' order by log_time";
rs2=stm.executeQuery(sql2);
out.println(sql2);
rs2.close();
}
rs.close();
stm.close();
conn.close();
%>

总是说rs2已经关闭了？？？？
谢谢

[aku0708]

你　两的结果集都是同用一个连接，
RS2已经把关闭了，把RS2。CLOSE（）删除了，就可以了

[gdx]

1.将Statement改为PrepareStatement[不是必须]
2.每个Result对应一个PrepareStatement(Statement)
如题:
Statement stm2 = conn.createStatement();
Result rs2 = stm2.execute("your sql statement")