0 JDBC ARCHITECTURE
JDBC API
• The JDBC API uses a driver manager and database-specific drivers to provide transparent
connectivity to heterogeneous databases.
• JDBC API provides classes and interfaces to connect or communicate Java application with the database.
JDBC Driver Manager (Class)
• This class manages a list of database drivers.
• It ensures that the correct driver is used to access each data source.
• The driver manager is capable of supporting multiple concurrent drivers connected to multiple heterogeneous databases.
Driver (Interface)
• This interface handles the communications with the database server.
• It also abstracts the details associated with working with Driver objects
Connection (Interface)
• This interface with all methods for contacting a database.
• The connection object represents communication context, i.e., all communication with the database is through connection object only.
Statement (Interface)
• You use objects created from this interface to submit the SQL statements to the database. Some derived interfaces accept parameters in addition to executing stored procedures.
ResultSet (Interface)
• These objects hold data retrieved from a database after you execute an SQL query using Statement objects.
• It acts as an iterator to allow you to move through its data.
SQLException (Class)
This class handles any errors that occur in a database application.
