forumdaoim.java

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

package com.yhbbs.forum.dao;

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

import com.ibatis.sqlmap.client.SqlMapClient;
import com.yhbbs.data.AppSqlMap;
import com.yhbbs.forum.itface.Forum;
import com.yhbbs.forum.itface.ForumArtPost;
import com.yhbbs.forum.itface.ForumDao;
import com.yhbbs.forum.itface.ForumJump;
/**
 * <p>Title:论坛数据存取模块Bean</p>
 * <li>	论坛数据存取模块
 * <br><b>WebSite: www.yyhweb.com</b>
 * <br><b>CopyRight: yyhweb[由由华网]</b>
 * @author stephen
 * @version YHBBS-2.0
 */
public class ForumDaoIm implements ForumDao {

	private SqlMapClient sqlMapClient = null;
	
	private static ForumDao forumdao = new ForumDaoIm();
	
	/**
	 * Constructor Method
	 */
	public ForumDaoIm() {		
		sqlMapClient = AppSqlMap.getInstance();
	}
	
	/**
	 * @return 获得一个ForumDao
	 */
	public static ForumDao getInstance(){
		return forumdao;
	}
	private String getString(Object ob){
		if(ob!=null){
			return ob.toString();
		}else
			return "";
	}
	private Integer getInt(Object ob){
		if(ob!=null){
			return Integer.valueOf(ob.toString());
		}else
			return 0;
	}
	public List getAllForumId() throws SQLException {
		
		return (List)sqlMapClient.queryForList("getAllForumId",null);
	}
	
	public int getForumClassId(int forumId) throws SQLException {
		
		return getInt(sqlMapClient.queryForObject("getForumClassId",forumId));
	}
	
	public String getForumName(int forumId) throws SQLException {
		
		return getString(sqlMapClient.queryForObject("getForumName",forumId));
	}

	public int getForumLArtId(int forumId) throws SQLException{
		Object ob = sqlMapClient.queryForObject("getForumLArtId",forumId);
		if(ob!=null)
			return Integer.parseInt(ob.toString());
		else
			return 0;
	}
	
	public void upForumLArtTitle(ForumJump forum) throws SQLException{
		
		sqlMapClient.insert("upForumLArtTitle",forum);
	}
	
	public boolean deleteForum(int forumId) throws SQLException {
		
		return sqlMapClient.delete("deleteForum",forumId)>0;
	}

	public String getForumadmin(int forumId) throws SQLException {
		
		return getString(sqlMapClient.queryForObject("getForumadmin",forumId));
	}

	public List getAllForums() throws SQLException {
		
		return (List)sqlMapClient.queryForList("getAllForums",null);
	} 
	
	public void upYesdayCount(int forumId) throws SQLException {
		
		sqlMapClient.update("upYesdayCount",forumId);
	}

	public void forumPostArt(ForumArtPost fArtPost,boolean flag) throws SQLException {
		if(flag)
			sqlMapClient.update("forumArtPost",fArtPost);
		else
			sqlMapClient.update("forumArtReplay",fArtPost);
	}
	
	public void forumMoveArt(ForumArtPost fArtPost,boolean flag) throws SQLException {
		if(flag)
			sqlMapClient.update("forumArtMoveToday",fArtPost);
		else
			sqlMapClient.update("forumArtMove",fArtPost);
	}
	
	public void forumDelArt(ForumArtPost fArtDel,boolean flag,boolean istoday) throws SQLException {
		if(istoday){
			if(flag)
				sqlMapClient.update("forumTodayArtDel",fArtDel);
			else
				sqlMapClient.update("forumTodayRepDel",fArtDel);
		}else{
			if(flag)
				sqlMapClient.update("forumArtDel",fArtDel);
			else
				sqlMapClient.update("forumRepDel",fArtDel);
		}
		
	}
	public void delArticle(int forumId,boolean flag,boolean istoday) throws SQLException {
		if(istoday){
			if(flag)
				sqlMapClient.update("delTodayArticle",forumId);
			else
				sqlMapClient.update("delTodayReplay",forumId);
		}else{
			if(flag)
				sqlMapClient.update("delArticle",forumId);
			else
				sqlMapClient.update("delReplay",forumId);
		}
	}
	
	// admin use
	

	public void addForum(Forum forum) throws SQLException {
		
		sqlMapClient.insert("addForum",forum);
	}

	public boolean editForum(Forum forum) throws SQLException {
		
		return sqlMapClient.update("editForum",forum)>0;
	}

	
	public Forum getForumById(int id) throws SQLException {
		
		return (Forum)sqlMapClient.queryForObject("getForumById",id);
	}
	public boolean moveForum(int forumId,int classId) throws SQLException {
		Map<String, Integer> map = new HashMap<String, Integer>();
		map.put("forumId", forumId);
		map.put("classId", classId);
		return sqlMapClient.update("moveForum",map)>0;
	}
	public int getForumMaxId() throws SQLException {
		
		return getInt(sqlMapClient.queryForObject("getForumMaxId",null));
	}
	
	public int getForumMaxSort(int classId) throws SQLException {
		
		return getInt(sqlMapClient.queryForObject("getForumMaxSort",classId));
	}
	
	public boolean addForumadmin(int forumId,String forumAdmin) throws SQLException {
		Map<String, Comparable> map = new HashMap<String, Comparable>();
		map.put("id", forumId);
		map.put("admin", forumAdmin);
		return sqlMapClient.update("addForumadmin",map)>0;
	}

	public boolean forumSort(int forumId, int forumSort) throws SQLException {
		Map<String, Integer> map = new HashMap<String, Integer>();
		map.put("id", forumId);
		map.put("sort", forumSort);
		return sqlMapClient.update("forumSort",map)>0;
	}
}