Take a challenge exercise to implement a basic DAO.
(upbeat music)…- [Instructor] Now it's time for your code challenge,…and I'm going to have you implement a much more complex DAO.…You'll create the DAO for the order domain.…Now in order to keep this time bound a little bit,…I only want you to operate…on the read action, so the find by ID.…Create or require other domains to be completed,…and update and delete just don't add a lot of value…to what we're trying to learn here…when we're dealing with this complex domain.…
So again, only the read operation.…Let me show you a little bit…about what the database itself looks like.…So at the center of this is the orders record,…and on the orders record are two values…that must be populated.…There's a customer ID and a sales person ID,…so we have a one-to-one join between those two.…Now, for every order, there's an associated…order item table, and that order item…can have one or more order items per order record,…but each order item will have one…and only one product record.…
So this is really the entity relationship…that we're going to build from.…
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: Databaseswith Simon Allardice3h 11m Appropriate for all
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.