Derby (Java DB) - ResultSet Objects of Queries

JDBC Tutorials - Herong's Tutorial Examples

∟Derby (Java DB) - ResultSet Objects of Queries

This chapter provides tutorial notes on JDBC ResultSet with Derby (Java DB) JDBC Driver. Topics include ResultSet cursor, scrollable, and update capability; getString() and updateString() methods; updateRow(), insertRow(), and deleteRow() methods.

What Is ResultSet?

ResultSet Cursor and Scrollability

ResultSet Cursor Initial Position: Before First Row

Retrieving Column Values with getXXX() Methods

ResultSet Default Type: Forward-only

Scrollable ResultSet and Moving Cursor Backward

ResultSet Objects with Update Capability

insertRow() - Inserting New Rows through ResultSet Objects

updateXXX() - Updating Column Values for Row Update or Insert

deleteRow() - Deleting Rows through ResultSet Objects

Takeaways:

To execute a SELECT statement, you need to use the executeQuery() method, which returns a ResultSet object.
A ResultSet object represents data returned from the SELECT statement as a table of rows and fields.
getXXX() methods can be used retrieve data from a given field of the current row (where the cursor is pointing to) in a ResultSet object.
next() methods can be used to move the cursor to point to the next row in a ResultSet object.

Table of Contents

About This Book

JDBC (Java Database Connectivity) Introduction

JDK (Java SE) Installation

Installing and Running Derby (Java DB)

Derby (Java DB) JDBC Driver

Derby (Java DB) JDBC DataSource Objects

Derby (Java DB) - DML Statements

►Derby (Java DB) - ResultSet Objects of Queries

Derby (Java DB) - PreparedStatement

Summary of JDBC Drivers and Database Servers

Using Connection Pool with JDBC

Archived Tutorials

References

Full Version in PDF/EPUB