linkdaoim.java

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

package com.yhbbs.bbs.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.bbs.itface.Link;
import com.yhbbs.bbs.itface.dao.LinkDao;
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 LinkDaoIm implements LinkDao {
	
	private SqlMapClient sqlMapClient;
		
	public LinkDaoIm() {
		sqlMapClient = AppSqlMap.getInstance();
	}

	private static LinkDao linkdao = new LinkDaoIm();
	
	/**getInstance()
	 * @return 取得一个linkdao实例
	 */
	public static LinkDao getInstance(){
		return linkdao;
	}
	
	public Link getLinkById(int id) throws SQLException {
		
		return (Link)sqlMapClient.queryForObject("getLinkById",id);
	}

	public void addLink(Link link) throws SQLException {
		
		sqlMapClient.insert("addLink",link);
	}
	
	public boolean updateLink(Link link) throws SQLException {
		
		return sqlMapClient.update("updateLink",link)>0;
	}

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

	public List getLinks(int start,int pageSize,String type) throws SQLException {
		Map map = new HashMap();
		map.put("start", start);
		map.put("pageSize", pageSize);
		map.put("type", type);
		
		if(type.equals("2"))
			return (List)sqlMapClient.queryForList("getAllLinks",map);
		else
			return (List)sqlMapClient.queryForList("getLinks",map);
	}
	
	// 管理使用
	
	public int getLinkCount(String i) throws SQLException {
		if(i.equals("2"))
			return getInt(sqlMapClient.queryForObject("getAllLinkCount",null));
		else
			return getInt(sqlMapClient.queryForList("getLinkCount",i));
	}
	private int getInt(Object ob){
		if(ob!=null)
			return Integer.parseInt(ob.toString());
		else
			return 0;
	}
}