JDBC.java

import java.sql.*;
public class JDBC {
 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()) {

 // Insert data
 String insertQuery = "INSERT INTO students (id, name, age) VALUES (1, 'John', 20)";
 stmt.executeUpdate(insertQuery);

 // Retrieve data
 String selectQuery = "SELECT * FROM students";
 ResultSet rs = stmt.executeQuery(selectQuery);
 while (rs.next()) {
 System.out.println("ID: " + rs.getInt("id") + ", Name: " + rs.getString("name") + ", Age: " + rs.getInt("age"));
 }
 } catch (SQLException e) {
 e.printStackTrace();
 }
 }
}