• 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

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

JDBC Connection steps

• JDBC connection steps in Java

Steps to connect all leading Database

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

Database operation using Statement Interface

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

CRUD operations using Statement Interface

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

CRUD operations using PreparedStatement Interface

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

Callable Statement

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

JDBC Transaction

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

Integration with Spring/Hibernate framework

• Integration with Spring framework (Spring JDBC)

Database clause

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

Metadata

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

Interview question on JDBC

• Interview question and answer on JDBC

 

Suggest tutorials from Contact Us page