permaculture playing cards*
The moose likes JDBC and the fly likes Result Set Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Result Set" Watch "Result Set" New topic
Author

Result Set

Tome Wagese
Greenhorn

Joined: Jan 13, 2007
Posts: 24
Greetings everyone,
When i try to print the result, it only prints first row even though it has multiple rows.What am i doing wrong here.

Scott Selikoff
Saloon Keeper

Joined: Oct 23, 2005
Posts: 3704
    
    5

I gotta say I'm not familiar with your strategy here... why aren't you just using the common practice of iterating over a result set with a while loop?


My Blog: Down Home Country Coding with Scott Selikoff
Herman Schelti
Ranch Hand

Joined: Jul 17, 2006
Posts: 387
hi Tome,

your example is from http://jakarta.apache.org/commons/dbutils/examples.html,
right?

Just look at the text below the example:
"In the examples above we implemented the ResultSetHandler interface to turn the FIRST row of the ResultSet into an Object[]."

If you want to display all rows, just use one of the other resultsethandlers that DBUtils has(BeanListHandler looks OK to me).

Herman
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321

Originally posted by Tome Wagese:

When i try to print the result, it only prints first row even though it has multiple rows.


what the java Docs Says :
A ResultSet object maintains a cursor pointing to its current row of data. Initially the cursor is positioned before the first row. The next method moves the cursor to the next row, and because it returns false when there are no more rows in the ResultSet object, it can be used in a while loop to iterate through the result set


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
Tome Wagese
Greenhorn

Joined: Jan 13, 2007
Posts: 24
Thanks everyone.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Result Set