pagebusiness.java~55~

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

package bbs.beans.displayplan ;

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

public abstract class PageBusiness
{
  public Statement stm;
  public ResultSet result;
  public int parentid;// 主题帖号
  public int boardid;//帖子所属的版块名
  public java.util.Vector v;//要显示的信息

  public PageBusiness()
  {
    ContactBean contact=new ContactBean();
    stm=contact.getStm();
  }
 //获得所有记录的数量
  public abstract int getAvailableCount()throws Exception;
  //返回要显示的信息
  public Vector getResult()throws Exception
  {
     return v;
  }
  //一个帮助方法,用于获得指定表的记录数量
  public final int getAvailableCountHelper()throws Exception
  {
    int ret=0;
    if(parentid==0)
    {
       result=stm.executeQuery("select count(*) from topicplan where boardid="+this.boardid+"");
       if(result.next())
       {ret=result.getInt(1);}
     }
      else
   {
      result=stm.executeQuery("select count(*) from replyplan where parentid="+this.parentid+" and boardid="+this.boardid);
      if(result.next())
       {ret=result.getInt(1);}
        ret=ret+1;
    }
    return ret;

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

}