forumstylemanager.java

BBS论坛设计JSP＋MYSQL

package com.bcxy.bbs.forum;

import java.util.Vector;

import javax.servlet.http.HttpServletRequest;

import com.bcxy.bbs.database.DBConnect;
import com.bcxy.bbs.util.ParamUtil;
import com.bcxy.cache.CacheManager;
import com.bcxy.conf.ENV;
import com.bcxy.db.SqlQuery;

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

public class ForumStyleManager {
	
	public static ForumStyle getForumStyle(int styleID) throws Exception
	{
		ForumStyle fs = null;
		try{
			fs = (ForumStyle)CacheManager.getCache(ENV.GATEWAY).get("forumstyle"+styleID);
			if(fs==null){
				fs = new ForumStyle(styleID);
				CacheManager.getCache(ENV.GATEWAY).put("forumstyle"+styleID, fs);
			}
		}catch(ForumStyleNotFoundException e){
			throw e;
		}catch(Exception e){
			throw new Exception("取得论坛样式出错！");
		}
		return fs;
	}
	
	public static Vector getForumStyles() throws Exception
	{
		Vector fss = new Vector();
		SqlQuery rs = new SqlQuery();		
		try{
			rs.doQuery("select id from forumstyle");
			while(rs.next()){
				ForumStyle fs = getForumStyle(rs.getInt(1));
				fss.add(fs);
			}
		}catch(Exception e){
			throw e;
		}
		return fss;
	}
	
	public static void saveNew(HttpServletRequest request) throws Exception{
		int id = ParamUtil.getInt(request, "id", 0);
		String styleName = ParamUtil.getString(request, "stylename", "");
		int flag = ParamUtil.getInt(request, "flag", 0);
		String tableBack = ParamUtil.getString(request, "Tableback", "");
		String aTableBack = ParamUtil.getString(request, "aTableback", "");
		String tableTitle = ParamUtil.getString(request, "Tabletitle", "");
		String aTableTitle = ParamUtil.getString(request, "aTabletitle", "");
		String tableBody = ParamUtil.getString(request, "Tablebody", "");
		String aTableBody = ParamUtil.getString(request, "aTablebody", "");
		String tableContent = ParamUtil.getString(request, "TableContent", "");
		String tableFont = ParamUtil.getString(request, "TableFont", "");
		String alertFont = ParamUtil.getString(request, "AlertFont", "");
		String bodyBgImage = ParamUtil.getString(request, "bodybgimage", "");
		DBConnect dbc = null;
		String sql = null;
		try{
			dbc = new DBConnect();
			sql = " insert into forumstyle(id,stylename,tableback,atableback,tabletitle,atabletitle,tablebody,atablebody,tablefont,tablecontent,alertfont,flag,bodybgimage) "
				+ " values(?,?,?,?,?,?,?,?,?,?,?,?,?) ";
			dbc.prepareStatement(sql);
			int i = 1;
			dbc.setInt(i++, id);
			dbc.setString(i++,styleName);
			dbc.setString(i++,tableBack);
			dbc.setString(i++,aTableBack);
			dbc.setString(i++,tableTitle);
			dbc.setString(i++,aTableTitle);
			dbc.setString(i++,tableBody);
			dbc.setString(i++,aTableBody);
			dbc.setString(i++,tableFont);
			dbc.setString(i++,tableContent);
			dbc.setString(i++,alertFont);
			dbc.setInt(i++, flag);
			dbc.setString(i++,bodyBgImage);
			dbc.executeUpdate();
		}catch(Exception e){
			throw e;
		}finally{
			if(dbc!=null){
				dbc.close();
			}
		}
	}
	
	public static void saveEdit(HttpServletRequest request) throws Exception{
		int id = ParamUtil.getInt(request, "editid", 0);
		String styleName = ParamUtil.getString(request, "stylename", "");
		int flag = ParamUtil.getInt(request, "flag", 0);
		String tableBack = ParamUtil.getString(request, "Tableback", "");
		String aTableBack = ParamUtil.getString(request, "aTableback", "");
		String tableTitle = ParamUtil.getString(request, "Tabletitle", "");
		String aTableTitle = ParamUtil.getString(request, "aTabletitle", "");
		String tableBody = ParamUtil.getString(request, "Tablebody", "");
		String aTableBody = ParamUtil.getString(request, "aTablebody", "");
		String tableContent = ParamUtil.getString(request, "TableContent", "");
		String tableFont = ParamUtil.getString(request, "TableFont", "");
		String alertFont = ParamUtil.getString(request, "AlertFont", "");
		String bodyBgImage = ParamUtil.getString(request, "bodybgimage", "");
		DBConnect dbc = null;
		String sql = null;
		try{
			dbc = new DBConnect();
			sql = " update forumstyle set id=?,stylename=?,tableback=?,atableback=?,tabletitle=?,atabletitle=?,tablebody=?,atablebody=?,tablefont=?,tablecontent=?,alertfont=?,flag=?,bodybgimage=? "
				+ " where id=? ";
			dbc.prepareStatement(sql);
			int i = 1;
			dbc.setInt(i++, id);
			dbc.setString(i++,styleName);
			dbc.setString(i++,tableBack);
			dbc.setString(i++,aTableBack);
			dbc.setString(i++,tableTitle);
			dbc.setString(i++,aTableTitle);
			dbc.setString(i++,tableBody);
			dbc.setString(i++,aTableBody);
			dbc.setString(i++,tableFont);
			dbc.setString(i++,tableContent);
			dbc.setString(i++,alertFont);
			dbc.setInt(i++, flag);
			dbc.setString(i++,bodyBgImage);
			dbc.setInt(i++, id);
			dbc.executeUpdate();
			//
			CacheManager.getCache(ENV.GATEWAY).remove("forumstyle"+id);
		}catch(Exception e){
			throw e;
		}finally{
			if(dbc!=null){
				dbc.close();
			}
		}		
	}
	
	public static void del(HttpServletRequest request) throws Exception{
		int id = ParamUtil.getInt(request, "id", 0);
		DBConnect dbc = null;
		String sql = null;
		try{
			dbc = new DBConnect();
			sql = " delete from forumstyle where id=? ";
			dbc.prepareStatement(sql);
			dbc.setInt(1, id);
			dbc.executeUpdate();
		}catch(Exception e){
			throw e;
		}finally{
			if(dbc!=null){
				dbc.close();
			}			
		}
	}
}