left.java

BBS-CS_3b_Tomcat4 java BBS

package com.laoer.bbscs.bbs;

import java.sql.*;
import java.io.*;
import java.util.*;
import com.laoer.bbscs.db.*;
import com.laoer.bbscs.txthtml.*;
import com.laoer.bbscs.admin.BBSConf;
import com.laoer.bbscs.board.Boards;
/**
 * <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 Left {

  String SQL = "";
  DbTrans DBSQL;
  DoText myDoText;
  BBSConf myBBSConf;
  ResultSet rs = null;

  public Left() {
      this.DBSQL = new DbTrans();
      this.myDoText = new DoText();
      this.myBBSConf = new BBSConf();
  }

  public String getLeft1() {
      String left1 = "";
      if (myBBSConf.getConfStyle()==1) {
      left1 += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle><a href='in.jsp' target='mainFrame'>社区首页</a><BR>\n";
      left1 += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle>社区导读<BR>\n";
      left1 += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle>个人服务<BR>\n";
      left1 += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle><a href='jinghua.jsp' target='mainFrame'>社区精华</a><BR>\n";
      }
      else {
      left1 += "　→ <a href='in.jsp' target='mainFrame'>社区首页</a><BR>\n";
      left1 += "　→ 社区导读<BR>\n";
      left1 += "　→ 个人服务<BR>\n";
      left1 += "　→ <a href='jinghua.jsp' target='mainFrame'>社区精华</a><BR>\n";
      }
      return left1;
  }

  public String getLeftIsSerive() {
      String leftIsSerive = "";
      if (myBBSConf.getConfStyle()==1) {
          leftIsSerive += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle><a href='left.jsp'>社区服务</a><BR>\n";
          leftIsSerive += "<img src='images/line_05.gif' width='37' height='16' align='absmiddle'><a href='searchf.jsp' target='mainFrame'>查询网友</a><BR>\n";
          leftIsSerive += "<img src='images/line_05.gif' width='37' height='16' align='absmiddle'><a href='guestbook.jsp' target='mainFrame'>传纸条</a><BR>\n";
          leftIsSerive += "<img src='images/line_05.gif' width='37' height='16' align='absmiddle'><a href='grzc.jsp' target='mainFrame'>珍藏配置</a><BR>\n";
          leftIsSerive += "<img src='images/line_06.gif' width='37' height='16' align='absmiddle'><a href='peizhi.jsp' target='mainFrame'>资料配置</a><BR>\n";
      }
      else {
          leftIsSerive += "　→ <a href='left.jsp'>社区服务</a><BR>\n";
          leftIsSerive += "　├ <a href='searchf.jsp' target='mainFrame'>查询网友</a><BR>\n";
          leftIsSerive += "　├ <a href='guestbook.jsp' target='mainFrame'>传纸条</a><BR>\n";
          leftIsSerive += "　├ <a href='grzc.jsp' target='mainFrame'>珍藏配置</a><BR>\n";
          leftIsSerive += "　├ <a href='peizhi.jsp' target='mainFrame'>资料配置</a><BR>\n";
      }
      return leftIsSerive;
  }

  public String getLeftSerive() {
      String leftSerive = "";
      if (myBBSConf.getConfStyle()==1) {
          leftSerive += "<img src=images/line_01.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle><a href='left.jsp?serive=1'>社区服务</a><BR>\n";
      }
      else {
          leftSerive += "　→ <a href='left.jsp?serive=1'>社区服务</a><BR>\n";
      }
      return leftSerive;
  }

  public String getLeftBoard() {
      String leftBoard = "";
      if (myBBSConf.getConfStyle()==1) {
          leftBoard += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle><a href='boardconf.jsp' target='mainFrame'>版区管理</a><BR>\n";
      }
      else {
          leftBoard += "　→ <a href='boardconf.jsp' target='mainFrame'>版区管理</a><BR>\n";
      }
      return leftBoard;
  }

  public String getLefetUserAdmin() {
      String leftUserAdmin = "";
      if (myBBSConf.getConfStyle()==1) {
          leftUserAdmin += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle><a href='unpostconf.jsp?bid=0' target='mainFrame'>用户管理</a><BR>\n";
      }
      else {
          leftUserAdmin += "　→ <a href='unpostconf.jsp?bid=0' target='mainFrame'>用户管理</a><BR>\n";
      }
      return leftUserAdmin;
  }

  public String getLeftPhoto() {
      String leftPhoto = "";
      if (myBBSConf.getConfStyle()==1) {
          leftPhoto += "<img src=images/line_01_2.gif width=18 height=16 align=absmiddle><img src=images/i_option.gif width=16 height=16 align=absmiddle><a href='photolist.jsp' target='mainFrame'>浏览照片</a><BR>\n";
      }
      else {
          leftPhoto += "　→ <a href='photolist.jsp' target='mainFrame'>浏览照片</a><BR>\n";
      }
      return leftPhoto;
  }

  public String getLeftGrzc(String strUserID) {
      String leftGrzc = "";
      Boards myBoards = new Boards();
      if (myBBSConf.getConfStyle()==1) {
          leftGrzc += "<img src=images/line_01_2.gif width=18 height=16 align='absmiddle'><img src=images/i_person.gif width=16 height=16 align='absmiddle'><a href='left.jsp'>个人珍藏</a><br>\n";
          int zcnum = 0;
          SQL = "select count(*) as zcnum from grzc where UID="+ strUserID +" order by zc";
          try {
              rs = DBSQL.executeQuery(SQL);
              if (rs.next()) {
                  zcnum = rs.getInt("zcnum");
              }
              rs.close();
          }
          catch (SQLException e){
          }
          int zcID = 0;
          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.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.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){
          }
      }
      else {
          leftGrzc += "　→ <a href='left.jsp'>个人珍藏</a><br>\n";
          int zcID = 0;
          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 += "　├ <a href='right.jsp?bid="+ zcID +"&pages=1' target='mainFrame' >"+ myDoText.iso2gb(boardsname_zc) +"</a><BR>\n";
	          //}
	          //else {
                  //    leftGrzc += "<img src='images/line_05.gif' width='37' height='16' align='absmiddle'><a href='right.jsp?bid="+ zcID +"&pages=1' target='mainFrame' >"+ boardsname_zc +"</a><BR>\n";
	          //}
	          //inde++;
              }
              rs.close();
          }
          catch (SQLException e){
          }
      }
      return leftGrzc;
  }

  public String getLeftGrzc() {
      String leftGrzc = "";
      if (myBBSConf.getConfStyle()==1) {
          leftGrzc += "<img src=images/line_01.gif width=18 height=16 align='absmiddle'><img src=images/i_person.gif width=16 height=16 align='absmiddle'><a href='left.jsp?grzc=1'>个人珍藏</a><br>\n";
      }
      else {
          leftGrzc += "　→ <a href='left.jsp?grzc=1'>个人珍藏</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 += "<img src='images/line_01_2.gif' width='18' height='16' align='absmiddle'><img src='images/folder_01.gif' width='16' height='16' align='absmiddle'><a href='left.jsp'>"+ 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 += "<img src='images/line_01.gif' width='18' height='16' align='absmiddle'><img src='images/folder_01.gif' width='16' height='16' align='absmiddle'><a href='left.jsp?meid="+ BoardID +"' target='leftFrame1'>"+ 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'>"+ 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 += "　├ <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' >"+ boardsname +"</a><BR>\n";
                          //}
		        //  i1++;
	              }
	              rs_boards.close();
                  }
                  else {
                      leftBoards += "　→ <a href='left.jsp?meid="+ BoardID +"' target='leftFrame1'>"+ myDoText.iso2gb(boardname) +"</a><BR>\n";
                  }
              }
              rs.close();
          }
          catch (SQLException e){
          }
      }
      return leftBoards;
  }

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

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