Join Frank P Moley III for an in-depth discussion in this video The Data Access Object (DAO) pattern, part of Learning JDBC.
- [Frank] One of the most common patterns…when dealing with databases,…is the DAO pattern.…Data access objects, or DAOs,…provide an abstraction layer…between the raw JDBC code…and the rest of your code, specifically the business logic.…Now, DAOs can really come in two forms,…and it's really a personal preference.…They can be a simple abstraction,…or it can be a true object.…Most people use DTOs with DAOs…as a pure abstraction layer.…
Regardless of which way you use, however,…it provides a clear separation of concerns…in your code itself.…Now, if you're using a DAO as a pure abstraction layer,…you're going to have a DTO, or a data transfer object.…The data transfer object provides a single domain…of data,…and its fully-encapsulated objects…that may also contain subobjects.…This often transforms itself in the concept…of a table and subtables, or child tables,…that there are joins to.…
Now, the output and input…of a single DAO should be a single DTO…and all of its child objects.…The DAO itself often leverages a common interface,…
AuthorFrank P Moley III
- Deciphering JDBC terminology
- Using containerized PostgreSQL
- Creating, reading, updating, and deleting data
- The Repository pattern
- Using stored procedures
- Ordering and limiting results
- Transactions in JDBC
- Handling exceptions
Skill Level Intermediate
Database Foundations: Core Conceptswith Adam Wilbert2h 14m Beginner
Programming Foundations: Databases (2015)with Simon Allardice3h 11m Intermediate
Java Essential Training: Objects and APIswith David Gassner2h 46m Intermediate
What you need to know5m 10s
1. Introducing Java Data Access
2. Data Access Basics
3. Advanced Data Access
Next steps3m 26s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.