JDBC

• JDBC stands for Java DataBase Connectivity
• It is a standard set of API (Application Programming Interface)
• Which is used to interact with different variety of databases from Java application

Here is the index for Java JDBC concepts

JDBC Introduction and basics

• Java – Introduction to JDBC
• Java – JDBC Driver types
• Java – Core JDBC components
• Java – JDBC Driver list for all leading database

JDBC Connection steps

• Java – JDBC connection steps

Connect Vendor Database

• Java – An example to connect MySQL database
• Java – An example to connect Oracle database
• Java – An example to connect MS Access database
• Java 8 – An example to connect MS Access database in Java 8
• Java – JDBC program to connect IBM DB2 database running on Mainframe z/OS system

Database operation using Statement Interface

• Java – Creating database using JDBC Statement interface
• Java – Droping database using JDBC Statement interface

CRUD operations using Statement Interface

• Java – Creating a table using JDBC Statement interface
• Java – Inserting a record using JDBC Statement interface
• Java – Getting all list of records using JDBC Statement interface
• Java – Getting single record using JDBC Statement interface
• Java – Updating a record using JDBC Statement interface
• Java – Deleting a record using JDBC Statement interface
• Java – Dropping a table using JDBC Statement interface
• Java – Batch update using JDBC Statement interface
• Java – Batch insert using JDBC Statement interface

CRUD operations using PreparedStatement Interface

• Java – Creating a table using JDBC PreparedStatement interface
• Java – Inserting a record using JDBC PreparedStatement interface
• Java – Getting all list of records using JDBC PreparedStatement interface
• Java – Getting single record using JDBC PreparedStatement interface
• Java – Updating a record using JDBC PreparedStatement interface
• Java – Deleting a record using JDBC PreparedStatement interface
• Java – Batch update using JDBC PreparedStatement interface
• Java – Batch insert using JDBC PreparedStatement interface

Callable Statement

• Java – Calling Stored Procedure using JDBC CallableStatement interface
• Java – Calling Stored Function using JDBC CallableStatement interface
• Java – Calling Stored Procedure using JDBC CallableStatement interface with Batch execution

JDBC Transaction

• Java – Transaction handling using JDBC Statement interface
• Java – Transaction handling using JDBC PreparedStatement interface

Integration with Spring/Hibernate framework

• Java – Integration with Spring framework (Spring JDBC)

Database clause

• Java – Where clause example using JDBC Statement interface
• Java – Like clause example using JDBC Statement interface
• Java – Order by clause example using JDBC Statement interface

Metadata

• Java – Metadata of database using JDBC DatabaseMetaData interface
• Java – Metadata of Resultset using JDBC ResultSetMetaData interface

Interview question on JDBC

• Java – Interview question and answer on JDBC

Suggest tutorials from Contact Us page

Happy Coding !!
Happy Learning !!