import [Link].
*;
import [Link].*;
import [Link];
import [Link];
import [Link].*;
public class StudentManagementGUI extends JFrame {
private JTextField rollField, nameField, marksField;
private JTextArea resultArea;
private final String DB_URL = "jdbc:mysql://localhost:3306/student";
private final String DB_USER = "root";
private final String DB_PASSWORD = "";
public StudentManagementGUI() {
setLayout(new BorderLayout());
// Input Panel
JPanel inputPanel = new JPanel(new GridLayout(4, 2));
[Link](new JLabel("Roll Number:"));
rollField = new JTextField();
[Link](rollField);
[Link](new JLabel("Name:"));
nameField = new JTextField();
[Link](nameField);
[Link](new JLabel("Marks:"));
marksField = new JTextField();
[Link](marksField);
JButton addButton = new JButton("Add");
JButton retrieveButton = new JButton("Retrieve");
[Link](addButton);
[Link](retrieveButton);
// Result Area
resultArea = new JTextArea(8, 30);
[Link](false);
add(inputPanel, [Link]);
add(new JScrollPane(resultArea), [Link]);
// Add Action Listeners
[Link](e -> addStudent());
[Link](e -> retrieveStudents());
// Frame Settings
setTitle("Student Management");
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
pack();
setVisible(true);
}
private void addStudent() {
try (Connection conn = [Link](DB_URL, DB_USER,
DB_PASSWORD)) {
String query = "INSERT INTO students (roll_number, name, marks) VALUES
(?, ?, ?)";
PreparedStatement pstmt = [Link](query);
[Link](1, [Link]([Link]()));
[Link](2, [Link]());
[Link](3, [Link]([Link]()));
[Link]();
// Clear fields after adding
[Link]("");
[Link]("");
[Link]("");
} catch (Exception ex) {
[Link]("Error: " + [Link]());
}
}
private void retrieveStudents() {
try (Connection conn = [Link](DB_URL, DB_USER,
DB_PASSWORD);
Statement stmt = [Link]();
ResultSet rs = [Link]("SELECT * FROM students")) {
// Using StringBuilder for efficient string manipulation
StringBuilder result = new StringBuilder("Roll Number\tName\tMarks\n");
while ([Link]()) {
[Link]([Link]("roll_number")).append("\t\t")
.append([Link]("name")).append("\t\t")
.append([Link]("marks")).append("\n");
}
[Link]([Link]());
} catch (Exception ex) {
[Link]("Error: " + [Link]());
}
}
public static void main(String[] args) {
try {
[Link]("[Link]");
} catch (ClassNotFoundException e) {
[Link]("MySQL Driver not found.");
}
[Link](StudentManagementGUI::new);
}
}
