dao « SQL « Java Database Q&A

1. Pros and Cons of the use of DAO pattern    stackoverflow.com

As I mention, I'm interested to know what do you (as experienced developers) thinks about the use of DAO pattern, specifically within a Web Application. If possible what advantages have you ...

2. Where should I put the following method?    stackoverflow.com

I have 2 tables with the relationship:

Purchase 1:m Payment

• Each purchase has a primary key "purchaseId".
• Each payment has a primary key "transactionId" and a foreign key "purchaseId";