【java 程序设计实训】学生请假管理系统

古城微笑少年丶 2024-03-17 13:35 54阅读 0赞

#### 学生请假管理系统 ####

*  运行结果
 *  学生请假管理系统需求分析
 *  GUI 编程
 *  事件处理
 *  数据库编程
 *  部分代码
 *   *  项目结构
     *  实体类 Admin.java
     *  LeaveData.java
     *  UserLogin.java
     *  MainWindow.java
     *  leaveList.java
 *  注：完整内容可下载查看完整报告

声明：未经允许，请勿转载

## 运行结果 ##

![在这里插入图片描述][bbdd9c11f51741aaa16fc5e8b7de80e8.png]  
![在这里插入图片描述][89e34e762d68407ca4aa297aca775a07.png]  
![在这里插入图片描述][e3de208505e84d628e814c54ce486a88.png]  
![在这里插入图片描述][acb2ee2b423b4c45a919445b92c78305.png]  
![在这里插入图片描述][325c3cdd7cf64ce09642e4f1df561a32.png]  
![在这里插入图片描述][34b08d984e1f46e48dd6dcfb4e009ade.png]  
![在这里插入图片描述][5a57f6716eb240a2b48a9e5063c02b39.png]  
![在这里插入图片描述][b01985e8c6f540f69f85903c605f1f9c.png]

## 学生请假管理系统需求分析 ##

![在这里插入图片描述][74567ef03b38485e886828ff3e0919b7.png]

![在这里插入图片描述][035706b64caf47c89d04947fea4e9760.png]  
![在这里插入图片描述][1322341fb5bd4e5e97bdd55dd92e9e07.png]

![在这里插入图片描述][38ba828413404f2586edbd30eee5ee9c.png]

## GUI 编程 ##

![在这里插入图片描述][2b0f614b13764ffd9c509b432b7181dd.png]  
![在这里插入图片描述][709322afd8b3483297f32dd619b75df6.png]  
![在这里插入图片描述][f20d439b22be4162b05246ab1cc5ec97.png]  
![在这里插入图片描述][36b24fef703943f2b316fe1ef9f67140.png]  
![在这里插入图片描述][0f81ab6294f246d5a291891f89af1871.png]

## 事件处理 ##

![在这里插入图片描述][8bf40dea37fd43a9a0d3d37018631515.png]  
![在这里插入图片描述][c96c813511c54274be02322ea775509d.png]  
![在这里插入图片描述][c2f31e5b0f6241a1a4b399928439674b.png]  
![在这里插入图片描述][f4493cee685d455d9a750f95c589728b.png]  
![在这里插入图片描述][825d0e16d19441d6b0448008ce52d22e.png]  
![12c8371b89264a92a89e0f8bb7a11aa2.png][]  
![在这里插入图片描述][7825cf71c49440179265cad6cf698053.png]  
![在这里插入图片描述][ae776d04a1284c6dbff3ec0910e21db1.png]  
![在这里插入图片描述][c6cf6581a6c84816bdf9ec12d34cdeee.png]  
![在这里插入图片描述][a7a33b0fecba437e9918e9721b54f7ea.png]  
![在这里插入图片描述][4d1243b458ab44639e0f6b5eb5916c8a.png]  
![在这里插入图片描述][562f7625b39547d78731667dddd5a623.png]  
![在这里插入图片描述][d6b280ef004549f1b353ef4fd6647a32.png]

## 数据库编程 ##

![在这里插入图片描述][0df3a5d43f5546ef802fcfada3b4ff32.png]  
![在这里插入图片描述][236f81de78e34caa87ea8a6d6f28506a.png]  
![在这里插入图片描述][3c60180622174f33ab2f06c2acf66cba.png]

![在这里插入图片描述][245f000d04b64fca81a415c4aa334e64.png]  
![在这里插入图片描述][ccb8f6e5d9f24afcb055b8f7ef56acd5.png]

## 部分代码 ##

### 项目结构 ###

![在这里插入图片描述][7aa5d4739d1c4764b06077810293553c.png]

### 实体类 Admin.java ###

package info;
    
    public class Admin {
        
        //管理员信息类
        private String UserIdentity; //用户身份，用于判断登录用户是学生Student还是教师Teacher还是管理员Admin
        private String id; // 工号,即用户账号
        private String password; //用户密码
        private String name; // 姓名
        private String sex; // 性别
        private String age; //年龄
        private String jobTitle; //职称
        private String Phone;//联系电话
        private String address; // 家庭住址
    
        // 2120220087 010718 小庄 男 21 电气与计算机工程学院 教师  15018722839 广东省广州市
    //("Admin"," 2120220087 ","1 ","小庄"," 男 ","21 "," 教务处主任"," 15018722839"," 广东省广州市");
        public Admin() {
        
        }
    
        public Admin(String userIdentity, String id, String password, String name, String sex, String age, String jobTitle, String phone, String address) {
        
            this.UserIdentity = userIdentity;
            this.id = id;
            this.password = password;
            this.name = name;
            this.sex = sex;
            this.age = age;
            this.jobTitle = jobTitle;
            this.Phone = phone;
            this.address = address;
        }
    
        public String getUserIdentity() {
        
            return UserIdentity;
        }
    
        public void setUserIdentity(String userIdentity) {
        
            UserIdentity = userIdentity;
        }
    
        public String getId() {
        
            return id;
        }
    
        public void setId(String id) {
        
            this.id = id;
        }
    
        public String getPassword() {
        
            return password;
        }
    
        public void setPassword(String password) {
        
            this.password = password;
        }
    
        public String getName() {
        
            return name;
        }
    
        public void setName(String name) {
        
            this.name = name;
        }
    
        public String getSex() {
        
            return sex;
        }
    
        public void setSex(String sex) {
        
            this.sex = sex;
        }
    
        public String getAge() {
        
            return age;
        }
    
        public void setAge(String age) {
        
            this.age = age;
        }
    
        public String getJobTitle() {
        
            return jobTitle;
        }
    
        public void setJobTitle(String jobTitle) {
        
            this.jobTitle = jobTitle;
        }
    
        public String getPhone() {
        
            return Phone;
        }
    
        public void setPhone(String phone) {
        
            Phone = phone;
        }
    
        public String getAddress() {
        
            return address;
        }
    
        public void setAddress(String address) {
        
            this.address = address;
        }
    }

### LeaveData.java ###

package info;
    
    public class LeaveData {
        
        //请假信息表单
        private String num; // 编号
        private String name; // 姓名
        private String ID; // 学号
        private String sex;//性别
        private String age;//年龄
        private String faculties; // 所在院系
        private String profession;//专业名称
        private String className; // 班级名称
        private String Phone;//联系电话
        private String requestData; //申请日期
        private String StartTime; // 开始时间
        private String EndEime; // 结束时间
        private String reason;//申请理由
        private String Approver;//审核人
        private String ApprovalReason; //审核意见
        private String state;//状态
    
        /**
         * 状态：
         * 编辑保存  ----未提交
         * 请假----请假申请中
         * 请假审批通过 ---请假成功
         * 请假审批不通过--请假失败
         * 销假 ---销假申请中
         * 销假审批通过--销假成功
         * 销假审批不通过---销假失败
         */
    
        public LeaveData() {
        
        }
    
        public LeaveData(String num, String name, String ID, String sex, String age, String faculties, String profession,
                         String className, String phone, String requestData, String startTime, String endEime, String approver,
                         String approvalReason, String reason, String state) {
        
            this.num = num;
            this.name = name;
            this.ID = ID;
            this.sex = sex;
            this.age = age;
            this.faculties = faculties;
            this.profession = profession;
            this.className = className;
            this.Phone = phone;
            this.requestData = requestData;
            this.StartTime = startTime;
            this.EndEime = endEime;
            this.Approver = approver;
            this.ApprovalReason = approvalReason;
            this.reason = reason;
            this.state = state;
        }
    
        public String getNum() {
        
            return num;
        }
    
        public void setNum(String num) {
        
            this.num = num;
        }
    
        public String getName() {
        
            return name;
        }
    
        public void setName(String name) {
        
            this.name = name;
        }
    
        public String getID() {
        
            return ID;
        }
    
        public void setID(String ID) {
        
            this.ID = ID;
        }
    
        public String getSex() {
        
            return sex;
        }
    
        public void setSex(String sex) {
        
            this.sex = sex;
        }
    
        public String getAge() {
        
            return age;
        }
    
        public void setAge(String age) {
        
            this.age = age;
        }
    
        public String getFaculties() {
        
            return faculties;
        }
    
        public void setFaculties(String faculties) {
        
            this.faculties = faculties;
        }
    
        public String getProfession() {
        
            return profession;
        }
    
        public void setProfession(String profession) {
        
            this.profession = profession;
        }
    
        public String getClassName() {
        
            return className;
        }
    
        public void setClassName(String className) {
        
            this.className = className;
        }
    
        public String getPhone() {
        
            return Phone;
        }
    
        public void setPhone(String phone) {
        
            Phone = phone;
        }
    
        public String getRequestData() {
        
            return requestData;
        }
    
        public void setRequestData(String requestData) {
        
            this.requestData = requestData;
        }
    
        public String getStartTime() {
        
            return StartTime;
        }
    
        public void setStartTime(String startTime) {
        
            StartTime = startTime;
        }
    
        public String getEndEime() {
        
            return EndEime;
        }
    
        public void setEndEime(String endEime) {
        
            EndEime = endEime;
        }
    
        public String getReason() {
        
            return reason;
        }
    
        public void setReason(String reason) {
        
            this.reason = reason;
        }
    
        public String getApprover() {
        
            return Approver;
        }
    
        public void setApprover(String approver) {
        
            Approver = approver;
        }
    
        public String getApprovalReason() {
        
            return ApprovalReason;
        }
    
        public void setApprovalReason(String approvalReason) {
        
            ApprovalReason = approvalReason;
        }
    
        public String getState() {
        
            return state;
        }
    
        public void setState(String state) {
        
            this.state = state;
        }
    }

### UserLogin.java ###

package GUI;
    
    import info.Admin;
    import info.Student;
    import info.Teacher;
    import info.User;
    
    import javax.swing.*;
    import javax.swing.event.DocumentEvent;
    import javax.swing.plaf.FontUIResource;
    import java.awt.*;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.sql.Connection;
    import java.sql.ResultSet;
    import java.sql.SQLException;
    import java.sql.Statement;
    import java.util.Enumeration;
    import java.util.Objects;
    
    import static toolbox.LeaveDataBase.getConnection;
    
    public class UserLogin extends JFrame implements ActionListener {
        
        private JTextField fieldAccount = new JTextField(); //账号输入框文本
        private JPasswordField fieldPassword = new JPasswordField();//密码输入框文本
        private JButton buttonLogin = new JButton("登  录");
        static User user = new User();//用于存储登录者的账户密码及身份
    
        Admin admin;
        Teacher teacher;
        Student student;
    
        public static void main(String[] args) {
        
            initGobalFont(new Font("宋体", Font.PLAIN, 12));
            try {
        
                //org.jb2011.lnf.beautyeye.BeautyEyeLNFHelper.launchBeautyEyeLNF();
                new UserLogin();
            } catch (Exception e) {
        
                e.printStackTrace();
            }
        }
    
        public UserLogin() {
        
            this.setTitle("登录系统");
            this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口
            this.setBounds(500, 150, 630, 450);//设置页面大小
            this.setResizable(false);//设置页面不可拖拽改变大小
            this.setLocationRelativeTo(null); // 设置登录界面居中
            this.getContentPane().setLayout(null);
            this.setVisible(true);
    
            JLabel titleLabel = new JLabel("学生请假管理系统");
            titleLabel.setFont(new Font("华文行楷", Font.PLAIN, 30));
            titleLabel.setIcon(new ImageIcon(Objects.requireNonNull(UserLogin.class.getResource("/images/logo.png"))));
            titleLabel.setBounds(150, 70, 350, 65);
            this.getContentPane().add(titleLabel);
    
            //用户账号
            JLabel labelAccount = new JLabel("账号：");
            labelAccount.setFont(new Font("宋体", Font.PLAIN, 20));
            labelAccount.setAlignmentY(CENTER_ALIGNMENT);
            labelAccount.setIcon(new ImageIcon(Objects.requireNonNull(UserLogin.class.getResource("/images/userName.png"))));
            labelAccount.setBounds(150, 172, 81, 30);
            fieldAccount.setBounds(243, 172, 200, 30);
            //fieldAccount.setText("1");///==========
            this.getContentPane().add(labelAccount);
            this.getContentPane().add(fieldAccount, BorderLayout.CENTER);
            fieldAccount.getDocument().addDocumentListener(new javax.swing.event.DocumentListener() {
        
                                                               public void changedUpdate(DocumentEvent e) {
        //这是更改操作的处理
                                                                   user.setAccount(fieldAccount.getText().trim());//trim()方法用于去掉你可能误输入的空格号
                                                               }
    
                                                               public void insertUpdate(DocumentEvent e) {
        //这是插入操作的处理
                                                                   user.setAccount(fieldAccount.getText().trim());
                                                               }
    
                                                               public void removeUpdate(DocumentEvent e) {
        //这是删除操作的处理
                                                                   user.setAccount(fieldAccount.getText().trim());
                                                               }
                                                           }
            );
    
    
            // 用户密码
            JLabel labelPwd = new JLabel("密码：");
            labelPwd.setFont(new Font("宋体", Font.PLAIN, 20));
            labelPwd.setAlignmentY(CENTER_ALIGNMENT);
            labelPwd.setIcon(new ImageIcon(Objects.requireNonNull(UserLogin.class.getResource("/images/password.png"))));
            labelPwd.setBounds(150, 222, 81, 30);
            fieldPassword.setBounds(243, 222, 200, 30);
            //fieldPassword.setText("1");///
            this.getContentPane().add(labelPwd);
            this.getContentPane().add(fieldPassword, BorderLayout.CENTER);
            fieldPassword.getDocument().addDocumentListener(new javax.swing.event.DocumentListener() {
        
                                                                public void changedUpdate(DocumentEvent e) {
        //这是更改操作的处理
                                                                    user.setPassword(fieldPassword.getText().trim());//trim()方法用于去掉你可能误输入的空格号
                                                                }
    
                                                                public void insertUpdate(DocumentEvent e) {
        //这是插入操作的处理
                                                                    user.setPassword(fieldPassword.getText().trim());
                                                                }
    
                                                                public void removeUpdate(DocumentEvent e) {
        //这是删除操作的处理
                                                                    user.setPassword(fieldPassword.getText().trim());
                                                                }
                                                            }
            );
    
            // 登陆按钮
            buttonLogin.setBounds(275, 282, 95, 30);
            buttonLogin.setFont(new Font("宋体", Font.PLAIN, 13));
            buttonLogin.setIcon(new ImageIcon(Objects.requireNonNull(UserLogin.class.getResource("/images/login.png"))));
            this.getContentPane().add(buttonLogin);
            //去掉按钮文字周围的焦点框
            buttonLogin.setFocusPainted(false);
            buttonLogin.addActionListener(this);
            this.setVisible(true);
            this.revalidate();
            this.repaint();
        }
    
        @Override
        public void actionPerformed(ActionEvent e) {
        
            if (e.getSource() == buttonLogin) {
        
    
                boolean LoginUser = false;
                try {
        
                    LoginUser = verifyAccount(user.getAccount(), user.getPassword());
                } catch (SQLException ex) {
        
                    throw new RuntimeException(ex);
                }
                if (LoginUser) {
        
                    //判断权限，加载相应面板
                    if (user.getUserIdentity().equals("Student")) {
        
                        JOptionPane.showMessageDialog(this, "账号密码正确，即将进入系统学生端！", "提示", JOptionPane.INFORMATION_MESSAGE);// 提示
                        new MainWindow(student);
                    } else if (user.getUserIdentity().equals("Teacher")) {
        
                        JOptionPane.showMessageDialog(this, "账号密码正确，即将进入系统教师端！", "提示", JOptionPane.INFORMATION_MESSAGE);//
                        new MainWindow(teacher);
                    } else if (user.getUserIdentity().equals("Admin")) {
        
                        JOptionPane.showMessageDialog(this, "账号密码正确，即将进入系统管理端！", "提示", JOptionPane.INFORMATION_MESSAGE);//
                        new MainWindow(admin);
                    }
                    this.dispose(); // 关闭当前窗口
                }
            }
        }
    
    
        private boolean verifyAccount(String account, String password) throws SQLException {
        
            // 判断输入账号或密码为空与空格的情况
            if (account == null || "".equals(account.trim()) || password == null || "".equals(password.trim())) {
        
                // 警示框,"Title",JOptionPane.WARNING_MESSAGE
                JOptionPane.showMessageDialog(null, "账号与密码均不能为空！", "警告", JOptionPane.WARNING_MESSAGE);
            } else {
        
                Connection conn = getConnection();
                Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
                //查询学生表
                ResultSet rs = stmt.executeQuery("SELECT *FROM StudentList WHERE id = '" + account + "' AND password = '" + password + "';");
                if (!rs.isBeforeFirst()) {
        
                    //若学生表中不存在，则查询教师表
                    rs = stmt.executeQuery("SELECT *FROM TeacherList WHERE id = '" + account + "' AND password = '" + password + "';");
                }
                if (!rs.isBeforeFirst()) {
        
                    //若学生表与教师表中不存在，则查询管理员表
                    rs = stmt.executeQuery("SELECT *FROM AdminList WHERE id = '" + account + "' AND password = '" + password + "';");
                }
                if (!rs.isBeforeFirst()) {
        
                    //若学生表与教师表与管理员表中不存在，则提示账户密码错误
                    //错误提示框,"Title",JOptionPane.ERROR_MESSAGE
                    JOptionPane.showMessageDialog(this, "账号密码错误，请重新登录！", "警告", JOptionPane.ERROR_MESSAGE);
                    fieldPassword.setText(null);
                    return false;
                }
                while (rs.next()) {
        
                    user.setUserIdentity(rs.getString(1));
                    //创建对应身份信息的实体类并赋值
                    if (user.getUserIdentity().equals("Student")) {
        
    
                        student = new Student(rs.getString(1),
                                rs.getString(2),
                                rs.getString(3),
                                rs.getString(4),
                                rs.getString(5),
                                rs.getString(6),
                                rs.getString(7),
                                rs.getString(8),
                                rs.getString(9),
                                rs.getString(10),
                                rs.getString(11));
                    } else if (user.getUserIdentity().equals("Teacher")) {
        
    
                        teacher = new Teacher(rs.getString(1),
                                rs.getString(2),
                                rs.getString(3),
                                rs.getString(4),
                                rs.getString(5),
                                rs.getString(6),
                                rs.getString(7),
                                rs.getString(8),
                                rs.getString(9),
                                rs.getString(10));
                    } else if (user.getUserIdentity().equals("Admin")) {
        
    
                        admin = new Admin(rs.getString(1),
                                rs.getString(2),
                                rs.getString(3),
                                rs.getString(4),
                                rs.getString(5),
                                rs.getString(6),
                                rs.getString(7),
                                rs.getString(8),
                                rs.getString(9));
                    }
                }
                rs.close();
                stmt.close();
                return true;
            }
            return false;
        }
    
        //全局字体 https://blog.csdn.net/lifaxing/article/details/79365078
        public static void initGobalFont(Font font) {
        
            FontUIResource fontResource = new FontUIResource(font);
            for (Enumeration<Object> keys = UIManager.getDefaults().keys(); keys.hasMoreElements(); ) {
        
                Object key = keys.nextElement();
                Object value = UIManager.get(key);
                if (value instanceof FontUIResource) {
        
                    UIManager.put(key, fontResource);
                }
            }
        }
    }

### MainWindow.java ###

package GUI;
    
    import info.Admin;
    import info.Student;
    import info.Teacher;
    import panel.PanelAdmin;
    import panel.PanelStudent;
    import panel.PanelTeacher;
    
    import javax.swing.*;
    import javax.swing.border.EtchedBorder;
    import java.awt.*;
    import java.awt.event.ActionEvent;
    import java.awt.event.ActionListener;
    import java.util.Objects;
    
    public class MainWindow {
        
        public static JFrame frame;
        public static JTabbedPane tabbedPane;
        public static JLabel label_status;
        private JMenuBar menuBar;
        private JMenuItem mntmNewMenuItem_exit, menuItem_setting, mntmNewMenuItem_help;
        private JPanel panel_status; //登录状态
    
        //参数 学生
        public MainWindow(Student student) {
        
            windowLoads();
            new PanelStudent(student);
        }
    
        //参数 教师
        public MainWindow(Teacher teacher) {
        
            windowLoads();
            new PanelTeacher(teacher);
        }
    
        //参数 管理员
        public MainWindow(Admin admin) {
        
            windowLoads();
            new PanelAdmin();
        }
    
    
        private void windowLoads() {
        
            frame = new JFrame();
            // 设置窗口标题图标
            frame.setIconImage(Toolkit.getDefaultToolkit().getImage("C:\\Users\\ZHUANG\\Desktop\\LeaveSystem1\\LeaveSystem\\src\\images\\icon.png"));
            frame.setTitle("学生请假管理系统");
            frame.setBounds(0, 0, 820, 626);
            frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);//关闭窗口
            frame.getContentPane().setLayout(null);
            frame.setVisible(true);
            tabbedPane = new JTabbedPane(JTabbedPane.TOP);
            tabbedPane.setBounds(0, 30, 820, 522);
            frame.getContentPane().add(tabbedPane);
            frame.setResizable(false);//设置页面不可拖拽改变大小
            frame.setLocationRelativeTo(null); // 设置登录界面居中
    
            // 系统菜单
            menuBar = new JMenuBar();
            menuBar.setBounds(0, 0, 820, 21);
            frame.getContentPane().add(menuBar);
    
            JMenu mnNewMenu = new JMenu("系统");
            menuBar.add(mnNewMenu);
            mnNewMenu.setIcon(new ImageIcon(Objects.requireNonNull(UserLogin.class.getResource("/images/base.png"))));
    
            menuItem_setting = new JMenuItem("设置");
            mnNewMenu.add(menuItem_setting);
    
            mntmNewMenuItem_exit = new JMenuItem("直接退出");
            mnNewMenu.add(mntmNewMenuItem_exit);
            mntmNewMenuItem_exit.addActionListener(new ActionListener() {
        
                @Override
                public void actionPerformed(ActionEvent e) {
        
                    Object[] options = {
        "确认", "取消"};        //定义按钮上的文字
                    int n = JOptionPane.showOptionDialog(null, "是否退出本账户？", "提示", JOptionPane.YES_NO_OPTION, JOptionPane.QUESTION_MESSAGE, null, options, options[1]);
                    if (n == 0) {
        
                        frame.dispose();
                        new UserLogin();
                    }
                }
            });
    
            JMenu mnNewMenu_1 = new JMenu("关于");
            menuBar.add(mnNewMenu_1);
    
            mntmNewMenuItem_help = new JMenuItem("帮助");
            mnNewMenu_1.add(mntmNewMenuItem_help);
    
            //状态栏
            panel_status = new JPanel();
            panel_status.setLocation(0, 570);
            panel_status.setSize(820, 22);
            panel_status.setBorder(new EtchedBorder(EtchedBorder.LOWERED, null, null));//边框
            frame.getContentPane().add(panel_status);
            label_status = new JLabel("登录成功");
            label_status.setBounds(207, 1, 820, 25);
            JProgressBar progressBar = new JProgressBar();
            progressBar.setBounds(0, 1, 200, 25);
            panel_status.setLayout(null);
            panel_status.add(label_status);
            panel_status.add(progressBar);
            frame.setVisible(true);
    
        }
    
    }

### leaveList.java ###

package Functional.Student;
    
    import info.LeaveData;
    import info.Student;
    
    import javax.swing.*;
    import javax.swing.table.DefaultTableCellRenderer;
    import javax.swing.table.DefaultTableModel;
    import java.awt.*;
    import java.awt.event.MouseAdapter;
    import java.sql.Connection;
    import java.sql.ResultSet;
    import java.sql.Statement;
    import java.util.ArrayList;
    import java.util.List;
    
    import static toolbox.LeaveDataBase.getConnection;
    
    public class leaveList extends JFrame {
        
    
        public leaveList(Student student) {
        
            List<LeaveData> dataList = new ArrayList<LeaveData>();
            try {
        
                //查询数据库对应该学生学号的数据
                Connection conn = getConnection();
                Statement stmt = null;
                stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
                ResultSet rs = stmt.executeQuery("SELECT *FROM LeaveData WHERE id='" + student.getId() + "';");
                if (rs.isBeforeFirst()) {
        
                    while (rs.next()) {
        
                        LeaveData leaveData = new LeaveData();
                        leaveData.setNum(rs.getString(1));
                        leaveData.setName(rs.getString(2));
                        leaveData.setID(rs.getString(3));
                        leaveData.setSex(rs.getString(4));
                        leaveData.setAge(rs.getString(5));
                        leaveData.setFaculties(rs.getString(6));
                        leaveData.setProfession(rs.getString(7));
                        leaveData.setClassName(rs.getString(8));
                        leaveData.setPhone(rs.getString(9));
                        leaveData.setRequestData(rs.getString(10));
                        leaveData.setStartTime(rs.getString(11));
                        leaveData.setEndEime(rs.getString(12));
                        leaveData.setReason(rs.getString(13));
                        leaveData.setApprover(rs.getString(14));
                        leaveData.setApprovalReason(rs.getString(15));
                        leaveData.setState(rs.getString(16));
                        dataList.add(leaveData);
                    }
                } else {
        
                    JOptionPane.showMessageDialog(this, "无请假历史数据！", "提示", JOptionPane.ERROR_MESSAGE);
                }
                rs.close();
                stmt.close();
            } catch (Exception ex) {
        
                throw new RuntimeException(ex);
            }
    
    
            String[] columnName = new String[]{
        "编号", "申请日期", "开始时间", "结束时间", "申请理由", "审核人", "审核意见", "状态"};
            String[][] columnDate = new String[dataList.size()][];
            for (int i = 0; i < dataList.size(); i++) {
        
                LeaveData d = dataList.get(i);
                columnDate[i] = new String[]{
        d.getNum(), d.getRequestData(), d.getStartTime(), d.getEndEime(), d.getReason(), d.getApprover(), d.getApprovalReason(), d.getState()};
            }
    
            this.setLayout(null); // 绝对布局
            setSize(680, 522); // 设置界面大小
            this.setVisible(true);
            this.setTitle("查询");
            setResizable(false); // 设置界面大小不可改变
            setLocationRelativeTo(null); // 设置登录界面居中
            this.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE); // 设置默认关闭操作
    
            JLabel title = new JLabel("请假信息列表");
            title.setFont(new Font("宋体", Font.PLAIN, 22));
            title.setBounds(260, 10, 180, 50);
            this.add(title);
    
            DefaultTableModel dtm = new DefaultTableModel(columnDate, columnName);
            JTable jtable = new JTable(dtm) {
        
                //可选择表格行，但不可编辑
                public boolean isCellEditable(int row, int column) {
        
                    return false;
                }
            };
            jtable.setShowVerticalLines(false); //去掉竖线
            DefaultTableCellRenderer r = new DefaultTableCellRenderer(); //此三行 内容居中
            r.setHorizontalAlignment(JLabel.CENTER);
            jtable.getTableHeader().setReorderingAllowed(false);//  表头不可拖动
            jtable.setDefaultRenderer(Object.class, r);
            JScrollPane scrollPane = new JScrollPane(); //直接添加容器，表头不显示
            scrollPane.setBounds(30, 70, 600, 370);
            this.add(scrollPane);
            scrollPane.setViewportView(jtable);
    
            //给table加上一个鼠标事件监听器对象
            jtable.addMouseListener(new MouseAdapter() {
        
                public void mouseReleased(java.awt.event.MouseEvent e) {
        
                    //是否左建双击
                    if (e.getClickCount() == 2 && SwingUtilities.isLeftMouseButton(e)) {
        
                        //添加双击后的
                        int count = jtable.getSelectedRow();//获取你选中的行号
                        String[] datarow = new String[]{
        "", "", "", "", "", "", "", ""};
                        for (int i = 0; i < datarow.length; i++) {
        
                            String getname = jtable.getValueAt(count, i).toString();//读取获取行号的某一列的值
                            datarow[i] = getname;
                        }
                        new JtablePopUps(datarow);
                    }
                }
            });
    
            JLabel tip = new JLabel("tip:双击表行可以查看其详细信息！");
            tip.setFont(new Font("宋体", Font.PLAIN, 12));
            tip.setBounds(30, 435, 300, 50);
            this.add(tip);
        }
    }

## 注：完整内容可下载查看完整报告 ##

[下载链接][Link 1]  
https://download.csdn.net/download/weixin\_66397563/87976888

[bbdd9c11f51741aaa16fc5e8b7de80e8.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/f56142b7204e4ce590e7c39fdfa6a118.png
[89e34e762d68407ca4aa297aca775a07.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/10f08e080e16467eb454d0ff8222b942.png
[e3de208505e84d628e814c54ce486a88.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/5ccf2455399e43528fe16524e0d601ac.png
[acb2ee2b423b4c45a919445b92c78305.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/7954b4faf04a43969979de524532643a.png
[325c3cdd7cf64ce09642e4f1df561a32.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/adeb754fc5094e5b81cb0d63a3d0c3ef.png
[34b08d984e1f46e48dd6dcfb4e009ade.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/3ba50caf01454e72831d28c479d588e1.png
[5a57f6716eb240a2b48a9e5063c02b39.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/69c130fa600a44d2a234be5516c9bd6d.png
[b01985e8c6f540f69f85903c605f1f9c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/d9af0ee66dc2433788dbb00487db1ea1.png
[74567ef03b38485e886828ff3e0919b7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/229d9bdcba6046249e2407261908c63f.png
[035706b64caf47c89d04947fea4e9760.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/a33b43f69abe4ad39584170fb85d60ac.png
[1322341fb5bd4e5e97bdd55dd92e9e07.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/bde4f7e275f24c18a40b78445d81eb06.png
[38ba828413404f2586edbd30eee5ee9c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/a1d8e81077d1422b9ed034c1486c33e4.png
[2b0f614b13764ffd9c509b432b7181dd.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/88c22a1317614fbab614dfde58f00179.png
[709322afd8b3483297f32dd619b75df6.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/003fe04c91b340038bc451a79dc5d689.png
[f20d439b22be4162b05246ab1cc5ec97.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/78f70edac3644324b2503e190537fc14.png
[36b24fef703943f2b316fe1ef9f67140.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/ac830cb10c3a44718350ef477741e015.png
[0f81ab6294f246d5a291891f89af1871.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/baab3bd68bf347189f1abb6cdbe2b879.png
[8bf40dea37fd43a9a0d3d37018631515.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/04f1991ff7bd4fdea73c00985f2252fe.png
[c96c813511c54274be02322ea775509d.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/7a524c93dee34e74838cbcb08ef10c38.png
[c2f31e5b0f6241a1a4b399928439674b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/000c1e89121848279b8be6d4b663e227.png
[f4493cee685d455d9a750f95c589728b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/82bd64d9624f4596a1d71bdc2b934117.png
[825d0e16d19441d6b0448008ce52d22e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/dd9bccf5ff6242968dcd7624f1bd783d.png
[12c8371b89264a92a89e0f8bb7a11aa2.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b97f440ecc124688b195b9551cb8a38f.png
[7825cf71c49440179265cad6cf698053.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/d2f83b89cd52450592ae1bf807428d0c.png
[ae776d04a1284c6dbff3ec0910e21db1.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/786babb7235a4bffbea3c2e38096f1aa.png
[c6cf6581a6c84816bdf9ec12d34cdeee.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/e651f530174c4a148f7bc0a3f552a74a.png
[a7a33b0fecba437e9918e9721b54f7ea.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/68df3ecee4c7462fac6981e1f2ef4d01.png
[4d1243b458ab44639e0f6b5eb5916c8a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b727fa31b0db4d1d817793b9b573859d.png
[562f7625b39547d78731667dddd5a623.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/2734b9186daa41eb842621796fb089c3.png
[d6b280ef004549f1b353ef4fd6647a32.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b4d16bbfc586482ca2468be8452de626.png
[0df3a5d43f5546ef802fcfada3b4ff32.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/ecff738b85134421bd765012bc80d25e.png
[236f81de78e34caa87ea8a6d6f28506a.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/9a25084552204b2d88d741311c52d495.png
[3c60180622174f33ab2f06c2acf66cba.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/0c02b84316f6491b8898fb11bc427bdf.png
[245f000d04b64fca81a415c4aa334e64.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/b26383264e874f76807e1d4822589d98.png
[ccb8f6e5d9f24afcb055b8f7ef56acd5.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/d4f6fdd2b6db4ec6bb8502f6cbd99bc9.png
[7aa5d4739d1c4764b06077810293553c.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/15/01f6390dc77341d295cdac5bfe8c3692.png
[Link 1]: https://download.csdn.net/download/weixin_66397563/87976888