adminmanageframe.java

酒店管理系统后台数据库存储过程

package operation;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import java.awt.GridLayout;
import javax.swing.JPanel;
import java.awt.CardLayout;
import java.awt.*;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import entity.DBOperatorBean;
import java.sql.ResultSet;
import java.sql.*;

/**
 * <p>Title: 山海假日酒点信息管理系统</p>
 *
 * <p>Description: 小型酒店信息管理软件</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: FZ编程小组</p>
 *
 * @author not attributable
 * @version 1.0
 */
public class AdminManageFrame extends JFrame {
    public AdminManageFrame() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(borderLayout1);
        PanAdmin.setLayout(null);
        btnupdate.setBackground(new Color(212, 255, 255));
        btnupdate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnupdate.setForeground(Color.blue);
        btnupdate.setText("");
        btnupdate.addActionListener(new AdminManageFrame_btnupdate_actionAdapter(this));
        btnlogin.setBackground(new Color(210, 255, 255));
        btnlogin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnlogin.setForeground(Color.blue);
        btnlogin.addActionListener(new AdminManageFrame_btnlogin_actionAdapter(this));
        btndelete.setBackground(new Color(212, 255, 255));
        btndelete.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btndelete.setForeground(Color.blue);

        btndelete.addActionListener(new AdminManageFrame_btndelete_actionAdapter(this));
        PanAdmin.setBackground(new Color(212, 255, 255));
        PanAdmin.setBorder(null);
        registPan.setBackground(new Color(212, 240, 255));
        registPan.setBorder(null);
        registPan.setLayout(null);
        lblusername.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblusername.setText("管理员帐号：");
        lblusername.setBounds(new Rectangle(26, 30, 100, 30));
        lblokpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblokpsw.setText("确 认 密 码：");
        lblokpsw.setBounds(new Rectangle(26, 170, 100, 30));
        lblpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblpsw.setText("密          码：");
        lblpsw.setBounds(new Rectangle(26, 123, 100, 30));
        txtusername1.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtusername1.setBounds(new Rectangle(142, 29, 130, 30));
        pswpassword.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        pswpassword.setText("");
        pswpassword.setBounds(new Rectangle(142, 122, 130, 30));
        pswokpassword.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        pswokpassword.setText("");
        pswokpassword.setBounds(new Rectangle(141, 168, 130, 31));
        btnReg.setBackground(new Color(212, 255, 255));
        btnReg.setBounds(new Rectangle(39, 263, 100, 30));
        btnReg.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnReg.setForeground(Color.blue);
        btnReg.setText("");
        btnReg.addActionListener(new AdminManageFrame_tbnok_actionAdapter(this));
        cboClass.setBackground(new Color(255, 230, 255));
        cboClass.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboClass.setBounds(new Rectangle(142, 211, 130, 30));
        cboClass.addItem("客房管理员");
        cboClass.addItem("经营管理员");
        cboClass.addItem("系统管理员");
        lblClass.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblClass.setText("管理员类别：");
        lblClass.setBounds(new Rectangle(25, 214, 101, 30));
        lblid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblid.setText("员 工 ID 号：");
        lblid.setBounds(new Rectangle(26, 76, 100, 30));
        txtid.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtid.setText("");
        txtid.setBounds(new Rectangle(142, 79, 130, 30));
        btnReset.setBackground(new Color(212, 255, 255));
        btnReset.setBounds(new Rectangle(169, 263, 100, 30));
        btnReset.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnReset.setForeground(Color.blue);

        btnReset.setText("");
        btnReset.addActionListener(new AdminManageFrame_btnrescript_actionAdapter(this));
        AdminManagePan.setBorder(BorderFactory.createEtchedBorder());
        AdminManagePan.setBounds(new Rectangle(59, 138, 594, 365));
        AdminManagePan.setLayout(cardLayout1);
        lblusernam2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblusernam2.setText("管理员帐号：");
        lblusernam2.setBounds(new Rectangle(36, 34, 100, 30));
        deletePan.setLayout(null);
        lblpassword2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblpassword2.setText("密           码：");
        lblpassword2.setBounds(new Rectangle(35, 80, 100, 30));
        txtusername2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtusername2.setText("");
        txtusername2.setBounds(new Rectangle(147, 34, 120, 31));
        txtpsw.setText("");
        txtpsw.setBounds(new Rectangle(148, 82, 120, 30));
        btnok.setBackground(new Color(212, 255, 255));
        btnok.setBounds(new Rectangle(37, 180, 100, 30));
        btnok.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnok.setForeground(Color.blue);
        btnok.setText("");
        btnok.addActionListener(new AdminManageFrame_btnok_actionAdapter(this));
        resetPan.setLayout(null);
        lblusername3.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblusername3.setText("管理员帐号：");
        lblusername3.setBounds(new Rectangle(27, 28, 100, 30));
        lbloldpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbloldpsw.setText("旧    密    码：");
        lbloldpsw.setBounds(new Rectangle(27, 71, 100, 30));
        lblnewpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblnewpsw.setText("新    密    码：");
        lblnewpsw.setBounds(new Rectangle(27, 116, 100, 30));
        lblqrnewpsw.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblqrnewpsw.setText("确认新密码：");
        lblqrnewpsw.setBounds(new Rectangle(27, 164, 100, 31));
        txtUserName3.setText("");
        txtUserName3.setBounds(new Rectangle(146, 27, 130, 30));
        txtOldPsw.setBounds(new Rectangle(146, 74, 130, 29));
        txtNewPsw.setText("");
        txtNewPsw.setBounds(new Rectangle(145, 116, 130, 30));
        txtNewConfirPsw.setText("");
        txtNewConfirPsw.setBounds(new Rectangle(146, 163, 130, 30));
        btnupda.setBackground(new Color(212, 240, 255));
        btnupda.setBounds(new Rectangle(64, 289, 101, 30));
        btnupda.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnupda.setForeground(Color.blue);
        btnupda.setText("");
        btnupda.addActionListener(new AdminManageFrame_jButton1_actionAdapter(this));
        jToolBar1.setBackground(new Color(212, 230, 255));
        jToolBar1.setBorder(BorderFactory.createEtchedBorder());
        jToolBar1.setBounds(new Rectangle(58, 72, 594, 54));
        resetPwdPan.setBackground(new Color(212, 225, 255));
        resetPwdPan.setBorder(BorderFactory.createEtchedBorder());
        resetPwdPan.setBounds(new Rectangle(30, 36, 307, 229));
        resetPwdPan.setLayout(null);
        btnExit.setBackground(new Color(212, 255, 255));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnExit.setForeground(Color.blue);
        btnExit.setText("");
        btnExit.addActionListener(new AdminManageFrame_btnExit_actionAdapter(this));
        lblPicture.setBorder(BorderFactory.createEtchedBorder());
        lblPicture.setText("");
        lblPicture.setBounds(new Rectangle(353, 31, 220, 290));
        lblPicture.setIcon(i1);
        DelPan.setBackground(new Color(212, 230, 255));

        DelPan.setBorder(BorderFactory.createEtchedBorder());
        DelPan.setBounds(new Rectangle(19, 19, 300, 300));
        DelPan.setLayout(null);
        lblPivture2.setBorder(BorderFactory.createEtchedBorder());
        lblPivture2.setText("");
        lblPivture2.setBounds(new Rectangle(340, 15, 230, 320));
        lblPivture2.setIcon(i2);
        btnResetDel.setBackground(new Color(212, 255, 255));
        btnResetDel.setBounds(new Rectangle(159, 179, 100, 30));
        btnResetDel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnResetDel.setForeground(Color.blue);
        btnResetDel.setText("");
        btnResetDel.addActionListener(new
                AdminManageFrame_btnResetDel_actionAdapter(this));
        lblPicture3.setBorder(BorderFactory.createEtchedBorder());
        lblPicture3.setText("");
        lblPicture3.setBounds(new Rectangle(345, 19, 230, 299));
        lblPicture3.setIcon(i3);
        RegPan.setBackground(new Color(212, 230, 255));
        RegPan.setBorder(BorderFactory.createEtchedBorder());
        RegPan.setBounds(new Rectangle(22, 14, 298, 326));
        RegPan.setLayout(null);
        lblTitle.setBackground(Color.white);
        lblTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 35));
        lblTitle.setForeground(Color.magenta);
        lblTitle.setHorizontalAlignment(SwingConstants.CENTER);
        lblTitle.setText("管 理 员 管 理");
        lblTitle.setBounds(new Rectangle(213, 11, 258, 52));
        btnResetRe.setBackground(new Color(212, 240, 255));
        btnResetRe.setBounds(new Rectangle(190, 290, 100, 30));
        btnResetRe.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnResetRe.setForeground(Color.blue);
        btnResetRe.setText("");
        btnResetRe.addActionListener(new
                                     AdminManageFrame_btnResetRe_actionAdapter(this));

        this.btnlogin.setIcon(new ImageIcon("image\\frame\\adminfrm\\registAdmin.jpg"));
        this.btndelete.setIcon(new ImageIcon("image\\frame\\adminfrm\\deleteadmin.jpg"));
        this.btnupdate.setIcon(new ImageIcon("image\\frame\\adminfrm\\resetPWD.jpg"));
        this.btnExit.setIcon(new ImageIcon("image\\frame\\adminfrm\\exit.jpg"));
        this.btnupda.setIcon(new ImageIcon("image\\frame\\adminfrm\\btnRS.jpg"));
        this.btnResetRe.setIcon(new ImageIcon("image\\frame\\adminfrm\\btnRES.jpg"));
        this.btnok.setIcon(new ImageIcon("image\\frame\\adminfrm\\btnDEL.jpg"));
        this.btnResetDel.setIcon(new ImageIcon("image\\frame\\adminfrm\\btnRES.jpg"));
        this.btnReg.setIcon(new ImageIcon("image\\frame\\adminfrm\\btnREG.jpg"));
        this.btnReset.setIcon(new ImageIcon("image\\frame\\adminfrm\\btnRES.jpg"));
        resetPan.setBackground(new Color(212, 240, 255));
        deletePan.setBackground(new Color(212, 240, 255));
        this.setTitle("管理员管理");
        registPan.add(lblPivture2);
        registPan.add(RegPan);
        RegPan.add(btnReg);
        RegPan.add(pswpassword);
        RegPan.add(lblpsw);
        RegPan.add(lblid);
        RegPan.add(txtid);
        RegPan.add(txtusername1);
        RegPan.add(lblClass);
        RegPan.add(cboClass);
        RegPan.add(lblusername);
        RegPan.add(pswokpassword);
        RegPan.add(lblokpsw);
        RegPan.add(btnReset);

        jToolBar1.add(btnlogin);
        jToolBar1.add(btndelete);
        jToolBar1.add(btnupdate);
        jToolBar1.add(btnExit);
        PanAdmin.add(lblTitle);
        PanAdmin.add(jToolBar1);
        PanAdmin.add(AdminManagePan);

        DelPan.add(lblusernam2);
        DelPan.add(btnok);
        DelPan.add(btnResetDel);
        DelPan.add(txtpsw);
        DelPan.add(lblpassword2);
        DelPan.add(txtusername2);
        deletePan.add(lblPicture3);
        deletePan.add(DelPan);
        AdminManagePan.add(resetPan, "Panupdate");
        AdminManagePan.add(deletePan, "Pandelete");

        resetPwdPan.add(lbloldpsw);
        resetPwdPan.add(lblqrnewpsw);
        resetPwdPan.add(lblnewpsw);
        resetPwdPan.add(txtUserName3);
        resetPwdPan.add(lblusername3);
        resetPwdPan.add(txtOldPsw);
        resetPwdPan.add(txtNewConfirPsw);
        resetPwdPan.add(txtNewPsw);
        resetPan.add(btnResetRe);
        resetPan.add(btnupda);
        resetPan.add(lblPicture);
        resetPan.add(resetPwdPan);
        AdminManagePan.add(registPan, "registPan");
        this.getContentPane().add(PanAdmin, java.awt.BorderLayout.CENTER);
        btndelete.setText("");
        btnlogin.setText("");
        registPan.setVisible(true);
        deletePan.setVisible(false);
        resetPan.setVisible(false);

    }

    JPanel PanAdmin = new JPanel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JButton btnlogin = new JButton();
    JButton btndelete = new JButton();
    JButton btnupdate = new JButton();
    TitledBorder titledBorder2 = new TitledBorder("");
    JPanel registPan = new JPanel();
    JLabel lblusername = new JLabel();
    JLabel lblokpsw = new JLabel();
    JLabel lblpsw = new JLabel();
    JTextField txtusername1 = new JTextField();
    JPasswordField pswpassword = new JPasswordField();
    JPasswordField pswokpassword = new JPasswordField();
    JButton btnReg = new JButton();
    DBOperatorBean dbo = new DBOperatorBean();
    JComboBox cboClass = new JComboBox();
    JLabel lblClass = new JLabel();
    JLabel lblid = new JLabel();
    JTextField txtid = new JTextField();
    JButton btnReset = new JButton();
    BorderLayout borderLayout1 = new BorderLayout();
    JPanel AdminManagePan = new JPanel();
    CardLayout cardLayout1 = new CardLayout();
    JPanel deletePan = new JPanel();
    JPanel resetPan = new JPanel();
    JLabel lblusernam2 = new JLabel();
    JLabel lblpassword2 = new JLabel();
    JTextField txtusername2 = new JTextField();
    JPasswordField txtpsw = new JPasswordField();
    JButton btnok = new JButton();
    JLabel lblusername3 = new JLabel();
    JLabel lbloldpsw = new JLabel();
    JLabel lblnewpsw = new JLabel();
    JLabel lblqrnewpsw = new JLabel();
    JTextField txtUserName3 = new JTextField();
    JPasswordField txtOldPsw = new JPasswordField();
    JPasswordField txtNewPsw = new JPasswordField();
    JPasswordField txtNewConfirPsw = new JPasswordField();
    JButton btnupda = new JButton();
    JToolBar jToolBar1 = new JToolBar();
    JPanel resetPwdPan = new JPanel();
    JButton btnExit = new JButton();
    JLabel lblPicture = new JLabel();
    JPanel DelPan = new JPanel();
    JLabel lblPivture2 = new JLabel();
    JButton btnResetDel = new JButton();
    JLabel lblPicture3 = new JLabel();
    JPanel RegPan = new JPanel();
    JLabel lblTitle = new JLabel();
    JButton btnResetRe = new JButton();

  ImageIcon i1 = new ImageIcon("image\\img4\\4007.jpg");
   ImageIcon i3 = new ImageIcon("image\\img4\\4012.jpg");

   ImageIcon i2 = new ImageIcon("image\\img4\\4010.jpg");
    public void tbnok_actionPerformed(ActionEvent e) {
        if(this.txtid.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"员工ID号不能为空！");
            this.txtid.requestFocus();
            return;
        }
        if(this.txtusername1.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"帐号不能为空！");
            this.txtusername1.requestFocus();
            return;
        }
        if(this.pswpassword.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"密码不能为空！");
            this.pswokpassword.requestFocus();
            return;
        }
        if(this.pswokpassword.getText().equals(""))
        {
            JOptionPane.showMessageDialog(null,"确认密码不能为空！");