left.java

BBS-CS是采用JSP+JavaBean+Servlet开发的一套网络虚拟社区系统。

          String boardsname_zc = "";
          //String sql_board = "";
          //ResultSet rs_board;
          int inde = 1;
          SQL = "select zc from grzc where UID="+ strUserID +" order by zc";
          try {
              rs = DBSQL.executeQuery(SQL);
              while (rs.next()) {
                  zcID = rs.getInt("zc");
                  myBoards.getBoards(String.valueOf(zcID));
                  boardsname_zc = myBoards.getBoardsName();
                  if (inde==zcnum) {
                      leftGrzc += "<img src='images/line_06_copy.gif' width='37' height='16' align='absmiddle'><a href='right.jsp?bid="+ zcID +"&pages=1' target='mainFrame' >"+ myDoText.iso2gb(boardsname_zc) +"</a><BR>\n";
	          }
	          else {
                      leftGrzc += "<img src='images/line_05_copy.gif' width='37' height='16' align='absmiddle'><a href='right.jsp?bid="+ zcID +"&pages=1' target='mainFrame' >"+ myDoText.iso2gb(boardsname_zc) +"</a><BR>\n";
	          }
	          inde++;
              }
              rs.close();
          }
          catch (SQLException e){
          }
      }
      return leftGrzc;
  }

  public String getLeftGrzc() {
      String leftGrzc = "";
      if (myBBSConf.getConfStyle()==1) {
          leftGrzc += "<a href='left.jsp?grzc=1'><img src=images/line_01.gif width=18 height=16 align='absmiddle' border=0><img src=images/i_person.gif width=16 height=16 align='absmiddle' border=0>个人珍藏</a><br>\n";
      }
      else {
          leftGrzc += "<a href='left.jsp?grzc=1'><img src=images/line_01_copy.gif width=18 height=16 align='absmiddle' border=0><img src=images/i_person.gif width=16 height=16 align='absmiddle' border=0>个人珍藏</a><br>\n";
      }
      return leftGrzc;
  }

  public String getLeftBoards(String meid) {
      String leftBoards = "";
      if (myBBSConf.getConfStyle()==1) {
          int BoardID = 0;
          int BoardsID = 0;
          String boardname = "";
          String boardsname = "";
          int boardsnum = 0;
          String sql_boards;
          ResultSet rs_boards;
          SQL = "select * from board order by xu";
          try {
              rs = DBSQL.executeQuery(SQL);
              while (rs.next()) {
                  BoardID = rs.getInt("ID");
	          boardname =rs.getString("boardname");
                  if (meid!=null && meid.equals(String.valueOf(BoardID))) {
                      leftBoards += "<a href='left.jsp'><img src='images/line_01_2.gif' width='18' height='16' align='absmiddle' border=0><img src='images/folder_01.gif' width='16' height='16' align='absmiddle' border=0>"+ myDoText.iso2gb(boardname) +"</a><BR>\n";
                      sql_boards = "select count(*) as boardsnum from boards where boardID="+ meid +"  and  usestate = 1 order by xu";
	              rs_boards = DBSQL.executeQuery(sql_boards);
	              if (rs_boards.next()) {
                          boardsnum = rs_boards.getInt("boardsnum");
	              }
                      rs_boards.close();
                      sql_boards = "select * from boards where boardID="+ meid + " and  usestate = 1 order by xu";
                      rs_boards = DBSQL.executeQuery(sql_boards);
	              int i1=1;
                      while (rs_boards.next()) {
	                  BoardsID = rs_boards.getInt("ID");
		          boardsname = rs_boards.getString("boardsname");
                          if (i1==boardsnum) {
                              leftBoards += "<img src='images/line_06.gif' width='37' height='16' align='absmiddle'><a href='right.jsp?bid="+ BoardsID +"&pages=1' target='mainFrame' >"+ myDoText.iso2gb(boardsname) +"</a><BR>\n";
                          }
                          else {
                              leftBoards += "<img src='images/line_05.gif' width='37' height='16' align='absmiddle'><a href='right.jsp?bid="+ BoardsID +"&pages=1' target='mainFrame' >"+ myDoText.iso2gb(boardsname) +"</a><BR>\n";
                          }
		          i1++;
	              }
	              rs_boards.close();
                  }
                  else {
                      leftBoards += "<a href='left.jsp?meid="+ BoardID +"' target='leftFrame1'><img src='images/line_01.gif' width='18' height='16' align='absmiddle' border=0><img src='images/folder_01.gif' width='16' height='16' align='absmiddle' border=0>"+ myDoText.iso2gb(boardname) +"</a><BR>\n";
                  }
              }
              rs.close();
          }
          catch (SQLException e){
          }
      }
      else {
          int BoardID = 0;
          int BoardsID = 0;
          String boardname = "";
          String boardsname = "";
          int boardsnum = 0;
          String sql_boards;
          ResultSet rs_boards;
          SQL = "select * from board order by xu";
          try {
              rs = DBSQL.executeQuery(SQL);
              while (rs.next()) {
                  BoardID = rs.getInt("ID");
	          boardname =rs.getString("boardname");
                  if (meid!=null && meid.equals(String.valueOf(BoardID))) {
                      leftBoards += "<a href='left.jsp'><img src='images/line_01_2_copy.gif' width='18' height='16' align='absmiddle' border=0><img src='images/folder_01_copy.gif' width='16' height='16' align='absmiddle' border=0>"+ myDoText.iso2gb(boardname) +"</a><BR>\n";
                      sql_boards = "select count(*) as boardsnum from boards where boardID="+ meid;
	              rs_boards = DBSQL.executeQuery(sql_boards);
	              if (rs_boards.next()) {
                          boardsnum = rs_boards.getInt("boardsnum");
	              }
                      rs_boards.close();
                      sql_boards = "select * from boards where boardID="+ meid +" and  usestate = 1 order by xu";
                      rs_boards = DBSQL.executeQuery(sql_boards);
	              int i1=1;
                      while (rs_boards.next()) {
	                  BoardsID = rs_boards.getInt("ID");
		          boardsname = rs_boards.getString("boardsname");
                          if (i1==boardsnum) {
                              leftBoards += "<img src='images/line_06_copy.gif' width='37' height='16' align='absmiddle'><a href='right.jsp?bid="+ BoardsID +"&pages=1' target='mainFrame' >"+ myDoText.iso2gb(boardsname) +"</a><BR>\n";
                          }
                          else {
                              leftBoards += "<img src='images/line_05_copy.gif' width='37' height='16' align='absmiddle'><a href='right.jsp?bid="+ BoardsID +"&pages=1' target='mainFrame' >"+ myDoText.iso2gb(boardsname) +"</a><BR>\n";
                          }
		          i1++;
	              }
	              rs_boards.close();
                  }
                  else {
                      leftBoards += "<a href='left.jsp?meid="+ BoardID +"' target='leftFrame1'><img src='images/line_01_copy.gif' align='absmiddle' border=0><img src='images/folder_01_copy.gif' width='16' height='16' align='absmiddle' border=0>"+ myDoText.iso2gb(boardname) +"</a><BR>\n";
                  }
              }
              rs.close();
          }
          catch (SQLException e){
          }
      }
      return leftBoards;
  }

  public String getLeftLogout() {
      String leftLogout = "";
      if (myBBSConf.getConfStyle()==1) {
          leftLogout += "<a href='userlogout.jsp' target='_parent'><img src=images/line_01_2.gif width=18 height=16 align='absmiddle' border=0><img src=images/i_exit.gif width=16 height=16 align='absmiddle' border=0>退出社区</a>\n";
      }
      else {
          leftLogout += "<a href='userlogout.jsp' target='_parent'><img src=images/line_01_2_copy.gif align='absmiddle' border=0><img src=images/i_exit.gif width=16 height=16 align='absmiddle' border=0>退出社区</a>\n";
      }
      return leftLogout;
  }

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