usersign.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 UserSign {

  String SQL = "";
  DbTrans DBSQL;
  DoText myDoText;
  ResultSet rs = null;
  private String sign_name1 = "";
  private String sign_detail1 = "";
  private String sign_name2 = "";
  private String sign_detail2 = "";
  private String sign_name3 = "";
  private String sign_detail3 = "";
  public UserSign() {
      this.DBSQL = new DbTrans();
      this.myDoText = new DoText();
  }

  public void setUserSign(String strUserID) {
      SQL = "select * from sign where UID="+ strUserID;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              this.sign_name1 = rs.getString("sign_name1");
              this.sign_detail1 = myDoText.delBr(rs.getString("sign_detail1"));
              this.sign_name2 = rs.getString("sign_name2");
              this.sign_detail2 = myDoText.delBr(rs.getString("sign_detail2"));
              this.sign_name3 = rs.getString("sign_name3");
              this.sign_detail3 = myDoText.delBr(rs.getString("sign_detail3"));
          }
          rs.close();
      }
      catch (SQLException e){
      }
  }

  public String getSignName1() {
      return this.sign_name1;
  }

  public String getSignDetail1() {
      return this.sign_detail1;
  }

  public String getSignName2() {
      return this.sign_name2;
  }

  public String getSignDetail2() {
      return this.sign_detail2;
  }

  public String getSignName3() {
      return this.sign_name3;
  }

  public String getSignDetail3() {
      return this.sign_detail3;
  }

  public boolean setSignOK(String strUserID,String strSignName1,String strSignDetail1,String strSignName2,String strSignDetail2,String strSignName3,String strSignDetail3) {
      strSignName1 = myDoText.htmlEncode(strSignName1);
      strSignDetail1 = myDoText.addBr(myDoText.addSlashes(myDoText.ScriptEncode(strSignDetail1)));
      strSignName2 = myDoText.htmlEncode(strSignName2);
      strSignDetail2 = myDoText.addBr(myDoText.addSlashes(myDoText.ScriptEncode(strSignDetail2)));
      strSignName3 = myDoText.htmlEncode(strSignName3);
      strSignDetail3 = myDoText.addBr(myDoText.addSlashes(myDoText.ScriptEncode(strSignDetail3)));
      int mesign = 0;
      SQL = "select count(*) as mesign from sign where UID="+ strUserID;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              mesign = rs.getInt("mesign");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      if (mesign == 1) {
          SQL = "update sign set sign_name1='"+ strSignName1 +"',sign_detail1='"+ strSignDetail1 +"',sign_name2='"+ strSignName2 +"',sign_detail2='"+ strSignDetail2 +"',sign_name3='"+ strSignName3 +"',sign_detail3='"+ strSignDetail3 +"' where UID="+ strUserID;
          try {
              DBSQL.executeUpdate(SQL);
              return true;
          }
          catch (SQLException e){
              return false;
          }
      }
      else {
          SQL =  "insert into sign (UID,sign_name1,sign_detail1,sign_name2,sign_detail2,sign_name3,sign_detail3) values ('"+ strUserID +"','"+ strSignName1 +"','"+ strSignDetail1 +"','"+ strSignName2 +"','"+ strSignDetail2 +"','"+ strSignName3 +"','"+ strSignDetail3 +"')";
	  try {
              DBSQL.executeUpdate(SQL);
              return true;
          }
          catch (SQLException e){
              return false;
          }
      }

  }

  public String getShowSign(String strUserID) {
      String strShowSign = "";
      String sign_name1 = "";
      String sign_detail1 = "";
      String sign_name2 = "";
      String sign_detail2 = "";
      String sign_name3 = "";
      String sign_detail3 = "";
      SQL = "select * from sign where UID="+ strUserID;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              sign_name1 = rs.getString("sign_name1");
              sign_detail1 = rs.getString("sign_detail1");
              sign_name2 = rs.getString("sign_name2");
              sign_detail2 = rs.getString("sign_detail2");
              sign_name3 = rs.getString("sign_name3");
              sign_detail3 = rs.getString("sign_detail3");
          }
	  rs.close();
          if (sign_name1 != null && sign_name1.length()>0 && sign_detail1 != null && sign_detail1.length()>0) {
              strShowSign += "<input type='radio' name='sign' value='1'>"+ myDoText.iso2gb(sign_name1) +" ";
          }
	  if (sign_name2 != null && sign_name2.length()>0 && sign_detail2 != null && sign_detail2.length()>0) {
              strShowSign += "<input type='radio' name='sign' value='2'>"+ myDoText.iso2gb(sign_name2) +" ";
          }
	  if (sign_name3 != null && sign_name3.length()>0 && sign_detail3 != null && sign_detail3.length()>0) {
              strShowSign += "<input type='radio' name='sign' value='3'>"+ (sign_name3) +" ";
          }
      }
      catch (SQLException e){
      }
      return strShowSign;
  }

  public String getPostUserSign(String strUserID, String sign) {
      String sign_detail = "";
      //签名
      String sign_name1 = "";
      String sign_detail1 = "";
      String sign_name2 = "";
      String sign_detail2 = "";
      String sign_name3 = "";
      String sign_detail3 = "";
      SQL = "select * from sign where UID="+ strUserID;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              sign_name1 = rs.getString("sign_name1");
              sign_detail1 = rs.getString("sign_detail1");
              sign_name2 = rs.getString("sign_name2");
              sign_detail2 = rs.getString("sign_detail2");
              sign_name3 = rs.getString("sign_name3");
              sign_detail3 = rs.getString("sign_detail3");
          }
	  rs.close();
	  if (sign.equals("1")) {
              sign_detail = sign_detail1;
          }
	  if (sign.equals("2")) {
              sign_detail = sign_detail2;
          }
	  if (sign.equals("3")) {
              sign_detail = sign_detail3;
          }
      }
      catch (SQLException e){
      }
      return sign_detail;
  }

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


}