friendsdaoim.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.Friends;
import com.yhbbs.user.itface.dao.FriendsDao;
/**
 * <p>Title:论坛好友数据存取模块Interface</p>
 * <li> 论坛好友数据存取模块 <br>
 * <br><b>WebSite: www.yyhweb.com</b>
 * <br><b>CopyRight: yyhweb[由由华网]</b>
 * @author stephen
 * @version YHBBS-2.0
 */
public class FriendsDaoIm implements FriendsDao {

	private SqlMapClient sqlMapClient = null;
	
	private static FriendsDao friendsdao = new FriendsDaoIm();
	
	/**
	 * Constructor Method
	 */
	public FriendsDaoIm(){
		sqlMapClient = AppSqlMap.getInstance();
	}
		
	/**
	 * @return 获得一个FriendsDaoIm
	 */
	public static FriendsDao getInstance(){
		return friendsdao;
	}
	
	private int getInt(Object ob){
		if(ob!=null)
			return Integer.parseInt(ob.toString());
		else
			return 0;
	}
	public int getMaxId() throws SQLException{
		
		return getInt(sqlMapClient.queryForObject("getFriendMaxId",null));
	}
	
	public List getFriends(int userid) throws SQLException {
		
		return (List)sqlMapClient.queryForList("getFriends",userid);
	}
	
	public int isFriends(Friends friend) throws SQLException {
		
		return getInt(sqlMapClient.queryForObject("isFriends",friend));
	}
	
	public void addFriend(Friends friend) throws SQLException {
		
		sqlMapClient.insert("addFriend",friend);
	}

	public void delFriend(Friends friend) throws SQLException {
		
		sqlMapClient.delete("delFriend",friend);
	}
}