50分求救!同一个JSP页面中为什么不能定义两个数据库结果集??
我要分别从两张不同的表中获取数据,在一张表中获得一条记录显示后,马上要从另外一张表上读取其他相应的记录来显示……再显示第一张表的下一条记录;JSP代码如下:
<% String sql=
"SELECT * FROM party";
String sql2=
"SELECT * FROM power";
ResultSet rs=stms.executeQuery(sql);
ResultSet rs2=stms.executeQuery(sql2);%>
<% while(rs.next()){
String name=rs.getString("partyName");%>
<div id="KB1Parent" class="parent"> <a href="#" onClick="expandIt('KB1'); return false" ><img src="fold.gif"
border=0><%=name%></a></div>
<div id="KB1Child" class="child">
<% while(rs2.next()){
String pow=rs2.getString("pow");%>
<a href="sample.htm" target="_blank" ><img src="list.gif" border=0 alt=""><img src="open.gif"
border=0><%=pow%></a><br>
<%};%>
<%};
stms.close();
conn.close(); %>
在浏览器上总是说:
Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error
The server encountered an unexpected condition which prevented it from fulfilling the request