This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes EJB and other Java EE Technologies and the fly likes Complex DAO Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Complex DAO" Watch "Complex DAO" New topic
Author

Complex DAO

aakash bhatt
Ranch Hand

Joined: Jan 09, 2003
Posts: 182
Can i get some examples how to insert/ update / select in ComplexDAO
Regards,
aakash
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
What is ComplexDAO?


Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
If you mean a Complex DAO, then I would look at Martin Fowler's book "Patterns of Enterprise Application Architecture".
Kyle


Kyle Brown, Author of Persistence in the Enterprise and Enterprise Java Programming with IBM Websphere, 2nd Edition
See my homepage at http://www.kyle-brown.com/ for other WebSphere information.
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
Originally posted by Kyle Brown:
If you mean a Complex DAO, then I would look at Martin Fowler's book "Patterns of Enterprise Application Architecture".

Hmm. I've skimmed through the book (haven't bought it yet) and don't remember such a pattern. Could you post a short description of it (what makes it "complex")?
aakash bhatt
Ranch Hand

Joined: Jan 09, 2003
Posts: 182
What I meant to say of Complex DAO is a DAO comprising of more than one table. In a case when in a scenario I want to fetch records from more than 2 tables using DAO. In that case my Complex DAO will be of multiple tables.
Something like in SQL it will be.
SELECT * from ORDER, ORDERDETAIL where order.orderno = orderdetail.orderdetailno;
Kyle Brown
author
Ranch Hand

Joined: Aug 10, 2001
Posts: 3892
    
    5
Joins and relationships are one of the things Martin's book touches on. There are about a dozen databse related patterns there that you might find useful.
Kyle
 
jQuery in Action, 2nd edition
 
subject: Complex DAO