是java+JSP 代码
JSP代码如下
rs.close();
stmt.close();
conn.close();
三个全注释掉 就没报:ResultSet is closed 但有时能输出数据表中数据,有时不能.
java代码如下:
package ttt;
import java.util.Timer;
import java.util.TimerTask;
import java.sql.ResultSet;
import javax.servlet.jsp.JspWriter;
import java.io.IOException;
import java.sql.SQLException;
public class FHTimer{
private Tasktt tt=null;
private ResultSet srs;
private JspWriter out;
public FHTimer(ResultSet re,JspWriter jout){
srs=re;
out=jout;
}
public void start(){
tt = new Tasktt();
tt.setreou(srs,out);
Timer tir = new Timer();
tir.schedule(tt,0,800);
}
public void getsel(){
tt.select_Tables();
}
public class Tasktt extends TimerTask {
private String rh="";
private ResultSet rs;
private JspWriter out;
public Tasktt(){
}
public void setreou(ResultSet re,JspWriter jout){
rs=re;
out=jout;
try{
out.print("<script>DDD.innerHTML='已赋值'</script>");
}catch(IOException ioe3){}
}
public void select_Tables(){
try{
rs.beforeFirst();
rh="";
while(rs.next()){
rh+="昵称: "+rs.getString("昵称");
rh+=" 状态: "+rs.getString("状态");
rh+=" 内容: "+rs.getString("内容")+"<br>";
try{
out.print("<script>DDD.innerHTML="+"'"+rh+"'"+"</script>");
}catch (IOException ioe){}
}
}catch(SQLException sqle){
rh="SQL 错误: "+sqle.getMessage();
try{
out.print("<script>DDD.innerHTML="+"'"+rh+"'"+"</script>");
}catch(IOException ioe3){}
}
}
public void run() {
try{
out.print("<script>DDD.innerHTML='开始'</script>");
}catch(IOException ioe3){}
//----------------------------------------
select_Tables();
//----------------------------------------
try{
out.print("<script>DDD2.innerHTML='结束'</script>");
}catch(IOException ioe3){}
}
}
}
