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) {      }  }}