userdb.java

cwbbs 云网论坛源码

        return re;
    }

    public void setPrimaryKey() {
        primaryKey = new PrimaryKey("name", PrimaryKey.TYPE_STRING);
    }

    public UserDb getUserDbByIP(String ip) {
        String sql =
                "select name from sq_user where ip=? order by RegDate desc";
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        Conn conn = new Conn(connname);
        try {
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, ip);
            rs = conn.executePreQuery();
            if (rs != null && rs.next()) {
                return getUser(rs.getString(1));
            }
        } catch (Exception e) {
            logger.error("getUserDbByIP: " + e.getMessage());
        } finally {
            if (conn != null) {
                conn.close();
                conn = null;
            }
        }
        return null;
    }

    public UserDb getUserDbByNick(String nick) {
        UserCache uc = new UserCache(this);
        return uc.getUserDbByNick(nick);
    }

    public boolean validEmailOnly(String email) {
        String sql = "select name from sq_user where Email=?";
        PreparedStatement pstmt = null;
        ResultSet rs = null;
        Conn conn = new Conn(connname);
        try {
            pstmt = conn.prepareStatement(sql);
            pstmt.setString(1, email);
            rs = conn.executePreQuery();
            if (rs != null && rs.next()) {
                return false;
            }
        } catch (Exception e) {
            logger.error("getUserDbByNick: " + e.getMessage());
        } finally {
            if (conn != null) {
                conn.close();
                conn = null;
            }
        }
        return true;
    }


    
    public String getNicksLike(String nick) {
        String sql = "select name from sq_user where nick like " +
                     StrUtil.sqlstr("%" + nick + "%");
        ResultSet rs = null;
        String nicks = "";
        Conn conn = new Conn(connname);
        try {
            rs = conn.executeQuery(sql);
            if (rs != null) {
                while (rs.next()) {
                    if (nicks.equals(""))
                        nicks = StrUtil.sqlstr(rs.getString(1));
                    else
                        nicks += "," + StrUtil.sqlstr(rs.getString(1));
                }
            }
        } catch (Exception e) {
            logger.error("getNicksLike: " + e.getMessage());
        } finally {
            if (conn != null) {
                conn.close();
                conn = null;
            }
        }
        return nicks;
    }

    public synchronized void load() {
        Conn conn = new Conn(connname);
        ResultSet rs = null;
        try {
            PreparedStatement pstmt = conn.prepareStatement(QUERY_LOAD);
            pstmt.setString(1, name);
            rs = conn.executePreQuery();
            if (rs != null && rs.next()) {
                pwdMd5 = rs.getString(1);
                question = StrUtil.getNullStr(rs.getString(2));
                answer = StrUtil.getNullStr(rs.getString(3));
                realName = StrUtil.getNullStr(rs.getString(4));
                career = StrUtil.getNullStr(rs.getString(5));
                gender = StrUtil.getNullStr(rs.getString(6));
                job = StrUtil.getNullStr(rs.getString(7));
                try {
                    birthday = DateUtil.parse(rs.getString(8));
                } catch (Exception e) {}
                marriage = rs.getInt(9);
                phone = StrUtil.getNullStr(rs.getString(10));
                mobile = StrUtil.getNullStr(rs.getString(11));
                state = StrUtil.getNullStr(rs.getString(12));
                city = StrUtil.getNullStr(rs.getString(13));
                address = StrUtil.getNullStr(rs.getString(14));
                postCode = StrUtil.getNullStr(rs.getString(15));
                IDCard = StrUtil.getNullStr(rs.getString(16));
                realPic = StrUtil.getNullStr(rs.getString(17));
                hobbies = StrUtil.getNullStr(rs.getString(18));
                email = StrUtil.getNullStr(rs.getString(19));
                oicq = StrUtil.getNullStr(rs.getString(20));
                sign = StrUtil.getNullStr(rs.getString(21));
                myface = StrUtil.getNullString(rs.getString(22));
                experience = rs.getInt(23);
                credit = rs.getInt(24);
                addCount = rs.getInt(25);
                delCount = rs.getInt(26);
                arrestDay = rs.getInt(27);
                arrestReason = StrUtil.getNullStr(rs.getString(28));
                arrestTime = DateUtil.parse(rs.getString(29));
                arrestPolice = StrUtil.getNullStr(rs.getString(30));
                isPolice = rs.getInt(31);
                try {
                    regDate = DateUtil.parse(rs.getString(32));
                    lastTime = DateUtil.parse(rs.getString(33));
                    curTime = DateUtil.parse(rs.getString(34));
                } catch (Exception e) {}
                eliteCount = rs.getInt(35);
                gold = rs.getInt(36);
                favoriate = StrUtil.getNullString(rs.getString(37));
                valid = rs.getInt(38) == 1 ? true : false;
                rawPwd = rs.getString(39);
                diskSpaceAllowed = rs.getInt(40);
                diskSpaceUsed = rs.getInt(41);
                secret = rs.getInt(42) == 1 ? true : false;
                id = name;
                ip = StrUtil.getNullStr(rs.getString(43));
                releaseTime = DateUtil.parse(rs.getString(44));
                String tzID = StrUtil.getNullStr(rs.getString(45));
                timeZone = TimeZone.getTimeZone(tzID);
                home = StrUtil.getNullStr(rs.getString(46));
                msn = StrUtil.getNullStr(rs.getString(47));
                groupCode = StrUtil.getNullStr(rs.getString(48));
                locale = StrUtil.getNullStr(rs.getString(49));
                nick = rs.getString(50);
                checkStatus = rs.getInt(51);
                onlineTime = rs.getFloat(52);
                fetion = StrUtil.getNullStr(rs.getString(53));
                canRename = rs.getInt(54)==1;
                loaded = true;
                primaryKey.setValue(name);
            }
        } catch (Exception e) {
            logger.error("load: " + e.getMessage());
        } finally {
            if (conn != null) {
                conn.close();
                conn = null;
            }
        }
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getExperience() {
        return this.experience;
    }

    public void setExperience(int e) {
        this.experience = e;
    }

    public int getCredit() {
        return this.credit;
    }

    public void setCredit(int c) {
        this.credit = c;
    }

    public int getAddCount() {
        return addCount;
    }

    public void setAddCount(int a) {
        this.addCount = a;
    }

    public int getDelCount() {
        return delCount;
    }

    public void setDelCount(int d) {
        this.delCount = d;
    }

    public String getPwdMd5() {
        return pwdMd5;
    }

    public void setPwdMd5(String p) {
        this.pwdMd5 = p;
    }

    public String getRealName() {
        return realName;
    }

    public String getEmail() {
        return email;
    }

    public String getGender() {
        return gender;
    }

    public Date getRegDate() {
        return regDate;
    }

    public String getSign() {
        return sign;
    }

    public String getMyface() {
        return myface;
    }

    public void setRealName(String r) {
        realName = r;
    }

    public void setEmail(String e) {
        email = e;
    }

    public void setGender(String gender) {
        this.gender = gender;
    }

    public void setRegDate(Date regDate) {
        this.regDate = regDate;
    }

    public void setSign(String sign) {
        this.sign = sign;
    }

    public String getQuestion() {
        return question;
    }

    public String getAnswer() {
        return answer;
    }

    public String getJob() {
        return job;
    }

    public String getPhone() {
        return phone;
    }

    public Date getBirthday() {
        return birthday;
    }

    public String getMobile() {
        return mobile;
    }

    public String getState() {
        return state;
    }

    public String getAddress() {
        return address;
    }

    public String getOicq() {
        return oicq;
    }

    public String getPostCode() {
        return postCode;
    }

    public String getHobbies() {
        return hobbies;
    }

    public String getCity() {
        return city;
    }

    public boolean isLoaded() {
        return loaded;
    }

    public String getIDCard() {
        return IDCard;
    }

    
    public UserGroupDb getUserGroupDb() {
        String userGroupCode = "";
        UserGroupDb ugd = new UserGroupDb();
        if (groupCode.equals("")) { 
            UserLevelDb uld = getUserLevelDb();
            
            if (uld.getGroupCode().equals("")) {
                return ugd.getUserGroupDb(ugd.EVERYONE);
            } else
                userGroupCode = uld.getGroupCode();
        } else
            userGroupCode = groupCode;
        return ugd.getUserGroupDb(userGroupCode);
    }

    public UserLevelDb getUserLevelDb() {
        UserLevelDb uld = new UserLevelDb();
        Config cfg = Config.getInstance();
        String level = cfg.getProperty("forum.userLevel");
        
        int levelCompare = 0;

        if (level.equals("levelCredit")) {
            if (credit < 0) {
                credit = 0;
            }
            levelCompare = credit;
        } else if (level.equals("levelExperience")) {
            if (experience < 0) {
                experience = 0;
            }
            levelCompare = experience;
        } else if (level.equals("levelGold")) {
            if (gold < 0) {
                gold = 0;
            }
            levelCompare = gold;
        } else if (level.equals("levelTopticCount")) {
            if (addCount < 0) {
                addCount = 0;
            }
            levelCompare = addCount;
        }

        return uld.getUserLevelDbByLevel(levelCompare);
    }

    
    public String getLevelPic() {
        return getUserLevelDb().getLevelPicPath();
    }

    
    public String getLevelDesc() {
        return getUserLevelDb().getDesc();
    }

    public void setMyface(String myface) {
        this.myface = myface;
    }

    public void setQuestion(String question) {
        this.question = question;
    }

    public void setAnswer(String answer) {
        this.answer = answer;
    }

    public void setJob(String job) {
        this.job = job;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public void setMobile(String mobile) {
        this.mobile = mobile;
    }