JDBC Tutorial for beginners

 
JDBC is a Java API that enables Java application to connect and execute query to the database. JDBC API uses jdbc drivers to connect to the database.

This tutorial will not cover every single detail of the JDBC API, but focus on the most commonly used features. Here you will learn many step by step examples on using JDBC Statement, PreparedStatement, CallableStatement, and JDBC Transaction.

The rest you can read about in the JavaDoc afterwards.

Happy learning :-)
 

Quick Start

Some quick guides to show how JDBC interact with databases like MySQL, Oracle and PostgreSQL.

• Five Steps to connect to the database

• Connect to MySQL with JDBC driver

• Connect to Oracle DB via JDBC driver

• Connect to PostgreSQL with JDBC driver

JDBC & Statement interface

• JDBC Statement example to Create a table

• JDBC Statement example to Insert a record

• JDBC Statement Example to Update a Record

• JDBC Statement example to Delete a Record

• JDBC Statement example to Drop a table

• JDBC Statement example to Select list of Records from database

JDBC & PreparedStatement interface

The PreparedStatement interface is a sub interface of Statement. It is used to execute parameterized query.

Why use PreparedStatement?

You can use a PreparedStatement instead of a Statement and benefit the following features of the PreparedStatement.
The PreparedStatement’s primary features are:

1. Easy to insert parameters into the SQL statement.
2. Easy to reuse the PreparedStatement with new parameters.
3. Increase performance of executed statements  because query is compiled only once.
4. Enables easier batch updates.

• JDBC PreparedStatement example to Create a table

• JDBC PreparedStatement example to Insert a Record

• JDBC PreparedStatement example to Update a Record

• JDBC PreparedStatement example to Delete a record

• JDBC PreparedStatement example to Select list of the records

JDBC & Stored Procedure

• CallableStatement interface

• JDBC CallableStatement – Stored Procedure IN parameter example

• JDBC CallableStatement – Stored Procedure OUT parameter example

• JDBC CallableStatement – Stored Procedure CURSOR example

JDBC Batch Update example

• JDBC Batch update example

JDBC Performance Tuning

• JDBC Performance Tuning

FAQ

• How to create a AUTO_INCREMENT column in Oracle?