怪问题（谁来解决一下或 up一下）

[eaglecoody]

从数据库中去数据在页面 中显示
由于是从几个表中从中取数据。所以在Connection conn=aaa.getConn();建立连接后
对rs进行几次操作。rs=aaa.executerQuery(select1);rs.close.....rs=aaa.executerQuery(select2);rs.close.....
rs=aaa.executerQuery(select3);rs.close.....
这样的页面第一次打开正常，但
当刷新页面的时候出现“无法打开指定站点。下载指定资源失败”不知道是什么原因/
望指教。谢谢

[eaglecoody]

up

[eaglecoody]

调用代码如下：
<Connection conn=issue.getConn();

ResultSet rs=issue.executeQuery("select all top 8 * from tbl_lore");
String lore_title;
String lore_sn;
int lore_tmp;
while(rs.next())
{lore_tmp=rs.getInt("lore_sn");
lore_sn=Integer.toString(lore_tmp);
lore_title=rs.getString("lore_title");
lore_title=new String(lore_title.getBytes("iso8859_1"),"gb2312");
out.print("<tr><td bgcolor=\"#fefeee\">"+lore_sn+"  "+lore_title+"</td></tr>");
}
rs.close(); %>

.....
<%

/*生成通知*/
rs=issue.executeQuery("select all top 8 * from tbl_news order by issueDate_update DESC");
while(rs.next())
{issueID=rs.getString("issueID");
if(issueID==null) issueID="null";
else issueID=new String(issueID.getBytes("ISO8859_1"),"gb2312");
issueTitle=rs.getString("issueTitle");
if(issueID==null) issueID="null";
else issueTitle=new String(issueTitle.getBytes("ISO8859_1"),"gb2312");
date_news=rs.getDate("issueDate_update");
/*str_datenews=date_news.toString();
//out.print(str_datenews+dateresult2);
//if(str_datenews.subString().)
//if(date_news==null) date_news="00-00-00";*/
out.print("<tr><td width='98%'><img src='image/description.gif'>  <a href='issuecontent.jsp?issueID="+issueID+"&issueTitle="+issueTitle+"' onclick=\"window.open(this.href,'newtxt','top=0,left=0,width=800,height=450,scrollbars=yes,resizable=yes');return false;\">"+issueTitle+"  "+date_news+"</a><img src='image/new.gif' width='28' height='11'></td></tr>");
}
rs.close();%>
......

<%rs=issue.executeQuery("select all top 8 * from tbl_law order by lawDate_update DESC");

while(rs.next())
{issueID=rs.getString("lawID");
if(issueID==null) issueID="null";
else issueID=new String(issueID.getBytes("ISO8859_1"),"gb2312");
issueTitle=rs.getString("lawTitle");
if(issueID==null) issueID="null";
else issueTitle=new String(issueTitle.getBytes("ISO8859_1"),"gb2312");
date_news=rs.getDate("lawDate_update");
out.print("<tr><td width='98%'><img src='image/description.gif'>  <a href='lawcontent.jsp?lawID="+issueID+"&lawTitle="+issueTitle+"' onclick=\"window.open(this.href,'newtxt','top=0,left=0,width=800,height=450,scrollbars=yes,resizable=yes');return false;\">"+issueTitle+"  "+date_news+"</a><img src='image/new.gif' width='28' height='11'></td></tr>");
}
rs.close();
%>...

当rs.executequery(sql)超过3个就出现上面问题，2个很正常。数据库是sql server200.

[luckybeggar]

up

[eaglecoody]

up

[xuefeifangpei]

最后一起close 侃侃

[akiko]

up

[gisgeoboy]

Connection conn=aaa.getConn();
Statement stmt=conn.createStatement();
Statement stmt1=conn.createStatement();
Statement stmt2=conn.createStatement();
...........
ResultSet rs=stmt.executeQuery(select);
ResultSet rs1=stmt1.executeQuery(select1);
ResultSet rs2=stmt2.executeQuery(select2);
........
rs.close();
rs1.close();
rs2.close();
........

[whodsow]

没遇到过

[Wnyu]

up