<div>
ooops Vk33........... I guess I am a victim of close timing......... :-) 
</div>


ooops Vk33........... I guess I am a victim of close timing......... :-)

<div>
oh~~!!<br />
<br />
I got it~ thanks!!!
</div>


<div>
Hah, well done Kuldeepchaturvedi! ;)
</div>


<div>
<div class="content wysiwyg-content">
Hi all,<br />
<br />
Can I do the multi ResultSet?<br />
<br />
for example.<br />
<br />
Statement state = myConn.createStatement();<br />
// the first resultset<br />
ResultSet testRS = state.executeQuery(&quot;select<wbr /> * from testing&quot;);<br />
<br />
if (testRS.next()){<br />
<br />
//out.println(&quot;anything here&quot;);<br />
<br />
do{<br />
<br />
//the second result set with the testRS id<br />
ResultSet ndRS = state.executeQuery(&quot;select<wbr /> * from nd where nd_id=&quot; + testRS.test_id);<br />
<br />
if (ndRS.next()){<br />
<br />
do{<br />
<br />
//out.println(&quot;Result here!&quot;);<br />
<br />
}<br />
<br />
}<br />
<br />
}while (testRS.next());<br />
<br />
}<br />
<br />
<br />
after I added this code, it shows:<br />
<br />
Operation not allowed after ResultSet closed<br />
<br />
Why it said ResultSet is closed?<br />
How can I settle it?<br />
<br />
Thanks,<br />
Eric.
</div>
</div>


Hi all,

Can I do the multi ResultSet?

for example.

Statement state = myConn.createStatement();
// the first resultset
ResultSet testRS = state.executeQuery("select * from testing");

if (testRS.next()){

//out.println("anything here");

do{

//the second result set with the testRS id
ResultSet ndRS = state.executeQuery("select * from nd where nd_id=" + testRS.test_id);

if (ndRS.next()){

do{

//out.println("Result here!");

}

}

}while (testRS.next());

}


after I added this code, it shows:

Operation not allowed after ResultSet closed

Why it said ResultSet is closed?
How can I settle it?

Thanks,
Eric.

multi ResultSet?

JavaServer Pages (JSP) allow the development of dynamically generated web pages. It uses the Java programming language; JSP pages are translated into servlets at runtime, with each servlet being cached and reused until the JSP is modified. JSP allows Java code to be interleaved with static web markup content, so the resulting page can be compiled and executed on the server to deliver the content.