aspose file tools*
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 The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript 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
 
 
subject: Complex DAO