sysinfo.java

留言簿架构 oracle 9i + jsp + struts 留言簿基本功能： 1 、客人签写留言 2 、基本的UBB支持

package com.guestbook.sys;

import java.util.*;
import java.sql.*;
import java.io.*;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

import com.guestbook.sys.*;

public class SysInfo
{
	private static final Log logger = LogFactory.getLog(SysInfo.class);
	private Hashtable dynamicParameter = new Hashtable( 50 );
	private static SysInfo instance = null; 
	/*
	 *  获得禁用IP列表  
	 */
	public void LoadBanIp(){
	   Hashtable banIP=new Hashtable( 10 ); 
	   try{
		    
		    String sql = "select ip from t_banIp";
			Vector dataTable =   DataBaseUtil.getDataTable( sql );
			String ip=""; 
			for(int i=0;i<dataTable.size();i++)
			{			 
				ip=((Vector)(dataTable.get(i))).get(0).toString();
				if(ip==null||"".equals(ip))
				{
					continue;
				} 
				banIP.put(ip, ip);
			} 
			putToHashtable( "banip", banIP);
		
	   }catch(Exception ex){
		   logger.info("Get BAn IP Error!");
		   logger.error(ex.getMessage());
	   }
		//return banIP;
	}
	
	private SysInfo()
	{	
		LoadConfig();
	}
	
	synchronized public static SysInfo getInstance()
	{
		if( instance == null )
		{
			instance = new SysInfo();
		}
		return instance;
	}
	
	
	public void LoadConfig()
	{
		LoadSystemConfig();
		LoadMasterInfoConfig();
		LoadBulletinInfoConfig();
		LoadBanIp();
	}
	 
	private void putToHashtable( Object key, Object value )
	{
		if( value != null )
		{
			dynamicParameter.put( key, value );
		}
	}
	
	
	public void LoadSystemConfig()
	{		
		try
		{
			String sql = "select guestBookName,webSiteUrl,pageSize,copyRight,versionNumber,auditing,facePic,ubbPic,secretly,displayStyle,leaveWordLength,filterChar from t_systemConfig where id = 1";
			Vector dataTable = (Vector)( ( Vector)DataBaseUtil.getDataTable( sql ).get( 0 ) );
			putToHashtable( "guestBookName", dataTable.get( 0 ) );
			putToHashtable( "webSiteUrl", dataTable.get( 1 ) );
			putToHashtable( "pageSize", dataTable.get( 2 ) );
			putToHashtable( "copyRight", dataTable.get( 3 ) );
			putToHashtable( "versionNumber", dataTable.get( 4 ) );
			boolean auditing = false;
			if( new Integer( dataTable.get( 5 ).toString() ) == 1 )
			{
				auditing = true;
			}
			putToHashtable( "auditing", auditing );
			boolean facePic = false;
			if( new Integer( dataTable.get( 6 ).toString() ) == 1 )
			{
				facePic = true;
			}
			putToHashtable( "facePic", facePic );
			boolean ubbPic = false;
			if( new Integer( dataTable.get( 7 ).toString() ) == 1 )
			{
				ubbPic = true;
			}
			putToHashtable( "ubbPic", ubbPic );
			boolean secretly = false;
			if( new Integer( dataTable.get( 8 ).toString() ) == 1 )
			{
				secretly = true;
			}
			putToHashtable( "secretly", secretly );		
			putToHashtable( "displayStyle", new Integer( dataTable.get( 9 ).toString() ) );
			putToHashtable( "leaveWordLength", new Integer( dataTable.get( 10 ).toString() ) );
			putToHashtable( "filterChar", dataTable.get( 11 ) );
	
			LoadStyleInfoConfig();
		}
		catch( Exception exp )
		{
			logger.info( exp );
		}
	}
	
	public void LoadMasterInfoConfig()
	{
		/*
		putToHashtable( "masterInfo/nickname", "lee" );
		putToHashtable( "masterInfo/id", "likaiabc" );
		putToHashtable( "masterInfo/qq", "115308723" );
		putToHashtable( "masterInfo/mail", "[e-mail]" );
		putToHashtable( "masterInfo/msn", "[e-mail]" );
		putToHashtable( "masterInfo/icq", "1156" );
		putToHashtable( "masterInfo/homePage", "http://www.zz.ha.cn" );
		putToHashtable( "masterInfo/explain", "更新中" );
		*/
		
		String sql = "select ID,NICKNAME,OID,QQ,MAIL,MSN,ICQ,HOMEPAGE,EXPLAIN from t_MasterInfo where id = 1";
		Vector dataTable = (Vector)( ( Vector)DataBaseUtil.getDataTable( sql ).get( 0 ) );
		
		putToHashtable( "masterInfo/id", dataTable.get( 0 ) );
		putToHashtable( "masterInfo/nickname", dataTable.get( 1 ) );
		putToHashtable( "masterInfo/oid", dataTable.get( 2 ) );
		putToHashtable( "masterInfo/qq", dataTable.get( 3 ) );
		putToHashtable( "masterInfo/mail", dataTable.get( 4 ) );
		putToHashtable( "masterInfo/msn", dataTable.get( 5 ) );
		putToHashtable( "masterInfo/icq", dataTable.get( 6 ) );
		putToHashtable( "masterInfo/homePage", dataTable.get( 7 ) );
		putToHashtable( "masterInfo/explain", dataTable.get( 8 ) );	
	}
	
	public void LoadBulletinInfoConfig()
	{
		String sql = "select TITLE,CONTENT from t_BulletinInfo where rownum = 1";
		Vector dataTable = (Vector)( ( Vector)DataBaseUtil.getDataTable( sql ).get( 0 ) );
		
		putToHashtable( "bulletinInfo/title", dataTable.get( 0 ) );
		putToHashtable( "bulletinInfo/content", dataTable.get( 1 ) );
	}

	private void LoadStyleInfoConfig()
	{
		int displayStyle = Integer.parseInt( dynamicParameter.get( "displayStyle" ).toString() );

		switch( displayStyle )
		{
			case 1 :
				putToHashtable( "styleInfo/bordercolor", "#3675C9" );
				putToHashtable( "styleInfo/tablebgcolor", "#D5E3FD" );
				putToHashtable( "styleInfo/bodytableleft", "#86BBF7" );
				putToHashtable( "styleInfo/add_leftbg", "#1C94DB" );
				putToHashtable( "styleInfo/add_fontcolor", "#ffffff" );
				putToHashtable( "styleInfo/link", "#333333" );
				putToHashtable( "styleInfo/hover", "#800000" );
				putToHashtable( "styleInfo/scrollbarshadow", "#F3F3F4" );
				putToHashtable( "styleInfo/arrow", "#000000" );
				putToHashtable( "styleInfo/trackcolor", "#E1EAF4" );
				putToHashtable( "styleInfo/basecolor", "#d1eaf1" );
				break;
			case 2 :
				putToHashtable( "styleInfo/bodybgcolor", "#ffffff" );	
				putToHashtable( "styleInfo/bordercolor", "#000000" );	
				putToHashtable( "styleInfo/bodytableleft", "#DDDDDD" );	
				putToHashtable( "styleInfo/tablebgcolor", "#f7f7f7" );	
				putToHashtable( "styleInfo/add_leftbg", "#9d9d9d" );
				putToHashtable( "styleInfo/add_rightbg", "#C8C9CA" );
				putToHashtable( "styleInfo/alink", "#ff0000" );
				putToHashtable( "styleInfo/link", "#333333" );
				putToHashtable( "styleInfo/add_fontcolor", "#ffffff" );
				putToHashtable( "styleInfo/vlink", "#333333" );
				putToHashtable( "styleInfo/scrollbarshadow", "#F3F3F4" );
				putToHashtable( "styleInfo/arrow", "#000000" );
				putToHashtable( "styleInfo/trackcolor", "#c9c9c9" );
				putToHashtable( "styleInfo/basecolor", "#E4E4E4" );
				break;
			case 3 :
				putToHashtable( "styleInfo/bodybgcolor", "#ffffff" );	
				putToHashtable( "styleInfo/bordercolor", "#000000" );	
				putToHashtable( "styleInfo/bodytableleft", "#DDDDDD" );	
				putToHashtable( "styleInfo/tablebgcolor", "#f7f7f7" );	
				putToHashtable( "styleInfo/add_leftbg", "#9d9d9d" );	
				putToHashtable( "styleInfo/add_rightbg", "#C8C9CA" );	
				putToHashtable( "styleInfo/add_fontcolor", "#ffffff" );	
				putToHashtable( "styleInfo/link", "#333333" );	
				putToHashtable( "styleInfo/vlink", "#333333" );	
				putToHashtable( "styleInfo/alink", "#ff0000" );	
				putToHashtable( "styleInfo/scrollbarshadow", "#F3F3F4" );	
				putToHashtable( "styleInfo/arrow", "#000000" );	
				putToHashtable( "styleInfo/trackcolor", "#c9c9c9" );	
				putToHashtable( "styleInfo/basecolor", "#E4E4E4" );
				break;
			case 4 :
				putToHashtable( "styleInfo/bodybgcolor", "#ffffff" );
				putToHashtable( "styleInfo/bordercolor", "#008000" );
				putToHashtable( "styleInfo/tablebgcolor", "#EAF7EA" );
				putToHashtable( "styleInfo/bodytableleft", "#94EB96" );
				putToHashtable( "styleInfo/add_leftbg", "#57C644" );
				putToHashtable( "styleInfo/add_rightbg", "#d1cb78" );
				putToHashtable( "styleInfo/add_fontcolor", "#ffffff" );
				putToHashtable( "styleInfo/link", "#333333" );
				putToHashtable( "styleInfo/vlink", "#333333" );
				putToHashtable( "styleInfo/alink", "#ff0000" );
				putToHashtable( "styleInfo/scrollbarshadow", "#009900" );
				putToHashtable( "styleInfo/arrow", "#ffffff" );
				putToHashtable( "styleInfo/trackcolor", "#C4DFB9" );
				putToHashtable( "styleInfo/basecolor", "#A7DCA0" );
				break;
		}
	}
	
	public Hashtable getDynamicParameter()
	{
		return this.dynamicParameter;
	}

}