Derby (Java DB) - PreparedStatement

JDBC Tutorials - Herong's Tutorial Examples

∟Derby (Java DB) - PreparedStatement

This chapter provides tutorial notes on JDBC PreparedStatement with Derby (Java DB) JDBC Driver. Topics include creating PreparedStatement objects; setting PreparedStatement parameters; running PreparedStatement in batch mode; comparing PreparedStatement performance.

Tutorial programs in this chapter use DataSource objects retrieved from a JNDI directory service to create connections. Read previous chapters to learn how store DataSource objects into a JNDI directory service.

PreparedStatement Overview

PreparedStatement with Parameters

PreparedStatement in Batch Mode

Performance of Inserting Rows with a PreparedStatement

Performance of Inserting Rows with a Regular Statement

Performance of Inserting Rows with a ResultSet

Takeaways:

SQL statements in PreparedStatement objects are pre-compiled on the database server side.
IN parameters are supported in SQL statements in PreparedStatement objects.
setXXX() methods can be used to provide values to parameters in PreparedStatement objects.
Batch execution mode is supported to run the run SQL statement multiple times in a single transaction.
For multiple repeating insert operations, PreparedStatement performs better than regular INSERT statement.

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