JDBC Tutorial

Home Next

JDBC (Java Database Connectivity) is Java's standard API for connecting to and working with relational databases. Whatever database you use — MySQL, PostgreSQL, Oracle, SQL Server — JDBC gives you the same set of Java classes and interfaces to connect, run queries, and read results.

Where this fits: This site's own PHP pages talk to MySQL using mysqli. JDBC is the Java equivalent — same idea (connect, query, read results), different language and API. Once you know JDBC, Hibernate (coming soon) will make much more sense, since it's built on top of it.

The JDBC Architecture

[Your Java Code] --uses--> [JDBC API] --loaded by--> [JDBC Driver] --talks to--> [Database]

Layer	What it does
JDBC API	A set of standard interfaces (`Connection`, `Statement`, `ResultSet`, etc.) that every JDBC driver implements.
JDBC Driver	A database-specific library that translates JDBC API calls into the database's own network protocol (e.g. MySQL Connector/J for MySQL).
DriverManager	Manages the list of loaded drivers and hands your code a `Connection` for a given database URL.

A Quick Look Ahead

Example: The Shape of Every JDBC Program

import java.sql.*;

public class QuickLook {
  public static void main(String[] args) throws Exception {
    // 1) Connect
    Connection conn = DriverManager.getConnection(
      "jdbc:mysql://localhost:3306/coding_with_sonu", "root", "");

    // 2) Query
    Statement stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS total FROM visitor_logs");

    // 3) Read results
    if (rs.next()) {
      System.out.println("Total: " + rs.getInt("total"));
    }

    // 4) Close everything
rs.close(); stmt.close(); conn.close();
  }
}

Note: This page's code is a preview, not something you can run right on this website — this server runs PHP, not a Java runtime. Every example in this track is real, correct Java/JDBC code meant to be copied into your own Java project and run there.

Why Learn JDBC?

Reason	What it means for you
Foundation for ORMs	Hibernate and JPA both run on top of JDBC under the hood
Database-agnostic API	Same code style works with MySQL, PostgreSQL, Oracle, and more
Full control	You write the exact SQL that runs — nothing hidden or auto-generated
Used everywhere	Any Java backend that talks to a relational database touches JDBC somewhere

Next steps: Head to JDBC Drivers to see the different driver types and which one you'll actually use.

Home Next