returnpopedom.java~8~

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

package hotelinformationmanagesystem;

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;
import java.util.Date;
import java.text.SimpleDateFormat;

/**
 * <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 ReturnPopedom {

    public ReturnPopedom() {
    }

    DataConnect connect = new DataConnect();
    JudgeValidity judgeval = new JudgeValidity();
//------------------------------------------------------------------------
    public static String strEmpID = null; //全局变量，用于存放登录用户ID
    public static String strName = null; //全局变量，用于存放登录用户姓名
    public static String strSex = null; //全局变量，用于存放登录用户性别
    public static String strNationality = null; //全局变量，用于存放登录用户的民族
    public static Date   Birthday = null; //全局变量，用于存放登录用户生日
    public static String strIDCard = null; //全局变量，用于存放登录用户身分证号
    public static String strNative = null; //全局变量，用于存放登录用户籍贯
    public static String strAddress = null; //全局变量，用于存放登录用户地址
    public static String strPhone = null; //全局变量，用于存放登录用户联系电话
    public static String strDepartment = null; //全局变量，用于存放登录用户部门
    public static String strDuty = null; //全局变量，用于存放登录用户职责
    public static String strPopedom = null; //全局变量，用于存放登录用户权限
    public static String strPassword = null; //全局变量，用于存放登录用户密码
    public static String strRemark = null; //全局变量，用于存放登录用户备注
//----------------------------------------------------－－－－－－－－---上述全局变量用于存储登录用户的信息

    int inFlagth = 0; //用于存放用户输入错误的次数，超过三次自动退出系统

    public void returnpower(LoggingIn logg) {
        int inFlag = 0; //设定标志位，如果inFlag=0,则说明用户名或密码不正确
        strEmpID = logg.jTGetEmpID.getText(); //取出输入的用户名，并存放入变量中
        strPassword = String.valueOf(logg.jPGetPassword.getPassword()); //取出输入的密码值，并存放入变量中
        if(!judgeval.IsNumberAndLetter(strEmpID)){
            JOptionPane.showMessageDialog(null,
                              "您输入的用户名有误，请重新输入！",
                              "酒店信息管理系统警告",
                              JOptionPane.WARNING_MESSAGE);
            logg.jTGetEmpID.setText("");
            return;
        }
        try {
            //-----------------------------------------------------------------------------------------------------
            connect.Connnect(); //装入驱动
            connect.con1 = DriverManager.getConnection(connect.url); //建立连接
            connect.stmt1 = connect.con1.createStatement(); //创建语句
            connect.sql1 = "SELECT * FROM HIMS_Employee";
            ResultSet rs1 = connect.stmt1.executeQuery(connect.sql1);
            //-----------------------------------------------------------------------------------------------------
            while (rs1.next()) {
                String strDateEmpID = rs1.getString("EmpID"); //用于存放库中的员工ID
                strName = rs1.getString("Name");
                strSex = rs1.getString("Sex");
                strNationality = rs1.getString("Nationality");
                Birthday = rs1.getDate("Birthday");
                strIDCard = rs1.getString("IDCard");
                strNative = rs1.getString("Native");
                strAddress = rs1.getString("Address");
                strPhone = rs1.getString("Phone");
                strDepartment = rs1.getString("Department");
                strDuty = rs1.getString("Duty");
                String strDatePopedom = rs1.getString("Purview"); //用于存放库中的员工权限
                String strDatePassword = rs1.getString("Password"); //用于存放库中的员工密码
                strRemark = rs1.getString("Remark");

                if (strDateEmpID.equals(strEmpID) && strDatePassword.equals(strPassword) &&
                    strDatePopedom.equals("0")) { //系统管理员
                    inFlag = 1; //如果用户名和密码正确，则将该标志位设为1
                    strPopedom = strDatePopedom;
                    logg.setVisible(false);
                    return;
                }
                //----------------------------------------------------------------------------------------------------------
                if (strDateEmpID.equals(strEmpID) && strDatePassword.equals(strPassword) &&
                    strDatePopedom.equals("1")) { //服务部经理
                    inFlag = 1; //如果用户名和密码正确，则将该标志位设为1
                    strPopedom = strDatePopedom;
                    logg.setVisible(false);
                    return;
                }
                //----------------------------------------------------------------------------------------------------------
                if (strDateEmpID.equals(strEmpID) && strDatePassword.equals(strPassword) &&
                    strDatePopedom.equals("2")) { //客房部经理
                    inFlag = 1; //如果用户名和密码正确，则将该标志位设为1
                    strPopedom = strDatePopedom;
                    logg.setVisible(false);
                    return;
                }
                //----------------------------------------------------------------------------------------------------------
                if (strDateEmpID.equals(strEmpID) && strDatePassword.equals(strPassword) &&
                    strDatePopedom.equals("3")) { //前台服务员
                    inFlag = 1; //如果用户名和密码正确，则将该标志位设为1
                    strPopedom = strDatePopedom;
                    logg.setVisible(false);
                    return;
                }
                //----------------------------------------------------------------------------------------------------------
                if (strDateEmpID.equals(strEmpID) && strDatePassword.equals(strPassword) &&
                    strDatePopedom.equals("4")) { //其它工作人员
                    inFlag = 1; //如果用户名和密码正确，则将该标志位设为1
                    strPopedom = strDatePopedom;
                    logg.setVisible(false);
                    return;
                }
            } //while

            //-----------------------------------------------------------------------------------------------------------
            if (inFlag != 1) { //如果用户名和密码输入不正确，则
                inFlagth++; //第输入错误一次，标志位自动加一
                JOptionPane.showMessageDialog(null,
                                              "您输入的用户名或密码有误，请重新输入！",
                                              "酒店信息管理系统警告",
                                              JOptionPane.WARNING_MESSAGE);
                logg.jTGetEmpID.setText(""); //清空文本框中的内容
                logg.jPGetPassword.setText(""); //清空文本框中的内容
            }
            if (inFlagth == 3) {
                JOptionPane.showMessageDialog(null,
                                              "您输入的错误次数已三次，系统自动退出，谢谢使用！",
                                              "酒店信息管理系统警告",
                                              JOptionPane.WARNING_MESSAGE);
                System.exit(0);
            } //if 当输入次数超过三次时，自动退出系统

        } catch (SQLException ex) {
            System.err.println("SQLException:" + ex.getMessage());
        } finally {
            try {
                if (connect.con1 != null) {
                    connect.con1.close(); //关闭数据库
                    connect.stmt1.close();
                } //if
            } catch (SQLException ex) {
                System.out.println(ex);
            } //catch
        } //finally
    }

}