GUI窗口
各个部件
添加学生记录
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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<Student> students;
public AddStudentFrame(String title) {
super(title);
initGUI();
}
private void initGUI() {
panel = (JPanel) getContentPane();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
pnlRow1 = new JPanel();
pnlRow2 = new JPanel();
pnlRow3 = new JPanel();
pnlRow4 = new JPanel();
pnlRow5 = new JPanel();
pnlRow6 = new JPanel();
pnlRow7 = new JPanel();
pnlRow1.setLayout(new FlowLayout(FlowLayout.LEFT));
pnlRow2.setLayout(new FlowLayout(FlowLayout.LEFT));
pnlRow3.setLayout(new FlowLayout(FlowLayout.LEFT));
pnlRow4.setLayout(new FlowLayout(FlowLayout.LEFT));
pnlRow5.setLayout(new FlowLayout(FlowLayout.LEFT));
pnlRow6.setLayout(new FlowLayout(FlowLayout.LEFT));
pnlRow7.setLayout(new FlowLayout(FlowLayout.LEFT));
lblId = new JLabel("学号：");
lblName = new JLabel("姓名：");
lblSex = new JLabel("性别：");
lblAge = new JLabel("年龄：");
lblDepartment = new JLabel("系部：");
lblClass = new JLabel("班级：");
lblTelephone = new JLabel("电话：");
txtId = new JTextField(20);
txtName = new JTextField(20);
txtSex = new JTextField(20);
txtAge = new JTextField(20);
txtDepartment = new JTextField(20);
txtClass = new JTextField(20);
txtTelephone = new JTextField(20);
btnOK = new JButton("确定[O]");
btnCancel = new JButton("取消[C]");
btnExit = new JButton("退出[X]");
btnOK.setMnemonic(KeyEvent.VK_O);
btnCancel.setMnemonic(KeyEvent.VK_C);
btnExit.setMnemonic(KeyEvent.VK_X);
panel.setLayout(new BorderLayout());
panel.add(pnlCenter, BorderLayout.CENTER);
panel.add(pnlSouth, BorderLayout.SOUTH);
pnlCenter.setLayout(new GridLayout(7, 1));
pnlCenter.add(pnlRow1);
pnlCenter.add(pnlRow2);
pnlCenter.add(pnlRow3);
pnlCenter.add(pnlRow4);
pnlCenter.add(pnlRow5);
pnlCenter.add(pnlRow6);
pnlCenter.add(pnlRow7);
pnlRow1.add(lblId);
pnlRow1.add(txtId);
pnlRow2.add(lblName);
pnlRow2.add(txtName);
pnlRow3.add(lblSex);
pnlRow3.add(txtSex);
pnlRow4.add(lblAge);
pnlRow4.add(txtAge);
pnlRow5.add(lblDepartment);
pnlRow5.add(txtDepartment);
pnlRow6.add(lblClass);
pnlRow6.add(txtClass);
pnlRow7.add(lblTelephone);
pnlRow7.add(txtTelephone);
pnlSouth.add(btnOK);
pnlSouth.add(btnCancel);
pnlSouth.add(btnExit);
setSize(500, 300);
setResizable(false);
pack();
setLocationRelativeTo(null);
setTitle("添加学生记录");
setVisible(true);
setDefaultCloseOperation(JFrame.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();
}
}
});
}
boolean isNumber(String str) {
for (int i = 0; i < str.length(); i++) {
if (str.charAt(i) < '0' || str.charAt(i) > '9') {
return false;
}
}
return true;
}
public static void main(String[] args) {
new AddStudentFrame("");
}
}
浏览学生记录
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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;
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();
}
});
}
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());
}
}
public static void main(String[] args) {
new BrowseStudentsFrame("");
}
}
修改用户密码
package net.lr.student.gui;
import net.lr.student.app.Application;
import net.lr.student.bean.User;
import net.lr.student.service.UserService;
import net.lr.student.service.impl.UserServiceImpl;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
/**
* 功能：修改用户密码
* 作者：刘瑞
* 日期：2019.7.2
*/
public class ChangePasswordFrame extends JFrame {
private JPanel panel;
private JPanel pnlRow1;
private JPanel pnlRow2;
private JPanel pnlRow3;
private JPanel pnlRow4;
private JPanel pnlRow5;
private JLabel lblUsername;
private JLabel lblPassword;
private JLabel lblNewPassword1;
private JLabel lblNewPassword2;
private JTextField txtUsername;
private JPasswordField txtPassword;
private JPasswordField txtNewPassword1;
private JPasswordField txtNewPassword2;
private JButton btnOK;
private JButton btnCancel;
private UserService userService;
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();
}
}
});
txtNewPassword1.addKeyListener(new KeyAdapter() {
@Override
public void keyPressed(KeyEvent e) {
if (e.getKeyCode() == KeyEvent.VK_ENTER) {
txtNewPassword2.requestFocus();
}
}
});
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);
}
}
}
public static void main(String[] args) {
Application.id = 1;
Application.username = "李刚";
new ChangePasswordFrame("");
}
}
按班级统计学生人数
package net.lr.student.gui;
import net.lr.student.service.StudentService;
import net.lr.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<String> colHead;
private JTable table;
private JScrollPane scroller;
private StudentService studentService;
public CountStudentsByClassFrame(String title) {
super(title);
initGUI();
}
private void initGUI() {
panel = (JPanel) getContentPane();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
btnPrint = new JButton("打印[P]");
btnPrint.setMnemonic(KeyEvent.VK_P);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnPrint);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("统计结果");
pnlCenter.setBorder(tb);
studentService = new StudentServiceImpl();
rows = studentService.findRowsByClass();
colHead.add("班级");
colHead.add("人数");
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
}
setSize(300, 200);
setResizable(false);
setLocationRelativeTo(null);
setTitle("按班级统计学生人数");
setVisible(true);
setDefaultCloseOperation(JFrame.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();
}
}
});
}
public static void main(String[] args) {
new CountStudentsByClassFrame("");
}
}
按系部统计学生人数
package net.lr.student.gui;
import net.lr.student.service.StudentService;
import net.lr.student.service.impl.StudentServiceImpl;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.KeyEvent;
import java.awt.print.PrinterException;
import java.util.Vector;
/**
* 功能：按系部统计学生人数
* 作者：刘瑞
* 日期：2019.7.2
*/
public class CountStudentsByDepartmentFrame extends JFrame {
private JPanel panel;
private JPanel pnlSouth;
private JPanel pnlCenter;
private JButton btnPrint;
private JButton btnExit;
private Vector rows;
private Vector<String> colHead;
private JTable table;
private JScrollPane scroller;
private StudentService studentService;
public CountStudentsByDepartmentFrame(String title) {
super(title);
initGUI();
}
private void initGUI() {
panel = (JPanel) getContentPane();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
btnPrint = new JButton("打印[P]");
btnPrint.setMnemonic(KeyEvent.VK_P);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnPrint);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("统计结果");
pnlCenter.setBorder(tb);
studentService = new StudentServiceImpl();
rows = studentService.findRowsByDepartment();
colHead.add("系部");
colHead.add("人数");
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
}
setSize(300, 200);
setResizable(false);
setLocationRelativeTo(null);
setTitle("按系部统计学生人数");
setVisible(true);
setDefaultCloseOperation(JFrame.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();
}
}
});
}
public static void main(String[] args) {
new CountStudentsByDepartmentFrame("");
}
}
按性别统计学生人数
package net.lr.student.gui;
import net.lr.student.service.StudentService;
import net.lr.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<String> colHead;
private JTable table;
private JScrollPane scroller;
private StudentService studentService;
public CountStudentsBySexFrame(String title) {
super(title);
initGUI();
}
private void initGUI() {
panel = (JPanel) getContentPane();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
btnPrint = new JButton("打印[P]");
btnPrint.setMnemonic(KeyEvent.VK_P);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnPrint);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("统计结果");
pnlCenter.setBorder(tb);
studentService = new StudentServiceImpl();
rows = studentService.findRowsBySex();
colHead.add("性别");
colHead.add("人数");
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
}
setSize(300, 200);
setResizable(false);
setLocationRelativeTo(null);
setTitle("按性别统计学生人数");
setVisible(true);
setDefaultCloseOperation(JFrame.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();
}
}
});
}
public static void main(String[] args) {
new CountStudentsBySexFrame("");
}
}
按学号删除学生记录
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;
public DeleteStudentByIdFrame(String title) {
super(title);
intiGUI();
}
private void intiGUI() {
panel = (JPanel) getContentPane();
pnlNorth = new JPanel();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
lblInputId = new JLabel("输入学号：");
txtId = new JTextField(10);
txtId.setHorizontalAlignment(JTextField.CENTER);
btnQuery = new JButton("查询[Q]");
btnQuery.setMnemonic(KeyEvent.VK_Q);
btnBrowseAll = new JButton("显示全部记录[A]");
btnBrowseAll.setMnemonic(KeyEvent.VK_A);
btnDelete = new JButton("删除查询的记录[D]");
btnDelete.setEnabled(false);// 删除按钮不可用
btnDelete.setMnemonic(KeyEvent.VK_D);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
panel.add(pnlNorth, BorderLayout.NORTH);
pnlNorth.add(lblInputId);
pnlNorth.add(txtId);
pnlNorth.add(btnQuery);
pnlNorth.add(btnBrowseAll);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnDelete);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("查询结果");
pnlCenter.setBorder(tb);
studentService = new 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<String> currentRow = new Vector<String>();
currentRow.addElement(student.getId());
currentRow.addElement(student.getName());
currentRow.addElement(student.getSex());
currentRow.addElement(student.getAge() + "");
currentRow.addElement(student.getDepartment());
currentRow.addElement(student.getClazz());
currentRow.addElement(student.getTelephone());
rows.add(currentRow);
}
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有符合条件的记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
txtId.setText("");
} else {
scroller.getVerticalScrollBar().setValue(0);
}
}
public static void main(String[] args) {
new DeleteStudentByIdFrame("");
}
}
按班级删除学生记录
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;
public DeleteStudentsByClassFrame(String title) {
super(title);
intiGUI();
}
private void intiGUI() {
panel = (JPanel) getContentPane();
pnlNorth = new JPanel();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
lblInputClass = new JLabel("输入班级：");
txtClass = new JTextField(10);
txtClass.setHorizontalAlignment(JTextField.CENTER);
btnQuery = new JButton("查询[Q]");
btnQuery.setMnemonic(KeyEvent.VK_Q);
btnBrowseAll = new JButton("显示全部记录[A]");
btnBrowseAll.setMnemonic(KeyEvent.VK_A);
btnDelete = new JButton("删除查询的记录[D]");
btnDelete.setEnabled(false);// 删除按钮不可用
btnDelete.setMnemonic(KeyEvent.VK_D);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
panel.add(pnlNorth, BorderLayout.NORTH);
pnlNorth.add(lblInputClass);
pnlNorth.add(txtClass);
pnlNorth.add(btnQuery);
pnlNorth.add(btnBrowseAll);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnDelete);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("查询结果");
pnlCenter.setBorder(tb);
studentService = new 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<String> currentRow = new Vector<String>();
currentRow.addElement(student.getId());
currentRow.addElement(student.getName());
currentRow.addElement(student.getSex());
currentRow.addElement(student.getAge() + "");
currentRow.addElement(student.getDepartment());
currentRow.addElement(student.getClazz());
currentRow.addElement(student.getTelephone());
rows.add(currentRow);
}
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有符合条件的记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
txtClass.setText("");
} else {
scroller.getVerticalScrollBar().setValue(0);
}
}
public static void main(String[] args) {
new DeleteStudentsByClassFrame("");
}
}
按系部删除学生记录
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;
public DeleteStudentsByDepartmentFrame(String title) {
super(title);
intiGUI();
}
private void intiGUI() {
panel = (JPanel) getContentPane();
pnlNorth = new JPanel();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
lblInputDepartment = new JLabel("输入系部：");
txtDepartment = new JTextField(10);
txtDepartment.setHorizontalAlignment(JTextField.CENTER);
btnQuery = new JButton("查询[Q]");
btnQuery.setMnemonic(KeyEvent.VK_Q);
btnBrowseAll = new JButton("显示全部记录[A]");
btnBrowseAll.setMnemonic(KeyEvent.VK_A);
btnDelete = new JButton("删除查询的记录[D]");
btnDelete.setEnabled(false);// 删除按钮不可用
btnDelete.setMnemonic(KeyEvent.VK_D);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
panel.add(pnlNorth, BorderLayout.NORTH);
pnlNorth.add(lblInputDepartment);
pnlNorth.add(txtDepartment);
pnlNorth.add(btnQuery);
pnlNorth.add(btnBrowseAll);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnDelete);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("查询结果");
pnlCenter.setBorder(tb);
studentService = new 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<String> currentRow = new Vector<String>();
currentRow.addElement(student.getId());
currentRow.addElement(student.getName());
currentRow.addElement(student.getSex());
currentRow.addElement(student.getAge() + "");
currentRow.addElement(student.getDepartment());
currentRow.addElement(student.getClazz());
currentRow.addElement(student.getTelephone());
rows.add(currentRow);
}
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有符合条件的记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
txtDepartment.setText("");
} else {
scroller.getVerticalScrollBar().setValue(0);
}
}
public static void main(String[] args) {
new DeleteStudentsByDepartmentFrame("");
}
}
按学号查询学生记录
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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.1
*/
public class FindStudentByIdFrame extends JFrame {
private JLabel lblInputId;
private JTextField txtId;
private JPanel panel;
private JPanel pnlSouth;
private JPanel pnlCenter;
private JPanel pnlNorth;
private JButton btnQuery;
private JButton btnBrowseAll;
private JButton btnPrint;
private JButton btnExit;
private Vector rows;
private Vector<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;
public FindStudentByIdFrame(String title) {
super(title);
intiGUI();
}
private void intiGUI() {
panel = (JPanel) getContentPane();
pnlNorth = new JPanel();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
lblInputId = new JLabel("输入学号：");
txtId = new JTextField(10);
txtId.setHorizontalAlignment(JTextField.CENTER);
btnQuery = new JButton("查询[Q]");
btnQuery.setMnemonic(KeyEvent.VK_Q);
btnBrowseAll = new JButton("显示全部记录[A]");
btnBrowseAll.setMnemonic(KeyEvent.VK_A);
btnPrint = new JButton("打印[P]");
btnPrint.setMnemonic(KeyEvent.VK_D);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
panel.add(pnlNorth, BorderLayout.NORTH);
pnlNorth.add(lblInputId);
pnlNorth.add(txtId);
pnlNorth.add(btnQuery);
pnlNorth.add(btnBrowseAll);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnPrint);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("查询结果");
pnlCenter.setBorder(tb);
studentService = new 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<String> currentRow = new Vector<String>();
currentRow.addElement(student.getId());
currentRow.addElement(student.getName());
currentRow.addElement(student.getSex());
currentRow.addElement(student.getAge() + "");
currentRow.addElement(student.getDepartment());
currentRow.addElement(student.getClazz());
currentRow.addElement(student.getTelephone());
rows.add(currentRow);
}
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有符合条件的记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
txtId.setText("");
} else {
scroller.getVerticalScrollBar().setValue(0);
}
}
public static void main(String[] args) {
new FindStudentByIdFrame("");
}
}
按班级查询
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;
public FindStudentsByClassFrame(String title) {
super(title);
intiGUI();
}
private void intiGUI() {
panel = (JPanel) getContentPane();
pnlNorth = new JPanel();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
lblInputClass = new JLabel("输入班级：");
txtClass = new JTextField(10);
txtClass.setHorizontalAlignment(JTextField.CENTER);
btnQuery = new JButton("查询[Q]");
btnQuery.setMnemonic(KeyEvent.VK_Q);
btnBrowseAll = new JButton("显示全部记录[A]");
btnBrowseAll.setMnemonic(KeyEvent.VK_A);
btnPrint = new JButton("打印[P]");
btnPrint.setMnemonic(KeyEvent.VK_D);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
panel.add(pnlNorth, BorderLayout.NORTH);
pnlNorth.add(lblInputClass);
pnlNorth.add(txtClass);
pnlNorth.add(btnQuery);
pnlNorth.add(btnBrowseAll);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnPrint);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("查询结果");
pnlCenter.setBorder(tb);
studentService = new 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<String> currentRow = new Vector<String>();
currentRow.addElement(student.getId());
currentRow.addElement(student.getName());
currentRow.addElement(student.getSex());
currentRow.addElement(student.getAge() + "");
currentRow.addElement(student.getDepartment());
currentRow.addElement(student.getClazz());
currentRow.addElement(student.getTelephone());
rows.add(currentRow);
}
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有符合条件的记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
txtClass.setText("");
} else {
scroller.getVerticalScrollBar().setValue(0);
}
}
public static void main(String[] args) {
new FindStudentsByClassFrame("");
}
}
按系部查询
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.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<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;
public FindStudentsByDepartmentFrame(String title) {
super(title);
intiGUI();
}
private void intiGUI() {
panel = (JPanel) getContentPane();
pnlNorth = new JPanel();
pnlCenter = new JPanel();
pnlSouth = new JPanel();
rows = new Vector();
colHead = new Vector();
lblInputDepartment = new JLabel("输入系部：");
txtDepartment = new JTextField(10);
txtDepartment.setHorizontalAlignment(JTextField.CENTER);
btnQuery = new JButton("查询[Q]");
btnQuery.setMnemonic(KeyEvent.VK_Q);
btnBrowseAll = new JButton("显示全部记录[A]");
btnBrowseAll.setMnemonic(KeyEvent.VK_A);
btnPrint = new JButton("打印[P]");
btnPrint.setMnemonic(KeyEvent.VK_D);
btnExit = new JButton("退出[X]");
btnExit.setMnemonic(KeyEvent.VK_X);
panel.add(pnlSouth, BorderLayout.SOUTH);
panel.add(pnlCenter, BorderLayout.CENTER);
panel.add(pnlNorth, BorderLayout.NORTH);
pnlNorth.add(lblInputDepartment);
pnlNorth.add(txtDepartment);
pnlNorth.add(btnQuery);
pnlNorth.add(btnBrowseAll);
pnlSouth.setLayout(new FlowLayout(FlowLayout.RIGHT));
pnlSouth.add(btnPrint);
pnlSouth.add(btnExit);
pnlCenter.setLayout(new BorderLayout());
TitledBorder tb = new TitledBorder("查询结果");
pnlCenter.setBorder(tb);
studentService = new 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<String> currentRow = new Vector<String>();
currentRow.addElement(student.getId());
currentRow.addElement(student.getName());
currentRow.addElement(student.getSex());
currentRow.addElement(student.getAge() + "");
currentRow.addElement(student.getDepartment());
currentRow.addElement(student.getClazz());
currentRow.addElement(student.getTelephone());
rows.add(currentRow);
}
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有符合条件的记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
txtDepartment.setText("");
} else {
scroller.getVerticalScrollBar().setValue(0);
}
}
public static void main(String[] args) {
new FindStudentsByDepartmentFrame("");
}
}
按姓名查询学生记录
package net.lr.student.gui;
import net.lr.student.bean.Student;
import net.lr.student.service.StudentService;
import net.lr.student.service.impl.StudentServiceImpl;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.*;
import java.awt.event.*;
import java.awt.print.PrinterException;
import java.util.Vector;
import java.util.List;
/**
* 功能：按姓名查询学生记录
* 日期：2019.7.2
*/
public class FindStudentsByNameFrame extends JFrame {
private JLabel lblInputName;
private JTextField txtName;
private JPanel panel;
private JPanel pnlSouth;
private JPanel pnlCenter;
private JPanel pnlNorth;
private JButton btnQuery;
private JButton btnBrowseAll;
private JButton btnPrint;
private JButton btnExit;
private Vector rows;
private Vector<String> colHead;
private JTable table;
private JScrollPane scroller;
private int currentRow;
private List<Student> students;
private StudentService studentService;
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);
}
table = new JTable(rows, colHead);
scroller = new JScrollPane(table, JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED,
JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
pnlCenter.add(scroller, BorderLayout.CENTER);
repaint();
if (rows.isEmpty()) {
JOptionPane.showMessageDialog(this, "没有符合条件的记录！", "错误提示", JOptionPane.WARNING_MESSAGE);
txtName.setText("");
} else {
scroller.getVerticalScrollBar().setValue(0);
}
}
public static void main(String[] args) {
new FindStudentsByNameFrame("");
}
}
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
