viewboard.java~104~

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

package bbs.beans.board;
import java.sql.*;
import java.util.*;
import bbs.beans.board.BoardInfo;
import bbs.beans.dbcontact.ExecuteSqlBean;

public class ViewBoard
{
  private ExecuteSqlBean exe;
  private Vector v;

  public ViewBoard()
  {
    exe=new ExecuteSqlBean();
    v=new Vector();
  }

  public  Vector listData()
  {
  try {
     ResultSet  rst = exe.ExecuteSql("select * from boardinfo,userinfo where masterid=userid order by boardown asc,boardid desc");
    while(rst.next() )
   {
        Object[] obj=new Object[8];
        obj[0]=rst.getString("boardid");
        obj[1]=rst.getString("boardown");
        obj[2]=rst.getString("boardname");
        //obj[3]=rst.getString("masterid");
        obj[3]=rst.getString("username");
        obj[4]=rst.getString("useremail");
        obj[5]=rst.getString("comment");
        obj[6]=rst.getString("boardhits");
        obj[7]=rst.getString("boardtopices");
        this.v.add(obj);

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