---

🌟 Introduction

In real-world Java applications, data is stored in databases like MySQL 🗄️
To interact with these databases, Java uses JDBC (Java Database Connectivity) 🔗

👉 In this blog, you will learn everything from scratch:

• 📥 Downloading JDBC driver
• 📂 Setting up folder
• ⚙️ Using PowerShell / CMD
• 🔗 Connecting Java to MySQL
• 🧾 Performing CRUD operations

---

🧱 Step 1: Prerequisites

---

✅ You must have:

• Java JDK installed ☕
• MySQL running (via phpMyAdmin) 🗄️
• Internet connection 🌐

---

📦 Step 2: Download MySQL Connector/J

---

👉 Download from official site:

• MySQL Connector/J (JDBC Driver)

---

🔹 Steps:

1. Open: https://dev.mysql.com/downloads/connector/j/
2. Select:
   • Platform Independent
3. Download ZIP file
4. Click:
   👉 “No thanks, just start my download”

---

📂 Step 3: Extract and Setup Folder

---

🔹 Extract ZIP

You will get:

mysql-connector-j-9.x.x.zip

👉 Extract it

---

🔹 Create Folder

Create:

C:\jdbc

---

🔹 Copy .jar file

Move this file:

mysql-connector-j-9.x.x.jar

👉 Into:

C:\jdbc

---

✅ Final Structure

C:\jdbc
│
├── JDBCConnect.java
├── mysql-connector-j-9.x.x.jar

---

🗄️ Step 4: Setup Database (phpMyAdmin)

---

▶️ Open phpMyAdmin

http://localhost/phpmyadmin

---

▶️ Create Database

CREATE DATABASE testdb;

---

▶️ Create Table

USE testdb;

CREATE TABLE student (
    id INT,
    name VARCHAR(50)
);

---

🧾 Step 5: Write Java Program (Notepad)

---

Create file:

C:\jdbc\JDBCConnect.java

---

✅ Basic Connectivity Program

import java.sql.*;

public class JDBCConnect {
    public static void main(String[] args) {

        try {
            Class.forName("com.mysql.cj.jdbc.Driver");

            Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/testdb",
                "root",
                ""
            );

            System.out.println("Connected successfully!");

            con.close();

        } catch (Exception e) {
            System.out.println(e);
        }
    }
}

---

⚙️ Step 6: Compile & Run (PowerShell)

---

▶️ Open PowerShell

Windows + R → powershell

---

▶️ Go to Folder

cd C:\jdbc

---

▶️ Compile

javac -cp ".;mysql-connector-j-9.6.0.jar" JDBCConnect.java

---

▶️ Run

java -cp ".;mysql-connector-j-9.6.0.jar" JDBCConnect

---

🎉 Output

Connected successfully!

---

🧠 Important Concept

👉 In PowerShell:

• Always use quotes " " with -cp

---

🧱 Step 7: CRUD Operations (Very Important)

---

🟢 1. INSERT (Create)

Statement stmt = con.createStatement();

stmt.executeUpdate("INSERT INTO student VALUES (1, 'Ajay')");

---

🔵 2. SELECT (Read)

ResultSet rs = stmt.executeQuery("SELECT * FROM student");

while (rs.next()) {
    System.out.println(rs.getInt("id") + " " + rs.getString("name"));
}

---

🟡 3. UPDATE

stmt.executeUpdate("UPDATE student SET name='Rahul' WHERE id=1");

---

🔴 4. DELETE

stmt.executeUpdate("DELETE FROM student WHERE id=1");

---

🧪 Complete CRUD Program

---

import java.sql.*;

public class JDBCCRUD {
    public static void main(String[] args) {

        try {
            Class.forName("com.mysql.cj.jdbc.Driver");

            Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/testdb",
                "root",
                ""
            );

            Statement stmt = con.createStatement();

            // INSERT
            stmt.executeUpdate("INSERT INTO student VALUES (1, 'Ajay')");

            // UPDATE
            stmt.executeUpdate("UPDATE student SET name='Rahul' WHERE id=1");

            // SELECT
            ResultSet rs = stmt.executeQuery("SELECT * FROM student");

            while (rs.next()) {
                System.out.println(rs.getInt(1) + " " + rs.getString(2));
            }

            // DELETE
            stmt.executeUpdate("DELETE FROM student WHERE id=1");

            con.close();

        } catch (Exception e) {
            System.out.println(e);
        }
    }
}

---

⚠️ Common Errors

---

❌ Driver not found

👉 Forgot .jar in classpath

---

❌ Unknown database

👉 Database not created

---

❌ Access denied

👉 Wrong username/password

---

❌ Table not found

👉 Table missing in phpMyAdmin

---

🤯 Common Confusions

---

🤔 Why use .jar file?

👉 It contains JDBC driver

---

🤔 Why -cp needed?

👉 To include external libraries

---

💼 Interview Questions

---

❓ What is JDBC?

👉 API to connect Java with database

---

❓ What is Connection?

👉 Represents database connection

---

❓ Difference between executeQuery & executeUpdate?

👉 SELECT vs INSERT/UPDATE

---

🎯 Best Practices

---

✔️ Always close connection
✔️ Use PreparedStatement (advanced)
✔️ Handle exceptions
✔️ Validate inputs

---

🏁 Conclusion

Now you can:

• 🔗 Connect Java to MySQL
• ⚙️ Use PowerShell to run programs
• 🧾 Perform CRUD operations
• 🧠 Understand real-world database interaction

---

💡 Final Thought

👉 JDBC is the bridge between Java and databases —
👉 mastering it opens doors to real-world development 🚀

---

🔥 One-Line Summary

👉 “JDBC connects Java to MySQL using drivers, enabling full database operations.”

---

💻 Happy Coding! 😄

You just built your first real database-connected Java program 🔥