JDBC stands for Java DataBase Connectivity, which is java API to connect and execute query with the database.
Advantages of using java with JDBC are as follows
Easy & economical
Development time of application is short
Installation is simple
JDBC API is designed to allow developers to create database frontend without rewriting their code
JDBC API actually communicates with JDBC manager driver API by sending SQL statements
The manager then communicates with the 3rd – party drivers which actually connect to the database & return the information of a query
JDBC API is available in 2 packages
It is a class used to load JDBC drivers in memory. It is also used to open connection to a data source
It represents a connection with a data source. It is also used by createStatement, prepareStatement & callableStatement objects
It represents a static SQL statement & it is also used to retrieve rows from a database table i.e. ResultSet object
It is a high performance alternative to statement object. It represents a pre-compiled SQL statement.
It represents a stored procedure.
It represents a result set which is generated by SELECT SQL statement
It is an exception class which encapsulates data base access error
It abstracts a data source. This object is used in place of Driver Manager to obtain the data source connection.
It allows the support for distributed transaction
It extends ResultSet interface to add support for disconnected result set