编程语言

修改用户密码窗口ChangePasswordFrame
package net.hlj.student.gui;

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

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;

/**

  • 功能:修改用户密码
  • 作者:黄丽娟
  • 日期: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("");
}

}

在这里插入图片描述
在这里插入图片描述
浏览学生窗口BrowseStudentsFrame
package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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);
    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(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_T);
    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(lblAge);
    pnlRow4.add(txtAge);
    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("");
}

}
在这里插入图片描述
添加学生窗口AddStudentFrame
package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      编辑学生窗口EditStudentFrame
      package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按学号删除学生窗口DeleteStudentByIdFrame
      package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      )按班级删除学生窗口DeleteStudentsByClass
      package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按系部删除学生窗口DeleteStudentsByDepartment
      package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按学号查询学生窗口FindStudentById
      package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按姓名查询学生窗口FindStudentsByName
      package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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;

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("");
}

}
在这里插入图片描述
按班级查询学生窗口FindStudentsByClass
package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按系部查询学生窗口FindStudentsByDepartment
      package net.hlj.student.gui;

import net.hlj.student.bean.Student;
import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按性别统计人数窗口CountStudentsBySex
      package net.hlj.student.gui;

import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按班级统计人数窗口CountStudentsByClass
      package net.hlj.student.gui;

import net.hlj.student.service.StudentService;
import net.hlj.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("");
      }
      }
      在这里插入图片描述
      按系部统计人数窗口CountStudentsByDepartment
      package net.hlj.student.gui;

import net.hlj.student.service.StudentService;
import net.hlj.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年6月20日
    /
    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("");
      }
      }
      在这里插入图片描述
      设置状态栏信息窗口SetStatusBarFrame
      package net.hlj.student.gui;

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

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

/**

  • 功能:设置状态栏信息

  • 作者:华卫

  • 日期:2019年7月2日
    /
    public class SetStatusBarFrame extends JFrame {
    /
    *

    • 面板
      /
      private JPanel panel;
      private JPanel panel1;
      private JPanel panel2;
      private JPanel panel3;
      private JPanel panel4;
      private JPanel panel5;
      /
      *
    • 标签
      /
      private JLabel lblCollege;
      private JLabel lblVersion;
      private JLabel lblAuthor;
      private JLabel lblTelephone;
      private JLabel lblAddress;
      private JLabel lblEmail;
      /
      *
    • 文本框
      /
      private JTextField txtCollege;
      private JTextField txtVersion;
      private JTextField txtAuthor;
      private JTextField txtTelephone;
      private JTextField txtAddress;
      private JTextField txtEmail;
      /
      *
    • 按钮
      /
      private JButton btnSave;
      private JButton btnExit;
      /
      *
    • 状态服务对象
      */
      private StatusService statusService;

    /**

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

    /**

    • 初始化用户界面
      */
      private void initGUI() {
      // 创建组件
      panel = (JPanel) getContentPane();
      panel1 = new JPanel();
      panel2 = new JPanel();
      panel3 = new JPanel();
      panel4 = new JPanel();
      panel5 = new JPanel();

      lblCollege = new JLabel(“校名:”);
      lblVersion = new JLabel(“版本:”);
      lblAuthor = new JLabel(“作者:”);
      lblTelephone = new JLabel(“电话:”);
      lblAddress = new JLabel(“地址:”);
      lblEmail = new JLabel(“邮件:”);

      txtCollege = new JTextField(12);
      txtVersion = new JTextField(12);
      txtAuthor = new JTextField(12);
      txtTelephone = new JTextField(12);
      txtAddress = new JTextField(29);
      txtEmail = new JTextField(29);

      btnSave = new JButton(“保存[S]”);
      btnSave.setMnemonic(KeyEvent.VK_S);
      btnExit = new JButton(“退出[X]”);
      btnExit.setMnemonic(KeyEvent.VK_X);

      // 添加组件
      panel.setLayout(new GridLayout(5, 1));
      panel.add(panel1);
      panel.add(panel2);
      panel.add(panel3);
      panel.add(panel4);
      panel.add(panel5);

      panel1.add(lblCollege);
      panel1.add(txtCollege);
      panel1.add(lblVersion);
      panel1.add(txtVersion);

      panel2.add(lblAuthor);
      panel2.add(txtAuthor);
      panel2.add(lblTelephone);
      panel2.add(txtTelephone);

      panel3.add(lblAddress);
      panel3.add(txtAddress);
      panel4.add(lblEmail);
      panel4.add(txtEmail);

      panel5.add(btnSave);
      panel5.add(btnExit);

      // 创建状态服务对象
      statusService = new StatusServiceImpl();
      // 按标识符获取状态对象
      Status status = statusService.findStatusById(1);
      if (status != null) {
      txtCollege.setText(status.getCollege());
      txtVersion.setText(status.getVersion());
      txtAuthor.setText(status.getAuthor());
      txtAddress.setText(status.getAuthor());
      txtTelephone.setText(status.getTelephone());
      txtAddress.setText(status.getAddress());
      txtEmail.setText(status.getEmail());
      }

      // 设置窗口大小
      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 arg0) {
      dispose();
      }
      });

      // 【保存】按钮事件处理
      btnSave.addActionListener(new ActionListener() {
      @Override
      public void actionPerformed(ActionEvent e) {
      // 获取状态信息对象
      Status status = statusService.findStatusById(1);
      // 修改属性值
      status.setCollege(txtCollege.getText());
      status.setVersion(txtVersion.getText());
      status.setAuthor(txtAuthor.getText());
      status.setTelephone(txtTelephone.getText());
      status.setAddress(txtAddress.getText());
      status.setEmail(txtEmail.getText());
      // 更新状态记录
      int count = statusService.updateStatus(status);
      // 判断是否更新成功
      if (count > 0) {
      Application.mainFrame.setStatusBar();
      Application.mainFrame.setTitle(“学生信息管理系统” + status.getVersion());
      }
      }
      });
      }
      }
      在这里插入图片描述
      在这里插入图片描述
      在这里插入图片描述
      在这里插入图片描述

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
提供的源码资源涵盖了安卓应用、小程序、Python应用和Java应用等多个领域,每个领域都包含了丰富的实例和项目。这些源码都是基于各自平台的最新技术和标准编写,确保了在对应环境下能够无缝运行。同时,源码中配备了详细的注释和文档,帮助用户快速理解代码结构和实现逻辑。 适用人群: 这些源码资源特别适合大学生群体。无论你是计算机相关专业的学生,还是对其他领域编程感兴趣的学生,这些资源都能为你提供宝贵的学习和实践机会。通过学习和运行这些源码,你可以掌握各平台开发的基础知识,提升编程能力和项目实战经验。 使用场景及目标: 在学习阶段,你可以利用这些源码资源进行课程实践、课外项目或毕业设计。通过分析和运行源码,你将深入了解各平台开发的技术细节和最佳实践,逐步培养起自己的项目开发和问题解决能力。此外,在求职或创业过程中,具备跨平台开发能力的大学生将更具竞争力。 其他说明: 为了确保源码资源的可运行性和易用性,特别注意了以下几点:首先,每份源码都提供了详细的运行环境和依赖说明,确保用户能够轻松搭建起开发环境;其次,源码中的注释和文档都非常完善,方便用户快速上手和理解代码;最后,我会定期更新这些源码资源,以适应各平台技术的最新发展和市场需求。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值