employeeframe.java

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

        lblRemarkRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblRemarkRs.setText("备注");
        lblRemarkRs.setBounds(new Rectangle(11, 133, 110, 30));
        txtNativeRs.setBackground(new Color(255, 225, 255));
        txtNativeRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtNativeRs.setEditable(false);
        txtNativeRs.setText("");
        txtNativeRs.setBounds(new Rectangle(132, 237, 130, 30));
        txtTitleRs.setText("");
        txtTitleRs.setBounds(new Rectangle(130, 94, 130, 30));
        lblTitleRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblTitleRs.setText("员工职务");
        lblTitleRs.setBounds(new Rectangle(11, 96, 110, 30));
        lblPictureRs.setBorder(BorderFactory.createEtchedBorder());
        lblPictureRs.setText("");
        this.lblPictureRs.setIcon(i1);
        lblPictureRs.setBounds(new Rectangle(12, 168, 250, 100));
        btnExitRs.setBackground(new Color(212, 236, 255));
        btnExitRs.setBounds(new Rectangle(316, 354, 90, 30));
        btnExitRs.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnExitRs.setForeground(new Color(255, 66, 0));
        btnExitRs.setText("");
        btnExitRs.addActionListener(new EmployeeFrame_btnExitRs_actionAdapter(this));
        txtSqlIDD.setFont(new java.awt.Font("Dialog", Font.PLAIN, 17));
        txtSqlIDD.setText("");
        txtSqlIDD.setBounds(new Rectangle(177, 26, 97, 30));
        txtSqlIDD.addActionListener(new EmployeeFrame_txtSqlIDD_actionAdapter(this));
        btnQueryD.setBackground(new Color(210, 246, 255));
        btnQueryD.setBounds(new Rectangle(302, 23, 100, 30));
        btnQueryD.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnQueryD.setForeground(new Color(255, 144, 0));
        btnQueryD.setText("");
        btnQueryD.addActionListener(new EmployeeFrame_btnQueryD_actionAdapter(this));
        lblInfoD.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        lblInfoD.setText("输入员工ID号");
        lblInfoD.setBounds(new Rectangle(35, 26, 131, 30));
        btnExitD.setBackground(new Color(212, 243, 255));
        btnExitD.setBounds(new Rectangle(228, 356, 100, 30));
        btnExitD.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnExitD.setForeground(new Color(255, 92, 0));
        btnExitD.setText("");
        btnExitD.addActionListener(new EmployeeFrame_btnExitD_actionAdapter(this));
        jScrollPane1.getViewport().setBackground(new Color(255, 223, 255));
        jScrollPane1.setBounds(new Rectangle(33, 73, 381, 266));
        txtShowD.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtShowD.setEditable(false);
        txtShowD.setText("");
        lblPictureDel.setBorder(BorderFactory.createEtchedBorder());
        lblPictureDel.setText("");
        lblPictureDel.setBounds(new Rectangle(433, 56, 170, 300));
        lblPictureDel.setIcon(i3);
        this.getContentPane().setBackground(new Color(225, 255, 255));
        this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
        this.setResizable(false);
        this.setTitle("员工信息管理");
        PanSql.setBackground(new Color(212, 230, 255));
        emSrlPan.getViewport().setBackground(Color.white);
        PanDel.setBackground(new Color(210, 230, 255));
        PanRSet.setBackground(new Color(212, 240, 249));
        PanReg.setBackground(new Color(210, 243, 255));
        btnQExit.setBackground(new Color(212, 255, 255));
        btnQExit.setBounds(new Rectangle(494, 17, 100, 30));
        btnQExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnQExit.setText("");
        btnQExit.addActionListener(new EmployeeFrame_btnQExit_actionAdapter(this));
        this.btnQuery.setIcon(new ImageIcon("image\\employee\\query.jpg"));
        this.btnDelet.setIcon(new ImageIcon("image\\employee\\delete.jpg"));
        this.btnRegist.setIcon(new ImageIcon("image\\employee\\regist.jpg"));
        this.btnExit.setIcon(new ImageIcon("image\\employee\\Qexit.jpg"));
        this.btnReset.setIcon(new ImageIcon("image\\employee\\reset.jpg"));
        this.btnSql.setIcon(new ImageIcon("image\\employee\\Qquery.jpg"));
        this.btnQExit.setIcon(new ImageIcon("image\\employee\\Qexit.jpg"));
        this.btnExitRs.setIcon(new ImageIcon("image\\employee\\Qexit.jpg"));
        this.btnReg.setIcon(new ImageIcon("image\\employee\\Reregist.jpg"));
        this.btnSaveRs.setIcon(new ImageIcon("image\\employee\\Rssave.jpg"));
        this.btnsqlRs.setIcon(new ImageIcon("image\\employee\\Qquery.jpg"));
        this.btnExitRs.setIcon(new ImageIcon("image\\employee\\Qexit.jpg"));
        this.btnQueryD.setIcon(new ImageIcon("image\\employee\\Qquery.jpg"));
        this.btnExitD.setIcon(new ImageIcon("image\\employee\\Qexit.jpg"));
        this.btnDelD.setIcon(new ImageIcon("image\\employee\\Ddelete.jpg"));

        this.getContentPane().add(mainPanel);
        PanSql.add(emPan);
        emPan.add(emSrlPan, java.awt.BorderLayout.CENTER);
        PanSql.add(txtSql);
        PanSql.add(lblSql);
        PanSql.add(rdoName);
        PanSql.add(rdoID);
        PanSql.add(rdoTitle);
        PanSql.add(rdoAll);
        PanSql.add(rdoNative);
        PanSql.add(btnSql);
        PanSql.add(btnQExit);
        regInfoPan1.add(lblEmName);
        regInfoPan1.add(txtEmID);
        regInfoPan1.add(txtEmName);
        regInfoPan1.add(txtEmAge);
        regInfoPan1.add(txEmIDNo);
        regInfoPan1.add(txtEmNationality);
        regInfoPan1.add(lblEmID);
        regInfoPan1.add(lbEmlSex);
        regInfoPan1.add(lblEmAge);
        regInfoPan1.add(lblEmIDNo);
        regInfoPan1.add(lblEmNational);
        regInfoPan1.add(txtEmNative);
        regInfoPan1.add(lblEmNative);
        regInfoPan1.add(rdomale);
        regInfoPan1.add(rdoFamale);
        PanReg.add(btnExit);
        PanReg.add(btnReg);
        PanReg.add(regInfoPan2);
        regInfoPan2.add(lblPicture);
        regInfoPan2.add(lblEmAddress);
        regInfoPan2.add(txtEmAddress);
        regInfoPan2.add(lblPhone);
        regInfoPan2.add(txtEmPhone);
        regInfoPan2.add(lblEmTitle);
        regInfoPan2.add(txtEmTitle);
        regInfoPan2.add(lblEmRemark);
        regInfoPan2.add(txtEmRemark);
        PanReg.add(regInfoPan1);
        mainPanel.add(PanRSet, "PanRSet");
        PanRSet.add(Panel1Rs);
        Panel1Rs.add(txtIDRs);
        Panel1Rs.add(lblIDRs);
        Panel1Rs.add(txtNameRs);
        Panel1Rs.add(txtSexRs);
        Panel1Rs.add(txtAgeRs);
        Panel1Rs.add(txtNationalityRs);
        Panel1Rs.add(txtCarID);
        Panel1Rs.add(lblCardID);
        Panel1Rs.add(lblNationalityRs);
        Panel1Rs.add(lblAgeRs);
        Panel1Rs.add(lblSexRs);
        Panel1Rs.add(lblNameRs);
        Panel1Rs.add(lblNativeRs);
        Panel1Rs.add(txtNativeRs);
        PanRSet.add(Panel2Rs);
        Panel2Rs.add(lblAddressRs);
        Panel2Rs.add(lblPhoneRs);
        Panel2Rs.add(txtAddressRs);
        Panel2Rs.add(txtPhoneRs);
        Panel2Rs.add(txtTitleRs);
        Panel2Rs.add(txtRemarkRs);
        Panel2Rs.add(lblTitleRs);
        Panel2Rs.add(lblRemarkRs);
        Panel2Rs.add(lblPictureRs);
        PanRSet.add(txtsqlRs);
        PanRSet.add(btnsqlRs);
        PanRSet.add(btnSaveRs);
        PanRSet.add(btnExitRs);
        PanRSet.add(lblsqlRs);
        mainPanel.add(PanDel, "PanDel");
        PanDel.add(lblInfoD);
        PanDel.add(jScrollPane1);
        PanDel.add(txtSqlIDD);
        PanDel.add(btnQueryD);
        PanDel.add(btnDelD);
        PanDel.add(btnExitD);
        PanDel.add(lblPictureDel);
        jScrollPane1.getViewport().add(txtShowD);
        emSrlPan.getViewport().add(emTab);
        mainPanel.add(PanSql, "PanSql");
        toolBar.add(btnQuery);
        toolBar.add(btnRegist);
        toolBar.add(btnReset);
        toolBar.add(btnDelet);
        this.getContentPane().add(lblTitle);
        this.getContentPane().add(toolBar);
        buttonGroup1.add(rdoID);
        buttonGroup1.add(rdoName);
        buttonGroup1.add(rdoNative);
        buttonGroup1.add(rdoTitle);
        buttonGroup1.add(rdoAll);
        this.PanSql.setVisible(true);
        this.PanReg.setVisible(false);
        this.PanRSet.setVisible(false);
        this.PanDel.setVisible(false);
        this.txtSql.requestFocus();
//select ID,title,name,sex,nationality,age,IDCard,native,address,phone,remark from employee
//
//        emdtm.addColumn("ID");
//        emdtm.addColumn("职务");
//        emdtm.addColumn("姓名");
//        emdtm.addColumn("性别");
//        emdtm.addColumn("民族");
//        emdtm.addColumn("年龄");
//        emdtm.addColumn("身份证号");
//        emdtm.addColumn("籍贯");
//        emdtm.addColumn("地址");
//        emdtm.addColumn("联系电话");
//        emdtm.addColumn("备注");
//
//        this.emTab.setModel(emdtm);
        dbo = new DBOperatorBean();
        buttonGroup2.add(rdoFamale);
        buttonGroup2.add(rdomale);
        mainPanel.add(PanReg, "PanReg");
    }

    JLabel lblTitle = new JLabel();
    JToolBar toolBar = new JToolBar();
    JButton btnQuery = new JButton();
    JButton btnRegist = new JButton();
    JButton btnReset = new JButton();
    JButton btnDelet = new JButton();
    TitledBorder titledBorder1 = new TitledBorder("");
    JPanel mainPanel = new JPanel();
    CardLayout cardLayout1 = new CardLayout();
    JPanel PanSql = new JPanel();
    JPanel PanRSet = new JPanel();
    JPanel PanReg = new JPanel();
    JPanel PanDel = new JPanel();
    JButton btnSql = new JButton();
    JButton btnReg = new JButton();
    JButton btnSaveRs = new JButton();
    JButton btnDelD = new JButton();
    JTextField txtSql = new JTextField();
    JLabel lblSql = new JLabel();
    JRadioButton rdoID = new JRadioButton();
    JRadioButton rdoName = new JRadioButton();
    JRadioButton rdoNative = new JRadioButton();
    JRadioButton rdoTitle = new JRadioButton();
    JPanel emPan = new JPanel();
    BorderLayout borderLayout1 = new BorderLayout();
    DefaultTableModel emdtm = new DefaultTableModel();
    ButtonGroup buttonGroup1 = new ButtonGroup();
    JScrollPane emSrlPan = new JScrollPane();
    JTable emTab = new JTable();
    JRadioButton rdoAll = new JRadioButton();
    DBOperatorBean dbo;
    JButton btnExit = new JButton();
    JTextField txtEmName = new JTextField();
    JLabel lblEmID = new JLabel();
    JLabel lblEmName = new JLabel();
    JTextField txtEmID = new JTextField();
    JPanel regInfoPan1 = new JPanel();
    JPanel regInfoPan2 = new JPanel();
    JLabel lbEmlSex = new JLabel();
    JLabel lblEmAge = new JLabel();
    JTextField txtEmAge = new JTextField();
    JLabel lblEmIDNo = new JLabel();
    JLabel lblEmNative = new JLabel();
    JLabel lblEmNational = new JLabel();
    JLabel lblPhone = new JLabel();
    JLabel lblEmAddress = new JLabel();
    JLabel lblEmTitle = new JLabel();
    JLabel lblEmRemark = new JLabel();
    JLabel lblPicture = new JLabel();
    JRadioButton rdomale = new JRadioButton();
    JRadioButton rdoFamale = new JRadioButton();
    JTextField txEmIDNo = new JTextField();
    JTextField txtEmNative = new JTextField();
    ButtonGroup buttonGroup2 = new ButtonGroup();
    JTextField txtEmNationality = new JTextField();
    JTextField txtEmAddress = new JTextField();
    JTextField txtEmPhone = new JTextField();
    JTextField txtEmTitle = new JTextField();
    JTextField txtEmRemark = new JTextField();
    EmployeeBean employee;
    JButton btnsqlRs = new JButton();
    JTextField txtsqlRs = new JTextField();
    JLabel lblsqlRs = new JLabel();
    JPanel Panel1Rs = new JPanel();
    JPanel Panel2Rs = new JPanel();
    JTextField txtSexRs = new JTextField();
    JLabel lblSexRs = new JLabel();
    JTextField txtNameRs = new JTextField();
    JLabel lblNameRs = new JLabel();
    JTextField txtAgeRs = new JTextField();
    JLabel lblIDRs = new JLabel();
    JTextField txtNationalityRs = new JTextField();
    JLabel lblAgeRs = new JLabel();
    JTextField txtCarID = new JTextField();
    JLabel lblNationalityRs = new JLabel();
    JTextField txtIDRs = new JTextField();
    JLabel lblCardID = new JLabel();
    JTextField txtAddressRs = new JTextField();
    JLabel lblPhoneRs = new JLabel();
    JTextField txtPhoneRs = new JTextField();
    JLabel lblAddressRs = new JLabel();
    JTextField txtRemarkRs = new JTextField();
    JLabel lblNativeRs = new JLabel();
    JLabel lblRemarkRs = new JLabel();
    JTextField txtNativeRs = new JTextField();
    JTextField txtTitleRs = new JTextField();
    JLabel lblTitleRs = new JLabel();
    JLabel lblPictureRs = new JLabel();
    JButton btnExitRs = new JButton();
    JTextField txtSqlIDD = new JTextField();
    JButton btnQueryD = new JButton();
    JLabel lblInfoD = new JLabel();
    JButton btnExitD = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTextArea txtShowD = new JTextArea();
    JLabel lblPictureDel = new JLabel();
    ImageIcon i1 = new ImageIcon("image\\img4\\4005.jpg");
    ImageIcon i2 = new ImageIcon("image\\img4\\4006.jpg");
    ImageIcon i3 = new ImageIcon("image\\img4\\4003.jpg");

    JButton btnQExit = new JButton();

    //显示查询面板
    public void btnQuery_actionPerformed(ActionEvent e) {
        this.PanSql.setVisible(true);
        this.PanReg.setVisible(false);
        this.PanRSet.setVisible(false);
        this.PanDel.setVisible(false);
    }
    //显示注册面板
    public void btnRegist_actionPerformed(ActionEvent e) {
        this.PanSql.setVisible(false);
        this.PanReg.setVisible(true);
        this.PanRSet.setVisible(false);
        this.PanDel.setVisible(false);

    }
     //显示信息修改面板
    public void btnReset_actionPerformed(ActionEvent e) {