This is complete beginners to expert up-to-date JDBC 4.2 Tutorial. In this tutorial, we will learn the latest features added to JDBC 4,4.1 and 4.2 release. All the source code examples in this tutorial are developed using JDK 8 with JDBC 4.2.

JDBC stands for Java Database Connectivity, which is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.

Java JDBC API Overview

• JDBC Statement - Update a Record Example

          Example to update a record in a table using Statement interface.

• JDBC Statement - Insert Multiple Records Example

          Example to insert multiple records in a table using Statement interface.

• JDBC Statement Create a Table Example

          Example to create a table using Statement interface.

• JDBC Statement Select Records Example

          Example to retrieve records from a table using Statement interface.

• JDBC Statement - Delete a Record Example

          Example to delete a record from a table using Statement interface.

• JDBC Statement - Batch Insert Example

          Example to insert records in a batch process via Statement interface.

• JDBC Statement - Batch Update Example

          Example to update records in a batch process via Statement interface.

• JDBC PreparedStatement - Insert a Record Example

         Example to insert a record in a table using PreparedStatement interface.

• JDBC PreparedStatement - Update a Record Example

         Example to update a record in a table using PreparedStatement interface.

• JDBC PreparedStatement - Select Records Example

          Example to retrieve records from a table using PreparedStatement interface.

• JDBC PreparedStatement with a list of values in an IN clause

          Example to pass a list of values to IN clause using PreparedStatement interface.

• JDBC PreparedStatement - Batch Insert Example

          Example to insert records in a batch process via PreparedStatement interface.

• JDBC PreparedStatement - Batch Update Example

          Example to update records in a batch process via PreparedStatement interface.

• JDBC CallableStatement Stored Procedures Example

          Create and use Stored Procedure examples using CallableStatement interface.

• JDBC Transactions with Example

          How to use JDBC transactions with examples.

• JDBC Handling SQLExceptions

• JDBC Connection Interface

• JDBC Statement Interface

         In this article, we will learn commonly used methods of Statement interface with examples.

• JDBC PreparedStatement Interface

          In this article, we will learn commonly used methods of PreparedStatement interface.

• JDBC CallableStatement Interface

          In this article, we will learn commonly used methods of CallableStatement interface.

• JDBC ResultSet Interface with Examples

          In this article, we will learn commonly used methods of ResultSet interface with examples.

• JDBC ResultSetMetaData Interface

          In this article, we will learn commonly used methods of ResultSetMetaData interface.

• JDBC DatabaseMetaData Interface

          In this article, we will learn commonly used methods of DatabaseMetadata interface.

• JDBC DriverManager Class

          In this article, we will learn commonly used methods of DriverManager class with examples.

• JDBC Batch Update MySQL Example

         Example to update records in a batch process using Statement and PreparedStatement interfaces.

• JDBC Batch Insert MySQL Example

         Example to insert records in a batch process using Statement and PreparedStatement interfaces.

• JDBC Statement - Batch Insert Example

          Example to insert records in a batch process via Statement interface.

• JDBC Statement - Batch Update Example

         Example to update records in a batch process via Statement interface.

• JDBC PreparedStatement - Batch Insert Example

         Example to insert records in a batch process via PreparedStatement interface.

• JDBC PreparedStatement - Batch Update Example

          Example to update records in a batch process via PreparedStatement interface.

• JDBC Dynamically Insert Multiple Rows to MySQL Example

         Example to dynamically insert rows using StringBuilder and PreparedStatement placeholders ?.

• Retrieve column names from java.sql.ResultSet

         This article provides how to retrieve column names of a table using getMetaData() method.

• JDBC DataSource Connection MySQL Example

          Example of how to use DataSource to connect with MySQL database.