classdaoim.java

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

package com.yhbbs.yhclass.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.yhclass.itface.BbsClass;
import com.yhbbs.yhclass.itface.ClassDao;
/**
 * <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 ClassDaoIm implements ClassDao {

	private SqlMapClient sqlMapClient;
	
	private static ClassDaoIm classdao = new ClassDaoIm();
	
	/**
	 * Constructor Method
	 */
	public ClassDaoIm() {		
		sqlMapClient = AppSqlMap.getInstance();
	}
	
	/**
	 * @return 获得一个ClassDaoIm
	 */
	public static ClassDaoIm getInstance(){
		return classdao;
	}

	private String getString(Object ob){
		if(ob!=null){
			return ob.toString();
		}else
			return "";
	}
	
	public int getClassMaxId() throws SQLException {
		Object ob =  sqlMapClient.queryForObject("getClassMaxId",null);
		if(ob!=null)
			return Integer.parseInt(ob.toString());
		else
			return 0;
	}
	
	public String getClassName(int classId) throws SQLException {
		
		return getString(sqlMapClient.queryForObject("getClassName",classId));
	}
	
	public BbsClass getClassById(int classid) throws SQLException{
		
		return (BbsClass)sqlMapClient.queryForObject("getClassById",classid);
	}

	public BbsClass getClassByName(String classname) throws SQLException {
		
		return (BbsClass)sqlMapClient.queryForObject("getClassByName",classname);
	}

	public boolean updateClass(BbsClass bbsclass) throws SQLException {
		
		return sqlMapClient.update("updateClass",bbsclass)>0;
	}

	public boolean deleteClass(int id) throws SQLException {
		return sqlMapClient.delete("deleteClass",id)>0;
	}

	public void addClass(BbsClass bbsclass) throws SQLException {
		sqlMapClient.insert("addClass",bbsclass);
	}

	public BbsClass getAllFmByCId(int id) throws SQLException {
	
		return (BbsClass)sqlMapClient.queryForObject("getAllFmByCId",id);
	}
	public List getOneClassFm(int id) throws SQLException {
		
		return sqlMapClient.queryForList("oneClassAllFm",id);
	}

	public List getAllClass() throws SQLException {
		
		return (List)sqlMapClient.queryForList("getAllClass",null);
	}
	
	public List getAllClassF() throws SQLException {
		
		return (List)sqlMapClient.queryForList("getAllClassF",null);
	}
	
	public List getJumpClassF() throws SQLException {
		
		return (List)sqlMapClient.queryForList("getJumpClassF",null);
	}
	
	public String getClassAdmin(int id) throws SQLException {
		
		return getString(sqlMapClient.queryForObject("getClassAdminById",id));
	}

	// 后台管理使用
	
	public int getMaxSortId() throws SQLException {
		Object ob =  sqlMapClient.queryForObject("getMaxSortId",null);
		if(ob!=null)
			return Integer.parseInt(ob.toString());
		else
			return 0;
	}
	public boolean addAdmin(int classId,String classAdmin) throws SQLException {
		Map<String, Comparable> map = new HashMap<String, Comparable>();
		map.put("id", classId);
		map.put("admin", classAdmin);
		return sqlMapClient.update("addClassAdmin",map)>0;
	}
	public boolean classSort(int classId, int classSort) throws SQLException {
		Map<String, Integer> map = new HashMap<String, Integer>();
		map.put("id", classId);
		map.put("sort", classSort);
		return sqlMapClient.update("classSort",map)>0;
	}
}