| Introduction JDBC API |
| When we need to use database drivers and the JDBC API while developing a Java application to retrieve or store data in database. The JDBC API classes and interfaces are available in the java.sql and the javax.sql package. The classes and interfaces perform a number of tasks, such as establish and close a connection with a database, send a request to a database, retrieve data from database, and update data in the database. |
| The commonly used classes and interfaces in the JDBC API are: |
| 1. DriverManager class: It Load the driver for a database. |
| 2. Driver interface: It represents a database driver. All JDBC driver classes must implement the Driver interface. |
| 3. Connection interface: It enables to establish a connection between a Java application and a database. |
| 4. Statement interface: It enables to execute SQL statements. |
| 5. ResultSet interface: It represents the information retrieve from a database. |
| 6. SQLException class: It provides information about the exception that occurs while interacting with database. |
| To query a database and display the result using Java applications, we need to: |
| a. Load a Driver |
| b. Connect to a database |
| c. Create and execute JDBC statements |
| d. Handle SQL exceptions |