jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes Many ResultSet. How to do layout??? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Many ResultSet. How to do layout???" Watch "Many ResultSet. How to do layout???" New topic
Author

Many ResultSet. How to do layout???

Albert Hopkins
Greenhorn

Joined: Jul 21, 2007
Posts: 21
Hi...
I have many Resultset in a page. For evert resultset, we have to the next() thing right??



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
Ranch Hand

Joined: Jan 01, 2009
Posts: 874


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
Greenhorn

Joined: Jul 21, 2007
Posts: 21
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
Ranch Hand

Joined: Jan 01, 2009
Posts: 874

Well for beginner Have a look at Retreiving ResultSet , MVC Tutorial Topics and JSP
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Many ResultSet. How to do layout???
 
It's not a secret anymore!