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;    }}