Follow an exercise in ordering and limiting results.
- [Instructor] So now that we've put a stored function…into the database and manipulated it,…we're going to take a look at a different way…of interacting with data in the database,…and that's through ordering and limiting.…And while this is not an actual JDBC operation,…we are going to leverage it in the next video…to do JDBC type operations, so we need to talk about…how ordering and limiting works within SQL itself.…So let's jump over to our IDE.…And we're going to open up our learning JDBC project…source > main > Java, our base package,…and we're going to start in our customer DAO.…
So like we've done so many times before,…we're going to put a string at the beginning of our class.…Alright, so private static final string.…And we're going to call this one get all limit…And then we'll set it equal to select customer ID,…first name, last name,…email, phone,…address,…city, state,…zip code from customer,…order by last name comma first name…with a limit of our question mark and terminate.…
And that's the sequel statement…
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.