forumlinkfactory.java

BBS论坛设计JSP＋MYSQL

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

import com.bcxy.cache.CacheManager;
import com.bcxy.conf.ENV;
import com.bcxy.db.SqlQuery;

public class ForumLinkFactory{

	public static Vector getForumLinks() throws ForumLinkNotFoundException{
		try{
			SqlQuery rs=new SqlQuery("select * from bbslink order by id");
			
			Vector forumLinkVector=new Vector();
			while(rs.next()){
				ForumLink tempLink=new ForumLink();
				tempLink.setLinkID(rs.getInt(1));
				tempLink.setForumName(rs.getString(2));
				tempLink.setReadMe(rs.getString(3));
				tempLink.setForumURL(rs.getString(4));
				forumLinkVector.add(tempLink);
			}
			
			return forumLinkVector;
		}
		catch(Exception e){
			e.printStackTrace();
			throw new ForumLinkNotFoundException();
		}
	}
	public static ForumLink getForumLink(int forumLinkID) throws Exception{
		//
		ForumLink tempLink = (ForumLink)CacheManager.getCache(ENV.FORUM_LINK).get(String.valueOf(forumLinkID));
		if(tempLink==null){
    		SqlQuery rs=new SqlQuery("select * from bbslink  where id="+forumLinkID);
    		if(!rs.next()){
    			throw new Exception("对不起，没有发现此联盟论坛！");
    		}
    		tempLink=new ForumLink();
    		tempLink.setLinkID(rs.getInt(1));
    		tempLink.setForumName(rs.getString(2));
    		tempLink.setReadMe(rs.getString(3));
    		tempLink.setForumURL(rs.getString(4));
    		CacheManager.getCache(ENV.FORUM_LINK).put(String.valueOf(forumLinkID),tempLink);
		}
		return tempLink;
	}
}