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

 

 

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

 

Read Also:

• JDBC Tutorial index
• Different types of JDBC drivers
• JDBC Driver list for all leading databases
• Basic components of JDBC
• JDBC connection steps
• MySQL database connection steps
• Oracle database connection steps
• MS Access database connection steps

 

References:

• https://docs.oracle.com/javase/tutorial/jdbc/basics/gettingstarted.html
• https://docs.oracle.com/cd/E11882_01/java.112/e16548/overvw.htm#JJDBC28025
• http://docs.oracle.com/javase/tutorial/jdbc/basics/index.html
• https://en.wikipedia.org/wiki/JDBC_driver

 

Happy Coding !!
Happy Learning !!