- 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
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
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
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
Suggest tutorials from Contact Us page