Java – Introduction to JDBC

In this article, we will learn and understand JDBC i.e.; Java DataBase Connectivity

JDBC (Java DataBase Connectivity) :

  • JDBC Java DataBase Connectivity is a standard set of API (Application Programming Interface)
  • It is used to interact with different variety of databases from Java application
1-Java-JDBC-interaction-with-database

Interaction with Database :

These interactions could be,

  • Creating and closing connection with database
  • Creating and executing DDL queries i.e.; create, drop, alter
  • Creating and executing DML queries i.e.; insert, select, update and delete
  • Creating and executing DCL queries i.e.; grant and revoke access privileges
  • Invoking and executing stored procedure
  • Invoking and executing stored function

Purpose of JDBC API :

JDBC API are set of classes and interfaces which defines how to interact with database to

  • Establish a connection with database
  • Executing SQL (DDL and DML) and MySql (stored procedure and stored function) queries
  • Processing result set obtained as a result of executing SQL and MySql queries
  • Getting metadata about database and result set
  • Maintaining integrity of the database using JDBC transaction
  • Gracefully closing all open connection and other things

Following article will discuss about different JDBC Driver types

Related Articles :

References :

Happy Coding !!
Happy Learning !!

Java – JDBC Driver types