JavaConceptBeginner · 3 min read

What is JDBC in Java: Simple Explanation and Example

JDBC (Java Database Connectivity) is a Java API that allows Java programs to connect and interact with databases. It provides methods to send SQL queries and retrieve results, enabling Java applications to work with data stored in databases.

⚙️

How It Works

Imagine you want to talk to a restaurant to order food. You need a way to communicate your order and get your food back. JDBC works like a waiter between your Java program and the database (the restaurant). Your program sends SQL commands (orders) through JDBC, and JDBC delivers these commands to the database.

The database processes the commands and sends back the results (like your food). JDBC then passes these results back to your program. This way, your Java code can read, add, update, or delete data in the database without worrying about the details of how the database works internally.

💻

Example

This example shows how to connect to a database, run a simple query, and print the results using JDBC.

java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JdbcExample {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/testdb";
        String user = "root";
        String password = "password";

        try (Connection conn = DriverManager.getConnection(url, user, password);
             Statement stmt = conn.createStatement()) {

            String query = "SELECT id, name FROM users";
            ResultSet rs = stmt.executeQuery(query);

            while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");
                System.out.println("User ID: " + id + ", Name: " + name);
            }

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

Output

User ID: 1, Name: Alice User ID: 2, Name: Bob

🎯

When to Use

Use JDBC when you need your Java program to work with a database. It is useful for applications that store data like user info, orders, or inventory. For example, web apps, desktop apps, or any system that needs to save and retrieve data from databases like MySQL, PostgreSQL, or Oracle.

JDBC is the standard way in Java to connect to databases, run SQL commands, and handle results. It is especially helpful when you want full control over SQL queries and database interactions.

✅

Key Points

JDBC is an API for Java to connect and interact with databases.
It uses SQL commands to communicate with the database.
JDBC acts like a bridge between Java programs and databases.
It supports many databases through different drivers.
Use JDBC when you need direct database access in Java.

✅

Key Takeaways

JDBC lets Java programs connect to and work with databases using SQL.

It acts as a bridge between Java code and the database system.

Use JDBC for applications that need to store, retrieve, or update data in databases.

JDBC supports many databases through specific drivers.

It provides a standard way to execute SQL commands from Java.