This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes JDBC and the fly likes Returning ResultSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Returning ResultSet" Watch "Returning ResultSet" New topic
Author

Returning ResultSet

Joe Deluca
Greenhorn

Joined: Jan 29, 2009
Posts: 14
Hey everyone, I am stuck on a little problem that I cant seem to figure out.

I'm writing a program to add, update and remove from a mySQL database. I would like to return my ResultSet in my data access class to my GUI class to display the data.
But the returned resultset always seems to be empty..

DataAccess Class


GUI Class


Any ideas...?

Thanks,
Joe


SCJP 6
Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
You should never pass connection, statement or resultset outside the block where they are been obtained. You should always acquire AND close them all in the shortest possible scope. If you want to return the results from the query, then you need to map the resultset to a collection of model objects (javabeans, DTO's, VO's, POJO's, or whatever you want to call it).
Joe Deluca
Greenhorn

Joined: Jan 29, 2009
Posts: 14
Thanks for the reply, I am not too familiar with model objects. Could your please give a small example or if you know a good site that explains it.

I need to display data for ResultSets that contain single and multiple rows. for example i need to extract just the first name attribute of a record in a table of one person.

Thanks,
Joe.

Bauke Scholtz
Ranch Hand

Joined: Oct 08, 2006
Posts: 2458
You may find this kickoff DAO example useful: http://balusc.blogspot.com/2008/07/dao-tutorial-data-layer.html
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Returning ResultSet