November 2001
Intermediate to advanced
496 pages
13h 51m
English
Content preview from Java Programming with Oracle JDBCBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 10. Result Sets
As you saw in Chapter 9,
when you execute a SELECT statement, the results are returned as a
java.sql.ResultSet object. You’ll use the
functionality of the ResultSet object to scroll
through the set of results; work with the values returned from the
database; and make inserts, updates, and deletes. In this chapter,
we’ll start by covering the various data types that can be
accessed using JDBC, and then we’ll take a practical look at
their use while considering the data types available with Oracle.
Next, we’ll discuss the various ResultSet
accessor methods. We’ll continue by discussing how to handle
database NULL values in Java and spend much of the second half of the
chapter discussing scrollable and updateable result sets. Finally,
we’ll discuss the Oracle proprietary extensions to the
ResultSet object.
Basic Cursor Positioning
When you
use the Statement object’s
executeQuery( )
method to query the database with a SQL
SELECT statement, the Statement object returns a
ResultSet object. For the sake of brevity, the
returned ResultSet object contains the results of
your query.
In the database, your data is organized as rows of columns in a
table. Consequently, the result of a query against the database is a
result set that is also organized as rows of columns. A
ResultSet object provides a set of methods for
selecting a specific row in the result set and another set of methods
for getting the values of the columns in the selected row.
When a ResultSet object is ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.