aspose file tools*
The moose likes JDBC and the fly likes OOD Q re: building object from a RDMS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "OOD Q re: building object from a RDMS" Watch "OOD Q re: building object from a RDMS" New topic
Author

OOD Q re: building object from a RDMS

Edmund Castermund
Ranch Hand

Joined: May 09, 2007
Posts: 85
Hi,
I'm writing a webapp and I'm working on the data access piece right now. I'm basically using the data access pattern which I get and works well, but my question is, what is the best way to retrieve data and built a set of objects from a DB?

right now if I have a Widget class with thing1 and thing1 as attributes. My WidgetDAO class has the object itself, plus setPrimaryKey(), getPrimaryKey(), storeData() and some other methods.

But if I want to go into the DB and get all widgets where thing1 == someValue, is it best to have a WidgetReader class with a public static ArrayList<Widget> getWidgets() method?

that's how I did it last time, and it was ok, but I was wondering if there are some other design ideas out there I should know about.
thanks.
ec
Jeanne Boyarsky
author & internet detective
Marshal

Joined: May 26, 2003
Posts: 30762
    
156

That's fine. As your application gets larger, you can use an object relational mapping framework such as Hibernate. It prevents you from having to write the code yourself for database access.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: OOD Q re: building object from a RDMS