showdoc.java

BBS-CS是采用JSP+JavaBean+Servlet开发的一套网络虚拟社区系统. 运行平台： Liunx + JDK + Apache + Tomcat + MYSQL 或 Window

              }
              else {
                  strShowDoc += "隐藏";
              }
              strShowDoc += "' border=0 height=16 src=images/ip.gif width=16></div>\n</td>\n</tr>\n<tr>";
              strShowDoc += "<td colspan=2>\n";
              strShowDoc += "<div align=right><span class=bt>";
              strShowDoc += "</td>\n</tr>\n";
              strShowDoc += "<tr bgcolor=#FFFFFF>\n";
              strShowDoc += "<td colspan=2 height=13>\n";
              strShowDoc += "<table width=98% border=0 align=center cellpadding=2 cellspacing=3>\n";
              strShowDoc += "<tr>\n";
              strShowDoc += "<td>"+myDoText.iso2gb(myDoText.changeColor(rs.getString("detail")))+"<br>";
              String sign = rs.getString("sign");
              if (sign!=null && sign.length()>0) {
                  strShowDoc += "<br><br>------<br>"+ myDoText.iso2gb(sign);
              }
              if (rs.getString("amend") != null && rs.getString("amend").length()>0) {
                  strShowDoc += "<br>------<br><span class=bt><font color=#0099CC>"+myDoText.iso2gb(rs.getString("amend"))+"</font></span>";
              }
              strShowDoc += "<br><font color=#0099CC><span class=bt>※ "+rs.getString("delusername")+" 删除于: "+rs.getString("deltime")+"．(来自: "+rs.getString("delip")+")</span></font>";
              strShowDoc += "</td>\n</tr>\n<tr>\n<td>\n";
              if (strUserName.equals(rs.getString("delusername")) || isBoardsMaster) {
              strShowDoc += "<hr size=1>";
              strShowDoc += "<div align=right>";
              strShowDoc += "<span class=bt><a href='undel.jsp?recid="+ rs.getString("id") +"&bid="+bid+"&pages="+pages+"'>恢复</a></span>";
              strShowDoc += "</div>\n";
              }
              strShowDoc += "</td>\n</tr>\n</table>\n</td>\n</tr>\n<tr>\n<td colspan=2>\n";
              strShowDoc += "<div align=center><font face=Verdana, Arial, Helvetica, sans-serif><b><font size=2 color=#D40000>WWW.LOVEROOM.COM.CN</font></b></font></div>\n";
              strShowDoc += "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>\n<table width=615 border=0>\n<tr>\n<td  height=2></td>\n</tr>\n</table>\n";
          }
          rs.close();
      }
      catch (SQLException e) {
      }
      myBBSConf.close();
      return strShowDoc;
  }

  public String getReadElite(String recid) {
      BBSConf myBBSConf = new BBSConf();
      String strReadElite = "";
      String tabledarkcolor = myBBSConf.gettabledarkcolor();
      String tablemaincolor = myBBSConf.gettablemaincolor();
      String tabletintcolor = myBBSConf.gettabletintcolor();
      SQL = "select * from forum where id = "+recid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              strReadElite += "<table width=98% border=0 align=center cellpadding=0 cellspacing=0>\n<tr>\n";
              strReadElite += "<td bgcolor="+tablemaincolor+" height=23>　<font color=#FFFFFF>主题："+myDoText.iso2gb(rs.getString("title"))+"</font></td>\n</tr>\n";
              strReadElite += "<tr>\n";
              strReadElite += "<td height=84 bgcolor="+tabledarkcolor+">\n";
              strReadElite += "<table width=98% border=0 align=center>\n<tr>\n";
              strReadElite += "<td width=98% class=bt> 发信人: "+myDoText.iso2gb(rs.getString("name"))+"("+myDoText.iso2gb(rs.getString("nickname"))+")<br>";
              strReadElite += "整理人: "+myDoText.iso2gb(rs.getString("doelitename"))+"("+rs.getString("doelitetime")+"), 站内信件</td></tr><tr>";
              strReadElite += "<td>\n<table width=96% border=0 align=center cellpadding=7 cellspacing=7>\n<tr bgcolor=#FFFFFF>\n<td>";
              strReadElite += myDoText.iso2gb(myDoText.changeColor(rs.getString("detail")))+"<br>\n";
              String sign = rs.getString("sign");
              if (sign!=null && sign.length()>0) {
                  strReadElite += "<br><br>------<br>"+ myDoText.iso2gb(sign);
              }
              strReadElite += "</td></tr>\n</table>\n</td>\n<tr>";
              strReadElite += "<td><div align=center><font face=Verdana, Arial, Helvetica, sans-serif><b><font size=2 color=#D40000>WWW.LOVEROOM.COM.CN</font></b></font></div>\n";
              strReadElite += "</td>\n</tr>\n</table>\n</td>\n</tr>\n</table>\n";
          }
          rs.close();
      }
      catch (SQLException e) {
      }
      return strReadElite;
  }

  public boolean artIsExist(String recid) {
      int numArtIsExist = 0;
      SQL = "select count(*) as numArtIsExist from forum where id = "+recid +" and delsign = 0";
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              numArtIsExist = rs.getInt("numArtIsExist");
          }
          rs.close();
      }
      catch (SQLException e) {
      }
      if (numArtIsExist == 1) {
          return true;
      }
      else {
          return false;
      }
  }

  public void setAddClick(String recid) {
      SQL = "update forum set click=click+1 where id="+ recid;
      try {
          DBSQL.executeUpdate(SQL);
      }
      catch (SQLException e) {
      }
  }

  public String getForumTitle(String recid) {
      String strTitle = "";
      SQL = "select title from forum where id = "+recid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              strTitle = rs.getString("title");
          }
          rs.close();
      }
      catch (SQLException e) {
      }
      return strTitle;
  }

  public String getForumDetail(String recid) {
      String strDetail = "";
      SQL = "select detail from forum where id = "+recid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              strDetail = rs.getString("detail");
          }
          rs.close();
      }
      catch (SQLException e) {
      }
      strDetail = myDoText.addColon(strDetail);
      strDetail = myDoText.delBr(strDetail);
      if (strDetail.length()>200) {
          strDetail = strDetail.substring(0,200);
      }
      strDetail = ":"+strDetail+"\n:......";
      return strDetail;
  }

  public String getAuthor(String recid) {
      String strAuthor = "";
      SQL = "select name from forum where id = "+recid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              strAuthor = rs.getString("name");
          }
          rs.close();
      }
      catch (SQLException e) {
      }
      return strAuthor;
  }

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