Java Database Connectivity

Why Trust Techopedia

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.


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.

Related Terms

Margaret Rouse
Technology Expert
Margaret Rouse
Technology Expert

Margaret 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 IT definitions have been published by Que in an encyclopedia of technology terms and cited in articles by the New York Times, Time Magazine, USA Today, ZDNet, PC Magazine, and Discovery Magazine. She joined Techopedia in 2011. Margaret's idea of a fun day is helping IT and business professionals learn to speak each other’s highly specialized languages.