userleveldaoim.java

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

package com.yhbbs.user.dao;

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

import com.ibatis.sqlmap.client.SqlMapClient;
import com.yhbbs.data.AppSqlMap;
import com.yhbbs.user.itface.bean.Grade;
import com.yhbbs.user.itface.bean.UserGroup;
import com.yhbbs.user.itface.dao.UserLevelDao;

/**
 * <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 UserLevelDaoIm implements UserLevelDao {
	
	private SqlMapClient sqlMapClient;
	
	private static UserLevelDao leveldao = new UserLevelDaoIm();
	
	/**
	 * Constructor Method
	 */
	public UserLevelDaoIm(){
		sqlMapClient = AppSqlMap.getInstance();
	}
		
	/**
	 * @return 获得一个UserLevelDao
	 */
	public static UserLevelDao getInstance(){
		return leveldao;
	}
	
	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 "";
	}
	public String getGradeName(int gid,int utype) throws SQLException {
		if(utype<4)
			return getString(sqlMapClient.queryForObject("getGradeNameById", gid));
		else
			return getString(sqlMapClient.queryForObject("getGradeNameByType", utype));
	}

	public int getGradePost(int gid) throws SQLException {

		return getInt(sqlMapClient.queryForObject("getGradePost", gid));
	}
	public Grade getGrade(int gid) throws SQLException {
		
		return (Grade) sqlMapClient.queryForObject("getGrade", gid);
	}
	
	public List getAllGrades() throws SQLException {
		
		return sqlMapClient.queryForList("getAllGrades", null);
	}
	
	// UserType
	
	public String getUserTypeName(int id) throws SQLException {
		
		return getString(sqlMapClient.queryForObject("getUserTypeName", id));
	}

	public List getUserTypes() throws SQLException {
		
		return sqlMapClient.queryForList("getUserTypes", null);
		
	}
	
	// UserGroup
	
	public void addUserGroup(UserGroup ugroup) throws SQLException{
		
		sqlMapClient.insert("addUserGroup", ugroup);
	}
	
	public boolean editUserGroup(UserGroup ugroup) throws SQLException{
		
		return sqlMapClient.update("editUserGroup", ugroup)>0;
	}
	
	public boolean delUserGroup(int gid) throws SQLException{
		
		return sqlMapClient.delete("delUserGroup", gid)>0;
	}
	
	public String getUserGroupName(int id) throws SQLException {
		
		return getString(sqlMapClient.queryForObject("getUserGroupName", id));
	}
	
	public List getUserGroups() throws SQLException {
		
		return sqlMapClient.queryForList("getUserGroups", null);
	}

	public boolean updateGrade(Grade grade) throws SQLException {
		
		return sqlMapClient.update("updateGrade", grade)>0;
	}
	
	
}