foruminfo.java

JSP论坛系统 数据库：mysql数据库； 技术平台：Tomcat 5.0服务器； 开发工具：Eclipse＋Lomboz、EditPlus开发工具； 操作系统：Windows XP Prof

package mybbs;
import java.sql.*;
public class ForumInfo {
  private int forumid;
  private String forum_name;
  private int total_post;
  private int total_topic;
  private String admin_author;
  private String pic_logo;
  private String description;

  public  ForumInfo()
  {
  }
  public void setForumid(int fid){
    this.forumid=fid;
  }
  public String getForumname()
  {

    try{
      DBConn con = new DBConn();
      String sql = "SELECT * FROM forums WHERE id = "+forumid;
      ResultSet rs = con.query(sql);
      if(rs.next()){
        forum_name = rs.getString("forum_name");
        total_topic = rs.getInt("total_topic");
        total_post = rs.getInt("total_post");
        admin_author = rs.getString("admin_author");
        pic_logo = rs.getString("pic_logo");
        description = rs.getString("description");
        rs.close();
        con.DBclose();
      }
      else{
        forum_name ="没找到";
        total_topic =0;
        total_post = 0;

      }
    }
    catch(Exception e){
      return e.toString();
    }
    return forum_name;
  }
  public int getTotal_post()
  {
    return total_post;
  }
  public int getTotal_topic()
{
  return total_topic;
}
public String getAdmin_author()
{
  return admin_author;
}
public String getDescrption()
{
  return description;
}
public String getPic_logo()
{
  return pic_logo;
}
//分论坛最后一个发贴
 public StringBuffer getLastTopic(int id)throws Exception
 {
   StringBuffer buffer=new StringBuffer();
   DBConn conn =new DBConn();
   String sql1="SELECT topic_id,title,author,post_time FROM posts WHERE istopic>0 AND forumid="+id
       +" ORDER BY post_time ASC";
   try{
     ResultSet rs2 = conn.query(sql1);
     if(rs2.last()){
       buffer.append("<TD rowspan='2' bgColor=#ffffff class=smalltxt>主题: ");
       buffer.append("<A href='disbbs.do?forumsid=" + id + "&topicid=" +
                     rs2.getString("topic_id") + "'>");
       buffer.append(rs2.getString("title") + "</A><BR>作者: ");
       buffer.append(rs2.getString("author") + "<BR>时间:" +
                     rs2.getString("post_time").substring(0, 16) + "</TD>");
     }
     else{
       buffer.append("<TD rowspan='2' bgColor=#ffffff class=smalltxt>主题: ");
       buffer.append("<A href='disbbs.do?forumsid=id'>");
       buffer.append("</A><BR>作者: ");
       buffer.append("<BR>时间:</TD>");
     }
     rs2.close();
   }
   catch(Exception e){
     System.out.print(e.toString());
   }
   conn.DBclose();
   return buffer;
 }
 public StringBuffer getAllbbs(){
   StringBuffer allbbs=new StringBuffer();
    try{
    DBConn conn =new DBConn();
    ResultSet rs=conn.query("SELECT * FROM forums WHERE isparent=0");
    while(rs.next()){
    allbbs.append("<option value='"+rs.getString("id")+"'>"+rs.getString("forum_name"));
      }
     rs.close();
     conn.DBclose();
    }
   catch(Exception e){
     allbbs.append("数据库操作出错！");
      }
    return allbbs;
    }



  /**
   * ForumInfo
   *
   * @param i int
   */

}