announcedaoim.java

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

package com.yhbbs.bbs.dao;

import java.sql.SQLException;
import java.util.List;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.yhbbs.bbs.itface.AnnceLink;
import com.yhbbs.bbs.itface.Announce;
import com.yhbbs.bbs.itface.dao.AnnounceDao;
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 AnnounceDaoIm implements AnnounceDao {

	private SqlMapClient sqlMapClient;
	
	private static AnnounceDao announcedao = new AnnounceDaoIm();
	/**
	 * Constructor method
	 */
	public AnnounceDaoIm() {
		sqlMapClient = AppSqlMap.getInstance();
	}

	/**
	 * @return get the instance of Announcedao
	 */
	public static AnnounceDao getInstance(){
		return announcedao;
	}
	
	public int getMaxId() throws SQLException{
		Object ob = sqlMapClient.queryForObject("getAnnceMaxId",null);
		if(ob!=null)
			return Integer.parseInt(ob.toString());
		else
		    return 0;
	}
		
	public AnnceLink getAnnceLink(int forumId) throws SQLException {
		
		return (AnnceLink)sqlMapClient.queryForObject("getAnnceLink",forumId);
	}
	
	public Announce getOneAnnce(int anId) throws SQLException {
		
		return (Announce)sqlMapClient.queryForObject("getOneAnnce",anId);
	}
	
	public List getAllAnnce(int forumId) throws SQLException {
		
		return (List)sqlMapClient.queryForList("getAllAnnce",forumId);
	}

	public void editAnnce(Announce announce) throws SQLException {
		
		sqlMapClient.update("editAn",announce);
	}

	public void deleteAnnce(int anId) throws SQLException {
		
		sqlMapClient.delete("deleteAn",anId);
	}

	public void postAnnce(Announce announce) throws SQLException {
		
		sqlMapClient.insert("postAn",announce);
	}

}