bbsstatdaoim.java

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

package com.yhbbs.bbs.dao;

import java.sql.SQLException;
import java.util.HashMap;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.yhbbs.bbs.itface.BbsStat;
import com.yhbbs.bbs.itface.dao.BbsStatDao;
import com.yhbbs.data.AppSqlMap;
/**
 * <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 BbsStatDaoIm implements BbsStatDao {

	private static BbsStatDao bbsstatdao = new BbsStatDaoIm();
	
	private SqlMapClient sqlMapClient;
		
	/**
	 * constructor
	 */
	public BbsStatDaoIm() {
		
		sqlMapClient = AppSqlMap.getInstance();
	}
	
	/**
	 * @return get the instance of bbsstatdaoim
	 */
	public static BbsStatDao getInstance(){
		
		return bbsstatdao;
	}
	
	public String getBbsTime() throws SQLException{
		return getString(sqlMapClient.queryForObject("getBbsTime",null));
	}
	
	public BbsStat getBbsStat() throws SQLException {
		
		return (BbsStat)sqlMapClient.queryForObject("getBbsStat",null);
	}
	
	public void upNewRegUser(int userId,String userName) throws SQLException {
		HashMap regUserMap = new HashMap();
		regUserMap.put("userid", userId);
		regUserMap.put("username", userName);
		sqlMapClient.update("upRegUser",regUserMap);
	}

	public void upPostCount() throws SQLException {
		
		sqlMapClient.update("upPostCount",null);
	}

	public void upRepCount() throws SQLException {

		sqlMapClient.update("upRepCount",null);
	}
	
	public void delArticle(boolean flag) throws SQLException {
		if(flag)
			sqlMapClient.update("upDelArt",null);
		else
			sqlMapClient.update("upDelRep",null);
	}

	public void upToday(boolean flag,int num) throws SQLException {
		if(flag){
			sqlMapClient.update("upToday1",null);
		}else{
			sqlMapClient.update("upToday2",num);
		}
	}

	public void upYesday(int num) throws SQLException {
		
		sqlMapClient.update("upYesday",num);
	}
	
	public int getToday() throws SQLException {
		
		return getInt(sqlMapClient.queryForObject("getToday",null));
	}
	
	public int getMaxPost() throws SQLException {
		
		return getInt(sqlMapClient.queryForObject("getMaxPost",null));
	}
	
	public int getMaxOnline() throws SQLException {
		
		return getInt(sqlMapClient.queryForObject("getMaxOnline",null));
	}

	public void upMaxPost(int num) throws SQLException {
		
		sqlMapClient.update("upMaxPost",num);
	}

	public void upMaxOnline(int num) throws SQLException {

		sqlMapClient.update("upMaxOnline",num);
	}
	
	private int getInt(Object ob){
		if(ob!=null)
			return Integer.parseInt(ob.toString());
		else
			return 0;
	}
	private String getString(Object ob){
		if(ob!=null)
			return ob.toString();
		else
			return "";
	}

}