pagebusiness.java~51~

用JSP写的论坛源代码 走过路过的各位千万不要错过啊！！！！

package bbs.beans.displayplan ;

import bbs.beans.dbcontact.ExecuteSqlBean;
import java.sql.*;
import java.util.Vector;

public abstract class PageBusiness
{
  private ExecuteSqlBean esb=new ExecuteSqlBean();
  public int parentid;// 主题帖号
  public int boardid;//帖子所属的版块名
  public java.util.Vector v;//要显示的信息
 //获得所有记录的数量
  public abstract int getAvailableCount()throws Exception;
  //返回要显示的信息
  public Vector getResult()throws Exception
  {
     return v;
  }
  //一个帮助方法,用于获得指定表的记录数量
  public final int getAvailableCountHelper()throws Exception
  { ResultSet rst;
    int ret=0;
    if(parentid==0)
    {
       rst=esb.ExecuteSql("select count(*) from topicplan where boardid="+this.boardid+"");
       if(rst.next())
       {ret=rst.getInt(1);}
     }
      else
   {
      rst=esb.ExecuteSql("select count(*) from replyplan where parentid="+this.parentid+" and boardid="+this.boardid);
      if(rst.next())
       {ret=rst.getInt(1);}
        ret=ret+1;
    }
    rst.close() ;
    return ret;

  }
  //执行数据库操作,返回包含了指定页面信息的PageBean
  public abstract PageBean listData(String page,String parentid,String boardname)throws Exception;

}