The JDBC is used whenever a Java application should communicate with a relational database for which a JDBC driver exists. JDBC is part of the Java platform standard; all visible CLASSES used in the Java/database communication are placed in PACKAGE java.sql.

Main JDBC classes:

• DriverManager: Manages a LIST of database drivers. Matches connection requests from the java application with the proper database driver using communication subprotocol. The first driver that recognizes a certain subprotocol under jdbc (such as odbc or dbAnywhere/dbaw) will be used to establish a database Connection.
• Driver: The database communications link, handling all communication with the database. Normally, once the driver is loaded, the developer need not call it EXPLICITLY.
• Connection: Interface with all methods for contacting a database.
• Statement: Encapsulates an SQL statement which is passed to the database to be parsed, compiled, planned and executed.
• RESULTSET: The answer/result from a statement. A ResultSet is a fancy 2D list which encapsulates all outgoing results from a given SQL query.

The JDBC is used whenever a Java application should communicate with a relational database for which a JDBC driver exists. JDBC is part of the Java platform standard; all visible classes used in the Java/database communication are placed in package java.sql.

Main JDBC classes: