wood burning stoves 2.0*
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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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???
 
Similar Threads
please figure this out..
HTTP method GET is not supported by this URL
database
Select multiple tables using single resultset - SQLException: ORA-00933: SQL command not properly en
login servlet = login successful doesn't show