JAVA实训第8天

今天是实训的最后一天,今天将学生管理系统的图像界面全部完成了,但注册界面任然存在问题。
添加学生记录
在这里插入图片描述
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.util.List;

public class AddStudentFrame extends JFrame {
    private JPanel panel;
    private JPanel pnlCenter;
    private JPanel pnlRow1;
    private JPanel pnlRow2;
    private JPanel pnlRow3;
    private JPanel pnlRow4;
    private JPanel pnlRow5;
    private JPanel pnlRow6;
    private JPanel pnlRow7;
    private JPanel pnlSouth;

    private JLabel lblId;
    private JLabel lblName;
    private JLabel lblSex;
    private JLabel lblAge;
    private JLabel lblDepartment;
    private JLabel lblClass;
    private JLabel lblTelephone;

    private JTextField txtId;
    private JTextField txtName;
    private JTextField txtSex;
    private JTextField txtAge;
    private JTextField txtDepartment;
    private JTextField txtClass;
    private JTextField txtTelephone;

    private JButton btnExit;
    private JButton btnOK;
    private JButton btnCancel;
    private int currentRow;
    private List<Student> students;

    public AddStudentFrame(String title) {
        super(title);
        initGUI();
    }
    private void initGUI() {
        panel = (JPanel) getContentPane();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        pnlRow1 = new JPanel();
        pnlRow2 = new JPanel();
        pnlRow3 = new JPanel();
        pnlRow4 = new JPanel();
        pnlRow5 = new JPanel();
        pnlRow6 = new JPanel();
        pnlRow7 = new JPanel();

        pnlRow1.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow2.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow3.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow4.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow5.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow6.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow7.setLayout(new FlowLayout(FlowLayout.LEFT));

        lblId = new JLabel("学号:");
        lblName = new JLabel("姓名:");
        lblSex = new JLabel("性别:");
        lblAge = new JLabel("年龄:");
        lblDepartment = new JLabel("系部:");
        lblClass = new JLabel("班级:");
        lblTelephone = new JLabel("电话:");

        txtId = new JTextField(20);
        txtName = new JTextField(20);
        txtSex = new JTextField(20);
        txtAge = new JTextField(20);
        txtDepartment = new JTextField(20);
        txtClass = new JTextField(20);
        txtTelephone = new JTextField(20);
        btnOK = new JButton("确定[O]");
        btnCancel = new JButton("取消[C]");
        btnExit = new JButton("退出[X]");
        btnOK.setMnemonic(KeyEvent.VK_O);
        btnCancel.setMnemonic(KeyEvent.VK_C);
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.setLayout(new BorderLayout());
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlSouth, BorderLayout.SOUTH);
        pnlCenter.setLayout(new GridLayout(7, 1));
        pnlCenter.add(pnlRow1);
        pnlCenter.add(pnlRow2);
        pnlCenter.add(pnlRow3);
        pnlCenter.add(pnlRow4);
        pnlCenter.add(pnlRow5);
        pnlCenter.add(pnlRow6);
        pnlCenter.add(pnlRow7);

        pnlRow1.add(lblId);
        pnlRow1.add(txtId);
        pnlRow2.add(lblName);
        pnlRow2.add(txtName);
        pnlRow3.add(lblSex);
        pnlRow3.add(txtSex);
        pnlRow4.add(lblAge);
        pnlRow4.add(txtAge);
        pnlRow5.add(lblDepartment);
        pnlRow5.add(txtDepartment);
        pnlRow6.add(lblClass);
        pnlRow6.add(txtClass);
        pnlRow7.add(lblTelephone);
        pnlRow7.add(txtTelephone);

        pnlSouth.add(btnOK);
        pnlSouth.add(btnCancel);
        pnlSouth.add(btnExit);

        setSize(500, 300);
        setResizable(false);
        pack();
        setLocationRelativeTo(null);
        setTitle("添加学生记录");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnOK.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (txtId.getText().trim().equals("")) {
                    JOptionPane.showMessageDialog(null, "学号不能为空!", "增加学生记录", JOptionPane.WARNING_MESSAGE);
                    txtId.requestFocus();
                    return;
                }
                if (!isNumber(txtAge.getText().trim())) {
                    JOptionPane.showMessageDialog(null, "注意:年龄全由数字构成!", "增加学生记录", JOptionPane.WARNING_MESSAGE);
                    txtAge.setText("");
                    txtAge.requestFocus();
                    return;
                }
                Student student = new Student();
                student.setId(txtId.getText().trim());
                student.setName(txtName.getText().trim());
                student.setSex(txtSex.getText().trim());
                student.setAge(Integer.parseInt(txtAge.getText()));
                student.setDepartment(txtDepartment.getText().trim());
                student.setClazz(txtClass.getText().trim());
                student.setTelephone(txtTelephone.getText().trim());

                StudentService studentService = new StudentServicelmpl();

                int count = studentService.addStudent(student);
                if (count > 0) {
                    JOptionPane.showMessageDialog(null, "添加记录成功!", "增加学生记录", JOptionPane.INFORMATION_MESSAGE);
                    txtId.setText("");
                    txtName.setText("");
                    txtSex.setText("");
                    txtAge.setText("");
                    txtDepartment.setText("");
                    txtClass.setText("");
                    txtTelephone.setText("");
                    txtId.requestFocus();
                }else {
                    JOptionPane.showMessageDialog(null, "添加记录失败!", "增加学生记录", JOptionPane.ERROR_MESSAGE);
                }
            }
        });
        btnCancel.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                txtId.setText("");
                txtName.setText("");
                txtSex.setText("");
                txtAge.setText("");
                txtDepartment.setText("");
                txtClass.setText("");
                txtTelephone.setText("");
                txtId.requestFocus();
            }
        });
        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                dispose();
            }
        });
        txtId.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    if (!txtId.getText().trim().equals("")) {
                        txtName.requestFocus();
                    }
                }
            }
        });
        txtName.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtSex.requestFocus();
                }
            }
        });
        txtSex.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtAge.requestFocus();
                }
            }
        });
        txtAge.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtDepartment.requestFocus();
                }
            }
        });
        txtDepartment.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtClass.requestFocus();
                }
            }
        });
        txtClass.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtTelephone.requestFocus();
                }
            }
        });
    }
    boolean isNumber(String str) {
        for (int i = 0; i < str.length(); i++) {
            if (str.charAt(i) < '0' || str.charAt(i) > '9') {
                return false;
            }
        }
        return true;
    }
    public static void main(String[] args) {
        new AddStudentFrame("");
    }
}

编辑学生记录
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyAdapter;
import java.awt.event.KeyEvent;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
import java.util.List;

public class EditStudentFrame extends JFrame{
    private JPanel panel;
    private JPanel pnlCenter;
    private JPanel pnlRow1;
    private JPanel pnlRow2;
    private JPanel pnlRow3;
    private JPanel pnlRow4;
    private JPanel pnlRow5;
    private JPanel pnlRow6;
    private JPanel pnlRow7;
    private JPanel pnlSouth;
    private JPanel pnlSouth1;
    private JPanel pnlSouth2;

    private JLabel lblId;
    private JLabel lblName;
    private JLabel lblSex;
    private JLabel lblAge;
    private JLabel lblDepartment;
    private JLabel lblClass;
    private JLabel lblTelephone;

    private JTextField txtId;
    private JTextField txtName;
    private JTextField txtSex;
    private JTextField txtAge;
    private JTextField txtDepartment;
    private JTextField txtClass;
    private JTextField txtTelephone;

    private JButton btnTop;
    private JButton btnPrevious;
    private JButton btnNext;
    private JButton btnBottom;
    private JButton btnExit;
    private JButton btnEdit;
    private JButton btnOK;
    private JButton btnCancel;


    private int currentRow;

    private List<Student>students;

    StudentService studentService;

    public EditStudentFrame(String title) {
        super(title);
        initGUI();
    }
    private void initGUI() {
        panel = (JPanel) getContentPane();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();
        pnlSouth.setLayout(new GridLayout(2, 1));

        pnlRow1 = new JPanel();
        pnlRow2 = new JPanel();
        pnlRow3 = new JPanel();
        pnlRow4 = new JPanel();
        pnlRow5 = new JPanel();
        pnlRow6 = new JPanel();
        pnlRow7 = new JPanel();
        pnlSouth1 = new JPanel();
        pnlSouth2 = new JPanel();

        pnlRow1.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow2.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow3.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow4.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow5.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow6.setLayout(new FlowLayout(FlowLayout.LEFT));
        pnlRow7.setLayout(new FlowLayout(FlowLayout.LEFT));

        lblId = new JLabel("学号:");
        lblName = new JLabel("姓名:");
        lblSex = new JLabel("性别:");
        lblAge = new JLabel("年龄:");
        lblDepartment = new JLabel("系部:");
        lblClass = new JLabel("班级:");
        lblTelephone = new JLabel("电话:");

        txtId = new JTextField(40);
        txtName = new JTextField(40);
        txtSex = new JTextField(40);
        txtAge = new JTextField(40);
        txtDepartment = new JTextField(40);
        txtClass = new JTextField(40);
        txtTelephone = new JTextField(40);
        txtId.setEditable(false);
        txtName.setEditable(false);
        txtSex.setEditable(false);
        txtAge.setEditable(false);
        txtDepartment.setEditable(false);
        txtClass.setEditable(false);
        txtTelephone.setEditable(false);

        btnTop = new JButton("第一条[T]");
        btnPrevious = new JButton("上一条[P]");
        btnNext = new JButton("下一条[N]");
        btnBottom = new JButton("最后一条[B]");
        btnExit = new JButton("退出[X]");
        btnEdit = new JButton("编辑[E]");
        btnOK = new JButton("确定[O]");
        btnCancel = new JButton("取消[C]");
        btnOK.setEnabled(false);
        btnCancel.setEnabled(false);
        btnTop.setMnemonic(KeyEvent.VK_T);
        btnPrevious.setMnemonic(KeyEvent.VK_P);
        btnNext.setMnemonic(KeyEvent.VK_N);
        btnBottom.setMnemonic(KeyEvent.VK_B);
        btnExit.setMnemonic(KeyEvent.VK_X);
        btnEdit.setMnemonic(KeyEvent.VK_E);
        btnOK.setMnemonic(KeyEvent.VK_O);
        btnCancel.setMnemonic(KeyEvent.VK_C);

        panel.setLayout(new BorderLayout());
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlSouth, BorderLayout.SOUTH);
        pnlCenter.setLayout(new GridLayout(7, 1));

        pnlCenter.add(pnlRow1);
        pnlCenter.add(pnlRow2);
        pnlCenter.add(pnlRow3);
        pnlCenter.add(pnlRow4);
        pnlCenter.add(pnlRow5);
        pnlCenter.add(pnlRow6);
        pnlCenter.add(pnlRow7);

        pnlRow1.add(lblId);
        pnlRow1.add(txtId);
        pnlRow2.add(lblName);
        pnlRow2.add(txtName);
        pnlRow3.add(lblSex);
        pnlRow3.add(txtSex);
        pnlRow4.add(lblAge);
        pnlRow4.add(txtAge);
        pnlRow5.add(lblDepartment);
        pnlRow5.add(txtDepartment);
        pnlRow6.add(lblClass);
        pnlRow6.add(txtClass);
        pnlRow7.add(lblTelephone);
        pnlRow7.add(txtTelephone);

        pnlSouth.add(pnlSouth1);
        pnlSouth.add(pnlSouth2);
        pnlSouth1.add(btnTop);
        pnlSouth1.add(btnPrevious);
        pnlSouth1.add(btnNext);
        pnlSouth1.add(btnBottom);
        pnlSouth1.add(btnExit);
        pnlSouth2.add(btnEdit);
        pnlSouth2.add(btnOK);
        pnlSouth2.add(btnCancel);

        setSize(500, 300);
        setResizable(false);
        pack();
        setLocationRelativeTo(null);
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        studentService = new StudentServicelmpl();
        students = studentService.findAllStudents();
        if (students.size() > 0) {
            currentRow = 1;
            setTitle("浏览学生表记录" + " && 当前记录:" + currentRow);
            fillFrameData(currentRow);
        }else {
            JOptionPane.showMessageDialog(null, "表中没有记录!", "浏览学生表记录", JOptionPane.ERROR_MESSAGE);
            btnTop.setEnabled(false);
            btnPrevious.setEnabled(false);
            btnNext.setEnabled(false);
            btnBottom.setEnabled(false);
        }
        btnTop.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                currentRow = 1;
                fillFrameData(currentRow);
            }
        });
        btnPrevious.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (currentRow > 1) {
                    currentRow--;
                    fillFrameData(currentRow);
                } else {
                    JOptionPane.showMessageDialog(null, "已到第一条记录!", "浏览学生表记录", JOptionPane.WARNING_MESSAGE);
                }
            }
        });
        btnNext.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (currentRow < students.size() - 1) {
                    currentRow++;
                    fillFrameData(currentRow);
                } else {
                    JOptionPane.showMessageDialog(null, "已到最后一条记录!", "浏览学生表记录", JOptionPane.WARNING_MESSAGE);
                }
            }
        });
        btnBottom.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                currentRow = students.size() - 1;
                fillFrameData(currentRow);
            }
        });
        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                dispose();
            }
        });
        btnEdit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                setTitle("编辑学生表记录" + " && 当前记录:" + currentRow);
                txtName.setEditable(true);
                txtSex.setEditable(true);
                txtAge.setEditable(true);
                txtDepartment.setEditable(true);
                txtClass.setEditable(true);
                txtTelephone.setEditable(true);
                btnOK.setEnabled(true);
                btnCancel.setEnabled(true);
            }
        });
        btnOK.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                Student student = students.get(currentRow);
                if (isNumber(txtAge.getText())) {
                    if (isLegalTelephone(txtTelephone.getText())) {
                        student.setName(txtName.getText());
                        student.setSex(txtSex.getText());
                        student.setAge(Integer.parseInt(txtAge.getText()));
                        student.setDepartment(txtDepartment.getText());
                        student.setClazz(txtClass.getText());
                        student.setTelephone(txtTelephone.getText());
                        int count = studentService.updateStudent(student);
                        if (count > 0) {
                            JOptionPane.showMessageDialog(null, "更新记录成功!", "编辑学生记录", JOptionPane.INFORMATION_MESSAGE);
                            btnOK.setEnabled(false);
                            btnCancel.setEnabled(false);
                            btnEdit.setEnabled(true);
                            txtName.setEditable(false);
                            txtSex.setEditable(false);
                            txtAge.setEditable(false);
                            txtDepartment.setEditable(false);
                            txtClass.setEditable(false);
                            txtTelephone.setEditable(false);
                            students = studentService.findAllStudents();
                            setTitle("浏览学生表记录" + " && 当前记录:" + currentRow);
                        } else {
                            JOptionPane.showMessageDialog(null, "更新记录失败!", "编辑学生记录", JOptionPane.ERROR_MESSAGE);
                        }
                    } else {
                        JOptionPane.showMessageDialog(null, "非法手机号!", "编辑学生记录", JOptionPane.ERROR_MESSAGE);
                        txtTelephone.selectAll();
                        txtTelephone.requestFocus();
                    }
                } else {
                    JOptionPane.showMessageDialog(null, "年龄必须是数字!", "编辑学生记录", JOptionPane.ERROR_MESSAGE);
                    txtAge.selectAll();
                    txtAge.requestFocus();
                }
            }
        });
        btnCancel.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                btnOK.setEnabled(false);
                btnCancel.setEnabled(false);
                btnEdit.setEnabled(true);
                txtName.setEditable(false);
                txtSex.setEditable(false);
                txtAge.setEditable(false);
                txtDepartment.setEditable(false);
                txtClass.setEditable(false);
                txtTelephone.setEditable(false);
                txtName.setText(students.get(currentRow).getName());
                txtSex.setText(students.get(currentRow).getSex());
                txtAge.setText(students.get(currentRow).getAge() + "");
                txtDepartment.setText(students.get(currentRow).getDepartment());
                txtClass.setText(students.get(currentRow).getClazz());
                txtTelephone.setText(students.get(currentRow).getTelephone());
            }
        });
        txtId.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtName.requestFocus();
                }
            }
        });
        txtName.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtSex.requestFocus();
                }
            }
        });
        txtSex.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtAge.requestFocus();
                }
            }
        });
        txtAge.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtDepartment.requestFocus();
                }
            }
        });
        txtDepartment.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtClass.requestFocus();
                }
            }
        });
        txtClass.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    txtTelephone.requestFocus();
                }
            }
        });
    }
    private void fillFrameData(int currentRow) {
        if (currentRow > 0) {
            setTitle("浏览学生表记录" + " && 当前记录:" + currentRow);
            txtId.setText(students.get(currentRow).getId());
            txtName.setText(students.get(currentRow).getName());
            txtSex.setText(students.get(currentRow).getSex());
            txtAge.setText(students.get(currentRow).getAge() + "");
            txtDepartment.setText(students.get(currentRow).getDepartment());
            txtClass.setText(students.get(currentRow).getClazz());
            txtTelephone.setText(students.get(currentRow).getTelephone());
        }
    }
    private boolean isNumber(String str) {
        for (int i = 0; i < str.length(); i++) {
            if (str.charAt(i) < '0' || str.charAt(i) > '9') {
                return false;
            }
        }
        return true;
    }
    private boolean isLegalTelephone(String telephone) {
        Pattern p = Pattern.compile("^((13[0-9])|(15[^4,\\D])|(18[0-9]))\\d{8}$");
        Matcher m = p.matcher(telephone);
        return m.matches();
    }
    public static void main(String[] args) {
        new EditStudentFrame("");
    }
}

删除学生记录
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.util.Vector;
import java.util.List;

public class DeleteStudentByIdFrame extends JFrame{
    private JLabel lblInputId;
    private JTextField txtId;
    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JPanel pnlNorth;

    private JButton btnQuery;
    private JButton btnBrowseAll;
    private JButton btnDelete;
    private JButton btnExit;
    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private int currentRow;
    private List<Student> students;
    private StudentService studentService;

    public DeleteStudentByIdFrame(String title) {
        super(title);
        intiGUI();
    }
    private void intiGUI() {
        panel = (JPanel) getContentPane();
        pnlNorth = new JPanel();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();
        rows = new Vector();
        colHead = new Vector();

        lblInputId = new JLabel("输入学号:");
        txtId = new JTextField(10);
        txtId.setHorizontalAlignment(JTextField.CENTER);
        btnQuery = new JButton("查询[Q]");
        btnQuery.setMnemonic(KeyEvent.VK_Q);
        btnBrowseAll = new JButton("显示全部记录[A]");
        btnBrowseAll.setMnemonic(KeyEvent.VK_A);
        btnDelete = new JButton("删除查询的记录[D]");
        btnDelete.setEnabled(false);// 删除按钮不可用
        btnDelete.setMnemonic(KeyEvent.VK_D);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlNorth, BorderLayout.NORTH);

        pnlNorth.add(lblInputId);
        pnlNorth.add(txtId);
        pnlNorth.add(btnQuery);
        pnlNorth.add(btnBrowseAll);
        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnDelete);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("查询结果");
        pnlCenter.setBorder(tb);
        studentService = new StudentServicelmpl();
        students = studentService.findAllStudents();
        fillTableData();

        setSize(600, 350);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按学号删除学生记录");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                dispose();
            }
        });
        btnDelete.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (!rows.isEmpty()) {
                    long choice = JOptionPane.showConfirmDialog(null, "是否要删除记录?");
                    if (choice == JOptionPane.OK_OPTION) {
                        String id = txtId.getText().trim();
                        int count = studentService.deleteStudentById(id);
                        if (count > 0) {
                            JOptionPane.showMessageDialog(null, "记录删除成功!", "提示", JOptionPane.INFORMATION_MESSAGE);
                            students = studentService.findAllStudents();
                            txtId.setText("");
                            fillTableData();
                            btnDelete.setEnabled(false);
                        } else {
                            JOptionPane.showMessageDialog(null, "记录删除失败!", "警告", JOptionPane.WARNING_MESSAGE);
                        }
                    }
                }
            }
        });
        btnQuery.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                doQuery();
            }
        });
        btnBrowseAll.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                students = studentService.findAllStudents();
                fillTableData();
                btnDelete.setEnabled(false);
            }
        });
        txtId.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    doQuery();
                }
            }
        });
        table.addMouseListener(new MouseAdapter() {
            public void mouseClicked(MouseEvent e) {
                int row = table.rowAtPoint(e.getPoint());
                table.setRowSelectionInterval(row, row);
                txtId.setText(table.getValueAt(row, 0).toString());
            }
        });
    }
    private void doQuery() {
        String id = txtId.getText().trim();
        if (!id.equals("")) {
            students.clear();
            Student student = studentService.findStudentById(id);
            if (student != null) {
                students.add(student);
                btnDelete.setEnabled(true);
            }
            fillTableData();
        } else {
            JOptionPane.showMessageDialog(this, "请输入待查学生学号!", "警告", JOptionPane.WARNING_MESSAGE);
            txtId.requestFocus();
        }
    }
    private void fillTableData() {
        colHead.clear();
        colHead.add("学号");
        colHead.add("姓名");
        colHead.add("性别");
        colHead.add("年龄");
        colHead.add("系部");
        colHead.add("班级");
        colHead.add("电话");

        rows.clear();
        for (Student student : students) {
            Vector<String> currentRow = new Vector<String>();
            currentRow.addElement(student.getId());
            currentRow.addElement(student.getName());
            currentRow.addElement(student.getSex());
            currentRow.addElement(student.getAge() + "");
            currentRow.addElement(student.getDepartment());
            currentRow.addElement(student.getClazz());
            currentRow.addElement(student.getTelephone());
            rows.add(currentRow);
        }
        table = new JTable(rows, colHead);
        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);

        repaint();

        if (rows.isEmpty()){
            JOptionPane.showMessageDialog(this, "没有符合条件的记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
            txtId.setText("");
        }else {
            scroller.getVerticalScrollBar().setValue(0);
        }
    }
    public static void main(String[] args) {
        new DeleteStudentByIdFrame("");
    }
}

按班级删除
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.util.Vector;
import java.util.List;


public class DeleteStudentsByClassFrame extends JFrame{
    private JLabel lblInputClass;
    private JTextField txtClass;

    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JPanel pnlNorth;

    private JButton btnQuery;
    private JButton btnBrowseAll;
    private JButton btnDelete;
    private JButton btnExit;

    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private int currentRow;
    private List<Student> students;
    private StudentService studentService;

    public DeleteStudentsByClassFrame(String title) {
        super(title);
        intiGUI();
    }
    private void intiGUI() {
        panel = (JPanel) getContentPane();
        pnlNorth = new JPanel();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        rows = new Vector();
        colHead = new Vector();

        lblInputClass = new JLabel("输入班级:");
        txtClass = new JTextField(10);
        txtClass.setHorizontalAlignment(JTextField.CENTER);
        btnQuery = new JButton("查询[Q]");
        btnQuery.setMnemonic(KeyEvent.VK_Q);
        btnBrowseAll = new JButton("显示全部记录[A]");
        btnBrowseAll.setMnemonic(KeyEvent.VK_A);
        btnDelete = new JButton("删除查询的记录[D]");
        btnDelete.setEnabled(false);
        btnDelete.setMnemonic(KeyEvent.VK_D);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlNorth, BorderLayout.NORTH);

        pnlNorth.add(lblInputClass);
        pnlNorth.add(txtClass);
        pnlNorth.add(btnQuery);
        pnlNorth.add(btnBrowseAll);
        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnDelete);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("查询结果");
        pnlCenter.setBorder(tb);
        studentService = new StudentServicelmpl();
        students = studentService.findAllStudents();
        fillTableData();

        setSize(600, 350);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按班级删除学生记录");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                dispose();
            }
        });
        btnDelete.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (!rows.isEmpty()) {
                    long choice = JOptionPane.showConfirmDialog(null, "是否要删除记录?");
                    if (choice == JOptionPane.OK_OPTION) {
                        String clazz = txtClass.getText().trim();
                        int count = studentService.deleteStudentsByClass(clazz);
                        if (count > 0) {
                            JOptionPane.showMessageDialog(null, "记录删除成功!", "提示", JOptionPane.INFORMATION_MESSAGE);
                            students = studentService.findAllStudents();
                            txtClass.setText("");
                            fillTableData();
                            btnDelete.setEnabled(false);
                        } else {
                            JOptionPane.showMessageDialog(null, "记录删除失败!", "警告", JOptionPane.WARNING_MESSAGE);
                        }
                    }
                }
            }
        });
        btnQuery.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                doQuery();
            }
        });
        btnBrowseAll.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                students = studentService.findAllStudents();
                fillTableData();
                btnDelete.setEnabled(false);
            }
        });
        txtClass.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    doQuery();
                }
            }
        });
        table.addMouseListener(new MouseAdapter() {
            public void mouseClicked(MouseEvent e) {
                int row = table.rowAtPoint(e.getPoint());
                table.setRowSelectionInterval(row, row);
                txtClass.setText(table.getValueAt(row, 5).toString());
            }
        });
    }
    private void doQuery() {
        String clazz = txtClass.getText().trim();
        if (!clazz.equals("")) {
            students = studentService.findStudentsByClass(clazz);
            if (students.size() > 0) {
                btnDelete.setEnabled(true);
            }
            fillTableData();
        } else {
            JOptionPane.showMessageDialog(this, "请输入待查班级!", "警告", JOptionPane.WARNING_MESSAGE);
            txtClass.requestFocus();
        }
    }
    private void fillTableData() {
        colHead.clear();
        colHead.add("学号");
        colHead.add("姓名");
        colHead.add("性别");
        colHead.add("年龄");
        colHead.add("系部");
        colHead.add("班级");
        colHead.add("电话");

        rows.clear();
        for (Student student : students) {
            Vector<String> currentRow = new Vector<String>();
            currentRow.addElement(student.getId());
            currentRow.addElement(student.getName());
            currentRow.addElement(student.getSex());
            currentRow.addElement(student.getAge() + "");
            currentRow.addElement(student.getDepartment());
            currentRow.addElement(student.getClazz());
            currentRow.addElement(student.getTelephone());
            rows.add(currentRow);
        }
        table = new JTable(rows, colHead);
        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);
        repaint();

        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有符合条件的记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
            txtClass.setText("");
        } else {
            scroller.getVerticalScrollBar().setValue(0);
        }
    }
    public static void main(String[] args) {
        new DeleteStudentsByClassFrame("");
    }
}

按系部删除

在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.util.Vector;
import java.util.List;

public class DeleteStudentsByDepartmentFrame extends JFrame{
    private JLabel lblInputDepartment;
    private JTextField txtDepartment;

    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JPanel pnlNorth;

    private JButton btnQuery;
    private JButton btnBrowseAll;
    private JButton btnDelete;
    private JButton btnExit;

    private Vector rows;
    private Vector<String> colHead;
    private JTable table;

    private JScrollPane scroller;
    private int currentRow;
    private List<Student> students;
    private StudentService studentService;

    public DeleteStudentsByDepartmentFrame(String title) {
        super(title);
        intiGUI();
    }
    private void intiGUI() {
        panel = (JPanel) getContentPane();
        pnlNorth = new JPanel();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        rows = new Vector();
        colHead = new Vector();

        lblInputDepartment = new JLabel("输入系部:");
        txtDepartment = new JTextField(10);
        txtDepartment.setHorizontalAlignment(JTextField.CENTER);
        btnQuery = new JButton("查询[Q]");
        btnQuery.setMnemonic(KeyEvent.VK_Q);
        btnBrowseAll = new JButton("显示全部记录[A]");
        btnBrowseAll.setMnemonic(KeyEvent.VK_A);
        btnDelete = new JButton("删除查询的记录[D]");
        btnDelete.setEnabled(false);
        btnDelete.setMnemonic(KeyEvent.VK_D);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlNorth, BorderLayout.NORTH);

        pnlNorth.add(lblInputDepartment);
        pnlNorth.add(txtDepartment);
        pnlNorth.add(btnQuery);
        pnlNorth.add(btnBrowseAll);
        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnDelete);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("查询结果");
        pnlCenter.setBorder(tb);

        studentService = new StudentServicelmpl();
        students = studentService.findAllStudents();

        fillTableData();
        setSize(600, 350);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按系部删除学生记录");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                dispose();
            }
        });
        btnDelete.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                if (!rows.isEmpty()) {
                    long choice = JOptionPane.showConfirmDialog(null, "是否要删除记录?");
                    if (choice == JOptionPane.OK_OPTION) {
                        String department = txtDepartment.getText().trim();
                        int count = studentService.deleteStudentsByDepartment(department);
                        if (count > 0) {
                            JOptionPane.showMessageDialog(null, "记录删除成功!", "提示", JOptionPane.INFORMATION_MESSAGE);
                            students = studentService.findAllStudents();
                            txtDepartment.setText("");
                            fillTableData();
                            btnDelete.setEnabled(false);
                        } else {
                            JOptionPane.showMessageDialog(null, "记录删除失败!", "警告", JOptionPane.WARNING_MESSAGE);
                        }
                    }
                }
            }
        });
        btnQuery.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                doQuery();
            }
        });
        btnBrowseAll.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                students = studentService.findAllStudents();
                fillTableData();
                btnDelete.setEnabled(false);
            }
        });
        txtDepartment.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    doQuery();
                }
            }
        });
        table.addMouseListener(new MouseAdapter() {
            public void mouseClicked(MouseEvent e) {
                int row = table.rowAtPoint(e.getPoint());
                table.setRowSelectionInterval(row, row);
                txtDepartment.setText(table.getValueAt(row, 4).toString());
            }
        });
    }
    private void doQuery() {
        String department = txtDepartment.getText().trim();
        if (!department.equals("")) {
            students = studentService.findStudentsByDepartment(department);
            if (students.size() > 0) {
                btnDelete.setEnabled(true);
            }
            fillTableData();
    }else {
            JOptionPane.showMessageDialog(this, "请输入待查系部!", "警告", JOptionPane.WARNING_MESSAGE);
            txtDepartment.requestFocus();
        }
    }
    private void fillTableData() {
        colHead.clear();
        colHead.add("学号");
        colHead.add("姓名");
        colHead.add("性别");
        colHead.add("年龄");
        colHead.add("系部");
        colHead.add("班级");
        colHead.add("电话");

        rows.clear();
        for (Student student : students) {
            Vector<String> currentRow = new Vector<String>();
            currentRow.addElement(student.getId());
            currentRow.addElement(student.getName());
            currentRow.addElement(student.getSex());
            currentRow.addElement(student.getAge() + "");
            currentRow.addElement(student.getDepartment());
            currentRow.addElement(student.getClazz());
            currentRow.addElement(student.getTelephone());
            rows.add(currentRow);
        }
        table = new JTable(rows, colHead);
        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);
        repaint();
        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有符合条件的记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
            txtDepartment.setText("");
        } else {
            scroller.getVerticalScrollBar().setValue(0);
        }
    }
    public static void main(String[] args) {
        new DeleteStudentsByDepartmentFrame("");
    }
}

按学号查询学生窗口
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.awt.print.PrinterException;
import java.util.Vector;
import java.util.List;


public class FindStudentByIdFrame extends JFrame{
    private JLabel lblInputId;
    private JTextField txtId;

    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JPanel pnlNorth;

    private JButton btnQuery;
    private JButton btnBrowseAll;
    private JButton btnPrint;
    private JButton btnExit;
    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private int currentRow;
    private List<Student> students;
    private StudentService studentService;

    public FindStudentByIdFrame(String title) {
        super(title);
        intiGUI();
    }
    private void intiGUI() {
        panel = (JPanel) getContentPane();
        pnlNorth = new JPanel();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();
        rows = new Vector();
        colHead = new Vector();

        lblInputId = new JLabel("输入学号:");
        txtId = new JTextField(10);
        txtId.setHorizontalAlignment(JTextField.CENTER);
        btnQuery = new JButton("查询[Q]");
        btnQuery.setMnemonic(KeyEvent.VK_Q);
        btnBrowseAll = new JButton("显示全部记录[A]");
        btnBrowseAll.setMnemonic(KeyEvent.VK_A);
        btnPrint = new JButton("打印[P]");
        btnPrint.setMnemonic(KeyEvent.VK_D);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlNorth, BorderLayout.NORTH);

        pnlNorth.add(lblInputId);
        pnlNorth.add(txtId);
        pnlNorth.add(btnQuery);
        pnlNorth.add(btnBrowseAll);
        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnPrint);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("查询结果");
        pnlCenter.setBorder(tb);

        studentService = new StudentServicelmpl();
        students = studentService.findAllStudents();
        fillTableData();

        setSize(600, 350);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按学号查询学生记录");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                dispose();
            }
        });
        btnPrint.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                try {
                    table.print();
                } catch (PrinterException e1) {
                    e1.printStackTrace();
                }
            }
        });
        btnQuery.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                doQuery();
            }
        });
        btnBrowseAll.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                students = studentService.findAllStudents();
                fillTableData();
                btnPrint.setEnabled(false);
            }
        });
        txtId.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    doQuery();
                }
            }
        });
        table.addMouseListener(new MouseAdapter() {
            public void mouseClicked(MouseEvent e) {
                int row = table.rowAtPoint(e.getPoint());
                table.setRowSelectionInterval(row, row);
                txtId.setText(table.getValueAt(row, 0).toString());
            }
        });
    }
    private void doQuery() {
        String id = txtId.getText().trim();
        if (!id.equals("")) {
            students.clear();
            Student student = studentService.findStudentById(id);
            if (student != null) {
                students.add(student);
            }
            fillTableData();
        } else {
            JOptionPane.showMessageDialog(this, "请输入待查学生学号!", "警告", JOptionPane.WARNING_MESSAGE);
            txtId.requestFocus();
        }
    }
    private void fillTableData() {
        colHead.clear();
        colHead.add("学号");
        colHead.add("姓名");
        colHead.add("性别");
        colHead.add("年龄");
        colHead.add("系部");
        colHead.add("班级");
        colHead.add("电话");

        rows.clear();
        for (Student student : students) {
            Vector<String> currentRow = new Vector<String>();
            currentRow.addElement(student.getId());
            currentRow.addElement(student.getName());
            currentRow.addElement(student.getSex());
            currentRow.addElement(student.getAge() + "");
            currentRow.addElement(student.getDepartment());
            currentRow.addElement(student.getClazz());
            currentRow.addElement(student.getTelephone());
            rows.add(currentRow);
        }
        table = new JTable(rows, colHead);
        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);
        repaint();
        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有符合条件的记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
            txtId.setText("");
        } else {
            scroller.getVerticalScrollBar().setValue(0);
        }
    }
    public static void main(String[] args) {
        new FindStudentByIdFrame("");
    }
}

按姓名查询学生
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.awt.print.PrinterException;
import java.util.Vector;
import java.util.List;

public class FindStudentsByNameFrame extends JFrame {
    private JLabel lblInputName;

    private JTextField txtName;

    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JPanel pnlNorth;

    private JButton btnQuery;
    private JButton btnBrowseAll;
    private JButton btnPrint;
    private JButton btnExit;


    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private int currentRow;
    private List<Student> students;
    private StudentService studentService;

    public FindStudentsByNameFrame(String title) {
        super(title);
        intiGUI();
    }

    private void intiGUI() {
        panel = (JPanel) getContentPane();
        pnlNorth = new JPanel();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        rows = new Vector();
        colHead = new Vector();

        lblInputName = new JLabel("输入姓名:");
        txtName = new JTextField(10);
        txtName.setHorizontalAlignment(JTextField.CENTER);
        btnQuery = new JButton("查询[Q]");
        btnQuery.setMnemonic(KeyEvent.VK_Q);
        btnBrowseAll = new JButton("显示全部记录[A]");
        btnBrowseAll.setMnemonic(KeyEvent.VK_A);
        btnPrint = new JButton("打印[P]");
        btnPrint.setMnemonic(KeyEvent.VK_D);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlNorth, BorderLayout.NORTH);

        pnlNorth.add(lblInputName);
        pnlNorth.add(txtName);
        pnlNorth.add(btnQuery);
        pnlNorth.add(btnBrowseAll);
        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnPrint);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("查询结果");
        pnlCenter.setBorder(tb);
        studentService = new StudentServicelmpl();
        students = studentService.findAllStudents();
        fillTableData();


        setSize(600, 350);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按姓名查询学生记录");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                dispose();
            }
        });

        btnPrint.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                try {
                    table.print();
                } catch (PrinterException e1) {
                    e1.printStackTrace();
                }
            }
        });

        btnQuery.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                doQuery();
            }
        });

        btnBrowseAll.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                students = studentService.findAllStudents();
                fillTableData();
            }
        });

        txtName.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    doQuery();
                }
            }
        });

        table.addMouseListener(new MouseAdapter() {
            public void mouseClicked(MouseEvent e) {
                int row = table.rowAtPoint(e.getPoint());
                table.setRowSelectionInterval(row, row);
                txtName.setText(table.getValueAt(row, 1).toString());
            }
        });
    }

    private void doQuery() {
        String name = txtName.getText().trim();
        if (!name.equals("")) {
            students = studentService.findStudentsByName(name);
            fillTableData();
        } else {
            JOptionPane.showMessageDialog(this, "请输入待查学生姓名!", "警告", JOptionPane.WARNING_MESSAGE);
            txtName.requestFocus();
        }
    }

    private void fillTableData() {
        colHead.clear();
        colHead.add("姓名");
        colHead.add("姓名");
        colHead.add("性别");
        colHead.add("年龄");
        colHead.add("系部");
        colHead.add("班级");
        colHead.add("电话");

        rows.clear();
        for (Student student : students) {
            Vector<String> currentRow = new Vector<String>();
            currentRow.addElement(student.getId());
            currentRow.addElement(student.getName());
            currentRow.addElement(student.getSex());
            currentRow.addElement(student.getAge() + "");
            currentRow.addElement(student.getDepartment());
            currentRow.addElement(student.getClazz());
            currentRow.addElement(student.getTelephone());
            rows.add(currentRow);
        }

        table = new JTable(rows, colHead);

        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);

        repaint();

        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有符合条件的记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
            txtName.setText("");
        } else {
            scroller.getVerticalScrollBar().setValue(0);
        }
    }


    public static void main(String[] args) {
        new FindStudentsByNameFrame("");
    }
}


按班级查询学生记录
在这里插入图片描述
package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.;
import javax.swing.border.TitledBorder;
import java.awt.
;
import java.awt.event.*;
import java.awt.print.PrinterException;
import java.util.Vector;
import java.util.List;

public class FindStudentsByClassFrame extends JFrame {
private JLabel lblInputClass;
private JTextField txtClass;

private JPanel panel;
private JPanel pnlSouth;
private JPanel pnlCenter;
private JPanel pnlNorth;

private JButton btnQuery;
private JButton btnBrowseAll;
private JButton btnPrint;
private JButton btnExit;
private Vector rows;
private Vector<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;

public FindStudentsByClassFrame(String title) {
    super(title);
    intiGUI();
}

private void intiGUI() {
    panel = (JPanel) getContentPane();
    pnlNorth = new JPanel();
    pnlCenter = new JPanel();
    pnlSouth = new JPanel();

    rows = new Vector();
    colHead = new Vector();

    lblInputClass = new JLabel("输入班级:");
    txtClass = new JTextField(10);
    txtClass.setHorizontalAlignment(JTextField.CENTER);
    btnQuery = new JButton("查询[Q]");
    btnQuery.setMnemonic(KeyEvent.VK_Q);
    btnBrowseAll = new JButton("显示全部记录[A]");
    btnBrowseAll.setMnemonic(KeyEvent.VK_A);
    btnPrint = new JButton("打印[P]");
    btnPrint.setMnemonic(KeyEvent.VK_D);
    btnExit = new JButton("退出[X]");
    btnExit.setMnemonic(KeyEvent.VK_X);

    panel.add(pnlSouth, BorderLayout.SOUTH);
    panel.add(pnlCenter, BorderLayout.CENTER);
    panel.add(pnlNorth, BorderLayout.NORTH);

    pnlNorth.add(lblInputClass);
    pnlNorth.add(txtClass);
    pnlNorth.add(btnQuery);
    pnlNorth.add(btnBrowseAll);
    pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
    pnlSouth.add(btnPrint);
    pnlSouth.add(btnExit);
    pnlCenter.setLayout(new BorderLayout());

    TitledBorder tb = new TitledBorder("查询结果");
    pnlCenter.setBorder(tb);

    studentService = new StudentServicelmpl();
    students = studentService.findAllStudents();
    fillTableData();

    setSize(600, 350);
    setResizable(false);
    setLocationRelativeTo(null);
    setTitle("按班级查询学生记录");
    setVisible(true);
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

    btnExit.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent event) {
            dispose();
        }
    });

    btnPrint.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            try {
                table.print();
            } catch (PrinterException e1) {
                e1.printStackTrace();
            }
        }
    });

    btnQuery.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent event) {
            doQuery();
        }
    });

    btnBrowseAll.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent event) {
            students = studentService.findAllStudents();

            fillTableData();
        }
    });

    txtClass.addKeyListener(new KeyAdapter() {
        @Override
        public void keyPressed(KeyEvent e) {
            if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                doQuery();
            }
        }
    });

    table.addMouseListener(new MouseAdapter() {
        public void mouseClicked(MouseEvent e) {
            int row = table.rowAtPoint(e.getPoint());
            table.setRowSelectionInterval(row, row);
            txtClass.setText(table.getValueAt(row, 5).toString());
        }
    });
}

private void doQuery() {
    String clazz = txtClass.getText().trim();
    if (!clazz.equals("")) {
        students = studentService.findStudentsByClass(clazz);
        fillTableData();
    } else {
        JOptionPane.showMessageDialog(this, "请输入待查班级!", "警告", JOptionPane.WARNING_MESSAGE);
        txtClass.requestFocus();
    }
}

private void fillTableData() {

    colHead.clear();
    colHead.add("班级");
    colHead.add("班级");
    colHead.add("性别");
    colHead.add("年龄");
    colHead.add("系部");
    colHead.add("班级");
    colHead.add("电话");


    rows.clear();
    for (Student student : students) {
        Vector<String> currentRow = new Vector<String>();
        currentRow.addElement(student.getId());
        currentRow.addElement(student.getName());
        currentRow.addElement(student.getSex());
        currentRow.addElement(student.getAge() + "");
        currentRow.addElement(student.getDepartment());
        currentRow.addElement(student.getClazz());
        currentRow.addElement(student.getTelephone());
        rows.add(currentRow);
    }

    table = new JTable(rows, colHead);

    scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
            JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
    pnlCenter.add(scroller, BorderLayout.CENTER);

    repaint();

    if (rows.isEmpty()) {
        JOptionPane.showMessageDialog(this, "没有符合条件的记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
        txtClass.setText("");
    } else {
        scroller.getVerticalScrollBar().setValue(0);
    }
}

public static void main(String[] args) {
    new FindStudentsByClassFrame("");
}

}
按系部查询学生窗口
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.bean.Student;
import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.awt.print.PrinterException;
import java.util.Vector;
import java.util.List;

public class FindStudentsByDepartmentFrame extends JFrame {
    private JLabel lblInputDepartment;
    private JTextField txtDepartment;
    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JPanel pnlNorth;

    private JButton btnQuery;
    private JButton btnBrowseAll;
    private JButton btnPrint;
    private JButton btnExit;
    
    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private int currentRow;
    private List<Student> students;
    private StudentService studentService;

    public FindStudentsByDepartmentFrame(String title) {
        super(title);
        intiGUI();
    }

    private void intiGUI() {
        panel = (JPanel) getContentPane();
        pnlNorth = new JPanel();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        rows = new Vector();
        colHead = new Vector();

        lblInputDepartment = new JLabel("输入系部:");
        txtDepartment = new JTextField(10);
        txtDepartment.setHorizontalAlignment(JTextField.CENTER);
        btnQuery = new JButton("查询[Q]");
        btnQuery.setMnemonic(KeyEvent.VK_Q);
        btnBrowseAll = new JButton("显示全部记录[A]");
        btnBrowseAll.setMnemonic(KeyEvent.VK_A);
        btnPrint = new JButton("打印[P]");
        btnPrint.setMnemonic(KeyEvent.VK_D);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);
        panel.add(pnlNorth, BorderLayout.NORTH);

        pnlNorth.add(lblInputDepartment);
        pnlNorth.add(txtDepartment);
        pnlNorth.add(btnQuery);
        pnlNorth.add(btnBrowseAll);
        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnPrint);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("查询结果");
        pnlCenter.setBorder(tb);

        studentService = new StudentServicelmpl();
        students = studentService.findAllStudents();
        fillTableData();

        setSize(600, 350);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按系部查询学生记录");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                dispose();
            }
        });

        btnPrint.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                try {
                    table.print();
                } catch (PrinterException e1) {
                    e1.printStackTrace();
                }
            }
        });

        btnQuery.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                doQuery();
            }
        });

        btnBrowseAll.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent event) {
                students = studentService.findAllStudents();
                fillTableData();
            }
        });

        txtDepartment.addKeyListener(new KeyAdapter() {
            @Override
            public void keyPressed(KeyEvent e) {
                if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                    doQuery();
                }
            }
        });

        table.addMouseListener(new MouseAdapter() {
            public void mouseClicked(MouseEvent e) {
                int row = table.rowAtPoint(e.getPoint());
                table.setRowSelectionInterval(row, row);
                txtDepartment.setText(table.getValueAt(row, 5).toString());
            }
        });
    }

    private void doQuery() {
        String department = txtDepartment.getText().trim();
        if (!department.equals("")) {
            students = studentService.findStudentsByDepartment(department);
            fillTableData();
        } else {
            JOptionPane.showMessageDialog(this, "请输入待查系部!", "警告", JOptionPane.WARNING_MESSAGE);
            txtDepartment.requestFocus();
        }
    }

    private void fillTableData() {
        colHead.clear();
        colHead.add("系部");
        colHead.add("系部");
        colHead.add("性别");
        colHead.add("年龄");
        colHead.add("系部");
        colHead.add("系部");
        colHead.add("电话");

        rows.clear();
        for (Student student : students) {
            Vector<String> currentRow = new Vector<String>();
            currentRow.addElement(student.getId());
            currentRow.addElement(student.getName());
            currentRow.addElement(student.getSex());
            currentRow.addElement(student.getAge() + "");
            currentRow.addElement(student.getDepartment());
            currentRow.addElement(student.getClazz());
            currentRow.addElement(student.getTelephone());
            rows.add(currentRow);
        }

        table = new JTable(rows, colHead);

        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);

        repaint();

        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有符合条件的记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
            txtDepartment.setText("");
        } else {
            scroller.getVerticalScrollBar().setValue(0);
        }
    }

    public static void main(String[] args) {
        new FindStudentsByDepartmentFrame("");
    }
}

按性别统计人数窗口
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.print.PrinterException;
import java.util.Vector;
import java.util.List;

public class CountStudentsBySexFrame extends JFrame {
    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JButton btnPrint;
    private JButton btnExit;
    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private StudentService studentService;

    public CountStudentsBySexFrame(String title) {
        super(title);
        initGUI();
    }


    private void initGUI() {
        panel = (JPanel) getContentPane();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        rows = new Vector();
        colHead = new Vector();

        btnPrint = new JButton("打印[P]");
        btnPrint.setMnemonic(KeyEvent.VK_P);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);

        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnPrint);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("统计结果");
        pnlCenter.setBorder(tb);

        studentService = new StudentServicelmpl();
        rows = studentService.findRowsBySex();
        colHead.add("性别");
        colHead.add("人数");

        table = new JTable(rows, colHead);
        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);
        repaint();
        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
        }

        // 设置窗口大小
        setSize(300, 200);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按性别统计学生人数");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent arg0) {
                dispose();
            }
        });
        btnPrint.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                try {
                    table.print();
                } catch (PrinterException e1) {
                    e1.printStackTrace();
                }
            }
        });
    }

    public static void main(String[] args) {
        new CountStudentsBySexFrame("");
    }
}

按班级统计人数
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.print.PrinterException;
import java.util.Vector;

public class CountStudentsByClassFrame extends JFrame {
    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;

    private JButton btnPrint;
    private JButton btnExit;

    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private StudentService studentService;

    public CountStudentsByClassFrame(String title) {
        super(title);
        initGUI();
    }

    private void initGUI() {
        panel = (JPanel) getContentPane();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        rows = new Vector();
        colHead = new Vector();

        btnPrint = new JButton("打印[P]");
        btnPrint.setMnemonic(KeyEvent.VK_P);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);

        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnPrint);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("统计结果");
        pnlCenter.setBorder(tb);

        studentService = new StudentServicelmpl();
        rows = studentService.findRowsByClass();
        colHead.add("班级");
        colHead.add("人数");

        table = new JTable(rows, colHead);
        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);

        repaint();

        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
        }

        setSize(300, 200);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按班级统计学生人数");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent arg0) {
                dispose();
            }
        });

        btnPrint.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                try {
                    table.print();
                } catch (PrinterException e1) {
                    e1.printStackTrace();
                }
            }
        });
    }

    public static void main(String[] args) {
        new CountStudentsByClassFrame("");
    }
}

按系部统计人数
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.service.StudentService;
import net.hw.student.service.impl.StudentServicelmpl;

import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.print.PrinterException;
import java.util.Vector;

public class CountStudentsByDepartmentFrame extends JFrame {
    private JPanel panel;
    private JPanel pnlSouth;
    private JPanel pnlCenter;
    private JButton btnPrint;
    private JButton btnExit;
    private Vector rows;
    private Vector<String> colHead;
    private JTable table;
    private JScrollPane scroller;
    private StudentService studentService;

    public CountStudentsByDepartmentFrame(String title) {
        super(title);
        initGUI();
    }

    private void initGUI() {
        panel = (JPanel) getContentPane();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();

        rows = new Vector();
        colHead = new Vector();

        btnPrint = new JButton("打印[P]");
        btnPrint.setMnemonic(KeyEvent.VK_P);
        btnExit = new JButton("退出[X]");
        btnExit.setMnemonic(KeyEvent.VK_X);

        panel.add(pnlSouth, BorderLayout.SOUTH);
        panel.add(pnlCenter, BorderLayout.CENTER);

        pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
        pnlSouth.add(btnPrint);
        pnlSouth.add(btnExit);
        pnlCenter.setLayout(new BorderLayout());

        TitledBorder tb = new TitledBorder("统计结果");
        pnlCenter.setBorder(tb);

        studentService = new StudentServicelmpl();
        rows = studentService.findRowsByDepartment();
        colHead.add("系部");
        colHead.add("人数");

        table = new JTable(rows, colHead);
        scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
                JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        pnlCenter.add(scroller, BorderLayout.CENTER);

        repaint();

        if (rows.isEmpty()) {
            JOptionPane.showMessageDialog(this, "没有记录!", "错误提示", JOptionPane.WARNING_MESSAGE);
        }

        setSize(300, 200);
        setResizable(false);
        setLocationRelativeTo(null);
        setTitle("按班级统计学生人数");
        setVisible(true);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent arg0) {
                dispose();
            }
        });

        btnPrint.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                try {
                    table.print();
                } catch (PrinterException e1) {
                    e1.printStackTrace();
                }
            }
        });
    }

    public static void main(String[] args) {
        new CountStudentsByDepartmentFrame("");
    }
}

设置状态栏信息窗口
在这里插入图片描述

package net.hw.student.gui;

import net.hw.student.app.Application;
import net.hw.student.bean.Status;
import net.hw.student.service.StatusService;
import net.hw.student.service.impl.StatusServicelmpl;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.io.IOException;

public class MainFrame  extends JFrame {
    private JMenuBar mnbMain;
    private JMenu mnuSet;
    private JMenuItem mniSetCollegeInfo;
    private JMenuItem mniSetStatusBar;
    private JMenuItem mniChangePassword;
    private JMenuItem mniExit;

    private JMenu mnuOperate;
    private JMenuItem mniAddStudent;
    private JMenuItem mniBrowseStudent;
    private JMenuItem mniEditStudent;

    private JMenu mnuDelStu;
    private JMenuItem mniDelStudentById;
    private JMenuItem mniDelStudentsByClass;
    private JMenuItem mniDelStudentsByDepartment;

    private JMenu mnuFind;
    private JMenuItem mniFindStudentById;
    private JMenuItem mniFindStudentsByName;
    private JMenuItem mniFindStudentsByClass;
    private JMenuItem mniFindStudentsByDepartment;

    private JMenu mnuCount;
    private JMenuItem mniCountStudentsBySex;
    private JMenuItem mniCountStudentsByClass;
    private JMenuItem mniCountStudentsByDepartment;

    private JMenu mnuHelp;
    private JMenuItem mniHelp;
    private JMenuItem mniAbout;

    private JPanel panel;
    private JPanel  pnlCenter;
    private JPanel  pnlSouth;

    private JLabel lblStatusBar;
    private JLabel lblBackground;

    private ImageIcon imgCollege;
    private ImageIcon imgExit;
    private ImageIcon imgPassword;
    private ImageIcon imgQuery;
    private ImageIcon imgBrowse;
    private ImageIcon imgCount;
    private ImageIcon imgBackground;

    private JToolBar toolbar;

    private JButton btnSetCollege;
    private JButton btnChangePassword;
    private JButton btnFindStudentById;
    private JButton btnExit;
    private JButton btnBrowseStudent;
    private JButton btnCountByDepartment;

    private Status status;
    private StatusService statusService;

    public MainFrame(String title){
        super(title);
        initGUI();
    }
    private void initGUI(){
        mnbMain = new JMenuBar();

        mnuSet = new JMenu("系统设置[S]");
        mnuSet.setMnemonic(KeyEvent.VK_S);
        mniSetCollegeInfo = new JMenuItem("学校信息");
        mniSetStatusBar = new JMenuItem("状态栏信息");
        mniChangePassword = new JMenuItem("修改密码");
        mniExit = new JMenuItem("退出系统");

        mnuOperate = new JMenu("数据操作[O]");
        mnuOperate.setMnemonic(KeyEvent.VK_O);
        mniAddStudent = new JMenuItem("增加学生表记录");
        mnuDelStu = new JMenu("删除学生表记录");
        mniEditStudent = new JMenuItem("编辑学生表记录");
        mniBrowseStudent = new JMenuItem("浏览学生表记录");

        mniDelStudentById = new JMenuItem("按学号删除");
        mniDelStudentsByClass = new JMenuItem("按班级删除");
        mniDelStudentsByDepartment = new JMenuItem("按系部删除");

        mnuFind = new JMenu("查询学生[Q]");
        mnuFind.setMnemonic(KeyEvent.VK_Q);
        mniFindStudentById = new JMenuItem("按学号查询");
        mniFindStudentsByName = new JMenuItem("按姓名查询");
        mniFindStudentsByClass = new JMenuItem("按班级查询");
        mniFindStudentsByDepartment = new JMenuItem("按系部查询");

        mnuCount = new JMenu("人数统计[C]");
        mnuCount.setMnemonic(KeyEvent.VK_C);
        mniCountStudentsBySex = new JMenuItem("按性别统计");
        mniCountStudentsByClass = new JMenuItem("按班级统计");
        mniCountStudentsByDepartment = new JMenuItem("按系部统计");

        mnuHelp = new JMenu("帮助[H]");
        mnuHelp.setMnemonic(KeyEvent.VK_H);
        mniHelp = new JMenuItem("帮助");
        mniAbout = new JMenuItem("关于");

        imgCollege = new ImageIcon("images/college.png");
        imgPassword = new ImageIcon("images/password.png");
        imgQuery = new ImageIcon("images/query.png");
        imgBrowse = new ImageIcon("images/browse.png");
        imgCount = new ImageIcon("images/count.png");
        imgExit = new ImageIcon("images/exit.png");

        toolbar = new JToolBar();
        btnSetCollege = new JButton("设置学校", imgCollege);
        btnSetCollege.setToolTipText("设置学校信息");
        btnSetCollege.setVerticalTextPosition(AbstractButton.BOTTOM);
        btnSetCollege.setHorizontalTextPosition(AbstractButton.CENTER);
        btnChangePassword = new JButton("修改密码", imgPassword);
        btnChangePassword.setToolTipText("修改用户密码");
        btnChangePassword.setVerticalTextPosition(AbstractButton.BOTTOM);
        btnChangePassword.setHorizontalTextPosition(AbstractButton.CENTER);
        btnBrowseStudent = new JButton("浏览学生", imgBrowse);
        btnBrowseStudent.setToolTipText("浏览学生记录");
        btnBrowseStudent.setVerticalTextPosition(AbstractButton.BOTTOM);
        btnBrowseStudent.setHorizontalTextPosition(AbstractButton.CENTER);
        btnFindStudentById = new JButton("查询学生", imgQuery);
        btnFindStudentById.setToolTipText("按学号查询学生记录");
        btnFindStudentById.setVerticalTextPosition(AbstractButton.BOTTOM);
        btnFindStudentById.setHorizontalTextPosition(AbstractButton.CENTER);
        btnCountByDepartment = new JButton("统计人数", imgCount);
        btnCountByDepartment.setToolTipText("按系部统计学生人数");
        btnCountByDepartment.setVerticalTextPosition(AbstractButton.BOTTOM);
        btnCountByDepartment.setHorizontalTextPosition(AbstractButton.CENTER);
        btnExit = new JButton("退出系统", imgExit);
        btnExit.setToolTipText("退出系统");
        btnExit.setVerticalTextPosition(AbstractButton.BOTTOM);
        btnExit.setHorizontalTextPosition(AbstractButton.CENTER);
        toolbar.add(btnSetCollege);
        toolbar.add(btnChangePassword);
        toolbar.add(btnBrowseStudent);
        toolbar.add(btnFindStudentById);
        toolbar.add(btnCountByDepartment);
        toolbar.add(btnExit);

        panel = (JPanel) getContentPane();
        pnlCenter = new JPanel();
        pnlSouth = new JPanel();
        pnlSouth.setLayout(new FlowLayout(FlowLayout.LEFT));

        imgBackground = new ImageIcon("images/background.jpg");
        lblBackground = new JLabel(imgBackground);
        lblStatusBar = new JLabel();

        setJMenuBar(mnbMain);
        mnbMain.add(mnuSet);
        mnuSet.add(mniSetCollegeInfo);
        mnuSet.add(mniSetStatusBar);
        mnuSet.add(mniChangePassword);
        mnuSet.addSeparator();
        mnuSet.add(mniExit);

        mnuDelStu.add(mniDelStudentById);
        mnuDelStu.add(mniDelStudentsByClass);
        mnuDelStu.add(mniDelStudentsByDepartment);

        mnbMain.add(mnuOperate);
        mnuOperate.add(mniAddStudent);
        mnuOperate.add(mniEditStudent);
        mnuOperate.add(mnuDelStu);
        mnuOperate.add(mniBrowseStudent);

        mnbMain.add(mnuFind);
        mnuFind.add(mniFindStudentById);
        mnuFind.add(mniFindStudentsByName);
        mnuFind.add(mniFindStudentsByClass);
        mnuFind.add(mniFindStudentsByDepartment);

        mnbMain.add(mnuCount);
        mnuCount.add(mniCountStudentsBySex);
        mnuCount.add(mniCountStudentsByClass);
        mnuCount.add(mniCountStudentsByDepartment);

        mnbMain.add(mnuHelp);
        mnuHelp.add(mniHelp);
        mnuHelp.add(mniAbout);

        panel.setLayout(new BorderLayout());
        panel.add(toolbar, "North");
        panel.add(pnlCenter, "Center");
        panel.add(pnlSouth, "South");
        pnlCenter.add(lblBackground);
        pnlSouth.add(lblStatusBar);

        if (!Application.username.equals("admin")) {
            mniSetStatusBar.setEnabled(false);
            mniAddStudent.setEnabled(false);
            mnuDelStu.setEnabled(false);
            mniEditStudent.setEnabled(false);
        }
        setStatusBar();

        statusService = new StatusServicelmpl();
        status = statusService.findStatusById(1);

        setSize(800, 640);
        setVisible(true);
        setLocationRelativeTo(null);
        setTitle("学生信息管理系统" + status.getVersion());

        addWindowListener(new WindowAdapter() {
            @Override
            public void windowClosing(WindowEvent e) {
                exitSystem();
            }
        });

        mniSetCollegeInfo.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new SetCollegeInfoFrame("");
            }
        });

        mniSetStatusBar.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new SetStatusBarFrame("");
            }
        });

        mniChangePassword.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new ChangPasswordFrame("");
            }
        });

        mniExit.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                exitSystem();
            }
        });

        mniFindStudentById.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new FindStudentByIdFrame("");
            }
        });

        mniFindStudentsByName.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new FindStudentsByNameFrame("");
            }
        });

        mniFindStudentsByClass.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new FindStudentsByClassFrame("");
            }
        });

        mniFindStudentsByDepartment.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new FindStudentsByDepartmentFrame("");
            }
        });

        mniCountStudentsBySex.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new CountStudentsBySexFrame("");
            }
        });

        mniCountStudentsByClass.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new CountStudentsByClassFrame("");
            }
        });

        mniCountStudentsByDepartment.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new CountStudentsByDepartmentFrame("");
            }
        });

        mniAddStudent.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                new AddStudentFrame("");
            }
        });

        mniDelStudentById.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new DeleteStudentByIdFrame("");
            }
        });

        mniDelStudentsByClass.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new DeleteStudentsByClassFrame("");
            }
        });

        mniDelStudentsByDepartment.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new DeleteStudentsByDepartmentFrame("");
            }
        });

        mniEditStudent.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                new EditStudentFrame("");
            }
        });

        mniBrowseStudent.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                new BrowseStudentsFrame("");
            }
        });

        mniHelp.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                try {
                    Runtime.getRuntime().exec("cmd /c start help/帮助文档.chm");
                } catch (IOException e1) {
                    JOptionPane.showMessageDialog(null, e1.getMessage(), "学生信息管理系统", JOptionPane.ERROR_MESSAGE);
                }
            }
        });

        mniAbout.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                JOptionPane.showMessageDialog(null,
                        "开发人员:" + status.getCollege() + "_" + status.getAuthor() + "\n联系电话:" + status.getTelephone()
                                + "\n电子邮箱:" + status.getEmils(),
                        "学生信息管理系统" + status.getVersion(), JOptionPane.INFORMATION_MESSAGE);
            }
        });

        btnSetCollege.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new SetCollegeInfoFrame("");
            }
        });

        btnChangePassword.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new ChangPasswordFrame("");
            }
        });

        btnBrowseStudent.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new BrowseStudentsFrame("");
            }
        });

        btnFindStudentById.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new FindStudentByIdFrame("");
            }
        });

        btnCountByDepartment.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                new CountStudentsByDepartmentFrame("");
            }
        });

        btnExit.addActionListener(new ActionListener() {
            @Override
            public void actionPerformed(ActionEvent e) {
                exitSystem();
            }
        });
    }
    private void exitSystem() {
        int choice = JOptionPane.showConfirmDialog(this,
                "您是否要退出系统?","学生信息管理系统", JOptionPane.YES_NO_OPTION);
        if (choice == JOptionPane.YES_OPTION) {
            System.exit(0);
        }else {
            dispose();
            Application.mainFrame = new MainFrame("学生信息管理系统" + status.getVersion());

        }
    }
    public void setStatusBar() {
        statusService = new StatusServicelmpl();
        status = statusService.findStatusById(1);
        lblStatusBar.setText(
                status.getCollege() + "学生信息管理系统" + status.getVersion() + "      作者:" + status.getAuthor() + "      地址:"
                        + status.getAddress() + "      电话:" + status.getTelephone() + "      邮箱:" + status.getEmils());
    }

    public static void main(String[]args){
        Application.mainFrame = new MainFrame("");
    }
}

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值