right.java

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

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.bbs.ListForum;

/**
 * <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 Right {

  String SQL = "";
  DbTrans DBSQL;
  DoText myDoText;
  ResultSet rs = null;
  PageBreak myPageBreak;
  ResultSet rsRight = null;
  int spage = 0;
  int allCol = 0;
  String listPageBreak = "";
  String bid = "";
  String pages = "";
  String tj = "";
  String zhuti = "";
  public Right() {
      this.DBSQL = new DbTrans();
      this.myDoText = new DoText();
      this.myPageBreak = new PageBreak();
  }

  public void getRightRs(String bid,String pages,String fileName,int intPageSize) {
      String strCountSQL = "";
      String strSQL = "";
      strCountSQL = "select count(*) as total from forum where board = "+ bid +" and new=1 and delsign=0";
      strSQL = "select * from forum where board = "+ bid +" and new=1 and delsign=0 order by lasttime desc";
      this.rsRight = myPageBreak.getPageBreak(pages,strCountSQL,strSQL,intPageSize);
      this.spage = myPageBreak.getSpage();
      this.allCol = myPageBreak.getAllCol();
      this.listPageBreak = myPageBreak.listPageBreak(myDoText.iso2gb(fileName));
      this.bid = bid;
      this.pages = pages;
  }

  public void getRightSearcRs(String bid,String pages,String fileName,int intPageSize,String tj,String zhuti) {
      String strCountSQL = "";
      String strSQL = "";
      strCountSQL = "select count(*) as total from forum where board = "+ bid +" and "+ tj +" like '%"+ zhuti +"%' and new=1 and delsign = 0";
      strSQL = "select * from forum where board = "+ bid +" and "+ tj +" like '%"+ zhuti +"%'  and new=1 and delsign=0 order by lasttime desc";
      this.rsRight = myPageBreak.getPageBreak(pages,strCountSQL,strSQL,intPageSize);
      this.spage = myPageBreak.getSpage();
      this.allCol = myPageBreak.getAllCol();
      this.listPageBreak = myPageBreak.listPageBreakPic(fileName);
      this.bid = bid;
      this.pages = pages;
      this.tj = tj;
      this.zhuti = zhuti;
  }

  public void getRightManager(String bid,String pages,String fileName,int intPageSize) {
      String strCountSQL = "";
      String strSQL = "";
      strCountSQL = "select count(*) as total from forum where board = "+ bid +" and delsign = 0";
      strSQL = "select * from forum where board = "+ bid +" and delsign=0 order by lasttime desc";
      this.rsRight = myPageBreak.getPageBreak(pages,strCountSQL,strSQL,intPageSize);
      this.spage = myPageBreak.getSpage();
      this.allCol = myPageBreak.getAllCol();
      this.listPageBreak = myPageBreak.listPageBreakPic(fileName);
      this.bid = bid;
      this.pages = pages;
  }

  public void getRightWasteBox(String bid,String pages,String fileName,int intPageSize) {
      String strCountSQL = "";
      String strSQL = "";
      strCountSQL = "select count(*) as total from forum where board = "+ bid +" and delsign = 1";
      strSQL = "select * from forum where board = "+ bid +" and delsign=1 order by deltime desc";
      this.rsRight = myPageBreak.getPageBreak(pages,strCountSQL,strSQL,intPageSize);
      this.spage = myPageBreak.getSpage();
      this.allCol = myPageBreak.getAllCol();
      this.listPageBreak = myPageBreak.listPageBreakPic(fileName);
      this.bid = bid;
      this.pages = pages;
  }

  public int getSpage() {
      return this.spage;
  }

  public int getAllCol() {
      return this.allCol;
  }

  public String getListPageBreak() {
      return this.listPageBreak;
  }

  public String getListForum(String tablemaincolor, String tabletintcolor, String tabledarkcolor) {
      String strListForum = "";
      ListForum myListForum = new ListForum();
      strListForum = myListForum.getListForum(this.rsRight,tablemaincolor, tabletintcolor, tabledarkcolor, this.bid, this.pages);
      myListForum.close();
      return strListForum;
  }

  public String getListForumS(String tablemaincolor, String tabletintcolor, String tabledarkcolor) {
      String strListForum = "";
      ListForum myListForum = new ListForum();
      strListForum = myListForum.getListForumS(this.rsRight,tablemaincolor, tabletintcolor, tabledarkcolor, this.bid, this.pages, this.tj,this.zhuti);
      myListForum.close();
      return strListForum;
  }

  public String getListForumManager(String tablemaincolor, String tabletintcolor, String tabledarkcolor) {
      String strListForum = "";
      ListForum myListForum = new ListForum();
      strListForum = myListForum.getListManageForum(this.rsRight,tablemaincolor, tabletintcolor, tabledarkcolor, this.bid, this.pages);
      myListForum.close();
      return strListForum;
  }

  public String getListWasteBox(String tablemaincolor, String tabletintcolor, String tabledarkcolor,String strUserName,boolean isBoardsMaster) {
      String strListForum = "";
      ListForum myListForum = new ListForum();
      strListForum = myListForum.getListWasteBox(this.rsRight,tablemaincolor, tabletintcolor, tabledarkcolor, this.bid, this.pages, strUserName ,isBoardsMaster);
      myListForum.close();
      return strListForum;
  }
  public void close() {
      try {
          DBSQL.close();
      }
      catch (SQLException e) {
      }
  }
}