forumnews.java

BBS论坛设计JSP＋MYSQL

package com.bcxy.bbs.forum;
/**
 * Title:
 * Description:
 * Copyright:
 * Company: www.liyunet.com
 * 
 * @author lishujiang	
 * @version 1.0
 */
import java.sql.ResultSet;

import com.bcxy.db.SqlQuery;

public class ForumNews
{
	private int id,boardid;
	private String title,content,username,addtime;
	public ForumNews(){}
	
	public ForumNews(int newsid) throws ForumNewsNotFoundException,Exception{
		SqlQuery rs=new SqlQuery("select * from bbsnews where id='"+newsid+"' order by id desc");
		if(rs.next()){
			this.id       = rs.getInt(1);
			this.boardid  = rs.getInt(2);
			this.title    = rs.getString(3);
			this.content  = rs.getString(4);
			this.username = rs.getString(5);
			this.addtime  = rs.getString(6);			
		}
		else {			
			throw new ForumNewsNotFoundException("没有找到论坛公告！ID="+newsid); 
		}
	}
	
	public int getId(){
		return this.id;
	}
	public void setId(int id){
		this.id=id;
	}

	public int getBoardid(){
		return this.boardid;
	}
	public void setBoardid(int boardid){
		this.boardid=boardid;
	}
	public String getTitle(){
		return this.title;
	}
	public void setTitle(String title){
		this.title=title;
	}
	public String getContent(){
		return this.content;
	}
	public void setContent(String content){
		this.content=content;
	}
	public String getUserName(){
		return this.username;
	}
	public void setUserName(String username){
		this.username=username;
	}
	public String getAddTime(){
		return this.addtime;
	}
	public void setAddTime(String addtime){
		this.addtime=addtime;
	}
}