left.java

又是一个虚拟社区

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 += "<a href='in.jsp' target='mainFrame'><img src=images/line_01_2.gif width=18 height=16 align=absmiddle border=0><img src=images/i_option.gif width=16 height=16 align=absmiddle border=0>社区首页</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 += "<a href='jinghua.jsp' target='mainFrame'><img src=images/line_01_2.gif width=18 height=16 align=absmiddle border=0 border=0><img src=images/i_option.gif width=16 height=16 align=absmiddle border=0>社区精华</a><BR>\n";
      }
      else {
      left1 += "<a href='in.jsp' target='mainFrame'><img src=images/line_01_2_copy.gif  align=absmiddle border=0><img src=images/i_option_copy.gif  align=absmiddle border=0>社区首页</a><BR>\n";
      left1 += "<img src=images/line_01_2_copy.gif  align=absmiddle border=0><img src=images/i_option_copy.gif  align=absmiddle border=0>社区导读<BR>\n";
      left1 += "<img src=images/line_01_2_copy.gif  align=absmiddle border=0><img src=images/i_option_copy.gif  align=absmiddle border=0>个人服务<BR>\n";
      left1 += "<a href='jinghua.jsp' target='mainFrame'><img src=images/line_01_2_copy.gif  align=absmiddle border=0><img src=images/i_option_copy.gif  align=absmiddle border=0>社区精华</a><BR>\n";
      }
      return left1;
  }

  public String getLeftIsSerive() {
      String leftIsSerive = "";
      if (myBBSConf.getConfStyle()==1) {
          leftIsSerive += "<a href='left.jsp'><img src=images/line_01_2.gif width=18 height=16 align=absmiddle border=0><img src=images/i_option.gif width=16 height=16 align=absmiddle>社区服务</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'><img src=images/line_01_2_copy.gif align=absmiddle border=0><img src=images/i_option_copy.gif align=absmiddle border=0>社区服务</a><BR>\n";
          leftIsSerive += "<img src='images/line_05_copy.gif' width='37' height='16' align='absmiddle'><a href='searchf.jsp' target='mainFrame'>查询网友</a><BR>\n";
          leftIsSerive += "<img src='images/line_05_copy.gif' width='37' height='16' align='absmiddle'><a href='guestbook.jsp' target='mainFrame'>传纸条</a><BR>\n";
          leftIsSerive += "<img src='images/line_05_copy.gif' width='37' height='16' align='absmiddle'><a href='grzc.jsp' target='mainFrame'>珍藏配置</a><BR>\n";
          leftIsSerive += "<img src='images/line_06_copy.gif' width='37' height='16' align='absmiddle'><a href='peizhi.jsp' target='mainFrame'>资料配置</a><BR>\n";
      }
      return leftIsSerive;
  }

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

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

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

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

  public String getLeftGrzc(String strUserID) {
      String leftGrzc = "";
      Boards myBoards = new Boards();
      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){
          }
      if (myBBSConf.getConfStyle()==1) {
          leftGrzc += "<a href='left.jsp'><img src=images/line_01_2.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";

          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'><img src=images/line_01_2_copy.gif  align='absmiddle' border=0><img src=images/i_person.gif width=16 height=16 align='absmiddle' border=0>个人珍藏</a><br>\n";
          int zcID = 0;