aspose file tools*
The moose likes JDBC 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
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???