java实验室预约管理系统（源码+数据库脚本）

代码说明：

随着高校教学资源逐步开发，高校教育资源的应用种类逐步增多。而实验室作为高校基本教育资源之一，与日常教学工作开展、课堂项目实践有着密切联系。由此，如何借助新时期技术，加强高校实验室应用数据信息程序开发，在高校智能化管理程序推广中占有基础性地位。该软件是以Java语言为实现预言。其功能在系统内部有源代码直接完成，操作人员只需输入一些简单的汉字，数字，即可达到自己的目标。 登陆账号：admin 密码：123456 package com.company; import com.company.Bean.Student;import com.company.Bean.Teacher;import com.company.Bean.User;import com.company.DB.DB; import javax.swing.*;import java.awt.event.ActionEvent;import java.awt.event.ActionListener; public class Main extends JFrame {    private JPanel p;    private JLabel lblName,lblPwd,lblRole;    private JTextField txtName;    private JPasswordField txtPwd;    private JButton btnOk,btnCancle;    String[] s = {"学生","教师","管理员"};    private JComboBox comboBox;    public Main(){        super("用户登录界面");        p = new JPanel();        p.setLayout(null);        lblRole=new JLabel("角色：");        comboBox=new JComboBox(s);        lblName = new JLabel("账户：");        lblPwd = new JLabel("密码：");        txtName = new JTextField(20);        txtPwd = new JPasswordField(20);        btnOk = new JButton("登录");        btnCancle = new JButton("取消");        //注册确定按钮的事件处理        btnOk.addActionListener(new ActionListener() {            @Override            public void actionPerformed(ActionEvent e) {                String strName = txtName.getText();                String strPwd = new String(txtPwd.getPassword());                System.out.println("用户名:" strName "密码:" strPwd);             }        });        //注册取消按钮的事件处理        btnCancle.addActionListener(new ActionListener() {             @Override            public void actionPerformed(ActionEvent e) {                //清空                txtName.setText("");                txtPwd.setText("");             }        });        lblRole.setBounds(90,50,60,25);        comboBox.setBounds(130,50,140,25);        lblName.setBounds(90,80,60,25);        txtName.setBounds(130,80,140,25);        lblPwd.setBounds(90,110,60,25);        txtPwd.setBounds(130,110,140,25);        btnOk.setBounds(130,150,60,25);        btnCancle.setBounds(200,150,60,25);        p.add(lblRole);        p.add(comboBox);        p.add(lblName);        p.add(txtName);        p.add(lblPwd);        p.add(txtPwd);        p.add(btnOk);        p.add(btnCancle);        this.add(p);        this.setSize(400,300);        this.setLocation(300,300);        //设置窗体不可改变大小        this.setResizable(false);        this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);        btnOk.addActionListener(new ActionListener() {            @Override            public void actionPerformed(ActionEvent e) {               String account =txtName.getText().trim();               String password=txtPwd.getText().trim();               String role=null;               if(comboBox.getSelectedItem().equals("管理员")){                   role="admin";               }               else if(comboBox.getSelectedItem().equals("学生")) {                   role="student";               }               else{                   role="teacher";               }                if(role.equals("admin")){                    User user=new User(account,password);                    if (DB.Login(user)) {                        JOptionPane.showMessageDialog(null, "登录成功", "", JOptionPane.PLAIN_MESSAGE);                        AdminMain adminMain = new AdminMain();                        adminMain.setVisible(true);                        Main.this.setVisible(false);                    }                      else {                        JOptionPane.showMessageDialog(null,"账号密码错误", "", JOptionPane.PLAIN_MESSAGE);                    }                }                else if (role.equals("student")){                    Student student=new Student(account,password);                    if(DB.studentLogin(student)){                        StudentMain studentMain=new  StudentMain();                        studentMain.setVisible(true);                        Main.this.setVisible(false);                        JOptionPane.showMessageDialog(null, "登录成功", "", JOptionPane.PLAIN_MESSAGE);                    }                    else {                        JOptionPane.showMessageDialog(null,"账号密码错误", "", JOptionPane.PLAIN_MESSAGE);                    }                }                else if (role.equals("teacher")){                   Teacher teacher=new Teacher(account,password);                    if(DB.teacherLogin(teacher)){                        TeacherMain teacherMain=new TeacherMain();                        teacherMain.setVisible(true);                        Main.this.setVisible(false);                        JOptionPane.showMessageDialog(null, "登录成功", "", JOptionPane.PLAIN_MESSAGE);                    }                    else {                        JOptionPane.showMessageDialog(null,"账号密码错误", "", JOptionPane.PLAIN_MESSAGE);                    }                }            }        });        btnCancle.addActionListener(new ActionListener() {            @Override            public void actionPerformed(ActionEvent e) {                            }        });    }    public static void main(String[] args) { // write your code here        Main main=new Main();        main.setVisible(true);     }}