userinfo.java

来自「用java写的用户管理程序」· Java 代码 · 共 156 行

package business.usermanage;

import java.sql.ResultSet;
import java.sql.SQLException;
import foundation.common.*;
import foundation.database.DbCommunion;

/**--------------------------------------------------------<br>
 * Title:        用户信息类【可用于Session管理】<br>
 * Description:  完成数据库的连接,查询,增删改数据以及执行存储过程等操作.<br>
 * Copyright:
 * Company:
 * @author
 * @version      1.0
 * @date
 *---------------------------------------------------------*/

public class UserInfo {
    //static define
    private static String strUserID;
    private static String strPwd;
    private static String strUserName;
    private static String strUserCode;
    private static int iUserRole;
    private static String strMemo;
    //enterprise part
    private static String iSendID;
    private static String strCompCode;
    private static String strCompName;
    private static String strCompTel;
    private static String strCompAddress;

    /** the database communion object */
    public DbCommunion dbCommunion = null;

    public String checkUser(DbCommunion DbCmmnn, String pstrUserID) {
        String strRet = null;
        try {
            String strSql = "SELECT UNAME,UPASSWORD,UCODE,UROLE,UMEMO,"
               +"T2.SendID,COMPCODE,COMPNAME,TEL,ADDRESS FROM [USER] t1, COMPINFO t2 "
               +"WHERE t1.SendID=t2.SendID And UID='" + pstrUserID + "' ";
            //执行查询
            ResultSet rs = DbCmmnn.executeQuery( strSql );

            if(rs!=null) {
                strRet = "OK";
                setUserID(pstrUserID);
                setUserName(rs.getString("UNAME"));
                setPassword(rs.getString("UPASSWORD"));
                setUserCode(rs.getString("UCODE"));
                setUserRole(rs.getInt("UROLE"));
                setMemo(rs.getString("UMEMO"));

                setSendID(rs.getString("SendID"));
                setCompCode(rs.getString("CompCODE"));
                setCompName(rs.getString("CompNAME"));
                setCompTel(rs.getString("TEL"));
                setCompAddr(rs.getString("ADDRESS"));

            }

        }
        catch(SQLException ex) {
            //write log
            System.err.println("error at checkuser id " + ex);
        }

        return strRet ;
    }

    public void setUserID(String pUserID) {
        this.strUserID = pUserID;
    }
    public String getUserID() {
        return this.strUserID;
    }

    public void setPassword(String pPWD) {
        this.strPwd = pPWD;
    }
    public String getPassword() {
        if(this.strPwd!=null)
            this.strPwd = this.strPwd.trim();
        return this.strPwd;
    }

    public void setUserName(String pUserName){
        this.strUserName = pUserName;
    }
    public String getUserName() {
        return this.strUserName;
    }

    public void setUserCode(String pCode) {
        this.strUserCode = pCode;
    }
    public String getUserCode() {
        return this.strUserCode;
    }

    public void setUserRole(int pRole) {
        this.iUserRole = pRole;
    }
    public int getUserRole() {
        return this.iUserRole;
    }

    public void setMemo(String pCode) {
        this.strMemo = pCode;
    }
    public String getMemo() {
        return this.strMemo;
    }

    public String getSendID() {
        return this.iSendID;
    }

    public String getCompCode() {
        return this.strCompCode;
    }

    public String getCompName() {
        return this.strCompName;
    }

    public String getCompTel() {
        return this.strCompTel;
    }

    public String getCompAddr() {
        return this.strCompAddress;
    }

    public void setSendID(String pValue) {
        this.iSendID = pValue;
    }

    public void setCompCode(String pValue) {
        this.strCompCode = pValue;
    }

    public void setCompName(String pValue) {
        this.strCompName = pValue;
    }

    public void setCompTel(String pValue) {
        this.strCompTel = pValue;
    }

    public void setCompAddr(String pValue) {
        this.strCompAddress = pValue;
    }

}