Java Training | Java Database Connection | JDBC Drivers | JDBC Components
JDBC :
JDBC (Java DataBase Connectivity) is a vendor independent API for accessing relational data from different database vendors in a consistent way.
JDBC Architecture:
Java code calls JDBC library
JDBC loads a driver
Driver talks to a particular database
Ideal: can change database engines without changing any application code
JDBC Drivers
Type I : “Bridge”
Type II : “Native”
Type III : “Middleware”
Type IV : “Pure”
JDBC Components:
Driver Manager: Loads database drivers, and manages the connection between application & driver.
Driver: Translates API calls to operations for a specific data source.
Connection: A session between an application and a driver.
Statement: A SQL statement to perform a query or an update operation.
Metadata: Information about the returned data, driver and the database.
Result Set : Logical set of columns and rows returned by executing a statement.
Cegonsoft
