"java.sql.SQLException: ResultSet is closed"错误??
<%@ 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已经关闭了????
谢谢