JDBC Tutorial Article List

JDBC is the abbreviation of Java Database Connectivity. Using JDBC, java application can communicate with numerous databases such as Access, ibatis, Mysql, PostgreSQL, Sql Server, Oracle and DB2 etc.

After you write java application, you can swap between different databases without the need to change the code, what you need to do is just change the database settings in configuration file.

In this tutorial we will introduce JDBC concepts and components such as Statement, Connection, ResultSet, PreparedStatement and CallableStatement. We will show you examples about how to use them.

JDBC Connection

  1. Connect Oracle DB Example
  2. Connect MySQL Database Server
  3. Connect PostgreSQL Database
  4. Connect Microsoft SQL Server
  5. Get Database Meta Data Example
  6. Load JDBC Configuration From Properties File Example

JDBC Statement

  1. Use Statement To Create Table
  2. Statement Examples – Insert, Update, Select and Delete
  3. Statement Examples – Batch Insert, Update, Delete

JDBC PreparedStatement

  1. PreparedStatement Example – Create Table, Insert, Update, Delete Records
  2. PreparedStatement Example – Select Data List From Table
  3. PreparedStatement Example – Batch Insert, Update, Delete

JDBC CallableStatement

  1. CallableStatement Stored Procedure Input Parameters Example
  2. CallableStatement Stored Procedure Output Parameters Example