2019.7.2实训总结

（1）设置学校信息窗口SetCollegeInfoFrame
package net.lyq.student.gui;

import net.lyq.student.bean.College;
import net.lyq.student.service.CollegeService;
import net.lyq.student.service.impl.CollegeServiceImpl;

import javax.swing.;
import java.awt.;
import java.awt.event.*;
import java.sql.Timestamp;
import java.text.ParseException;
import java.text.SimpleDateFormat;

/**

• 功能：设置学校信息

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  public class SetCollegeInfoFrame extends JFrame {
  /*

  • 面板
    /
    JPanel panel;
    JPanel pnlNorth;
    JPanel panel1;
    JPanel panel2;
    JPanel panel3;
    JPanel panel4;
    JPanel panel5;
    JPanel pnlCenter;
    JPanel pnlSouth;
    /*
  • 标签
    /
    JLabel lblName;
    JLabel lblPresident;
    JLabel lblStartTime;
    JLabel lblTelephone;
    JLabel lblEmail;
    JLabel lblAddress;
    JLabel lblProfile;
    /*
  • 按钮
    /
    JButton btnSave;
    JButton btnExit;
    /*
  • 文本框与文本区
    /
    JTextField txtName;
    JTextField txtPresident;
    JTextField txtStartTime;
    JTextField txtTelephone;
    JTextField txtEMail;
    JTextField txtAddress;
    JTextArea txtProfile;
    /*
  • 滚动面板
    /
    JScrollPane scrollPane;
    /*
  • 学校服务
    */
    private CollegeService collegeService;
    private College college;
    private int id = 1;

  /**

  • 构造方法
  • @param title
    */
    public SetCollegeInfoFrame(String title) {
    super(title);
    initGUI();
    }

  /**

  • 初始化用户界面
    */
    private void initGUI() {
    // 创建组件（面板与控件）
    panel = (JPanel) getContentPane();
    pnlNorth = new JPanel();
    panel1 = new JPanel();
    panel2 = new JPanel();
    panel3 = new JPanel();
    panel4 = new JPanel();
    panel5 = new JPanel();
    pnlCenter = new JPanel();
    pnlSouth = new JPanel();

    lblName = new JLabel(“学校名称：”);
    lblPresident = new JLabel(“校 长：”);
    lblStartTime = new JLabel(“建校时间：”);
    lblTelephone = new JLabel(“联系电话：”);
    lblEmail = new JLabel(“电子邮箱：”);
    lblAddress = new JLabel(“通讯地址：”);
    lblProfile = new JLabel(“学校简介：”);

    txtName = new JTextField(30);
    txtPresident = new JTextField(11);
    txtStartTime = new JTextField(12);
    txtTelephone = new JTextField(11);
    txtEMail = new JTextField(12);
    txtAddress = new JTextField(30);
    txtProfile = new JTextArea(5, 37);
    txtProfile.setLineWrap(true);// 让文本区自动换行
    scrollPane = new JScrollPane(txtProfile, ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED,
    ScrollPaneConstants.HORIZONTAL_SCROLLBAR_NEVER);
    btnSave = new JButton(“保存[S]”);
    btnSave.setMnemonic(KeyEvent.VK_S);
    btnExit = new JButton(“退出[X]”);
    btnExit.setMnemonic(KeyEvent.VK_X);

    // 设置大面板布局，将北面板、中面板与南面板添加到大面板
    panel.setLayout(new BorderLayout());
    panel.add(pnlNorth, “North”);
    panel.add(pnlCenter, “Center”);
    panel.add(pnlSouth, “South”);

    // 设置北面板布局，添加五个小面板
    pnlNorth.setLayout(new GridLayout(5, 1));
    pnlNorth.add(panel1);
    pnlNorth.add(panel2);
    pnlNorth.add(panel3);
    pnlNorth.add(panel4);
    pnlNorth.add(panel5);

    // 将控件依次添加到五个小面板
    panel1.add(lblName);
    panel1.add(txtName);
    panel2.add(lblPresident);
    panel2.add(txtPresident);
    panel2.add(lblStartTime);
    panel2.add(txtStartTime);
    panel3.add(lblTelephone);
    panel3.add(txtTelephone);
    panel3.add(lblEmail);
    panel3.add(txtEMail);
    panel4.add(lblAddress);
    panel4.add(txtAddress);
    panel5.add(lblProfile);

    // 将滚动面板添加到中面板
    pnlCenter.add(scrollPane);

    // 将两个按钮添加到南面板
    pnlSouth.add(btnSave);
    pnlSouth.add(btnExit);

    // 创建学校服务对象
    collegeService = new CollegeServiceImpl();
    // 获取学校对象
    college = collegeService.findCollegeById(id);
    // 利用学校对象属性值设置相应控件的内容
    txtName.setText(college.getName());
    txtPresident.setText(college.getPresident());
    txtStartTime.setText(college.getStartTime().toString());
    txtTelephone.setText(college.getTelephone());
    txtEMail.setText(college.getEmail());
    txtAddress.setText(college.getAddress());
    txtProfile.setText(college.getProfile());

    // 设置窗口大小
    setSize(450, 350);
    // 设置窗口屏幕居中
    setLocationRelativeTo(null);
    // 设置窗口不可调整大小
    setResizable(false);
    // 设置窗口刚好容纳组件
    pack();
    // 设置窗口标题
    setTitle(“设置学校信息”);
    // 设置窗口可见
    setVisible(true);
    // 设置窗口默认关闭操作（卸载当前窗口）
    setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

    // 【关闭】按钮单击事件处理
    btnExit.addActionListener(new ActionListener() {
    @Override
    public void actionPerformed(ActionEvent event) {
    // 关闭窗口
    dispose();
    }
    });

    // 【保存】按钮单击事件处理
    btnSave.addActionListener(new ActionListener() {
    @Override
    public void actionPerformed(ActionEvent event) {
    try {
    // 修改学校对象属性
    college.setName(txtName.getText());
    college.setPresident(txtPresident.getText());
    college.setStartTime(new Timestamp(
    new SimpleDateFormat(“yyyy-MM-dd”)
    .parse(txtStartTime.getText().toString()).getTime()));
    college.setTelephone(txtTelephone.getText());
    college.setEmail(txtEMail.getText());
    college.setAddress(txtAddress.getText());
    college.setProfile(txtProfile.getText());
    // 更新学校信息
    collegeService.updateCollege(college);
    // 提示用户更新成功
    JOptionPane.showMessageDialog(null, “更新数据成功！”);
    } catch (ParseException e) {
    // 提示用户更新失败
    JOptionPane.showMessageDialog(null, “更新数据失败！”);
    }
    }
    });
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new SetCollegeInfoFrame("");
    }
    }

运行结果如下：
运行结果如下：

（2）修改用户密码窗口ChangePasswordFrame
package net.lyq.student.gui;

import net.lyq.student.app.Application;
import net.lyq.student.bean.User;
import net.lyq.student.service.UserService;
import net.lyq.student.service.impl.UserServiceImpl;

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

/**

• 功能：修改用户密码
• 作者：刘燕琼
• 日期：2019年7月2日
  */

public class ChangePasswordFrame extends JFrame {
/**
* 面板
/
private JPanel panel;
private JPanel pnlRow1;
private JPanel pnlRow2;
private JPanel pnlRow3;
private JPanel pnlRow4;
private JPanel pnlRow5;
/*
* 标签
/
private JLabel lblUsername;
private JLabel lblPassword;
private JLabel lblNewPassword1;
private JLabel lblNewPassword2;
/*
* 文本框
/
private JTextField txtUsername;
private JPasswordField txtPassword;
private JPasswordField txtNewPassword1;
private JPasswordField txtNewPassword2;
/*
* 按钮
/
private JButton btnOK;
private JButton btnCancel;
/*
* 用户服务对象
*/
private UserService userService;

/**
 * 构造方法
 *
 * @param title
 */
public ChangePasswordFrame(String title) {
    super(title);
    initGUI();
}

/**
 * 初始化用户界面
 */
private void initGUI() {
    // 创建组件（面板与控件）
    panel = (JPanel) getContentPane();
    pnlRow1 = new JPanel();
    pnlRow2 = new JPanel();
    pnlRow3 = new JPanel();
    pnlRow4 = new JPanel();
    pnlRow5 = new JPanel();

    lblUsername = new JLabel("用户名：");
    lblPassword = new JLabel("旧密码：");
    lblNewPassword1 = new JLabel("新密码：");
    lblNewPassword2 = new JLabel("确    认：");

    txtUsername = new JTextField(20);
    txtUsername.setEditable(false);
    txtPassword = new JPasswordField(20);
    txtNewPassword1 = new JPasswordField(20);
    txtNewPassword2 = new JPasswordField(20);

    btnOK = new JButton("确定[O]");
    btnOK.setMnemonic(KeyEvent.VK_O);
    btnCancel = new JButton("取消[C]");
    btnCancel.setMnemonic(KeyEvent.VK_C);

    // 设置大面板布局，添加五个小面板
    panel.setLayout(new GridLayout(5, 1));
    panel.add(pnlRow1);
    panel.add(pnlRow2);
    panel.add(pnlRow3);
    panel.add(pnlRow4);
    panel.add(pnlRow5);

    // 将控件添加到五个小面板
    pnlRow1.add(lblUsername);
    pnlRow1.add(txtUsername);
    pnlRow2.add(lblPassword);
    pnlRow2.add(txtPassword);
    pnlRow3.add(lblNewPassword1);
    pnlRow3.add(txtNewPassword1);
    pnlRow4.add(lblNewPassword2);
    pnlRow4.add(txtNewPassword2);
    pnlRow5.add(btnOK);
    pnlRow5.add(btnCancel);

    // 设置窗口不可调整大小
    setResizable(false);
    // 设置窗口刚好容纳组件
    pack();
    // 设置窗口屏幕居中
    setLocationRelativeTo(null);
    // 设置窗口标题
    setTitle("修改用户密码");
    // 设置窗口可见
    setVisible(true);
    // 设置窗口默认关闭操作（卸载当前窗口）
    setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

    // 设置控件属性
    txtUsername.setEditable(false);
    txtUsername.setText(Application.username);

    // 【取消】按钮单击事件处理
    btnCancel.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            dispose();
        }
    });

    // 【确定】按钮单击事件处理
    btnOK.addActionListener(new ActionListener() {
        @Override
        public void actionPerformed(ActionEvent e) {
            changePassword();
        }
    });

    // 【确定】按钮按键事件处理
    btnOK.addKeyListener(new KeyAdapter() {
        @Override
        public void keyPressed(KeyEvent e) {
            if (e.getKeyCode() == 10) {
                changePassword();
            }
        }
    });

    // 【用户名】文本框按键事件处理
    txtUsername.addKeyListener(new KeyAdapter() {
        @Override
        public void keyPressed(KeyEvent e) {
            if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                txtPassword.requestFocus();
            }
        }
    });

    // 【密码】文本框按键事件处理
    txtPassword.addKeyListener(new KeyAdapter() {
        @Override
        public void keyPressed(KeyEvent e) {
            if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                txtNewPassword1.requestFocus();
            }
        }
    });

    // 【新密码1】文本框按键事件处理
    txtNewPassword1.addKeyListener(new KeyAdapter() {
        @Override
        public void keyPressed(KeyEvent e) {
            if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                txtNewPassword2.requestFocus();
            }
        }
    });

    // 【新密码2】文本框按键事件处理
    txtNewPassword2.addKeyListener(new KeyAdapter() {
        @Override
        public void keyPressed(KeyEvent e) {
            if (e.getKeyCode() == KeyEvent.VK_ENTER) {
                btnOK.requestFocus();
            }
        }
    });
}

/**
 * 修改密码方法
 */
private void changePassword() {
    // 获取用户信息
    int id = Application.id;
    String username = Application.username;

    // 保存用户输入的旧密码与两个新密码
    String password = new String(txtPassword.getPassword());
    String newPassword1 = new String(txtNewPassword1.getPassword());
    String newPassword2 = new String(txtNewPassword2.getPassword());

    // 创建学生服务对象
    userService = new UserServiceImpl();

    if (userService.login(username, password) == null) {
        JOptionPane.showMessageDialog(null, "旧密码错误，请重新输入！", "错误提示", JOptionPane.ERROR_MESSAGE);
        txtPassword.requestFocus();
        txtPassword.selectAll();
    } else if (newPassword1.equals("")) {
        JOptionPane.showMessageDialog(null, "新密码不能为空！", "错误提示", JOptionPane.ERROR_MESSAGE);
        txtNewPassword1.requestFocus();
    } else if (newPassword2.equals("")) {
        JOptionPane.showMessageDialog(null, "确认密码不能为空！", "错误提示", JOptionPane.ERROR_MESSAGE);
        txtNewPassword2.requestFocus();
    } else if (!newPassword1.equals(newPassword2)) {
        JOptionPane.showMessageDialog(null, "两次密码不一致，请重新输入！", "错误提示", JOptionPane.ERROR_MESSAGE);
        txtNewPassword1.setText("");
        txtNewPassword2.setText("");
        txtNewPassword1.requestFocus();
    } else {
        // 按标识符获取用户
        User user = userService.findUserById(id);
        // 修改用户的密码属性
        user.setPassword(newPassword1);
        // 调用用户服务对象的更新方法，更新用户信息
        int count = userService.updateUser(user);
        if (count > 0) {
            JOptionPane.showMessageDialog(null, "密码修改成功！", "设置密码", JOptionPane.INFORMATION_MESSAGE);
            dispose();
        } else {
            JOptionPane.showMessageDialog(null, "密码修改失败！", "设置密码", JOptionPane.WARNING_MESSAGE);
        }
    }
}

/**
 * 主方法
 *
 * @param args
 */
public static void main(String[] args) {
    Application.id = 1;
    Application.username = "李刚";
    new ChangePasswordFrame("");
}

}

运行结果如下：

（3）浏览学生窗口BrowseStudentsFrame
package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

import javax.swing.;
import java.awt.;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.util.List;

/**

• 功能：浏览学生记录
• 作者：刘燕琼
• 日期：2019年7月2日
  */

public class BrowseStudentsFrame 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 btnTop;
private JButton btnPrevious;
private JButton btnNext;
private JButton btnBottom;
private JButton btnExit;

/**
 * 当前记录行号
 */
private int currentRow;
/**
 * 学生列表
 */
private List<Student> students;
/**
 * 创建学生服务对象
 */
StudentService studentService;

/**
 * 构造方法
 *
 * @param title
 */
public BrowseStudentsFrame(String title) {
    super(title);
    intGUI();
}

/**
 * 初始化用户界面
 */
private void intGUI() {
    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(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]");
    btnTop.setMnemonic(KeyEvent.VK_P);
    btnPrevious.setMnemonic(KeyEvent.VK_P);
    btnNext.setMnemonic(KeyEvent.VK_N);
    btnBottom.setMnemonic(KeyEvent.VK_B);
    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(lblDepartment);
    pnlRow4.add(txtDepartment);
    pnlRow5.add(lblDepartment);
    pnlRow5.add(txtDepartment);
    pnlRow6.add(lblClass);
    pnlRow6.add(txtClass);
    pnlRow7.add(lblTelephone);
    pnlRow7.add(txtTelephone);

    pnlSouth.add(btnTop);
    pnlSouth.add(btnPrevious);
    pnlSouth.add(btnNext);
    pnlSouth.add(btnBottom);
    pnlSouth.add(btnExit);

    // 设置窗口属性
    setSize(500, 300);
    // 设置窗口不可调整大小
    setResizable(false);
    // 设置窗口刚好容纳组件
    pack();
    // 设置窗口屏幕居中
    setLocationRelativeTo(null);
    // 设置窗口可见
    setVisible(true);
    // 设置窗口默认关闭操作（卸载当前窗口）
    setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);

    // 创建学生服务对象
    studentService = new StudentServiceImpl();
    // 获取全部学生列表
    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();
        }
    });
}

/**
 * 将当前记录数据填充窗口各文本框
 *
 * @param currentRow
 */
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());
    }
}

/**
 * 主方法
 *
 * @param args
 */
public static void main(String[] args) {
    new BrowseStudentsFrame("");
}

}

运行结果如下：

（4）添加学生窗口AddStudentFrame
package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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

/**

• 功能：添加学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 students;

  /**

  • 构造方法
  • @param title
    */
    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.DISPOSE_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 StudentServiceImpl();
         // 添加学生记录
         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();
    }
    }
    });
    }

  /**

  • 判断一个字符串是否全是数字
  • @param str
  • @return
    */
    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;
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new AddStudentFrame("");
    }
    }
    运行结果如下：
    

（5）编辑学生窗口EditStudentFrame
package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：编辑学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 students;
    /*
  • 创建学生服务对象
    */
    StudentService studentService;

  /**

  • 构造方法
  • @param title
    */
    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.DISPOSE_ON_CLOSE);

    // 创建学生服务对象
    studentService = new StudentServiceImpl();
    // 获取全部学生列表
    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();
    }
    }
    });
    }

  /**

  • 将当前记录数据填充窗口各文本框
  • @param currentRow
    */
    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;
  }

  /**

  • 判断是否合法手机号
  • @param telephone
  • @return
    */
    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();
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new EditStudentFrame("");
    }
    }

运行结果如下：

（6）按学号删除学生窗口DeleteStudentByIdFrame

package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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

/**

• 功能：按学号删除学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 colHead;
    /*
  • 表格
    /
    private JTable table;
    /*
  • 滚动面板
    /
    private JScrollPane scroller;
    /*
  • 当前记录行号
    /
    private int currentRow;
    /*
  • 学生列表
    /
    private List students;
    /*
  • 创建学生服务对象
    */
    private StudentService studentService;

  /**

  • 构造方法
  • @param title
    */
    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 StudentServiceImpl();
   // 获取全部学生列表
   students = studentService.findAllStudents();
   // 填充表格数据
   fillTableData();
  
   // 设置窗口大小
   setSize(600, 350);
   // 设置窗口不可调整大小
   setResizable(false);
   // 设置窗口屏幕居中
   setLocationRelativeTo(null);
   // 设置窗口标题
   setTitle("按学号删除学生记录");
   // 设置窗口可见
   setVisible(true);
   // 设置窗口默认关闭操作（卸载当前窗口）
   setDefaultCloseOperation(JFrame.DISPOSE_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 currentRow = new Vector();
    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);
    }

    // 创建表格（参数1：记录集；参数2：表头）
    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);
    }
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new DeleteStudentByIdFrame("");
    }
    }
    运行结果如下：
    
    （7）按班级删除学生窗口DeleteStudentsByClass
    package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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

/**

• 功能：按班级删除学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 colHead;
    /*
  • 表格
    /
    private JTable table;
    /*
  • 滚动面板
    */
    private JScrollPane scroller;

  /**

  • 当前记录行号
    /
    private int currentRow;
    /*
  • 学生列表
    /
    private List students;
    /*
  • 创建学生服务对象
    */
    private StudentService studentService;

  /**

  • 构造方法
  • @param title
    */
    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 StudentServiceImpl();
   // 获取全部学生列表
   students = studentService.findAllStudents();
   // 填充表格数据
   fillTableData();
  
   // 设置窗口大小
   setSize(600, 350);
   // 设置窗口不可调整大小
   setResizable(false);
   // 设置窗口屏幕居中
   setLocationRelativeTo(null);
   // 设置窗口标题
   setTitle("按班级删除学生记录");
   // 设置窗口可见
   setVisible(true);
   // 设置窗口默认关闭操作（卸载当前窗口）
   setDefaultCloseOperation(JFrame.DISPOSE_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());
           if (row <= table.getRowCount()) {
               // 选中鼠标单击的行
               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 currentRow = new Vector();
    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);
    }

    // 创建表格（参数1：记录集；参数2：表头）
    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);
    }
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new DeleteStudentsByClassFrame("");
    }
    }
    运行结果如下：
    

（8）按系部删除学生窗口DeleteStudentsByDepartment

package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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

/**

• 功能：按系部删除学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 colHead;
    /*
  • 表格
    /
    private JTable table;
    /*
  • 滚动面板
    */
    private JScrollPane scroller;

  /**

  • 当前记录行号
    /
    private int currentRow;
    /*
  • 学生列表
    /
    private List students;
    /*
  • 创建学生服务对象
    */
    private StudentService studentService;

  /**

  • 构造方法
  • @param title
    */
    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 StudentServiceImpl();
   // 获取全部学生列表
   students = studentService.findAllStudents();
   // 填充表格数据
   fillTableData();
  
   // 设置窗口大小
   setSize(600, 350);
   // 设置窗口不可调整大小
   setResizable(false);
   // 设置窗口屏幕居中
   setLocationRelativeTo(null);
   // 设置窗口标题
   setTitle("按系部删除学生记录");
   // 设置窗口可见
   setVisible(true);
   // 设置窗口默认关闭操作（卸载当前窗口）
   setDefaultCloseOperation(JFrame.DISPOSE_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 currentRow = new Vector();
    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);
    }

    // 创建表格（参数1：记录集；参数2：表头）
    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);
    }
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new DeleteStudentsByDepartmentFrame("");
    }
    }
    运行结果如下：
    
    （9）学号查询学生窗口FindStudentById
    package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：按学号查询学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 colHead;
    /*
  • 表格
    /
    private JTable table;
    /*
  • 滚动面板
    /
    private JScrollPane scroller;
    /*
  • 当前记录行号
    /
    private int currentRow;
    /*
  • 学生列表
    /
    private List students;
    /*
  • 创建学生服务对象
    */
    private StudentService studentService;

  /**

  • 构造方法
  • @param title
    */
    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 StudentServiceImpl();
    // 获取全部学生列表
    students = studentService.findAllStudents();
    // 填充表格数据
    fillTableData();

    // 设置窗口大小
    setSize(600, 350);
    // 设置窗口不可调整大小
    setResizable(false);
    // 设置窗口屏幕居中
    setLocationRelativeTo(null);
    // 设置窗口标题
    setTitle(“按学号查询学生记录”);
    // 设置窗口可见
    setVisible(true);
    // 设置窗口默认关闭操作（卸载当前窗口）
    setDefaultCloseOperation(JFrame.DISPOSE_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 currentRow = new Vector();
    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);
    }

    // 创建表格（参数1：记录集；参数2：表头）
    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);
    }
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new FindStudentByIdFrame("");
    }
    }
    运行结果如下：
    
    (10)按姓名查询学生窗口FindStudentsByName
    package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：按姓名查询学生记录
• 作者：刘燕琼
• 日期：2019年7月2日
  */

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;

/**
 * 构造方法
 *
 * @param title
 */
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 StudentServiceImpl();
    // 获取全部学生列表
    students = studentService.findAllStudents();
    // 填充表格数据
    fillTableData();

    // 设置窗口大小
    setSize(600, 350);
    // 设置窗口不可调整大小
    setResizable(false);
    // 设置窗口屏幕居中
    setLocationRelativeTo(null);
    // 设置窗口标题
    setTitle("按姓名查询学生记录");
    // 设置窗口可见
    setVisible(true);
    // 设置窗口默认关闭操作（卸载当前窗口）
    setDefaultCloseOperation(JFrame.DISPOSE_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);
    }

    // 创建表格（参数1：记录集；参数2：表头）
    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);
    }
}

/**
 * 主方法
 *
 * @param args
 */
public static void main(String[] args) {
    new FindStudentsByNameFrame("");
}

}
运行结果如下：

（11）按班级查询学生窗口FindStudentsByClass
package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：按班级查询学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 colHead;
    /*
  • 表格
    /
    private JTable table;
    /*
  • 滚动面板
    */
    private JScrollPane scroller;

  /**

  • 当前记录行号
    /
    private int currentRow;
    /*
  • 学生列表
    /
    private List students;
    /*
  • 创建学生服务对象
    */
    private StudentService studentService;

  /**

  • 构造方法
  • @param title
    */
    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 StudentServiceImpl();
    // 获取全部学生列表
    students = studentService.findAllStudents();
    // 填充表格数据
    fillTableData();

    // 设置窗口大小
    setSize(600, 350);
    // 设置窗口不可调整大小
    setResizable(false);
    // 设置窗口屏幕居中
    setLocationRelativeTo(null);
    // 设置窗口标题
    setTitle(“按姓名查询学生记录”);
    // 设置窗口可见
    setVisible(true);
    // 设置窗口默认关闭操作（卸载当前窗口）
    setDefaultCloseOperation(JFrame.DISPOSE_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 currentRow = new Vector();
    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);
    }

    // 创建表格（参数1：记录集；参数2：表头）
    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);
    }
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new FindStudentsByClassFrame("");
    }
    }
    运行结果如下：
    
    （12）按系部查询学生窗口FindStudentsByDepartment
    package net.lyq.student.gui;

import net.lyq.student.bean.Student;
import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：按系部查询学生记录

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 colHead;
    /*
  • 表格
    /
    private JTable table;
    /*
  • 滚动面板
    */
    private JScrollPane scroller;

  /**

  • 当前记录行号
    /
    private int currentRow;
    /*
  • 学生列表
    /
    private List students;
    /*
  • 创建学生服务对象
    */
    private StudentService studentService;

  /**

  • 构造方法
  • @param title
    */
    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 StudentServiceImpl();
    // 获取全部学生列表
    students = studentService.findAllStudents();
    // 填充表格数据
    fillTableData();

    // 设置窗口大小
    setSize(600, 350);
    // 设置窗口不可调整大小
    setResizable(false);
    // 设置窗口屏幕居中
    setLocationRelativeTo(null);
    // 设置窗口标题
    setTitle(“按系部查询学生记录”);
    // 设置窗口可见
    setVisible(true);
    // 设置窗口默认关闭操作（卸载当前窗口）
    setDefaultCloseOperation(JFrame.DISPOSE_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, 4).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 currentRow = new Vector();
    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);
    }

    // 创建表格（参数1：记录集；参数2：表头）
    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);
    }
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new FindStudentsByDepartmentFrame("");
    }
    }

运行结果如下：

（13）按性别统计人数窗口CountStudentsBySex
package net.lyq.student.gui;

import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：按性别统计学生人数

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 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 StudentServiceImpl();
    // 获取按性别统计结果记录行集
    rows = studentService.findRowsBySex();
    // 设置表头
    colHead.add(“性别”);
    colHead.add(“人数”);

    // 创建表格（参数1：记录集；参数2：表头）
    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.DISPOSE_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();
    }
    }
    });
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new CountStudentsBySexFrame("");
    }
    }
    运行结果如下：
    
    （14）按班级统计人数窗口CountStudentsByClass
    package net.lyq.student.gui;

import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：按班级统计学生人数

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 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 StudentServiceImpl();
    // 获取按班级统计结果记录行集
    rows = studentService.findRowsByClass();
    // 设置表头
    colHead.add(“班级”);
    colHead.add(“人数”);

    // 创建表格（参数1：记录集；参数2：表头）
    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.DISPOSE_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();
    }
    }
    });
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new CountStudentsByClassFrame("");
    }
    }
    运行结果如下：
    
    （15）按系部统计人数窗口CountStudentsByDepartment
    package net.lyq.student.gui;

import net.lyq.student.service.StudentService;
import net.lyq.student.service.impl.StudentServiceImpl;

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;

/**

• 功能：按系部统计学生人数

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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 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 StudentServiceImpl();
    // 获取按系部统计结果记录行集
    rows = studentService.findRowsByDepartment();
    // 设置表头
    colHead.add(“系部”);
    colHead.add(“人数”);

    // 创建表格（参数1：记录集；参数2：表头）
    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.DISPOSE_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();
    }
    }
    });
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    new CountStudentsByDepartmentFrame("");
    }
    }
    运行结果如下：
    
    （16）设置状态栏信息窗口SetStatusBarFrame
    
    
    
    
    
    
    
    
    
    （17）系统主窗口MainFrame（V1.1）
    package net.lyq.student.gui;

import net.lyq.student.app.Application;
import net.lyq.student.bean.Status;
import net.lyq.student.service.StatusService;
import net.lyq.student.service.impl.StatusServiceImpl;

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

/**

• 功能：主界面窗口

•  通过菜单系统
  

•  调用各个功能模块
  

• 作者：刘燕琼

• 日期：2019年7月2日
  /
  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;

  /**

  • 构造方法
  • @param title
    */
    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 StatusServiceImpl();
    // 获取状态对象
    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 ChangePasswordFrame("");
    }
    });

    // 【退出系统】菜单项单击事件
    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.getEmail(),
    “学生信息管理系统” + 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 ChangePasswordFrame("");
    }
    });

    // 【浏览】按钮
    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 StatusServiceImpl();
    // 获取状态栏对象
    status = statusService.findStatusById(1);
    // 设置状态栏标签
    lblStatusBar.setText(
    status.getCollege() + “学生信息管理系统” + status.getVersion() + " 作者：" + status.getAuthor() + " 地址："
    + status.getAddress() + " 电话：" + status.getTelephone() + " 邮箱：" + status.getEmail());
    }

  /**

  • 主方法
  • @param args
    */
    public static void main(String[] args) {
    Application.mainFrame = new MainFrame("");
    }
    }
    运行结果如下：