forumtopic.java

一个用jsp写的完整的论坛源代码

package com.bcxy.bbs.forum;

/**
 * Title:
 * Description:
 * Copyright:
 * Company: www.liyunet.com
 * 
 * @author lishujiang	
 * @version 1.0
 */

import org.apache.log4j.Logger;

import com.bcxy.bbs.filter.MyFilter;
import com.bcxy.bbs.util.BBSConst;
import com.bcxy.db.JdbcWrapper;
import com.bcxy.util.StringUtil;

public class ForumTopic extends ForumMSG {

	String followMSG = "-----", followUser = "-------",
			followDateAndTime = "-------";

	private Logger log = Logger.getLogger(ForumTopic.class);

	public ForumTopic() {
		// super(announceID);
	}

	/**
	 * 重写构造函数
	 * 
	 */
	public ForumTopic(int forumRootID, int announceID) {
		super(announceID);
		//
		JdbcWrapper jw = new JdbcWrapper();
		try {
			String sql = "select  username,dateandtime,topic,body from "
					+ BBSConst.TABLE_BBS1 + " where rootid=" + forumRootID
					+ " and announceid!=" + forumRootID
					+ " order by announceid desc limit 0,1";

			jw.executeQuery(sql);
			if (jw.next()) {
				followUser = jw.getString(1);
				followDateAndTime = jw.getString(2);
				String followTopic = jw.getString(3);
				if (followTopic != null && !"".equals(followTopic.trim()))
					followMSG = StringUtil.escapeHTMLTags(followTopic);
				else {
					if (jw.getString(4).length() > 24)
						followMSG = StringUtil.escapeHTMLTags(jw.getString(4)
								.substring(0, 24).replaceAll("\\r|\\n", "")
								.replaceAll(" ", " "));
					else
						followMSG = StringUtil.escapeHTMLTags(jw.getString(4)
								.replaceAll("\\r|\\n", "").replaceAll(" ",
										" "));
				}
			}

		} catch (Exception e) {
			log.error("取得论坛主题出错", e);
		} finally {
			jw.close();
		}
	}

	public ForumTopic(int forumRootID) {
		super();
		JdbcWrapper jw = new JdbcWrapper();
		try {
			String sql = "select  username,dateandtime,topic,body from "
					+ BBSConst.TABLE_BBS1 + " where rootid=" + forumRootID
					+ " and announceid!=" + forumRootID
					+ " order by announceid desc";

			jw.executeQuery(sql);
			if (jw.next()) {
				followUser = jw.getString(1);
				followDateAndTime = jw.getString(2);
				String followTopic = jw.getString(3);
				if (followTopic != null && !"".equals(followTopic.trim()))
					followMSG = StringUtil.escapeHTMLTags(followTopic);
				else {
					if (jw.getString(4).length() > 24)
						followMSG = StringUtil.escapeHTMLTags(jw.getString(4)
								.substring(0, 24).replaceAll("\\r|\\n", "")
								.replaceAll(" ", " "));
					else
						followMSG = StringUtil.escapeHTMLTags(jw.getString(4)
								.replaceAll("\\r|\\n", "").replaceAll(" ",
										" "));
				}
			}

		} catch (Exception e) {
			log.error("取得论坛主题出错", e);
		} finally {
			jw.close();
		}
	}

	public String getNoFilterTopic() {
		if (topic != null && !"".equals(topic.trim())) {
			return StringUtil.replace(StringUtil.replace(StringUtil
					.convertNewlines(StringUtil.escapeHTMLTags(topic)), " ",
					"&nbsp;"), "<BR>", "");
		} else {
			String tempString = "";
			if (body.length() > 24) {
				tempString = body.substring(0, 24);
			} else {
				tempString = body;
			}
			return StringUtil.replace(StringUtil.replace(
					StringUtil.escapeHTMLTags(tempString).replaceAll("\\r|\\n",
							"&nbsp;"), " ", "&nbsp;"), "<BR>", "");
		}
	}

	public String getTopic() {

		if (topic != null && !("".equals(topic.trim()))) {
			return (new MyFilter(StringUtil.replace(StringUtil
					.convertNewlines(StringUtil.escapeHTMLTags(topic)), " ",
					"&nbsp;"))).getFilterString();
		} else {
			if (body.length() > 24) {
				return (new MyFilter(StringUtil.replace(StringUtil
						.convertNewlines(StringUtil.escapeHTMLTags(body
								.substring(0, 24))), " ", "&nbsp;")))
						.getFilterString();
			} else {
				return (new MyFilter(StringUtil.replace(StringUtil
						.convertNewlines(StringUtil.escapeHTMLTags(body)), " ",
						"&nbsp;"))).getFilterString();
			}

		}
	}

	public String getFollowMSG() {
		return followMSG;
	}

	public String getFollowUser() {
		return followUser;
	}

	public String getFollowDateAndTime() {
		return followDateAndTime;
	}
}