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";
I have a DAO class for ...