JDBC Tutorials - Herong's Tutorial Examples - v3.13, by Herong Yang
Java DB (Derby) - ResultSet Objects of Queries
This chapter provides tutorial notes on JDBC ResultSet with Java DB (Derby) JDBC Driver. Topics include ResultSet cursor, scrollable, and update capability; getString() and updateString() methods; updateRow(), insertRow(), and deleteRow() methods.
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
Takeaways:
Table of Contents
JDBC (Java Database Connectivity) Introduction
Installing and Running Java DB - Derby
Derby (Java DB) JDBC DataSource Objects
Java DB (Derby) - DML Statements
►Java DB (Derby) - ResultSet Objects of Queries
Java DB (Derby) - PreparedStatement
Summary of JDBC Drivers and Database Servers