Follow an exercise in paging results.
- [Instructor] In the previous video…we looked at ordering and limiting results…in order to prepare ourselves to actually do paging.…And paging is a construct within JBC…and really all database operations,…whereby we limit the amount of data…we return from the database in a given slice.…That way if we only need to see the first page,…we only see that.…But if we do need to see the 10th page…then we can slice through that data.…It provides a much more efficient mechanism…by getting data to the customer,…as opposed to giving them all the data at once.…
So let's take a look in Postgres how to implement paging.…So what I want you to do is jump back in your IDE.…Now I do want to reiterate here,…this is how you can do paging in Postgres.…There is more than one way to do paging,…and there's more than one way to do it across database.…This works for Postgres and this is a pattern…that I've utilized many times over.…So I'm going to show you my pattern for paging,…and you can expand on it as you wish.…The idea and concepts, however, will still be the same.…
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.