listforum.java

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

      }

      strListForum += "</table>";
      return strListForum;
  }

  public String getListManageForum(ResultSet rsListForum, String tablemaincolor, String tabletintcolor, String tabledarkcolor, String bid, String pages) {
      String strListForum = "";
      String tablecolor = "";
      strListForum += "<table width=98% border=0 align=center cellpadding=1 cellspacing=1 style=\"table-layout:fixed;word-break:break-all\">\n<tr bgcolor="+tablemaincolor+">";
      strListForum += "<td width=5%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>字数</span></font></div>\n";
      strListForum += "</td>\n<td width=7%>\n";
      strListForum += "<div align=center><font color=#FF0000><span class=bt>删除</span></font></div>\n";
      strListForum += "</td>\n<td width=55%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>题目</span></font></div>\n";
      strListForum += "</td>\n<td width=20%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>发表人</span></font></div>\n";
      strListForum += "</td>\n<td width=11%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>时间</span></font></div>\n";
      strListForum += "</td>\n</tr>\n";
      /*try {
          while (rsListForum.next()) {
              strListForum += rsListForum.getString("name");
          }
          rsListForum.close();
      }
      catch (SQLException e) {
      }*/

      try {
           int i = 1;
           int n = 2;
           while (rsListForum.next()) {
               if ((i %= n)==1) {
                   tablecolor = tabletintcolor;
               }
               else {
                   tablecolor = tabledarkcolor;
               }
               strListForum += "<tr bgcolor="+ tablecolor +">\n";
               strListForum += "<td width=5%><CENTER><span class=bt>";
               //if (rsListForum.getInt("re")==0) {
                   strListForum += rsListForum.getString("artsize");
               //}
               //else {
               //   strListForum += "<font color=#ff0000>[+"+ rsListForum.getInt("re") +"]<font>";
               //}
               strListForum += "</span></CENTER></td>\n";
               strListForum += "<td width=7%>&nbsp;<INPUT TYPE=checkbox NAME=delforum value='"+ rsListForum.getInt("id") +"'>";
               if (rsListForum.getInt("cannotdel")==1) {
                   strListForum += "<font color=#8f0000>&nbsp;M</font>";
               }
               strListForum += "</td>\n";
               strListForum += "<td width=55%><a href='showdoc.jsp?bid="+bid+"&recid="+rsListForum.getInt("id2")+"&pages="+pages+"' title ='点击："+rsListForum.getInt("click")+"'>"+myDoText.iso2gb(rsListForum.getString("title"))+"</a>";
               if (rsListForum.getInt("jd") != 0) {
                   strListForum += "<font color=#FF0000><span class=bt>荐</span></font>";
               }
               strListForum += "</td>\n";
               strListForum += "<td ALIGN=left nowrap><span class=bt><a href='userinfo.jsp?UID="+rsListForum.getInt("UID")+"'>"+myDoText.iso2gb(rsListForum.getString("nickname"))+" <font color=#666666>["+ myDoText.iso2gb(rsListForum.getString("name")) +"]</font></a></span></td>\n";
               strListForum += "<td width=11%><CENTER><span class=bt>"+ myDoDate.fotmatDate6(rsListForum.getTimestamp("time"))+"</span></CENTER></td></tr>\n";
           i++;
           }
           rsListForum.close();
      }
      catch (SQLException e) {
      }

      strListForum += "</table>";
      return strListForum;
  }

  public String getListWasteBox(ResultSet rsListForum, String tablemaincolor, String tabletintcolor, String tabledarkcolor, String bid, String pages ,String strUserName,boolean isBoardsMaster) {
      String strListForum = "";
      String tablecolor = "";
      strListForum += "<table width=98% border=0 align=center cellpadding=1 cellspacing=1 style=\"table-layout:fixed;word-break:break-all\">\n<tr bgcolor="+tablemaincolor+">";
      strListForum += "<td width=5%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>字数</span></font></div>\n";
      strListForum += "</td>\n<td width=7%>\n";
      strListForum += "<div align=center><font color=#FF0000><span class=bt>删除</span></font></div>\n";
      strListForum += "</td>\n<td width=50%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>题目</span></font></div>\n";
      strListForum += "</td>\n<td width=12%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>作者</span></font></div>\n";
      strListForum += "</td>\n<td width=12%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>操作人</span></font></div>\n";
      strListForum += "</td>\n<td width=12%>\n";
      strListForum += "<div align=center><font color=#FFFFFF><span class=bt>时间</span></font></div>\n";
      strListForum += "</td>\n</tr>\n";
      /*try {
          while (rsListForum.next()) {
              strListForum += rsListForum.getString("name");
          }
          rsListForum.close();
      }
      catch (SQLException e) {
      }*/

      try {
           int i = 1;
           int n = 2;
           while (rsListForum.next()) {
               if ((i %= n)==1) {
                   tablecolor = tabletintcolor;
               }
               else {
                   tablecolor = tabledarkcolor;
               }
               strListForum += "<tr bgcolor="+ tablecolor +">\n";
               strListForum += "<td width=5%><CENTER><span class=bt>";
               //if (rsListForum.getInt("re")==0) {
                   strListForum += rsListForum.getString("artsize");
               //}
               //else {
               //   strListForum += "<font color=#ff0000>[+"+ rsListForum.getInt("re") +"]<font>";
               //}
               strListForum += "</span></CENTER></td>\n";
               strListForum += "<td width=7%>&nbsp;<INPUT TYPE=checkbox NAME=delwaste value='"+ rsListForum.getInt("id") +"'";
               if (!isBoardsMaster) {
                   if (!rsListForum.getString("delusername").equals(strUserName)) {
                       strListForum += "disabled";
                   }
               }
               strListForum += ">";
               if (rsListForum.getInt("cannotdel")==1) {
                   strListForum += "<font color=#8f0000>&nbsp;M</font>";
               }
               strListForum += "</td>\n";
               strListForum += "<td width=50%><a href='readwaste.jsp?bid="+bid+"&recid="+rsListForum.getInt("id2")+"&pages="+pages+"' title ='点击："+rsListForum.getInt("click")+"'>"+myDoText.iso2gb(rsListForum.getString("title"))+"</a>";
               if (rsListForum.getInt("jd") != 0) {
                   strListForum += "<font color=#FF0000><span class=bt>荐</span></font>";
               }
               strListForum += "</td>\n";
               strListForum += "<td ALIGN=left nowrap><span class=bt><a href='userinfo.jsp?UID="+rsListForum.getInt("UID")+"'>"+myDoText.iso2gb(rsListForum.getString("nickname"))+" <font color=#666666>["+ myDoText.iso2gb(rsListForum.getString("name")) +"]</font></a></span></td>\n";
               strListForum += "<td width=12%>\n";
               strListForum += "<div align=center><span class=bt><a href='userinfo.jsp?UID="+rsListForum.getInt("deluserID")+"'>"+ myDoText.iso2gb(rsListForum.getString("delusername")) +"</a></span></div>\n";
               strListForum += "<td width=11%><CENTER><span class=bt>"+ myDoDate.fotmatDate6(rsListForum.getTimestamp("time"))+"</span></CENTER></td></tr>\n";
           i++;
           }
           rsListForum.close();
      }
      catch (SQLException e) {
      }

      strListForum += "</table>";
      return strListForum;
  }

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

}