学生管理系统（MySQL）v1.0 第七天

1、创建按班级查询学生窗口FindStudentsByClass

package net.student.gui;

import net.student.bean.Student;
import net.student.service.StudentService;
import net.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 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("");
}
}
运行程序，测试结果如下：

2、创建按系部查询学生窗口FindStudentsByDepartment

package net.student.gui;

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