Lesson - 01 : JDBC - Introduction to JDBC in Java

JDBC stands for Java Database Connectivity, which is a standard Java API for database-independent connectivity between the Java programming language and a wide range of databases.

The JDBC library includes APIs for each of the tasks mentioned below that are commonly associated with database usage.

Making a connection to a database.
Creating SQL or MySQL statements.
Executing SQL or MySQL queries in the database.
Viewing & Modifying the resulting records.

Before JDBC, ODBC API was the database API to connect and execute query with the database. But, ODBC API uses ODBC driver which is written in C language (i.e. platform dependent and unsecured). That is why Java has defined its own API (JDBC API) that uses JDBC drivers (written in Java language).

Java Database Connectivity (JDBC) architecture is an API specifying interfaces for accessing relational databases. JDBC helps to connect to a database, send queries and updates to the database, and retrieve and process the results obtained from the database for queries.

JDBC is a core part of the Java platform and is an API specification developed by Sun Microsystems. The JDBC architecture supports two-tier and three-tier processing models for accessing a database.