Learn about result sets and explore how to leverage them.
- [Instructor] So now that we've created some data…in our database, we now need to look at how to actually…read the data out.…But before we do that I want to talk a little bit about…the construct that you use to read data out of a database…specifically the ResultSet.…Now we've seen this briefly earlier but we're going to talk…a little bit more about what it actually means.…Essentially a ResultSet is a multidimensional array…or a table that returns from a database statement.…It also includes some metadata associated with the query…and where the cursor is as far as reading that table…that comes out.…
Now there's very limited functionality on seeing the size…and scope of results, you basically can go forward…and in some cases back or to a certain spot but you don't…really have the full grasp of everything that's in…a ResultSet in most implementations.…For all intents and purposes, in most use cases,…the ResultSet operates simply like an iterator and you're…just going to loop through the ResultSet to get the data…
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.