boards.java

又是一个虚拟社区

  /**
   * 显示版竹
   * @param bsid 版面ID
   * @return String型版竹字符串
   */
  public String getBsMaster(String bsid) {
      String strBsMaster = "";
      ResultSet bsrs = null;
      String SQLbs = "select bsmaster,bsmaster1,bsmaster2 from boards where ID = "+bsid;
      try {
          bsrs = DBSQL.executeQuery(SQLbs);
          if (bsrs.next()) {
              strBsMaster += bsrs.getString("bsmaster");
              if (bsrs.getString("bsmaster1") != null && bsrs.getString("bsmaster1").length() > 0) {
                  strBsMaster += ","+ bsrs.getString("bsmaster1");
              }
              if (bsrs.getString("bsmaster2") != null && bsrs.getString("bsmaster2").length() > 0) {
                  strBsMaster += ","+ bsrs.getString("bsmaster2");
              }
          }
          bsrs.close();
      }
      catch (SQLException e){
      }
      return strBsMaster;
  }

  public String getHTMLBsMaster(String bsid) {
      String strTHMLBsMaster = "";
      ResultSet bs_rs = null;
      String SQL_bs = "select bsmaster,bsmaster1,bsmaster2 from boards where ID = "+bsid;
      try {
          bs_rs = DBSQL.executeQuery(SQL_bs);
          if (bs_rs.next()) {
              strTHMLBsMaster += "<a href='userinfo.jsp?uname="+ myDoText.iso2gb(bs_rs.getString("bsmaster")) +"'>"+myDoText.iso2gb(bs_rs.getString("bsmaster"))+"</a>";
              if (bs_rs.getString("bsmaster1") != null && bs_rs.getString("bsmaster1").length() > 0) {
                  //StringTokenizer masterok = new StringTokenizer(BsMaster1,",");
                  String bsmaster1 = bs_rs.getString("bsmaster1");
                  StringTokenizer HTMLmasterok = new StringTokenizer(bsmaster1,",");
                  String uname = "";
                  while(HTMLmasterok.hasMoreTokens()) {
                      //strTHMLBsMaster += ","+HTMLmasterok.nextToken();
                      uname = HTMLmasterok.nextToken();
                      strTHMLBsMaster += ",<a href='userinfo.jsp?uname="+ myDoText.iso2gb(uname) +"'>"+myDoText.iso2gb(uname)+"</a>";
                  }
              }
              //if (bs_rs.getString("bsmaster2") != null && bs_rs.getString("bsmaster2").length() > 0) {
              //    strTHMLBsMaster += ",<a href='userinfo.jsp?uname="+ myDoText.iso2gb(bs_rs.getString("bsmaster2")) +"'>"+myDoText.iso2gb(bs_rs.getString("bsmaster2"))+"</a>";
              //}
          }
          bs_rs.close();
      }
      catch (SQLException e){
      }
      return strTHMLBsMaster;
  }

  /**
   * 显示版面列表
   * @param bid 一级版区ID
   * @return String型版区列表
   */
  public String listBoards(String bid) {
      String listBoards = "";
      SQL = "select * from boards where boardID="+ bid +" order by xu";
      try {
         rs = DBSQL.executeQuery(SQL);
         while (rs.next()) {
             listBoards += "<tr bgcolor=ECECEC>\n";
             listBoards += "<td><CENTER><a href='modboards.jsp?bsid="+ rs.getInt("ID") +"'>"+ myDoText.iso2gb(rs.getString("boardsname")) +"("+ myDoText.iso2gb(rs.getString("eboardsname")) +")</a></CENTER></td>\n";
             listBoards += "<td><CENTER>"+ myDoText.iso2gb(getBsMaster(rs.getString("ID"))) +"</CENTER></td>\n";
             listBoards += "<td><CENTER><a href='delboards.jsp?bsid="+ rs.getInt("ID") +"'>删除</CENTER></td>\n";
             listBoards += "</tr>\n";
         }
         rs.close();
      }
      catch (SQLException e){
      }
      return listBoards;
  }

  public String listBoardsConf(String bid, String tablecolor) {
      String strListBoardsConf = "";
      SQL = "";
      SQL = "select * from boards where boardID="+ bid +" order by xu";
      try {
         rs = DBSQL.executeQuery(SQL);
         while (rs.next()) {
             strListBoardsConf += "<tr bgcolor="+tablecolor+">\n";
             strListBoardsConf += "<td><CENTER>"+myDoText.iso2gb(rs.getString("boardsname"))+"（"+myDoText.iso2gb(rs.getString("eboardsname"))+"）</CENTER></td>\n";
             strListBoardsConf += "<td><CENTER>"+myDoText.iso2gb(getBsMaster(rs.getString("ID")))+"</CENTER></td>\n";
             strListBoardsConf += "<td><div align=center><a href='boardsconf.jsp?boid="+bid+"&BID="+rs.getString("ID")+"&xg=xgboards'>修改</a></div></td>\n";
             strListBoardsConf += "</tr>\n";
         }
         rs.close();
      }
      catch (SQLException e){
      }
      return strListBoardsConf;
  }

  public boolean setUpdateBoards(String bsid, String bid, String strBoardsName, String strEBoardsName, String strBsMaster, String strBsMaster1, String strBsMaster2, String strBoardsgg, String strAttrib, String strUseState, String strXu) {
      boolean isCanUpdate = false;
      SQL = "update boards set boardsname='"+ strBoardsName +"',eboardsname='"+ strEBoardsName +"',bsmaster='"+ strBsMaster +"',bsmaster1='"+ strBsMaster1 +"',bsmaster2='"+ strBsMaster2 +"',boardgg='"+ strBoardsgg +"',attrib='"+ strAttrib +"',usestate='"+ strUseState +"',xu='"+ strXu +"' where ID="+ bsid;
      try {
          DBSQL.executeQuery(SQL);
          isCanUpdate = true;
      }
      catch (SQLException e){
          isCanUpdate = false;
      }
      return isCanUpdate;
  }

  public String getSelectBoards(boolean isSuper, boolean isBoard) {
       ResultSet rs1 = null;
       String SQL1 = "";
       String strSelectBoards = "";
       SQL = "select ID from board order by xu";
       try {
           rs = DBSQL.executeQuery(SQL);
           while (rs.next()) {
               if (isSuper || isBoard) {
                   SQL1 = "select ID,boardsname from boards where boardID = "+rs.getInt("ID")+ " and  usestate = 1 order by xu";
               }
               else {
                   SQL1 = "select ID,boardsname from boards where boardID = "+rs.getInt("ID")+ " and attrib<>2 and attrib<>4 and  usestate = 1 order by xu";
               }
               rs1 = DBSQL.executeQuery(SQL1);
               while (rs1.next()) {
                   strSelectBoards += "<option value="+rs1.getInt("ID")+">"+myDoText.iso2gb(rs1.getString("boardsname"))+"</option>";
               }
               rs1.close();
           }
           rs.close();
       }
       catch (SQLException e){
       }
       return strSelectBoards;
  }

  public String getListUnPost(String bid) {
      String strListUnPost = "";
      SQL = "select * from unpost where bid="+bid;
      try {
          rs = DBSQL.executeQuery(SQL);
          while (rs.next()) {
              strListUnPost += "<tr align=center>\n";
              strListUnPost += "<td align=left><span class=bt><font color=#FF0000>"+rs.getString("Uname")+"</font></span></td>\n";
	      strListUnPost += "<td align=left><span class=bt>"+ myDoText.iso2gb(rs.getString("unpostreason")) +"</span></td>\n";
	      strListUnPost += "<td align=left><span class=bt>"+ rs.getString("unposttime") +"</span></td>\n";
              strListUnPost += "<td align=left><span class=bt>"+ rs.getString("Mname") +"</span></td>\n</tr>\n";
          }
          rs.close();
      }
      catch (SQLException e){
      }
      return strListUnPost;
  }

  public boolean isInUnPost(String strUserName,String bid) {
      int numInUnPost = 0;
      SQL = "select count(*) as numInUnPost from unpost where Uname='"+ strUserName +"' and bid="+bid;
      try {
          rs = DBSQL.executeQuery(SQL);
          if (rs.next()) {
              numInUnPost = rs.getInt("numInUnPost");
          }
          rs.close();
      }
      catch (SQLException e){
      }
      if (numInUnPost != 0) {
          return true;
      }
      else {
          return false;
      }
  }

  public boolean setUnPost(String bid,String strUID,String Uname,String MID,String Mname,String unpostreason,String unposttime) {
      User myUser = new User();
      if (!isInUnPost(Uname,bid)) {
          SQL = "insert into unpost (bid,UID,Uname,MID,Mname,unpostreason,unposttime) values ('"+bid+"','"+strUID+"','"+Uname+"','"+MID+"','"+Mname+"','"+unpostreason+"','"+unposttime+"')";
          try {
              if (myUser.setUserUnPost(strUID)) {
                  DBSQL.executeUpdate(SQL);
                  myUser.close();
                  return true;
              }
              else {
                  myUser.close();
                  return false;
              }
          }
          catch (SQLException e){
              return false;
          }
      }
      else {
          SQL = "update unpost set bid='"+bid+"',MID='"+MID+"',Manme='"+Mname+"',unpostreason='"+unpostreason+"',unposttime='"+unposttime+"' where Uname='"+Uname+"'";
          try {
              DBSQL.executeUpdate(SQL);
              return true;
          }
          catch (SQLException e){
              return false;
          }
      }
  }

  public boolean setUserPost(String Uname,String bid) {
      User myUser = new User();
      if (isInUnPost(Uname,bid)) {
          SQL = "delete from unpost where Uname='"+Uname+"' and bid ="+bid;
          try {
              if(myUser.setUserPost(Uname)) {
                  DBSQL.executeUpdate(SQL);
                  myUser.close();
                  return true;
              }
              else {
                  myUser.close();
                  return false;
              }
          }
          catch (SQLException e){
              return false;
          }
      }
      else {
          return false;
      }
  }

  public boolean setUpdateGG(String bid, String boardgg) {
      SQL = "update boards set boardgg='"+ boardgg +"' where ID="+ bid;
      try {
          DBSQL.executeUpdate(SQL);
          return true;
      }
      catch (SQLException e){
          return false;
      }
  }

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