What is Java Database Connectivity (JDBC)?

What does JDBC stand for?

Java Database Connectivity (JDBC) is an Application Programming Interface (API) which lets in the Programmer to connect and engage with Databases. It gives Methods to Query and UPDATE facts in the database through update Statements like SQL’s CREATE, UPDATE, DELETE and Insert and query statements including SELECT. Additionally, JDBC can run saved processes.

Like Java, JDBC is well matched with many structures like Unix and MAC OS.

What Does Java Database Connectivity Mean?

The JDBC API Makes use of Java preferred Classes and Interfaces to connect to databases. In order to apply JDBC to connect Java programs to a selected Database Server, a JDBC Driver that helps the JDBC API for that database Server is needed.

To set up a connection among the Java Software and the database, JDBC follows positive steps:

1. Loading the driver: The motive force provides a connection to the database.
2. Creating the connection: Once the driving force is loaded, the next step is to create a connection. The connection item makes use of a URL inside the specific layout, which includes the sySTEM name, port quantity and database name. It communicates with the database item.
3. Executing SQL statements: Requires an item for Constructing the SQL Declaration.
4. Returning the resultset: Retrieves and manipulates the database queries. Records can be Accessed from the primary row to the closing row of the database.