empinfmanage.java~3~

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

package hotelinformationmanagesystem;

import java.awt.*;
import com.borland.jbcl.layout.XYLayout;
import com.borland.jbcl.layout.*;
import java.sql.ResultSet;
import java.io.IOException;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.swing.*;
import javax.swing.BorderFactory;
import java.awt.Font;

/**
 * <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 EmpInfManage extends JFrame {
    XYLayout xYLayout1 = new XYLayout();
    JPanel jPEmpInf = new JPanel();
    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 jPTool2 = new JPanel();
    XYLayout xYLayout4 = new XYLayout();
    JButton jBPageUp = new JButton();
    JButton jBPageDown = new JButton();
    JButton jBEndPage = new JButton();
    JButton jBTopPage = new JButton();
    JPanel jPTool1 = new JPanel();
    JButton jBSearchEmpID = new JButton();
    XYLayout xYLayout5 = new XYLayout();
    JLabel jLSearchEmpID = new JLabel();
    JTextField jTSearchEmpID = new JTextField();
    JPanel jPEmpInf2 = 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 jPEmpInf1 = new JPanel();
    XYLayout xYLayout7 = new XYLayout();
    JPanel jPEmpInf5 = 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 jPEmpInf3 = new JPanel();
    XYLayout xYLayout9 = new XYLayout();
    JLabel jLShowPassword = new JLabel();
    JPasswordField jPGetPassword = new JPasswordField();
    JButton jBPassword = new JButton();
    JButton jBDelete = new JButton();
    JPanel jPEmpInf4 = new JPanel();
    XYLayout xYLayout10 = new XYLayout();
    JLabel jLShowPopedom = new JLabel();
    JButton jBPopedom = new JButton();
    JPanel jPEmpInf6 = new JPanel();
    XYLayout xYLayout11 = new XYLayout();
    JLabel jLShowRemark = new JLabel();
    JButton jBChange = new JButton();
    XYLayout xYLayout12 = new XYLayout();
    JButton jBBack = new JButton();
    JScrollPane jSGetRemark = new JScrollPane();
    JTextArea jTGetReMark = new JTextArea();
    JPanel jPTool5 = new JPanel();
    XYLayout xYLayout3 = new XYLayout();
    JPanel jPTool6 = new JPanel();
    XYLayout xYLayout13 = new XYLayout();
    JPanel jPTool4 = 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();
    JPanel jPTool3 = new JPanel();
    XYLayout xYLayout15 = new XYLayout();

    //------------------------------------------------------
    DataConnect connect1 = new DataConnect();
    DataConnect connect2 = new DataConnect();
    DataConnect connect3 = new DataConnect();

    ResultSet rs1l = null;
    //-------------------------------------------------------
    ReturnPopedom repower = new ReturnPopedom();
    String strNowEmpID = null;
    JTextField jTGetPopedom = new JTextField();


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

    private void jbInit() throws Exception {
        getContentPane().setLayout(xYLayout1);
        this.setTitle("酒店员工信息管理界面");
        this.setSize(480, 540); //设置窗口初始位置
        this.setResizable(false);
        SetFormCenter wcenter = new SetFormCenter();
        wcenter.setcenter(this);
        xYLayout1.setWidth(474);
        xYLayout1.setHeight(507);
        jPEmpInf.setBorder(BorderFactory.createEtchedBorder());
        jPEmpInf.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("退出");
        jPTool2.setLayout(xYLayout4);
        jPTool2.setBorder(BorderFactory.createEtchedBorder());
        jBPageUp.setText("上一页");
        jBPageDown.setText("下一页");
        jBEndPage.setText("末页");
        jBTopPage.setText("首页");
        jPTool1.setBorder(BorderFactory.createEtchedBorder());
        jPTool1.setLayout(xYLayout5);
        jBSearchEmpID.setText("查找");
        jLSearchEmpID.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLSearchEmpID.setText("员工ID");
        jPEmpInf2.setLayout(xYLayout6);
        jPEmpInf2.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("职　务");
        jPEmpInf1.setBorder(BorderFactory.createEtchedBorder());
        jPEmpInf1.setLayout(xYLayout7);
        jPEmpInf5.setBorder(BorderFactory.createEtchedBorder());
        jPEmpInf5.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("联系电话");
        jPEmpInf3.setBorder(BorderFactory.createEtchedBorder());
        jPEmpInf3.setLayout(xYLayout9);
        jLShowPassword.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowPassword.setText("密　码");
        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("删除");
        jPEmpInf4.setBorder(BorderFactory.createEtchedBorder());
        jPEmpInf4.setLayout(xYLayout10);
        jLShowPopedom.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowPopedom.setText("权　限");
        jBPopedom.setFont(new java.awt.Font("宋体",  Font.BOLD, 8));
        jBPopedom.setText("修改");
        jPEmpInf3.setBorder(BorderFactory.createEtchedBorder());
        jPEmpInf6.setLayout(xYLayout10);
        jLShowRemark.setFont(new java.awt.Font("宋体", Font.BOLD, 15));
        jLShowRemark.setText("备注");
        jBChange.setFont(new java.awt.Font("宋体", Font.BOLD, 18));
        jBChange.setToolTipText("完成");
        jBChange.setText("修改");
        jPTool5.setLayout(xYLayout3);
       jPTool5.setBorder(BorderFactory.createEtchedBorder());
        jPTool6.setLayout(xYLayout13);
        jPTool6.setBorder(BorderFactory.createEtchedBorder());
        jPTool4.setLayout(xYLayout14);
        jPTool4.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));
        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.setFont(new java.awt.Font("宋体", Font.PLAIN, 9));
        jBEmpID.setText("验证");
        jPEmpInf6.setBorder(BorderFactory.createEtchedBorder());
        jPTool3.setLayout(xYLayout15);
        jPTool3.setBorder(BorderFactory.createEtchedBorder());
        jBBack.setText("返回");
        jPEmpInf2.add(jLShowDuty, new XYConstraints(3, 57, -1, 20));
        jPEmpInf2.add(jLShowDepartment, new XYConstraints(3, 31, -1, 20));
        jPEmpInf2.add(jLShowEmpID, new XYConstraints(3, 6, -1, 20));
        jPEmpInf1.add(jShowName, new XYConstraints(5, 6, -1, 20));
        jPEmpInf1.add(jTGetName, new XYConstraints(98, 6, 104, -1));
        jPEmpInf1.add(jLShowSex, new XYConstraints(5, 38, 68, 20));
        jPEmpInf1.add(jTGetBirthday, new XYConstraints(98, 66, 86, -1));
        jPEmpInf1.add(jLShowNationality, new XYConstraints(5, 94, -1, 20));
        jPEmpInf1.add(jLShowBirthday, new XYConstraints(5, 66, -1, 20));
        jPEmpInf1.add(jTGetNationality, new XYConstraints(98, 94, 86, -1));
        jPEmpInf1.add(jLShowNative, new XYConstraints(5, 122, -1, -1));
        jPEmpInf.add(jPEmpInf1, new XYConstraints(4, 3, 249, 149));
        jPEmpInf5.add(jLShowIDCard, new XYConstraints(5, 7, -1, -1));
        jPEmpInf5.add(jLShowAddress, new XYConstraints(5, 60, -1, -1));
        jPEmpInf5.add(jTGetAddress, new XYConstraints(98, 58, 335, -1));
        jPEmpInf5.add(jLShowPhone, new XYConstraints(5, 33, -1, -1));
        jPEmpInf3.add(jLShowPassword, new XYConstraints(3, 1, -1, -1));
        jPEmpInf3.add(jPGetPassword, new XYConstraints(64, 1, 75, 18));
        jPEmpInf3.add(jBPassword, new XYConstraints(143, 1, 52, 18));
        jPEmpInf.add(jPEmpInf5, new XYConstraints(4, 155, 454, 85));
        jPTool1.add(jTSearchEmpID, new XYConstraints(60, 4, 125, 27));
        jPTool1.add(jBSearchEmpID, new XYConstraints(196, 4, 70, 27));
        jPTool1.add(jLSearchEmpID, new XYConstraints(4, 4, 53, 30));
        jPEmpInf.add(jPEmpInf3, new XYConstraints(256, 94, 202, 26));
        jPEmpInf.add(jPEmpInf4, new XYConstraints(256, 123, 202, 29));
        jPEmpInf4.add(jLShowPopedom, new XYConstraints(5, 4, -1, -1));
        jPEmpInf4.add(jBPopedom, new XYConstraints(143, 2, 52, 20));
        jPEmpInf1.add(jTGetNative, new XYConstraints(98, 120, 137, -1));
        jPEmpInf1.add(jCGetSex, new XYConstraints(98, 38, 48, 20));
        jPEmpInf.add(jPEmpInf2, new XYConstraints(256, 3, 202, 87));
        this.getContentPane().add(jPTool1, new XYConstraints(5, 389, 275, 41));
        jPTool2.add(jBPageUp, new XYConstraints(4, 4, 81, 26));
        jPTool2.add(jBPageDown, new XYConstraints(4, 35, 81, 26));
        jPTool2.add(jBEndPage, new XYConstraints(185, 34, 81, 26));
        jPTool2.add(jBTopPage, new XYConstraints(185, 4, 81, 26));
        jPTool2.add(jBBack, new XYConstraints(94, 18, 77, 31));
        this.getContentPane().add(jPTool2, new XYConstraints(5, 433, 274, 68));
        this.getContentPane().add(jPTool6, new XYConstraints(357, 463, 111, 38));
        this.getContentPane().add(jPTool4, new XYConstraints(283, 433, 69, 68));
        jPTool4.add(jBNewBuildFinish, new XYConstraints(2, 34, 61, 26));
        jPTool4.add(jBNewBuild, new XYConstraints(2, 4, 61, 26));
        jPEmpInf5.add(jTGetPhone, new XYConstraints(98, 30, 219, -1));
        jPEmpInf5.add(jTGetIDCard, new XYConstraints(98, 3, 219, -1));
        jPTool6.add(jBQuit, new XYConstraints(5, 2, 97, -1));
        this.getContentPane().add(jPTool5, new XYConstraints(357, 389, 111, 71));
        jPTool5.add(jBChange, new XYConstraints(5, 2, 97, 25));
        jPTool5.add(jBChangeFinish, new XYConstraints(5, 34, 97, 25));
        jPEmpInf2.add(jCGetDuty, new XYConstraints(64, 59, 130, 20));
        jPEmpInf2.add(jCGetDepartment, new XYConstraints(64, 31, 130, 20));
        jPEmpInf2.add(jTGetEmpID, new XYConstraints(64, 6, 75, -1));
        jPEmpInf2.add(jBEmpID, new XYConstraints(143, 5, 51, 21));
        jPEmpInf6.add(jLShowRemark, new XYConstraints(6, 2, 40, 21));
        jPEmpInf6.add(jSGetRemark, new XYConstraints(8, 23, 430, 95));
        jPEmpInf.add(jPEmpInf6, new XYConstraints(4, 246, 454, 127));
        jSGetRemark.getViewport().add(jTGetReMark);
        this.getContentPane().add(jPEmpInf, new XYConstraints(3, 5, 467, 381));
        this.getContentPane().add(jPTool3, new XYConstraints(283, 389, 69, 41));
        jPTool3.add(jBDelete, new XYConstraints(2, 3, 61, 30));
        jPEmpInf4.add(jTGetPopedom, new XYConstraints(64, 3, 75, -1));


    }
}