employeeframe.java

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

package operation;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.border.TitledBorder;
import javax.swing.table.DefaultTableModel;
import entity.DBOperatorBean;
import java.sql.ResultSet;
import java.sql.*;
import java.util.Vector;
import entity.EmployeeBean;

/**
 * <p>Title: Hawaii rummery manage</p>
 *
 * <p>Description: minityperummery manage</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: Yue.</p>
 *
 * @author not attributable
 * @version 1.0
 */
public class EmployeeFrame extends JFrame {
    public EmployeeFrame() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        lblTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 35));
        lblTitle.setForeground(Color.magenta);
        lblTitle.setHorizontalAlignment(SwingConstants.CENTER);
        lblTitle.setText("员工信息管理");
        lblTitle.setBounds(new Rectangle(216, 0, 274, 48));
        toolBar.setBackground(new Color(212, 230, 255));
        toolBar.setBorder(titledBorder1);
        toolBar.setBounds(new Rectangle(37, 44, 616, 55));
        btnQuery.setBackground(new Color(210, 255, 255));
        btnQuery.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnQuery.setForeground(Color.blue);

        btnQuery.setText("");
        btnQuery.addActionListener(new EmployeeFrame_btnQuery_actionAdapter(this));
        btnRegist.setBackground(new Color(210, 255, 255));
        btnRegist.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnRegist.setForeground(Color.blue);
        btnRegist.setSelectedIcon(null);
        btnRegist.setText("");
        btnRegist.addActionListener(new EmployeeFrame_btnRegist_actionAdapter(this));
        btnReset.setBackground(new Color(210, 255, 255));
        btnReset.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnReset.setForeground(Color.blue);
        btnReset.setText("");
        btnReset.addActionListener(new EmployeeFrame_btnReset_actionAdapter(this));
        btnDelet.setBackground(new Color(210, 255, 255));
        btnDelet.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnDelet.setForeground(Color.blue);

        btnDelet.setText("");
        btnDelet.addActionListener(new EmployeeFrame_btnDel_actionAdapter(this));
        mainPanel.setBorder(BorderFactory.createEtchedBorder());
        mainPanel.setBounds(new Rectangle(37, 97, 617, 403));
        mainPanel.setLayout(cardLayout1);
        PanSql.setLayout(null);
        PanReg.setLayout(null);
        PanRSet.setLayout(null);
        PanDel.setLayout(null);
        btnSql.setBackground(new Color(210, 255, 255));
        btnSql.setBounds(new Rectangle(373, 17, 100, 30));
        btnSql.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnSql.setForeground(Color.black);
        btnSql.setText("");
        btnSql.addActionListener(new EmployeeFrame_btnSql_actionAdapter(this));
        btnReg.setBackground(new Color(212, 236, 255));
        btnReg.setBounds(new Rectangle(208, 348, 100, 30));
        btnReg.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnReg.setForeground(Color.blue);
        btnReg.setText("");
        btnReg.addActionListener(new EmployeeFrame_btnReg_actionAdapter(this));
        btnSaveRs.setBackground(new Color(212, 239, 255));
        btnSaveRs.setBounds(new Rectangle(211, 355, 90, 30));
        btnSaveRs.setEnabled(true);
        btnSaveRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnSaveRs.setForeground(Color.red);

        btnSaveRs.setText("");
        btnSaveRs.addActionListener(new EmployeeFrame_btnSaveRs_actionAdapter(this));
        btnDelD.setBackground(new Color(212, 243, 255));
        btnDelD.setBounds(new Rectangle(81, 356, 100, 30));
        btnDelD.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnDelD.setForeground(new Color(255, 72, 0));

        btnDelD.setText("");
        btnDelD.addActionListener(new EmployeeFrame_btnDelD_actionAdapter(this));
        txtSql.setBackground(new Color(222, 222, 222));
        txtSql.setForeground(Color.blue);
        txtSql.setDisabledTextColor(Color.white);
        txtSql.setText("");
        txtSql.setBounds(new Rectangle(187, 17, 150, 28));
        txtSql.addActionListener(new EmployeeFrame_txtSql_actionAdapter(this));
        lblSql.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        lblSql.setToolTipText("");
        lblSql.setText("请选择查询内容：");
        lblSql.setBounds(new Rectangle(12, 16, 168, 32));
        rdoID.setBackground(new Color(255, 230, 255));
        rdoID.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoID.setForeground(Color.blue);
        rdoID.setSelected(true);
        rdoID.setText("员工ID号");
        rdoID.setBounds(new Rectangle(16, 57, 87, 31));
        rdoName.setBackground(new Color(255, 230, 255));
        rdoName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoName.setForeground(Color.blue);
        rdoName.setText("员工姓名");
        rdoName.setBounds(new Rectangle(108, 59, 89, 30));
        rdoNative.setBackground(new Color(255, 230, 255));
        rdoNative.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoNative.setForeground(Color.blue);
        rdoNative.setText("员工籍贯");
        rdoNative.setBounds(new Rectangle(199, 58, 88, 30));
        rdoTitle.setBackground(new Color(255, 230, 255));
        rdoTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoTitle.setForeground(Color.blue);
        rdoTitle.setText("员工职务");
        rdoTitle.setBounds(new Rectangle(301, 58, 91, 30));
        emPan.setBorder(BorderFactory.createEtchedBorder());
        emPan.setBounds(new Rectangle(9, 96, 602, 300));
        emPan.setLayout(borderLayout1);
        rdoAll.setBackground(new Color(255, 231, 255));
        rdoAll.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoAll.setForeground(Color.blue);
        rdoAll.setText("全部员工");
        rdoAll.setBounds(new Rectangle(398, 61, 91, 25));
        btnExit.setBackground(new Color(212, 236, 255));
        btnExit.setBounds(new Rectangle(334, 345, 100, 30));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnExit.setForeground(Color.blue);
        btnExit.setText("");
        btnExit.addActionListener(new EmployeeFrame_btnExit_actionAdapter(this));
        txtEmName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmName.setText("");
        txtEmName.setBounds(new Rectangle(139, 53, 120, 30));
        lblEmID.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmID.setText("ID号");
        lblEmID.setBounds(new Rectangle(13, 13, 100, 30));
        lblEmName.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmName.setText("姓名");
        lblEmName.setBounds(new Rectangle(13, 47, 100, 30));
        txtEmID.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmID.setText("");
        txtEmID.setBounds(new Rectangle(137, 12, 120, 30));
        regInfoPan1.setBackground(new Color(212, 230, 255));
        regInfoPan1.setBorder(BorderFactory.createEtchedBorder());
        regInfoPan1.setBounds(new Rectangle(28, 28, 280, 291));
        regInfoPan1.setLayout(null);
        regInfoPan2.setBackground(new Color(212, 230, 255));
        regInfoPan2.setBorder(BorderFactory.createEtchedBorder());
        regInfoPan2.setBounds(new Rectangle(326, 29, 270, 290));
        regInfoPan2.setLayout(null);
        lbEmlSex.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lbEmlSex.setText("性别");
        lbEmlSex.setBounds(new Rectangle(12, 80, 100, 29));
        lblEmAge.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmAge.setText("年龄");
        lblEmAge.setBounds(new Rectangle(12, 115, 100, 30));
        txtEmAge.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmAge.setText("");
        txtEmAge.setBounds(new Rectangle(138, 116, 120, 30));
        lblEmIDNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmIDNo.setText("身份证号(18位)");
        lblEmIDNo.setBounds(new Rectangle(11, 157, 104, 30));
        lblEmNative.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmNative.setText("籍贯");
        lblEmNative.setBounds(new Rectangle(15, 232, 100, 30));
        lblEmNational.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmNational.setToolTipText("");
        lblEmNational.setText("民族");
        lblEmNational.setBounds(new Rectangle(12, 193, 100, 30));
        lblPhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblPhone.setText("联系电话");
        lblPhone.setBounds(new Rectangle(17, 64, 100, 30));
        lblEmAddress.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmAddress.setText("住址");
        lblEmAddress.setBounds(new Rectangle(17, 17, 100, 30));
        lblEmTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmTitle.setText("员工职务");
        lblEmTitle.setBounds(new Rectangle(17, 105, 100, 30));
        lblEmRemark.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblEmRemark.setText("备注");
        lblEmRemark.setBounds(new Rectangle(17, 142, 100, 30));
        lblPicture.setBorder(BorderFactory.createEtchedBorder());
        lblPicture.setText("");
        lblPicture.setIcon(i2);
        lblPicture.setBounds(new Rectangle(18, 190, 235, 85));
        rdomale.setBackground(new Color(255, 227, 171));
        rdomale.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdomale.setForeground(Color.blue);
        rdomale.setSelected(true);
        rdomale.setText("男");
        rdomale.setBounds(new Rectangle(138, 87, 55, 30));
        rdoFamale.setBackground(new Color(255, 230, 217));
        rdoFamale.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        rdoFamale.setForeground(Color.blue);
        rdoFamale.setText("女");
        rdoFamale.setBounds(new Rectangle(201, 87, 55, 30));
        txEmIDNo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txEmIDNo.setText("");
        txEmIDNo.setBounds(new Rectangle(139, 157, 120, 30));
        txtEmNative.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmNative.setText("河北省秦皇岛市");
        txtEmNative.setBounds(new Rectangle(136, 234, 122, 30));
        txtEmNationality.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmNationality.setText("汉族");
        txtEmNationality.setBounds(new Rectangle(138, 196, 120, 30));
        txtEmAddress.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmAddress.setText("山海关区");
        txtEmAddress.setBounds(new Rectangle(131, 23, 120, 31));
        txtEmPhone.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmPhone.setText("");
        txtEmPhone.setBounds(new Rectangle(131, 63, 120, 30));
        txtEmTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmTitle.setText("");
        txtEmTitle.setBounds(new Rectangle(131, 105, 121, 30));
        txtEmRemark.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtEmRemark.setText("");
        txtEmRemark.setBounds(new Rectangle(131, 146, 120, 30));
        btnsqlRs.setBackground(new Color(212, 243, 255));
        btnsqlRs.setBounds(new Rectangle(320, 21, 89, 30));
        btnsqlRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnsqlRs.setForeground(new Color(255, 26, 0));
        btnsqlRs.setText("");
        btnsqlRs.addActionListener(new EmployeeFrame_btnsqlRs_actionAdapter(this));
        txtsqlRs.setBackground(new Color(255, 255, 240));
        txtsqlRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        txtsqlRs.setText("");
        txtsqlRs.setBounds(new Rectangle(180, 23, 100, 30));
        txtsqlRs.addActionListener(new EmployeeFrame_txtsqlRs_actionAdapter(this));
        lblsqlRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));

        lblsqlRs.setText("请输入员工ID号");
        lblsqlRs.setBounds(new Rectangle(19, 26, 150, 25));
        Panel1Rs.setBackground(new Color(210, 220, 250));
        Panel1Rs.setBorder(BorderFactory.createEtchedBorder());
        Panel1Rs.setBounds(new Rectangle(20, 64, 280, 280));
        Panel1Rs.setLayout(null);
        Panel2Rs.setBackground(new Color(210, 220, 255));
        Panel2Rs.setBorder(BorderFactory.createEtchedBorder());
        Panel2Rs.setBounds(new Rectangle(317, 64, 280, 280));
        Panel2Rs.setLayout(null);
        txtSexRs.setBackground(new Color(255, 235, 255));
        txtSexRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtSexRs.setEditable(false);
        txtSexRs.setText("");
        txtSexRs.setBounds(new Rectangle(132, 88, 130, 30));
        lblSexRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblSexRs.setText(" * 性别");
        lblSexRs.setBounds(new Rectangle(11, 89, 110, 26));
        txtNameRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtNameRs.setText("");
        txtNameRs.setBounds(new Rectangle(132, 52, 130, 30));
        lblNameRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblNameRs.setText("员工姓名");
        lblNameRs.setBounds(new Rectangle(11, 54, 110, 26));
        txtAgeRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAgeRs.setText("");
        txtAgeRs.setBounds(new Rectangle(132, 125, 130, 30));
        lblIDRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblIDRs.setText("员工ID号");
        lblIDRs.setBounds(new Rectangle(11, 16, 110, 26));
        txtNationalityRs.setBackground(new Color(255, 225, 255));
        txtNationalityRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtNationalityRs.setEditable(false);
        txtNationalityRs.setText("");
        txtNationalityRs.setBounds(new Rectangle(132, 160, 130, 30));
        lblAgeRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAgeRs.setText("年龄");
        lblAgeRs.setBounds(new Rectangle(11, 130, 110, 26));
        txtCarID.setBackground(new Color(255, 225, 255));
        txtCarID.setEditable(false);
        txtCarID.setText("");
        txtCarID.setBounds(new Rectangle(132, 200, 130, 30));
        lblNationalityRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblNationalityRs.setText("* 民族");
        lblNationalityRs.setBounds(new Rectangle(11, 166, 110, 26));
        txtIDRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtIDRs.setText("");
        txtIDRs.setBounds(new Rectangle(132, 15, 130, 30));
        lblCardID.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblCardID.setText("* 身份证号");
        lblCardID.setBounds(new Rectangle(11, 208, 110, 26));
        txtAddressRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtAddressRs.setText("");
        txtAddressRs.setBounds(new Rectangle(130, 16, 130, 30));
        lblPhoneRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblPhoneRs.setText("联系电话");
        lblPhoneRs.setBounds(new Rectangle(11, 51, 110, 30));
        txtPhoneRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtPhoneRs.setText("");
        txtPhoneRs.setBounds(new Rectangle(130, 55, 130, 30));
        lblAddressRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblAddressRs.setToolTipText("");
        lblAddressRs.setText("住址");
        lblAddressRs.setBounds(new Rectangle(11, 10, 110, 30));
        txtRemarkRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtRemarkRs.setText("");
        txtRemarkRs.setBounds(new Rectangle(130, 132, 130, 30));
        lblNativeRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblNativeRs.setText("* 籍贯");
        lblNativeRs.setBounds(new Rectangle(11, 240, 110, 30));