What is JDBC?

JDBC (Java Database Connectivity) is a Java API (Application Programming Interface) that defines a standard for communication between a Java application and a database. JDBC enables Java programmers to create database-driven applications. JDBC drivers are available for most databases, both commercial and free. The JDBC standard defines how an application can do the following: • Create a connection to a database • Send SQL commands to the database • Process the results of SQL commands JDBC provides Java programmers with a unified way to manage different databases. Programmers only need to learn the JDBC API and not the different databases' own APIs. This allows programmers to switch databases without having to change much code. JDBC drivers are available for most databases, both commercial and free. Most databases have a JDBC driver written in Java. This allows the JDBC drivers to be used on different platforms. There are two different types of JDBC drivers: • JDBC-ODBC drivers • Natives JDBC drivers JDBC-ODBC drivers use ODBC (Open Database Connectivity) to communicate with databases. ODBC is a standard for communicating with databases. JDBC-ODBC drivers are available for most databases. Native's JDBC drivers use the database's owLäs mer