File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes DAO for joined tables Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "DAO for joined tables" Watch "DAO for joined tables" New topic

DAO for joined tables

Cj Recto

Joined: Mar 02, 2012
Posts: 26
hellow guys, I'm currently on learning using Dao pattern in my project. So as what I know, one Table is equivalent to one DAO, am I right? just like StudentDao, SubjectDao. Each dao performs crud operations in their associated tables. But my question is , how am I going to create a DAO for joined tables? lets say I have a query to join student and subject table, then how do I create a DAO for that? Should I place it to the StudentDao? or to SubjectDao? or there's a good practice in that kind of situation?

Palak Mathur
Ranch Hand

Joined: Jan 29, 2007
Posts: 316

I think you may want to read If you still have more doubts than let us know.

Palak Mathur | My Blog | TechJaunt | What is JavaRanch? | List of All FAQs
rambabu desina
Ranch Hand

Joined: May 26, 2012
Posts: 39

Palak Mathur wrote:I think you may want to read If you still have more doubts than let us know.

thanks for your help
and i have read that article but i have understood DAO design pattern but i did not get any help for DAO class for joined tables

please give me some more explanation
Myyron Murray Latorilla
Ranch Hand

Joined: Dec 10, 2009
Posts: 65

my take is it is really upto you on where to put such method, but you may want to consider cohesion, for example, if you are querying for the name of students that are enrolled to a specific subject then you may want to consider to put that in the SubjectDAO because your result makes sense to be coming from such class than from StudentDAO. Having the method name something like "getStudents(String subject)" will also help you decide. Hope this helps.
I agree. Here's the link:
subject: DAO for joined tables
It's not a secret anymore!