bbspropdaoim.java

一个不错的bbs论坛系统．对初学者很有帮助

package com.yhbbs.bbs.dao;

import java.sql.SQLException;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.yhbbs.bbs.itface.BbsProp;
import com.yhbbs.bbs.itface.Parameter;
import com.yhbbs.bbs.itface.dao.BbsPropDao;
import com.yhbbs.data.AppSqlMap;
import com.yhbbs.utils.StringUtils;
/**
 * <p>Title:系统属性数据存取模块Bean</p>
 * <li> 系统属性数据存取模块<br>
 * <br><b>WebSite: www.yyhweb.com</b>
 * <br><b>CopyRight: yyhweb[由由华网]</b>
 * @author stephen
 * @version YHBBS-2.0
 */
public class BbsPropDaoIm implements BbsPropDao {
	
	private SqlMapClient sqlMapClient;
		
	private static BbsPropDaoIm bbspropdao = new BbsPropDaoIm();
	/**
	 * Constructor
	 */
	public BbsPropDaoIm() {
		sqlMapClient = AppSqlMap.getInstance();
	}
	
	/**
	 * @return get the instance of BbsPropDaoIm
	 */
	public static BbsPropDaoIm getInstance(){
		
		return bbspropdao;
	}
	
	public BbsProp getSysProp() throws SQLException {
		
		return (BbsProp)sqlMapClient.queryForObject("getSysProp",null);
	}
	
	public boolean updateSysProp(BbsProp bbsprop) throws SQLException {
	
		return sqlMapClient.update("updateSysProp",bbsprop)>0;
	}
	
	public String getForbid(int i) throws SQLException {
		if(i==0)
			return StringUtils.getString(sqlMapClient.queryForObject("getForbidUser",null));
		else if(i==1)
			return StringUtils.getString(sqlMapClient.queryForObject("getForbidMail",null));
		else
			return StringUtils.getString(sqlMapClient.queryForObject("getForbidIp",null));
	}
	
	public boolean updateForbid(int i, String content) throws SQLException {
		switch (i){
			case 0:return sqlMapClient.update("updateForbidUser",content)>0;
			case 1:return sqlMapClient.update("updateForbidMail",content)>0;
			case 2:return sqlMapClient.update("updateForbidIp",content)>0;
			case 3:return sqlMapClient.update("updateForbidRegIp",content)>0;
			default:return false;
		}
	}

	public Parameter getParameter() throws SQLException {
		
		return (Parameter) sqlMapClient.queryForObject("getSysParameter",null);
	}
	
	public boolean updateParameter(Parameter parameter) throws SQLException {
		
		return sqlMapClient.update("updateParameter",parameter)>0;
	}
}