JDBC

01What is JDBC?

JDBC (Java Database Connectivity) is an API that allows a Java program to connect to and interact with a relational database, like MySQL or PostgreSQL, to run queries and manage data.

02Why is it used?

Most real applications need to store and retrieve data from a database. JDBC provides a standard way for Java code to talk to different databases, without needing completely different code for each database type.

03Real-Life Example

Think of a universal translator that lets you communicate with people speaking different languages, using one consistent method of translation. JDBC lets Java communicate with different databases using one consistent approach.

java
import java.sql.*;

Connection conn = DriverManager.getConnection(url, username, password);

java
import java.sql.*;

public class JdbcDemo {
    public static void main(String[] args) {
        try {
            Connection conn = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/mydb", "root", "password"
            );
            System.out.println("Database connected successfully!");
            conn.close();
        } catch (SQLException e) {
            System.out.println("Connection failed: " + e.getMessage());
        }
    }
}

Database connected successfully!