JDBC Examples in Java

🎓 Top 15 Udemy Courses (80-90% Discount): My Udemy Courses - Ramesh Fadatare — All my Udemy courses are real-time and project oriented courses.

▶️ Subscribe to My YouTube Channel (178K+ subscribers): Java Guides on YouTube

▶️ For AI, ChatGPT, Web, Tech, and Generative AI, subscribe to another channel: Ramesh Fadatare on YouTube

Getting Started

Java JDBC API Overview

Overview of JDBC API, java.sql and javax.sql package.

JDBC CRUD Example Tutorial

JDBC API quick getting started tutorial- CREATE, INSERT, UPDATE, SELECT and DELETE.

JDBC 4.2 API - Statement

JDBC Statement Create a Table Example

Example to create a table using Statement interface.

JDBC Statement - Insert Multiple Records Example

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

JDBC Statement - Update a Record Example

Example to update a record in 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 4.2 API - PreparedStatement

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 4.2 API - CallableStatement

JDBC CallableStatement Stored Procedures Example

Create and use Stored Procedure examples using CallableStatement interface.

JDBC 4.2 API - Transactions

JDBC Transactions with Example

How to use JDBC transactions with examples.

JDBC 4.2 API - SQLExceptions Handling

JDBC Handling SQLExceptions

In this article, we will learn how to handle SQLExceptions while working with JDBC.

JDBC 4.2 API - java.sql Package

JDBC Connection Interface

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

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 4.2 API - Batch Processing

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 4.2 API FAQ

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.

Resource and Useful Links

Difference between Statement and PreparedStatement

How can I get the SQL of a PreparedStatement?

java.util.Date vs java.sql.Date

How to establish a connection pool in JDBC?

Closing JDBC Connections in Pool

How does a PreparedStatement avoid or prevent SQL injection?

Check if the table exists

Why do we use a DataSource instead of a DriverManager?

How to get row count using ResultSet in Java?

ResultSet is not closed when connection closed?

How to get database URL from java.sql.Connection?

JDBC 4.1 Features (Oracle Doc)

JDBC 4.2 Features (Oracle Doc)

Reference

My Top and Bestseller Udemy Courses. The sale is going on with a 70 - 80% discount. The discount coupon has been added to each course below:

Spring Boot + RabbitMQ Course - The Practical Guide

Java Guides

Search This Blog