JDBC

JDBC stands for Java Database Connectivity. It is an Application Programming Interface (API) of JavaSoft. JDBC allows different types of Java-based applications to access database management systems.

JDBC consists of a collection of classes and interfaces that were written and developed in the Java programming language. Using the classes and interfaces included in JDBC, a programmer can create an application that connects to a database. Once an application has been connected to the database, the programmer can use the Structured Query Language or SQL to send queries to the database and process the results that will be produced by the said statements. JDBC also lets the programmer use SQL to insert, update, and delete data found in the database he is working on.

JDBC enables a programmer to create one application that can run on several platforms and interact with various database management systems. This is because Java programs run in most platforms and almost all relational database management systems support the Structured Query Language.

JDBC can be compared to Open Database Connectivity or ODBC because both are examples of APIs and are used to access database systems. However, JDBC is designed specially for Java programs. This is in contrast to ODBC, which is not dependent on a particular language.

To adhere to the standards of the Java programming language, the components of JDBC are consistent with the core classes and interfaces such as java.awt and java.lang. JDBC, however, requires that the database management system should have a JDBC driver.