Home Java Tutorial JDBC Components

JDBC Components

by anupmaurya

 The components of the JDBC API are as follows :

Driver

A JDBC driver is a software component(or collection of Java classes) enabling a Java application to interact with a database. For instance, MySQL will have its own JDBC driver. A JDBC driver implements a lot of the JDBC interfaces. When your code uses a given JDBC driver, it actually just uses the standard JDBC interfaces. The concrete JDBC driver used is hidden behind the JDBC interfaces. Thus you can plug in a new JDBC driver without your code noticing it.

  • The driver handles the communication with the database server (like Oracle, MySQL).
  • You will interact directly with the Driver object very rarely.
  • Instead, you use Driver Manager objects, which manages objects, which manages objects of this type.
  • It also abstracts the details associated with the working of Driver Objects.

Driver Manager

It manages a list of database drivers .

  • It matches connection request from the java application with the proper database driver using communication sub-protocol.
  • The first driver that recognize a certain sub-protocol under JDBC will be used to established a database connection.


Connection Interface

It has all the method for contacting a database .

  • The connection object represents communication context. i.e all communication with the database is through connection object only.


Prepared Statements

Prepared Statement is an interface for representing SQL statements.

  • A SQL statement is precompiled and stored in a PreparedStatement object.
  • This Object can then be used to efficiently execute this statement multiple times.

ResultSets

ResultSet is an interface to represent a database table.

  • These objects hold data retrieved from a database after you execute an SQL query using Statement Objects.
  • It acts as an interface that allows you to move through its database.

SQLException

SQLException is a sub-class of Exception class in Java.

  • It is an exception that provides information on a database access error or other errors.

You may also like

Adblock Detected

Please support us by disabling your AdBlocker extension from your browsers for our website.