sweetuserinfodb.java

源码/软件简介: 云网论坛1.1RC国际版是采用JSP开发的集论坛、CMS（网站内容管理系统）、博客、聊天室、商城、交友、语音灌水等于一体的门户式社区。拥有CWBBS ( Cloud Web BBS

    public void setBook(String book) {
        this.book = book;
    }

    public void setMusic(String music) {
        this.music = music;
    }

    public void setCelebrity(String celebrity) {
        this.celebrity = celebrity;
    }

    public void setPhoto(String photo) {
        this.photo = photo;
    }

    public void setHobby(String hobby) {
        this.hobby = hobby;
    }

    public void setFrendType(String frendType) {
        this.frendType = frendType;
    }

    public void setFrendAge(String frendAge) {
        this.frendAge = frendAge;
    }

    public void setFrendTall(String frendTall) {
        this.frendTall = frendTall;
    }

    public void setFrendMarriage(String frendMarriage) {
        this.frendMarriage = frendMarriage;
    }

    public void setFrendProvince(String frendProvince) {
        this.frendProvince = frendProvince;
    }

    public void setFrendXueli(String frendXueli) {
        this.frendXueli = frendXueli;
    }

    public void setFrendSalary(String frendSalary) {
        this.frendSalary = frendSalary;
    }

    public void setFrendRequire(String frendRequire) {
        this.frendRequire = frendRequire;
    }

    public void setManager(String manager) {
        this.manager = manager;
    }

    public void setChecked(boolean checked) {
        this.checked = checked;
    }

    public void setMember(int member) {
        this.member = member;
    }

    public void setMSN(String MSN) {
        this.MSN = MSN;
    }

    public void setICQ(String ICQ) {
        this.ICQ = ICQ;
    }

    public void setOICQ(int OICQ) {
        this.OICQ = OICQ;
    }


    public String getName() {
        return name;
    }

    public String getGender() {
        return gender;
    }

    public int getAge() {
        return age;
    }

    public java.util.Date getBirthday() {
        return birthday;
    }

    public String getMarriage() {
        return marriage;
    }

    public String getProvince() {
        return province;
    }

    public String getWorkAddress() {
        return workAddress;
    }

    public int getTall() {
        return tall;
    }

    public String getXueli() {
        return xueli;
    }

    public String getJob() {
        return job;
    }

    public String getSalary() {
        return salary;
    }

    public String getAddress() {
        return address;
    }

    public int getPostCode() {
        return postCode;
    }

    public String getTel() {
        return tel;
    }

    public String getEmail() {
        return email;
    }

    public String getDescription() {
        return description;
    }

    public String getSport() {
        return sport;
    }

    public String getBook() {
        return book;
    }

    public String getMusic() {
        return music;
    }

    public String getCelebrity() {
        return celebrity;
    }

    public String getPhoto() {
        return photo;
    }

    public String getHobby() {
        return hobby;
    }

    public String getFrendType() {
        return frendType;
    }

    public String getFrendAge() {
        return frendAge;
    }

    public String getFrendTall() {
        return frendTall;
    }

    public String getFrendMarriage() {
        return frendMarriage;
    }

    public String getFrendProvince() {
        return frendProvince;
    }

    public String getFrendXueli() {
        return frendXueli;
    }

    public String getFrendSalary() {
        return frendSalary;
    }

    public String getFrendRequire() {
        return frendRequire;
    }

    public String getManager() {
        return manager;
    }

    public boolean isChecked() {
        return checked;
    }

    public int getMember() {
        return member;
    }

    public String getMSN() {
        return MSN;
    }

    public String getICQ() {
        return ICQ;
    }

    public int getOICQ() {
        return OICQ;
    }

    public String getSkinCode() {
        return "default";
        // return skinCode;
    }

    private String name;
    private String gender;
    /**
     * isPluginBoard
     */
    public boolean isPluginBoard(String name) {
        SweetBoardDb sb = (SweetBoardDb)getObjectDb(name);
        if (sb.isLoaded())
            return true;
        else
            return false;
    }

    public String getMemberDesc() {
        if (member==this.MEMBER_COMMON)
            return "普通";
        else if (member==this.MEMBER_SILVER)
            return "银卡";
        else if (member==this.MEMBER_GOLD)
            return "金卡";
        else
            return "";
    }

    public void initDB() {
        this.tableName = "plugin_sweet_userinfo";
        primaryKey = new PrimaryKey("name", PrimaryKey.TYPE_STRING);
        objectCache = new SweetUserInfoCache(this);

        this.QUERY_CREATE = "insert into plugin_sweet_userinfo (name,gender,age,birthday,marriage,province,workAddress,tall,xueli,job,salary,address,postCode,tel,email,OICQ,ICQ,MSN,description,sport,book,music,celebrity,photo,hobby,frendType,frendAge,frendTall,frendMarriage,frendProvince,frendXueli,frendSalary, frendRequire, manager, isChecked,member) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
        this.QUERY_SAVE = "update plugin_sweet_userinfo set gender=?,age=?,birthday=?,marriage=?,province=?,workAddress=?,tall=?,xueli=?,job=?,salary=?,address=?,postCode=?,tel=?,email=?,OICQ=?,ICQ=?,MSN=?,description=?,sport=?,book=?,music=?,celebrity=?,photo=?,hobby=?,frendType=?,frendAge=?,frendTall=?,frendMarriage=?,frendProvince=?,frendXueli=?,frendSalary=?, frendRequire=?, manager=?, isChecked=?, member=? where name=?";
        this.QUERY_DEL = "delete from plugin_sweet_userinfo where name=?";
        this.QUERY_LOAD =
                "select gender,age,birthday,marriage,province,workAddress,tall,xueli,job,salary,address,postCode,tel,email,OICQ,ICQ,MSN,description,sport,book,music,celebrity,photo,hobby,frendType,frendAge,frendTall,frendMarriage,frendProvince,frendXueli,frendSalary, frendRequire, manager, isChecked, member from " + tableName + " where name=?";
        this.QUERY_LIST = "select name from plugin_sweet_userinfo";
        isInitFromConfigDB = false;
    }

    private int age;
    private java.util.Date birthday;
    private String marriage;
    private String province;
    private String workAddress;
    private String xueli;
    private String job;
    private String salary;
    private int postCode;
    private String tel;
    private String email;
    private int OICQ;
    private String ICQ;
    private String MSN;
    private String description;
    private String sport;
    private String book;
    private String music;
    private String celebrity;
    private String photo;
    private String hobby;
    private String frendType;
    private String frendAge;
    private String frendTall;
    private String frendMarriage;
    private String frendProvince;
    private String frendXueli;
    private String frendSalary;
    private String frendRequire;
    private String manager;
    private boolean checked;
    private int member;

    //name,gender,age,birthday,marriage,province,workAddress,tall,xueli,job,salary,
    //address,postCode,tel,email,OICQ,ICQ,MSN,description,sport,book,music,celebrity,
    //photo,hobby,frendType,frendAge,frendTall,frendMarriage,frendProvince,frendXueli,
    //frendSalary,frendRequire,manager,isChecked
}