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

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 "\n密码:" 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);

    }
}