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){      }  }}