userdoc.java~121~

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

package bbs.beans.userdoc;

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


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

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

    private void getRownum()throws Exception
     {
       int ret=0;
        result=stm.executeQuery("select count(*) from "+table+" where userid="+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 table,String userid,String page)
   {

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

      try
      {
        if(!table.equalsIgnoreCase("userdoc"))
          {this.getRownum();
           this.countPageNum();
          if(table.equalsIgnoreCase("useradd"))
            result = stm.executeQuery("select top " + num * rowsperpage +" * from useradd,topicplan,boardinfo,userinfo where " +
                           " useradd.userid=userinfo.userid and useradd.parentid=topicplan.parentid"+
                           " and useradd.boardid=topicplan.boardid and useradd.boardid=boardinfo.boardid"+
                           " and useradd.userid="+userid+" order by topicplan.pubtime desc");
          else
             result = stm.executeQuery("select top " + num * rowsperpage +" * from userreply,topicplan,boardinfo,userinfo where " +
                                      " userreply.userid=userinfo.userid and userreply.parentid=topicplan.parentid"+
                                      " and userreply.boardid=topicplan.boardid and userreply.boardid=boardinfo.boardid"+
                                      " and userreply.userid="+userid+" order by topicplan.pubtime desc");

          while (result.next())
          {if (i > (num - 1) * rowsperpage - 1)
            { Object[] obj = new Object[10];
              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");
              obj[9]=result.getString("boardname");
              v.add(obj);
            }
            i++;
          }
          stm.close();
        }
        else
          {
            result = stm.executeQuery("select * from userdoc,topicplan where" +
                                      " userdoc.parentid=topicplan.parentid"+
                                      " and userdoc.boardid=topicplan.boardid"+
                                      " and userdoc.userid="+userid);
            while (result.next())
            {
                Object[] obj = new Object[9];
                obj[0] = result.getString("parentid");
                obj[1] = result.getString("childid");
                obj[2] = result.getString("boardid");
                //obj[3] = result.getString("username");
                obj[4] = result.getString("pubtime");
                obj[5] = result.getString("topic");
                obj[6] = result.getString("moodnum");
                //obj[7] = result.getString("boardname");
                obj[8] = result.getString("pagenum");
                v.add(obj);
            }
           /* result = stm.executeQuery("select * from userdoc,replyplan,userinfo,boardinfo where userdoc.parentid=replyplan.parentid"+
                                      " and userdoc.childid=replyplan.childid and userdoc.boardid=replyplan.boardid and userdoc.userid=userinfo.userid"+
                                      " and userdoc.boardid=boardinfo.boardid and not userdoc.childid=0 and userdoc.userid="+userid);

              while (result.next())
              {
                Object[] obj = new Object[9];
                  obj[0] = result.getString("parentid");
                  obj[1] = result.getString("childid");
                  obj[2] = result.getString("boardid");
                  obj[3] = result.getString("username");
                  obj[4] = result.getString("pubtime");
                  obj[5] = result.getString("topic");
                  obj[6] = result.getString("moodnum");
                  obj[7] = result.getString("boardname");
                  obj[8] = result.getString("pagenum");
                v.add(obj);
              }*/
              stm.close();
            }
       }
        catch(Exception e)
        {
         e.printStackTrace();
        }
    return v;
   }

}