forumstyle.java

BBS论坛设计JSP＋MYSQL

package com.bcxy.bbs.forum;

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

import com.bcxy.db.SqlQuery;


public class ForumStyle {
	int id = 0, flag = 0;
	String styleName = "", tableBack = "", tableTitle = "", tableBody = "", aTableBack = "", 
	       aTableTitle = "", aTableBody = "", tableFont = "", tableContent = "", alertFont = "",
	       bodyBgImage = "";

	public ForumStyle(int id) throws Exception {
		SqlQuery rs = new SqlQuery("select * from forumstyle where id="+id);
		if(rs.next()){
			setId(rs.getInt(1));
			setStyleName(rs.get(2));
			setTableBack(rs.get(3));
			setATableBack(rs.get(4));
			setTableTitle(rs.get(5));
			setATableTitle(rs.get(6));
			setTableBody(rs.get(7));
			setATableBody(rs.get(8));
			setTableFont(rs.get(9));
			setTableContent(rs.get(10));
			setAlertFont(rs.get(11));
			setFlag(rs.getInt(12));
			setBodyBgImage(rs.get(13));
		}else{
			throw new ForumStyleNotFoundException("没有找到论坛样式。样式代码"+id);
		}
	}
	
	public String getAlertFont() {
		return alertFont;
	}
	public void setAlertFont(String alertFont) {
		this.alertFont = alertFont;
	}
	public String getATableBack() {
		return aTableBack;
	}
	public void setATableBack(String tableBack) {
		aTableBack = tableBack;
	}
	public String getATableBody() {
		return aTableBody;
	}
	public void setATableBody(String tableBody) {
		aTableBody = tableBody;
	}
	public String getATableTitle() {
		return aTableTitle;
	}
	public void setATableTitle(String tableTitle) {
		aTableTitle = tableTitle;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getStyleName() {
		return styleName;
	}
	public void setStyleName(String styleName) {
		this.styleName = styleName;
	}
	public String getTableBack() {
		return tableBack;
	}
	public void setTableBack(String tableBack) {
		this.tableBack = tableBack;
	}
	public String getTableBody() {
		return tableBody;
	}
	public void setTableBody(String tableBody) {
		this.tableBody = tableBody;
	}
	public String getTableContent() {
		return tableContent;
	}
	public void setTableContent(String tableContent) {
		this.tableContent = tableContent;
	}
	public String getTableFont() {
		return tableFont;
	}
	public void setTableFont(String tableFont) {
		this.tableFont = tableFont;
	}
	public String getTableTitle() {
		return tableTitle;
	}
	public void setTableTitle(String tableTitle) {
		this.tableTitle = tableTitle;
	}

	public String getBodyBgImage() {
		return bodyBgImage;
	}

	public void setBodyBgImage(String bodyBgImage) {
		this.bodyBgImage = bodyBgImage;
	}

	public int getFlag() {
		return flag;
	}

	public void setFlag(int flag) {
		this.flag = flag;
	}
}