gui 3

CREATE DATABASE college;

USE college;

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

INSERT INTO student VALUES
(1, 'Rahul', 'CSE'),
(2, 'Sneha', 'IT'),
(3, 'Aman', 'ECE');

import java.sql.*;

public class StudentRetrieve {

public static void main(String[] args) {

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

        // Connect to Database
        Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/college",
                "root",
                "password");

        // SQL Query
        String query = "SELECT * FROM student";

        Statement st = con.createStatement();

        ResultSet rs = st.executeQuery(query);

        // Display Data
        System.out.println("ID\tName\tCourse");

        while (rs.next()) {

            int id = rs.getInt("id");
            String name = rs.getString("name");
            String course = rs.getString("course");

            System.out.println(id + "\t" + name + "\t" + course);
        }

        // Close Connection
        con.close();

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

}

---

CREATE TABLE marks (
id INT,
subject VARCHAR(50),
marks INT
);

INSERT INTO marks VALUES
(1, 'Java', 85),
(2, 'DBMS', 90),
(3, 'Python', 80);

import java.sql.*;

public class JoinDemo {

public static void main(String[] args) {

    try {

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

        // Connect Database
        Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/college",
                "root",
                "password");

        // JOIN Query
        String query = "SELECT student.id, student.name, marks.subject, marks.marks " +
                       "FROM student INNER JOIN marks " +
                       "ON student.id = marks.id";

        Statement st = con.createStatement();

        ResultSet rs = st.executeQuery(query);

        System.out.println("ID\tName\tSubject\tMarks");

        while (rs.next()) {

            int id = rs.getInt("id");
            String name = rs.getString("name");
            String subject = rs.getString("subject");
            int marks = rs.getInt("marks");

            System.out.println(id + "\t" + name + "\t" + subject + "\t" + marks);
        }

        con.close();

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

}

---

import javax.swing.;
import javax.swing.table.DefaultTableModel;
import java.sql.;

public class JTableDatabaseDemo {

public static void main(String[] args) {

    JFrame frame = new JFrame("Student Records");

    String[] columnNames = {"ID", "Name", "Course"};

    DefaultTableModel model = new DefaultTableModel(columnNames, 0);

    JTable table = new JTable(model);

    JScrollPane pane = new JScrollPane(table);

    frame.add(pane);

    frame.setSize(400, 300);
    frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    frame.setVisible(true);

    try {

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

        // Connect Database
        Connection con = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/college",
                "root",
                "password");

        // Query
        String query = "SELECT * FROM student";

        Statement st = con.createStatement();

        ResultSet rs = st.executeQuery(query);

        // Add rows into JTable
        while (rs.next()) {

            int id = rs.getInt("id");
            String name = rs.getString("name");
            String course = rs.getString("course");

            model.addRow(new Object[]{id, name, course});
        }

        con.close();

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

}

----------------------import java.sql.*;

public class InsertStudent {

public static void main(String[] args) {

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

        // Connect to Database
        Connection con = DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/college",
            "root",
            "password"
        );

        // SQL Insert Query
        String query = "INSERT INTO student VALUES (?, ?, ?)";

        // Create PreparedStatement
        PreparedStatement pst = con.prepareStatement(query);

        // Set values
        pst.setInt(1, 1);
        pst.setString(2, "Sudarshan");
        pst.setString(3, "CSE");

        // Execute Query
        pst.executeUpdate();

        System.out.println("Student inserted successfully!");

        // Close connection
        con.close();

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

}

---

import java.sql.*;

public class UpdateStudent {

public static void main(String[] args) {

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

        // Connect to Database
        Connection con = DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/college",
            "root",
            "password"
        );

        // SQL Update Query
        String query = "UPDATE student SET name=? WHERE id=?";

        // Create PreparedStatement
        PreparedStatement pst = con.prepareStatement(query);

        // Set new values
        pst.setString(1, "Rahul");
        pst.setInt(2, 1);

        // Execute Update
        pst.executeUpdate();

        System.out.println("Student record updated!");

        // Close connection
        con.close();

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

}

---

import java.sql.*;

public class DeleteStudent {

public static void main(String[] args) {

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

        // Connect to Database
        Connection con = DriverManager.getConnection(
            "jdbc:mysql://localhost:3306/college",
            "root",
            "password"
        );

        // SQL Delete Query
        String query = "DELETE FROM student WHERE id=?";

        // Create PreparedStatement
        PreparedStatement pst = con.prepareStatement(query);

        // Set id to delete
        pst.setInt(1, 1);

        // Execute Delete
        pst.executeUpdate();

        System.out.println("Student record deleted!");

        // Close connection
        con.close();

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

}

CREATE DATABASE college;

USE college;

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