import java.sql.*;

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

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

            // Database Connection
            Connection con = DriverManager.getConnection(url, user, password);

            // Create Statement
            Statement stmt = con.createStatement();

            // Create Table
            stmt.executeUpdate(
                "CREATE TABLE IF NOT EXISTS student(" +
                "id INT, name VARCHAR(50), marks INT)"
            );

            // Insert Values
            stmt.executeUpdate(
                "INSERT INTO student VALUES(1, 'Rahul', 85)"
            );
            System.out.println("Data Inserted Successfully");

            // Read (BREO) Values
            System.out.println("\nRetrieving Data from Table:");
            ResultSet rs = stmt.executeQuery("SELECT * FROM student");
            while (rs.next()) {
                System.out.println("ID: " + rs.getInt("id") + 
                                   ", Name: " + rs.getString("name") + 
                                   ", Marks: " + rs.getInt("marks"));
            }

            // Close Connection
            con.close();

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