Many ResultSet. How to do layout???

[Albert Hopkins]

Hi...
I have many Resultset in a page. For evert resultset, we have to the next() thing right??

  ResultSet rs13 = stmt.executeQuery("SELECT count(BLESS_SEVERITY) as sbmseverity1 from BLESS where BLESS_SEVERITY=1 AND bless_orno like '%_LOG_%'");
rs13.next();

out.println("<p>Result for Login Module (SEV1) = "+ rs13.getInt("sbmseverity1") + "</p>");

ResultSet rs14 = stmt.executeQuery("SELECT count(BLESS_SEVERITY) as sbmseverity2 from BLESS where BLESS_SEVERITY=2 AND bless_orno like '%_LOG_%'");
rs14.next();

out.println("<p>Result for Login Module (SEV2) = "+ rs14.getInt("sbmseverity2") + "</p>");  

When I try to display the result nicely on my page, I realized I have to display it concurrently because it is fixed by the next(). I can't display rs13 with rs14 together in my layout.

How to do this?? thank you

[Balu Sadhasivam]

Store the values of rs14.getInt() and rs13.getInt() before using it. It reduces most of the confusion. which adds to further , as connect DB , html out all happening inside the Servlet itself ( pretty awkward) !! change the design to atleast separate DB and View

[Albert Hopkins]

Hi..
thank you for the reply..

can you give me an example how to do it???

I'm really a beginner...just trying & trying...until I'm brain dead

[Balu Sadhasivam]

Well for beginner Have a look at Retreiving ResultSet , MVC Tutorial Topics and JSP