forumbean.java~313~

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

package bbs.beans.displayplan;
import java.sql.*;
import java.util.Vector;
import java.lang.Integer;
import bbs.beans.displayplan.PageBean;

public class ForumBean extends PageBusiness
{
  public ForumBean()
  {
    super();
    v=new Vector();
  }

  //获得所有的记录
  public int getAvailableCount()throws Exception
  {
  return this.getAvailableCountHelper();
 }

 //查询数据库,获得要显示的信息,然后通过PageBean返回.当parentid的返回值为0表示要显示一个版的主题帖
 //当parentid的返回值不为0时表示要显示一个主题帖的回复帖
 public PageBean listData(String page,String parentid,String boardid)throws Exception
 {
    this.parentid =Integer.parseInt(parentid);
    this.boardid =Integer.parseInt(boardid);
    PageBean pageBean=new PageBean(this);
    int num=Integer.parseInt(page);//.获得当前的页面号
    int i=0;


  try
     { if(this.parentid==0)
      {
        if(num==1)
       {result=stm.executeQuery("select * from topicplan,userinfo where state>=5 and state<>7 and topicplan.userid=userinfo.userid order by state asc,pubtime desc");
         while(result.next())
           {
                Object[] obj=new Object[9];
                obj[0]=result.getString("parentid") ;
                obj[1]=result.getString("username");
                obj[2]=result.getString("clicksnum");
                obj[3]=result.getDate("pubtime");
                obj[4]=result.getString("topic");
                obj[5]=result.getString("state");
                obj[6]=result.getString("replynum");
                obj[7]=result.getString("moodnum");
                obj[8]=result.getString("boardid");
               (this.v).add(obj);
             }//搜索固顶帖
         result=stm.executeQuery("select * from topicplan,userinfo where  state=7 and boardid="+this.boardid+" and topicplan.userid=userinfo.userid order by pubtime desc");
        while(result.next())
         {
         Object[] obj=new Object[9];
         obj[0]=result.getString("parentid") ;
         obj[1]=result.getString("username");
         obj[2]=result.getString("clicksnum");
         obj[3]=result.getDate("pubtime");
         obj[4]=result.getString("topic");
         obj[5]=result.getString("state");
         obj[6]=result.getString("replynum");
         obj[7]=result.getString("moodnum");
         obj[8]=result.getString("boardid");
         (this.v).add(obj);
         }//搜索区固顶帖

       }

       result=stm.executeQuery("select top "+num*pageBean.rowsperpage+" * from topicplan,userinfo where boardid="+this.boardid+" and state<=4 and topicplan.userid=userinfo.userid order by parentid desc");
        while(result.next())
          {
          if(i>(num-1)*pageBean.rowsperpage-1)
            {
               Object[] obj=new Object[9];
               obj[0]=result.getString("parentid") ;
               obj[1]=result.getString("username");
               obj[2]=result.getString("clicksnum");
               obj[3]=result.getDate("pubtime");
               obj[4]=result.getString("topic");
               obj[5]=result.getString("state");
               obj[6]=result.getString("replynum");
               obj[7]=result.getString("moodnum");
               obj[8]=result.getString("boardid");
              (this.v).add(obj);
            }
            i++;
          }
      }

    else
     {if(num==1)
        { result=stm.executeQuery("select * from topicplan,userinfo where topicplan.parentid="+this.parentid+" and topicplan.boardid="+this.boardid+" and topicplan.userid=userinfo.userid");
         if(result.next())
         {Object[] obj=new Object[14];
         obj[0]=result.getString("parentid") ;
         obj[1]="1";
         obj[2]=result.getString("userid");
         obj[3]=result.getDate("pubtime");
         obj[4]=result.getString("topic");
         obj[5]=result.getString("text");
         obj[6]=result.getString("moodnum");
         obj[7]=result.getString("username");
         obj[8]=result.getString("usersex");
         obj[9]=result.getString("usersign");
         obj[10]=result.getString("online");
         obj[11]=result.getString("plans");
         obj[12]=result.getString("registerdate");
         obj[13]=result.getString("facenum");
         (this.v).add(obj);}
       }
     result=stm.executeQuery("select top "+num*pageBean.rowsperpage+" * from replyplan,userinfo where replyplan.parentid="+
                           this.parentid+" and replyplan.boardid="+this.boardid+
                           " and replyplan.userid=userinfo.userid order by replyplan.childid asc");

     while(result.next())
    {
       if(i>(num-1)*pageBean.rowsperpage-1)
      {
          Object[] obj=new Object[14];
          obj[0]=result.getString("parentid") ;
          obj[1]=result.getString("childid");
          obj[2]=result.getString("userid");
          obj[3]=result.getDate("pubtime");
          obj[4]=result.getString("topic");
          obj[5]=result.getString("text");
          obj[6]=result.getString("moodnum");
          obj[7]=result.getString("username");
          obj[8]=result.getString("usersex");
          obj[9]=result.getString("usersign");
          obj[10]=result.getString("online");
          obj[11]=result.getString("plans");
          obj[12]=result.getString("registerdate");
          obj[13]=result.getString("facenum");
         (this.v).add(obj);
       }
       i++;
     }
    }
    stm.close();
    pageBean.curpage=num;
    pageBean.v=this.v;
    return pageBean;
   }
  catch(Exception e)
   {
     e.printStackTrace();
    throw e;
   }

 }

 public Vector getResult()throws Exception
 {
   return this.v;
 }
}