viewboard.java~110~

来自「bbs系统」· JAVA~110~ 代码 · 共 45 行

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

public class ViewBoard
{
  private Statement stm;
  private Vector v;

  public ViewBoard()
  {
   ContactBean 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 asc");
    while(rst.next() )
   {
        Object[] obj=new Object[10];
        obj[0]=rst.getString("boardid");
        obj[1]=rst.getString("boardown");
        obj[2]=rst.getString("boardname");
        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");
        obj[8]=rst.getString("userid");
        obj[9]=rst.getString("usersign");
        this.v.add(obj);

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