forumlinkfactory.java

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

package com.bcxy.bbs.forum;

/**
 * Title:
 * Description:
 * Copyright:
 * Company: www.liyunet.com
 * 
 * @author lishujiang	
 * @version 1.0
 */
import java.util.Vector;

import org.apache.log4j.Logger;

import com.bcxy.bbs.util.BBSConst;
import com.bcxy.cache.CacheManager;
import com.bcxy.conf.ENV;
import com.bcxy.db.JdbcWrapper;

public class ForumLinkFactory {

	private static Logger log = Logger.getLogger(ForumLinkFactory.class);

	public static Vector getForumLinks() throws ForumLinkNotFoundException {
		JdbcWrapper jw = new JdbcWrapper();
		Vector forumLinkVector = new Vector();
		try {
			jw.executeQuery("select * from " + BBSConst.TABLE_BBSLINK
					+ " order by id");
			while (jw.next()) {
				ForumLink tempLink = new ForumLink();
				tempLink.setLinkID(jw.getInt(1));
				tempLink.setForumName(jw.getString(2));
				tempLink.setReadMe(jw.getString(3));
				tempLink.setForumURL(jw.getString(4));
				forumLinkVector.add(tempLink);
			}
		} catch (Exception e) {
			log.error("取得论坛联盟列表出错", e);
			throw new ForumLinkNotFoundException("取得论坛联盟列表出错");
		} finally {
			jw.close();
		}
		return forumLinkVector;
	}

	public static ForumLink getForumLink(int forumLinkID) throws Exception {
		//
		ForumLink tempLink = (ForumLink) CacheManager.getCache(ENV.FORUM_LINK)
				.get(String.valueOf(forumLinkID));
		if (tempLink == null) {
			JdbcWrapper jw = new JdbcWrapper();
			try {
				jw.executeQuery("select * from " + BBSConst.TABLE_BBSLINK
						+ "  where id=" + forumLinkID);
				if (!jw.next()) {
					throw new Exception("对不起，没有发现此联盟论坛！");
				}
				tempLink = new ForumLink();
				tempLink.setLinkID(jw.getInt(1));
				tempLink.setForumName(jw.getString(2));
				tempLink.setReadMe(jw.getString(3));
				tempLink.setForumURL(jw.getString(4));
				CacheManager.getCache(ENV.FORUM_LINK).put(
						String.valueOf(forumLinkID), tempLink);
			} catch (Exception e) {
				log.error("取得论坛联盟信息出错", e);
				throw new ForumLinkNotFoundException("取得论坛联盟信息出错");
			} finally {
				jw.close();
			}
		}
		return tempLink;
	}
}