MySQL - PreparedStatement

JDBC for MySQL - Herong's Tutorial Examples

∟MySQL - PreparedStatement

This chapter provides tutorial notes on JDBC PreparedStatement with MySQL 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

InnoDB (MySQL 5.5 Default Engine) Slower on INSERT

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

MySQL Installation on Windows

MySQL JDBC Driver (MySQL Connector/J)

►MySQL - PreparedStatement

MySQL - Reference Implementation of JdbcRowSet

MySQL - JBDC CallableStatement

MySQL CLOB (Character Large Object) - TEXT

MySQL BLOB (Binary Large Object) - BLOB

Using Connection Pool with JDBC

Archived Tutorials

References

Full Version in PDF/EPUB