search.java

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

package bbs.beans.search;

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


public class Search
{
    private Statement stm;
    private ResultSet result;
    private String sql;
    private Vector v;
    public int curpage;//当前是多少页
    public int pagenum;//一共有多少页
    public int rownum;//一共有多少行
    public int rowsperpage=16;//每页有多少行

    public Search()
    {
      ContactBean contact=new ContactBean();
      stm=contact.getStm();
      v=new Vector();
    }

    private void getRownum()throws Exception
     {
       int ret=0;
     result=stm.executeQuery("select count(*) from topicplan,boardinfo,userinfo where "+sql+
                             " topicplan.boardid=boardinfo.boardid and topicplan.userid=userinfo.userid");
        if(result.next())
         { ret=result.getInt(1);}
       this.rownum=ret;
      }

   private void countPageNum()
    {
      if (this.rownum%this.rowsperpage==0)
          {
            this.pagenum=this.rownum/this.rowsperpage;
          }
          else
          {
            this.pagenum=this.rownum/this.rowsperpage+1;
          }
        }
//
   public Vector listData(String sql,String page)
   {

     int i=0;
     this.sql=sql;
     int num=Integer.parseInt(page);//.获得当前的页面号
     this.curpage=num;

      try
      {
        this.getRownum();
        this.countPageNum();
        result=stm.executeQuery("select top "+num*rowsperpage+" * from topicplan,boardinfo,userinfo where "+sql+
                             " topicplan.boardid=boardinfo.boardid and topicplan.userid=userinfo.userid");

     while(result.next())
    {
       if(i>(num-1)*rowsperpage-1)
      {
          Object[] obj=new Object[9];
              obj[0]=result.getString("parentid") ;
              obj[1]=result.getString("boardid");
              obj[2]=result.getString("username");
              obj[3]=result.getString("clicksnum");
              obj[4]=result.getDate("pubtime");
              obj[5]=result.getString("topic");
              obj[6]=result.getString("state");
              obj[7]=result.getString("replynum");
              obj[8]=result.getString("moodnum");
         v.add(obj);
       }
       i++;
     }

       }
        catch(Exception e)
        {
         e.printStackTrace();
        }
    return v;
   }

}