usermydata.java

BBS虚拟社区

package com.laoer.bbscs.user;

import java.sql.*;
import java.io.*;
import java.util.*;
import com.laoer.bbscs.db.*;
import com.laoer.bbscs.txthtml.*;

/**
 * <p>Title: BBS-CS</p>
 * <p>Description: BBS-CS(BBS式虚拟社区系统)</p>
 * <p>Copyright: Copyright (c) 2002</p>
 * <p>Company: loveroom.com.cn</p>
 * @author 龚天乙（laoer）
 * @version 3.0
 */

public class UserMyData {

  String SQL = "";
  DbTrans DBSQL;
  DoText myDoText;
  ResultSet rs = null;
  private String height = "";
  private String weight = "";
  private String interest = "";
  private String graduate = "";
  private String favourpeople = "";
  private String dreamjob = "";
  private String favourart = "";
  private String favourmusic = "";
  private String favourplace = "";
  private String favourmovie = "";
  private String favourchat = "";
  private String favourbook = "";
  private String dreamlover = "";
  private String favourteam = "";
  private String homepage = "";
  private String oicqno = "";
  private String icqno = "";
  private int sex = 0;
  private String brief = "";
  public UserMyData() {
      this.DBSQL = new DbTrans();
      this.myDoText = new DoText();
  }

  public void setUserMyData(String strUserID) {
      SQL = "select * from mydata where UID =" + strUserID;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              this.height = rs.getString("height");
              this.weight = rs.getString("weight");
              this.interest = rs.getString("interest");
              this.graduate = rs.getString("graduate");
              this.favourpeople = rs.getString("favourpeople");
              this.dreamjob = rs.getString("dreamjob");
              this.favourart = rs.getString("favourart");
              this.favourmusic = rs.getString("favourmusic");
              this.favourplace = rs.getString("favourplace");
              this.favourmovie = rs.getString("favourmovie");
              this.favourchat = rs.getString("favourchat");
              this.favourbook = rs.getString("favourbook");
              this.dreamlover = rs.getString("dreamlover");
              this.favourteam = rs.getString("favourteam");
              this.homepage = rs.getString("homepage");
              this.oicqno = rs.getString("oicqno");
              this.icqno = rs.getString("icqno");
	      this.sex = rs.getInt("sex");
              this.brief = rs.getString("brief");
	      //this.brief = myDoText.delBr(brief);
          }
          rs.close();
      }
      catch (SQLException e){
      }
  }

  public String getHeight() {
      if (this.height == null) {
          this.height = "";
      }
      return this.height;
  }

  public String getWeight() {
     if (this.weight == null) {
         this.weight = "";
     }
     return this.weight;
  }

  public String getInterest() {
      if (this.interest == null) {
          this.interest = "";
      }
      return this.interest;
  }

  public String getGraduate() {
      if (this.graduate == null) {
          this.graduate = "";
      }
      return this.graduate;
  }

  public String getFavourPeople() {
      if (this.favourpeople == null) {
          this.favourpeople = "";
      }
      return this.favourpeople;
  }

  public String getDreamJob() {
      if (this.dreamjob == null) {
          this.dreamjob = "";
      }
      return this.dreamjob;
  }

  public String getFavourArt() {
      if (this.favourart == null) {
          this.favourart = "";
      }
      return this.favourart;
  }

  public String getFavourMusic() {
      if (this.favourmusic == null) {
          this.favourmusic = "";
      }
      return this.favourmusic;
  }

  public String getFavourPlace() {
      if (this.favourplace == null) {
          this.favourplace = "";
      }
      return this.favourplace;
  }

  public String getFavourMovie() {
      if (this.favourmovie == null) {
          this.favourmovie = "";
      }
      return this.favourmovie;
  }

  public String getFavourChat() {
      if (this.favourchat == null){
          this.favourchat = "";
      }
      return this.favourchat;
  }

  public String getFavourBook() {
      if (this.favourbook == null) {
          this.favourbook = "";
      }
      return this.favourbook;
  }

  public String getDreamLover() {
      if (this.dreamlover == null) {
          this.dreamlover = "";
      }
      return this.dreamlover;
  }

  public String getFavourTeam() {
      if (this.favourteam == null) {
          this.favourteam = "";
      }
      return this.favourteam;
  }

  public String getHomePage() {
      if (this.homepage == null) {
          this.homepage = "";
      }
      return this.homepage;
  }

  public String getOicqNo() {
      if (this.oicqno == null) {
          this.oicqno = "";
      }
      return this.oicqno;
  }

  public String getIcqNo() {
      if (this.icqno == null) {
          this.icqno = "";
      }
      return this.icqno;
  }

  public int getSex() {
      return this.sex;
  }

  public String getBrief() {
      //this.brief = myDoText.delBr(this.brief);
      if (this.brief == null) {
          this.brief = "";
      }
      return this.brief;
  }

  public void close() {
      try {
          DBSQL.close();
      }
      catch (SQLException e) {
      }
  }
}