基于JAVA+JDBC+swing+mysql+IDEA实现学生信息管理系统

package ui; import javax.swing.*; import javax.swing.table.DefaultTableModel; import java.awt.*; import dao.DBOper; public class StudentManagementUI extends JFrame { private JTable table; private JTextField txtId, txtName, txtAge, txtGender, searchMsg; private JButton btnAdd, btnUpdate, btnDelete, btnIncreaseAge, btnDecreaseAge, btnSearchById, btnSearchByGender, returnButton, addButton, modifyButton; private DBOper dbOper; private DefaultTableModel tableModel; private JPopupMenu popupMenu; public StudentManagementUI() { dbOper = new DBOper(); setTitle("学生管理系统"); setLayout(new BorderLayout(5, 5)); // 表格初始化 String[] columnNames = {"ID", "姓名", "年龄", "性别"}; tableModel = new DefaultTableModel(columnNames, 0); // 从数据库获取学生信息并添加到表格中 Object[][] students = dbOper.getAllStudents(); for (Object[] student : students) { tableModel.addRow(student); } table = new JTable(tableModel); add(new JScrollPane(table), BorderLayout.CENTER); // 创建右键菜单 popupMenu = new JPopupMenu(); JMenuItem deleteMenuItem = new JMenuItem("删除"); popupMenu.add(deleteMenuItem); // 将右键菜单添加到表格中 table.setComponentPopupMenu(popupMenu); // 控制面板用于添加、更新和删除操作 JPanel controlPanel = new JPanel(new FlowLayout()); txtId = new JTextField(10); txtName = new JTextField(10); txtAge = new JTextField(10); txtGender = new JTextField(10); btnAdd = new JButton("添加"); btnUpdate = new JButton("更新"); btnDelete = new JButton("删除"); controlPanel.add(new JLabel("ID")); controlPanel.add(txtId); controlPanel.add(new JLabel("Name")); controlPanel.add(txtName); controlPanel.add(new JLabel("Age")); controlPanel.add(txtAge); controlPanel.add(new JLabel("Gender")); controlPanel.add(txtGender); controlPanel.add(btnAdd); controlPanel.add(btnUpdate); controlPanel.add(btnDelete); add(controlPanel, BorderLayout.SOUTH); JPanel searchPanel = new JPanel(new FlowLayout()); searchMsg = new JTextField(10); returnButton = new JButton("返回"); btnSearchById = new JButton("按id查询"); btnSearchByGender = new JButton("按性别查询"); searchPanel.add(btnSearchById); searchPanel.add(btnSearchByGender); searchPanel.add(searchMsg); searchPanel.add(returnButton); // addButton = new JButton("新增"); // searchPanel.add(addButton); controlPanel.add(new JLabel("searchMsg")); add(searchPanel, BorderLayout.NORTH); // addButton = new JButton("新增"); // add(addButton, BorderLayout.CENTER); JPanel buttonPanel = new JPanel(new FlowLayout()); addButton = new JButton("新增"); modifyButton = new JButton("修改"); btnIncreaseAge = new JButton("增加年龄"); btnDecreaseAge = new JButton("减少年龄"); buttonPanel.add(addButton); buttonPanel.add(modifyButton); buttonPanel.add(btnIncreaseAge); buttonPanel.add(btnDecreaseAge); add(buttonPanel, BorderLayout.SOUTH); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); pack(); setVisible(true); // 添加按钮功能实现 deleteMenuItem.addActionListener(e -> deleteSelectedRow()); btnIncreaseAge.addActionListener(e -> changeAddAge('+')); btnDecreaseAge.addActionListener(e -> changeAddAge('-')); btnSearchById.addActionListener(e -> searchById()); btnSearchByGender.addActionListener(e -> searchByGender()); returnButton.addActionListener(e -> returnToMain()); addButton.addActionListener(e -> returnToAdd()); modifyButton.addActionListener(e -> modifyInput()); } void returnToMain(){ searchMsg.setText(""); Object[][] students = dbOper.getAllStudents(); tableModel.setRowCount(0); // 将查询结果更新到表格中 for (Object[] student : students) { tableModel.addRow(student); } } private void deleteSelectedRow() { int selectedRow = table.getSelectedRow(); System.out.println("getid"+selectedRow); if (selectedRow >= 0) { int id = (int) tableModel.getValueAt(selectedRow, 0); // 获取选中行的ID dbOper.deleteStudent(id); returnToMain(); } } private void changeAddAge(char c) { int selectedRow = table.getSelectedRow(); System.out.println("getid"+selectedRow); if (selectedRow >= 0) { int id = (int) tableModel.getValueAt(selectedRow, 0); // 获取选中行的ID Object[][] students = dbOper.searchById(id); new changeAgeUI(this,students[0],c); returnToMain(); }else { System.out.println("没选择！！！！！！！！"); JOptionPane.showMessageDialog(null, "请在表格中选择需要修改年龄的学生!", "错误", JOptionPane.ERROR_MESSAGE); } } private void returnToAdd(){ new addStudentUI(this); // new addStudentUI(); } private void modifyInput() { if(searchMsg.getText().isEmpty()){ JOptionPane.showMessageDialog(null, "输入框不能为空!", "错误", JOptionPane.ERROR_MESSAGE); } else{ if(searchMsg.getText().matches("\\d+")){ int id = Integer.parseInt(searchMsg.getText()); System.out.println("点击修改按钮了！！！"); Object[][] students = dbOper.searchById(id); if(students.length == 0) { System.out.println("学号不存在！！！！！！"); JOptionPane.showMessageDialog(null, "当前查询学号不存在!", "错误", JOptionPane.ERROR_MESSAGE); searchMsg.setText(""); } else { System.out.println("主界面的modifyInput "+students[0][0]); new modifyStudentUI(this, students[0]); // 注意这里传递的是单个学生数据 } } else { JOptionPane.showMessageDialog(null, "输入错误!", "错误", JOptionPane.ERROR_MESSAGE); searchMsg.setText(""); } } } private void searchById() { if(searchMsg.getText().isEmpty()){ JOptionPane.showMessageDialog(null, "查询信息不能为空!", "错误", JOptionPane.ERROR_MESSAGE); searchMsg.setText(""); } else if (searchMsg.getText().matches("\\d+")){ int id = Integer.parseInt(searchMsg.getText()); Object[][] students = dbOper.searchById(id); if (students.length == 0 || students[0].length == 0 || students[0][0].toString().isEmpty()){ JOptionPane.showMessageDialog(null, "当前查询学号不存在!", "错误", JOptionPane.ERROR_MESSAGE); searchMsg.setText(""); } else{ // 清空表格数据 tableModel.setRowCount(0); // 将查询结果更新到表格中 for (Object[] student : students) { tableModel.addRow(student); } searchMsg.setText(""); } } else{ JOptionPane.showMessageDialog(null, "输入错误!", "错误", JOptionPane.ERROR_MESSAGE); sea