userdb.java

云网论坛CWBBS 源码,内容丰富,学习,参考,教学的好资料,具体见内说明,

                conn = null;
            }
        }
        return true;
    }


    /**
     * 搜索贴子时使用
     * @param nick String
     * @return String
     */
    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));
                myfaceWidth = rs.getInt(23);
                myfaceHeight = rs.getInt(24);
                experience = rs.getInt(25);
                credit = rs.getInt(26);
                addCount = rs.getInt(27);
                delCount = rs.getInt(28);
                arrestDay = rs.getInt(29);
                arrestReason = StrUtil.getNullStr(rs.getString(30));
                arrestTime = DateUtil.parse(rs.getString(31));
                arrestPolice = StrUtil.getNullStr(rs.getString(32));
                isPolice = rs.getInt(33);
                try {
                    regDate = DateUtil.parse(rs.getString(34));
                    lastTime = DateUtil.parse(rs.getString(35));
                    curTime = DateUtil.parse(rs.getString(36));
                } catch (Exception e) {}
                eliteCount = rs.getInt(37);
                gold = rs.getInt(38);
                favoriate = StrUtil.getNullString(rs.getString(39));
                valid = rs.getInt(40) == 1 ? true : false;
                rawPwd = rs.getString(41);
                diskSpaceAllowed = rs.getInt(42);
                diskSpaceUsed = rs.getInt(43);
                secret = rs.getInt(44) == 1 ? true : false;
                id = name;
                ip = StrUtil.getNullStr(rs.getString(45));
                releaseTime = DateUtil.parse(rs.getString(46));
                String tzID = StrUtil.getNullStr(rs.getString(47));
                timeZone = TimeZone.getTimeZone(tzID);
                home = StrUtil.getNullStr(rs.getString(48));
                msn = StrUtil.getNullStr(rs.getString(49));
                groupCode = StrUtil.getNullStr(rs.getString(50));
                locale = StrUtil.getNullStr(rs.getString(51));
                nick = rs.getString(52);
                checkStatus = rs.getInt(53);
                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 int getMyfaceWidth() {
        return myfaceWidth;
    }

    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 int getMyfaceHeight() {
        return this.myfaceHeight;
    }

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

    /**
     * 取得用户所属的组，如果用户被指定组，则返回指定组，如果未指定，即groupCode为空，则返回根据级别自动划分的组，如果都没有，则返回everyone组
     * 用以进行权限的判别，及页面的显示
     * @return UserGroupDb
     */
    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 = new Config();
        String level = cfg.getProperty("forum.userLevel");
        Vector v = uld.getAllLevel();
        int levelCompare = 0;

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


        int len = v.size();
        UserLevelDb myuld = (UserLevelDb) v.get(0);
        if(levelCompare < (myuld.getLevel()))
            return myuld;
        int i = 0;
        while (i < len) {
            myuld = (UserLevelDb) v.get(i);
            int lv = myuld.getLevel();
            if ((i + 1) < len) {
                UserLevelDb uld1 = (UserLevelDb) v.get(i + 1);
                int lv1 = uld1.getLevel();
                if (levelCompare >= lv && levelCompare < lv1) {
                    break;
                }
            } else {
                break;
            }
            i++;
        }
        return myuld;
    }

    /**
     * 取得等级的图像路径
     * @return String
     */
    public String getLevelPic() {
        return getUserLevelDb().getLevelPicPath();
    }

    /**
     * 取得等级的描述
     * @return String
     */
    public String getLevelDesc() {
        return getUserLevelDb().getDesc();
    }

    public void setMyfaceHeight(int h) {
        this.myfaceHeight = h;
    }

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

    public void setMyfaceWidth(int myfaceWidth) {
        this.myfaceWidth = myfaceWidth;
    }

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

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