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 |
Tags Introduction JDBC API JDBC API