Java Database Connectivity

What Does Java Database Connectivity Mean?

Java Database Connectivity (JDBC) is an application programming interface (API) which allows the programmer to connect and interact with databases. It provides methods to query and update data in the database through update statements like SQL’s CREATE, UPDATE, DELETE and INSERT and query statements such as SELECT. Additionally, JDBC can run stored procedures.

Advertisements

Like Java, JDBC is compatible with many platforms like Unix and MAC OS.

Techopedia Explains Java Database Connectivity

The JDBC API uses Java standard classes and interfaces to connect to databases. In order to use JDBC to connect Java applications to a specific database server, a JDBC driver that supports the JDBC API for that database server is required.

To establish a connection between the Java application and the database, JDBC follows certain steps:

  1. Loading the driver: The driver provides a connection to the database.
  2. Creating the connection: Once the driver is loaded, the next step is to create a connection. The connection object uses a URL in the specified format, which includes the machine name, port number and database name. It communicates with the database object.
  3. Executing SQL statements: Requires an object for building the SQL statement.
  4. Returning the resultset: Retrieves and manipulates the database queries. Records can be accessed from the first row to the last row of the database.
Advertisements

Related Terms

Latest Database Terms

Related Reading

Margaret Rouse

Margaret Rouse is an award-winning technical writer and teacher known for her ability to explain complex technical subjects to a non-technical, business audience. Over the past twenty years her explanations have appeared on TechTarget websites and she's been cited as an authority in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine and Discovery Magazine.Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages. If you have a suggestion for a new definition or how to improve a technical explanation, please email Margaret or contact her…