File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "OOD Q re: building object from a RDMS" Watch "OOD Q re: building object from a RDMS" New topic

OOD Q re: building object from a RDMS

Edmund Castermund
Ranch Hand

Joined: May 09, 2007
Posts: 99
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.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33124

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: OOD Q re: building object from a RDMS
It's not a secret anymore!