JDBC ( Java Database Ki Baat cheat ) = Java Database Connectivity

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

public class App {

public static void main(String[] args) throws Exception {

System.out.println("JDBC, Connecting.........!");

try {

// 1. Load Driver

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

// 2. Create Connection

String url = "jdbc:mysql://localhost:3306/codingwallah";

String user = "root";

String pass = "BangBang@1234";

Connection con = DriverManager.getConnection(url, user, pass);

// 3. Create Statement

Statement stmt = con.createStatement();

// 4. Execute Query

String query = "SELECT * FROM students";

ResultSet rs = stmt.executeQuery(query);

// 5. Process Result

while (rs.next()) {

int id = rs.getInt("id");

String name = rs.getString("name");

System.out.println(id + " " + name);

}

// 6. Close Connection

con.close();

}

catch (Exception e) {

e.printStackTrace();

}

Latest Post