StudentViewGUI.java

import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class StudentViewGUI {
    public static void main(String[] args) {
        Frame frame = new Frame("View Students");
        frame.setSize(600, 400);
        frame.setLayout(new BorderLayout());

        // Close operation
        frame.addWindowListener(new WindowAdapter() {
            public void windowClosing(WindowEvent e) {
                frame.dispose();
            }
        });

        // Use a TextArea for multi-line text display (read-only)
        TextArea textArea = new TextArea();
        textArea.setEditable(false);
        textArea.setFont(new Font("Monospaced", Font.PLAIN, 12));

        // Header for columns - fixed width formatting
        String header = String.format("%-6s %-20s %-30s %-15s%n", "ID", "Name", "Email", "Course");
        textArea.append(header);
        textArea.append("-------------------------------------------------------------\n");

        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection(
                "jdbc:mysql://localhost:3306/studentsdb?useSSL=false&serverTimezone=UTC",
                "root", ""
            );

            Statement stmt = conn.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT * FROM students");

            while (rs.next()) {
                String row = String.format("%-6d %-20s %-30s %-15s%n",
                    rs.getInt("id"),
                    rs.getString("name"),
                    rs.getString("email"),
                    rs.getString("course"));
                textArea.append(row);
            }

            conn.close();
        } catch (Exception e) {
            e.printStackTrace();
            // Show an AWT dialog on error
            Dialog errorDialog = new Dialog(frame, "Error", true);
            errorDialog.setLayout(new FlowLayout());
            Label msg = new Label("Error loading student data.");
            Button ok = new Button("OK");
            ok.addActionListener(ev -> errorDialog.dispose());
            errorDialog.add(msg);
            errorDialog.add(ok);
            errorDialog.setSize(300, 100);
            errorDialog.setLocationRelativeTo(frame);
            errorDialog.setVisible(true);
        }

        frame.add(textArea, BorderLayout.CENTER);
        frame.setVisible(true);
    }
}