empinfrecord.java~14~

酒店信息管理系统包括客户的信息

package hotelinformationmanagesystem;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import javax.swing.JPanel;
import javax.swing.BorderFactory;
import java.awt.Color;
import javax.swing.border.TitledBorder;
import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JTextField;
import java.awt.Font;
import javax.swing.Box;
import java.awt.Component;
import javax.swing.JComboBox;
import javax.swing.DebugGraphics;
import javax.swing.JPasswordField;
import javax.swing.JCheckBox;
import javax.swing.JEditorPane;
import javax.swing.JTextArea;
import javax.swing.JSpinner;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JScrollPane;
import javax.swing.JOptionPane;
import java.sql.ResultSet;
import java.io.IOException;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;

/**
 * <p>Title: 酒店信息管理系统</p>
 *
 * <p>Description: The Management Information System of Hotel</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: JSP</p>
 *
 * @author 江世澎
 * @version 1.0
 */
public class EmpInfRecord extends JFrame {
    XYLayout xYLayout1 = new XYLayout();
    JPanel jPanel1 = new JPanel();
    TitledBorder titledBorder1 = new TitledBorder("");
    JButton jBQuit = new JButton();
    JLabel jLShowEmpID = new JLabel();
    XYLayout xYLayout2 = new XYLayout();
    JTextField jTGetEmpID = new JTextField();
    JLabel jShowName = new JLabel();
    JTextField jTGetName = new JTextField();
    JLabel jLShowSex = new JLabel();
    JComboBox jCGetSex = new JComboBox();
    JPanel jPanel3 = new JPanel();
    XYLayout xYLayout4 = new XYLayout();
    JButton jButton3 = new JButton();
    JButton jButton4 = new JButton();
    JButton jButton5 = new JButton();
    JButton jButton6 = new JButton();
    JPanel jPanel4 = new JPanel();
    JButton jBSearchEmpID = new JButton();
    XYLayout xYLayout5 = new XYLayout();
    JLabel jLSearchEmpID = new JLabel();
    JTextField jTSearchEmpID = new JTextField();
    JPanel jPanel5 = new JPanel();
    XYLayout xYLayout6 = new XYLayout();
    JLabel jLShowNationality = new JLabel();
    JTextField jTGetNationality = new JTextField();
    JLabel jLShowBirthday = new JLabel();
    JTextField jTGetBirthday = new JTextField();
    JLabel jLShowNative = new JLabel();
    JTextField jTGetNative = new JTextField();
    JLabel jLShowDepartment = new JLabel();
    JLabel jLShowDuty = new JLabel();
    JPanel jPanel6 = new JPanel();
    XYLayout xYLayout7 = new XYLayout();
    JPanel jPanel7 = new JPanel();
    XYLayout xYLayout8 = new XYLayout();
    JLabel jLShowIDCard = new JLabel();
    JTextField jTGetIDCard = new JTextField();
    JLabel jLShowAddress = new JLabel();
    JTextField jTGetAddress = new JTextField();
    JLabel jLShowPhone = new JLabel();
    JTextField jTGetPhone = new JTextField();
    JPanel jPanel8 = new JPanel();
    XYLayout xYLayout9 = new XYLayout();
    JLabel jLShowPassword = new JLabel();
    JPasswordField jPGetPassword = new JPasswordField();
    JButton jBPassword = new JButton();
    JButton jBDelete = new JButton();
    JPanel jPanel9 = new JPanel();
    XYLayout xYLayout10 = new XYLayout();
    JLabel jLShowPopedom = new JLabel();
    JButton jBPopedom = new JButton();
    JPanel jPanel10 = new JPanel();
    XYLayout xYLayout11 = new XYLayout();
    JLabel jLShowRemark = new JLabel();
    TitledBorder titledBorder2 = new TitledBorder("");
    JButton jBChange = new JButton();
    JPanel jPanel11 = new JPanel();
    XYLayout xYLayout12 = new XYLayout();
    JButton jButton12 = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTextArea jTGetReMark = new JTextArea();
    JPanel jPanel2 = new JPanel();
    XYLayout xYLayout3 = new XYLayout();
    JPanel jPanel12 = new JPanel();
    XYLayout xYLayout13 = new XYLayout();
    JPanel jPanel13 = new JPanel();
    XYLayout xYLayout14 = new XYLayout();
    JButton jBNewBuild = new JButton();
    JButton jBNewBuildFinish = new JButton();
    JButton jBChangeFinish = new JButton();
    JComboBox jCGetDepartment = new JComboBox();
    JComboBox jCGetDuty = new JComboBox();
    JButton jBEmpID = new JButton();
    JComboBox jCGetPopedom = new JComboBox();


    public EmpInfRecord() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(xYLayout1);
       this.setTitle("酒店员工信息管理界面");
       xYLayout1.setWidth(472);
       xYLayout1.setHeight(503);
       jPanel1.setBorder(BorderFactory.createEtchedBorder());
       jPanel1.setToolTipText("");
       jPanel1.setLayout(xYLayout2);
        jShowName.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jShowName.setText("姓　　名");
        jLShowSex.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowSex.setText("性　　别");
        jBQuit.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        jBQuit.setActionCommand("退出");
       jPanel3.setLayout(xYLayout4);
       jPanel3.setBorder(BorderFactory.createEtchedBorder());
        jButton3.setText("上一页");
        jButton4.setText("下一页");
        jButton5.setText("末页");
        jButton6.setText("首页");
       jPanel4.setBorder(BorderFactory.createEtchedBorder());
       jPanel4.setLayout(xYLayout5);
        jBSearchEmpID.setText("查找");
        jLSearchEmpID.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLSearchEmpID.setText("员工ID");
       jPanel5.setLayout(xYLayout6);
       jPanel5.setBorder(BorderFactory.createEtchedBorder());
        jLShowNationality.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowNationality.setText("民　　族");
        jLShowBirthday.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowBirthday.setText("出生年月");
        jLShowNative.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowNative.setText("籍　　贯");
        jLShowDepartment.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowDepartment.setText("部　门");
        jLShowDuty.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowDuty.setText("职　务");
       jPanel6.setBorder(BorderFactory.createEtchedBorder());
       jPanel6.setLayout(xYLayout7);
       jPanel7.setBorder(BorderFactory.createEtchedBorder());
       jPanel7.setLayout(xYLayout8);
        jLShowIDCard.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowIDCard.setText("身份证号");
        jLShowAddress.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowAddress.setText("住　　址");
        jLShowPhone.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowPhone.setText("联系电话");
       jPanel8.setBorder(BorderFactory.createEtchedBorder());
       jPanel8.setLayout(xYLayout9);
        jLShowPassword.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowPassword.setText("密　码");
        jBPassword.setEnabled(false); //修改
        jBPassword.setFont(new java.awt.Font("宋体", Font.PLAIN, 8));
        jBPassword.setText("修改");
        jLShowEmpID.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowEmpID.setText("员工ID");
        jBQuit.setText("退出");
        jBDelete.setText("删除");
       jPanel9.setBorder(BorderFactory.createEtchedBorder());
       jPanel9.setLayout(xYLayout10);
        jLShowPopedom.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowPopedom.setText("权　限");
        jBPopedom.setEnabled(false); //修改
        jBPopedom.setFont(new java.awt.Font("宋体", Font.PLAIN, 8));
        jBPopedom.setText("修改");
       ///jPanel10.setBorder(o
     //ae10.setLayou(xYLyout11);
       jPanel10.setLayout(xYLayout10);
      //jLabel15.stont(new ava.wt.ont("宋体", Font.BOLD,8);
       // jLShowRmark.setFont(new av.awt("宋体,Font.BOLD, 15));
       jLShowRemark.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
      //// jLabel15.sTex("备 注");
        jLShowRemark.setText("备注");
       //jButton11.setFn(new java.awt.Font("体,Fot.BOLD, 18));
        jBChange.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        jBChange.setToolTipText("完成");
        jBChange.setText("修改");
       jPanel11.setBorder(BorderFactory.createEtchedBorder());
       jPanel11.setLayout(xYLayout12);
        jButton12.setText("返回");
       jPanel2.setBorder(BorderFactory.createEtchedBorder());
       jPanel2.setLayout(xYLayout3);
       jPanel12.setLayout(xYLayout13);
       jPanel12.setBorder(BorderFactory.createEtchedBorder());
       jPanel13.setLayout(xYLayout14);
       jPanel13.setBorder(BorderFactory.createEtchedBorder());
        jBNewBuild.setText("新建");
        jBNewBuildFinish.setText("完成");
        jBChangeFinish.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        jBChangeFinish.setText("完成");
        jTGetName.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jCGetSex.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetBirthday.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetBirthday.setToolTipText("输入格式：YYYY-MM-DD");
        jTGetNationality.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetNative.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetEmpID.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetEmpID.setToolTipText("");
        jPGetPassword.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
        jTGetIDCard.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetPhone.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetAddress.setFont(new java.awt.Font("宋体", Font.BOLD, 12));
        jTGetReMark.setFont(new java.awt.Font("Dialog", Font.BOLD, 13));
        jBEmpID.setEnabled(false);
        jBEmpID.setFont(new java.awt.Font("宋体", Font.PLAIN, 8));
        jBEmpID.setText("验证");
       jPanel5.add(jLShowDuty, new XYConstraints(3, 57, -1, 20));
       jPanel5.add(jLShowDepartment, new XYConstraints(3, 31, -1, 20));
       jPanel5.add(jLShowEmpID, new XYConstraints(3, 6, -1, 20));
       jPanel6.add(jShowName, new XYConstraints(5, 6, -1, 20));
       jPanel6.add(jTGetName, new XYConstraints(98, 6, 104, -1));
       jPanel6.add(jLShowSex, new XYConstraints(5, 38, 68, 20));
       jPanel6.add(jTGetBirthday, new XYConstraints(98, 66, 86, -1));
       jPanel6.add(jLShowNationality, new XYConstraints(5, 94, -1, 20));
       jPanel6.add(jLShowBirthday, new XYConstraints(5, 66, -1, 20));
       jPanel6.add(jTGetNationality, new XYConstraints(98, 94, 86, -1));
       jPanel6.add(jLShowNative, new XYConstraints(5, 122, -1, -1));
       jPanel1.add(jPanel6, new XYConstraints(4, 3, 249, 149));
       jPanel7.add(jLShowIDCard, new XYConstraints(5, 7, -1, -1));
       jPanel7.add(jLShowAddress, new XYConstraints(5, 60, -1, -1));
       jPanel7.add(jTGetAddress, new XYConstraints(98, 58, 335, -1));
       jPanel7.add(jLShowPhone, new XYConstraints(5, 33, -1, -1));
       jPanel8.add(jLShowPassword, new XYConstraints(3, 1, -1, -1));
       jPanel8.add(jPGetPassword, new XYConstraints(64, 1, 75, 18));
       jPanel8.add(jBPassword, new XYConstraints(143, 1, 52, 18));
       jPanel1.add(jPanel7, new XYConstraints(4, 155, 454, 85));
       jPanel4.add(jTSearchEmpID, new XYConstraints(60, 4, 125, 27));
       jPanel4.add(jBSearchEmpID, new XYConstraints(196, 4, 70, 27));
       jPanel4.add(jLSearchEmpID, new XYConstraints(4, 4, 53, 30));
       jPanel1.add(jPanel8, new XYConstraints(256, 94, 202, 26));
       jPanel1.add(jPanel9, new XYConstraints(256, 123, 202, 29));
       jPanel9.add(jLShowPopedom, new XYConstraints(5, 4, -1, -1));
        jPanel9.add(jBPopedom, new XYConstraints(143, 2, 52, 20));
        jPanel6.add(jTGetNative, new XYConstraints(98, 120, 137, -1));
       jPanel6.add(jCGetSex, new XYConstraints(98, 38, 48, 20));
       jPanel1.add(jPanel5, new XYConstraints(256, 3, 202, 87));
       jPanel11.add(jBDelete, new XYConstraints(1, 4, 61, 27));
       this.getContentPane().add(jPanel11, new XYConstraints(283, 389, 69, 41));
       this.getContentPane().add(jPanel4, new XYConstraints(5, 389, 275, 41));
       jPanel10.add(jScrollPane1, new XYConstraints(4, 24, 453, 95));
       jScrollPane1.getViewport().add(jTGetReMark);
       this.getContentPane().add(jPanel10, new XYConstraints(5, 259, 463, 127));
       this.getContentPane().add(jPanel1, new XYConstraints(3, 5, 465, 247));
       jPanel3.add(jButton3, new XYConstraints(4, 4, 81, 26));
       jPanel3.add(jButton4, new XYConstraints(4, 35, 81, 26));
       jPanel3.add(jButton5, new XYConstraints(185, 34, 81, 26));
       jPanel3.add(jButton6, new XYConstraints(185, 4, 81, 26));
       jPanel3.add(jButton12, new XYConstraints(94, 18, 77, 31));
       this.getContentPane().add(jPanel3, new XYConstraints(5, 433, 274, 68));
       this.getContentPane().add(jPanel12, new XYConstraints(357, 463, 111, 38));
       this.getContentPane().add(jPanel13, new XYConstraints(283, 433, 69, 68));
       jPanel13.add(jBNewBuildFinish, new XYConstraints(2, 34, 61, 26));
       jPanel13.add(jBNewBuild, new XYConstraints(2, 4, 61, 26));
       jPanel7.add(jTGetPhone, new XYConstraints(98, 30, 219, -1));
       jPanel7.add(jTGetIDCard, new XYConstraints(98, 3, 219, -1));
       jPanel12.add(jBQuit, new XYConstraints(5, 2, 97, -1));
       this.getContentPane().add(jPanel2, new XYConstraints(357, 389, 111, 71));
       jPanel2.add(jBChange, new XYConstraints(5, 2, 97, 25));
       jPanel2.add(jBChangeFinish, new XYConstraints(5, 34, 97, 25));
       jPanel5.add(jCGetDuty, new XYConstraints(64, 59, 130, 20));
       jPanel5.add(jCGetDepartment, new XYConstraints(64, 31, 130, 20));
       jPanel5.add(jTGetEmpID, new XYConstraints(64, 6, 75, -1));
        jPanel9.add(jCGetPopedom, new XYConstraints(64, 2, 75, 20));
        jPanel5.add(jBEmpID, new XYConstraints(143, 5, 51, 21));
        jPanel10.add(jLShowRemark, new XYConstraints(6, 2, 40, 21));
    }
}