favoriteforumimpl.java

这是一款最新的野蔷薇论坛源码,有需要的朋友可以尽情下载

/* 
 * Created on 2007-5-10
 * Last modified on 2007-5-10
 * Powered by YeQiangWei.com
 */
package com.yeqiangwei.club.dao.hibernate.impl;

import java.util.List;

import com.yeqiangwei.club.dao.FavoriteForumDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.model.FavoriteForum;
import com.yeqiangwei.club.param.FavoriteParameter;

public class FavoriteForumImpl implements FavoriteForumDAO{
	
	//private static final String DELETE_FAVORITEFORUMID = "delete from FavoriteForum where favoriteForumId=?";
	
	private static final String DELETES_FAVORITEFORUMID = "delete from FavoriteForum where favoriteForumId in (:ids)";
	
	private static final String FIND_FAVORITEFORUMID = "from FavoriteForum where favoriteForumId=?";
	
	private static final String FIND_USERID_FORUMID = "from FavoriteForum where userId=? and forumId=?";

	public FavoriteForum create(FavoriteForum item) {
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		item = facade.save(item);		
		return item;
	}

	public FavoriteForum update(FavoriteForum item) {
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		item = facade.update(item);		
		return item;
	}

	public int delete(FavoriteForum item) {
		StringBuffer hql = new StringBuffer();
		hql.append("delete from FavoriteForum");
		if(item.getFavoriteForumId()>0){
			hql.append(" where favoriteForumId=");
			hql.append(item.getFavoriteForumId());
		}
		else if(item.getUserId()>0){
			hql.append(" where userId=");
			hql.append(item.getUserId());
			if(item.getForumId()>0){
				hql.append(" and forumId=");
				hql.append(item.getForumId());
			}
		}
		else if(item.getForumId()>0){
			hql.append(" where forumId=");
			hql.append(item.getForumId());
		}
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		facade.createQuery(hql);
		return facade.executeUpdate();
	}

	public int delete(List<Integer> ids) {
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		facade.createQuery(DELETES_FAVORITEFORUMID);
		facade.setParameterList("ids",ids);
		int c = facade.executeUpdate();
		return c;
	}

	public FavoriteForum findById(int id) {
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		facade.createQuery(FIND_FAVORITEFORUMID);
		facade.setInt(0,id);
		FavoriteForum item = facade.uniqueResult();
		return item;
	}

	public List<FavoriteForum> findByParameter(FavoriteParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from FavoriteForum where favoriteForumId>0 ");
		if(param.getUserId()!=null){
			hql.append(" and userId=");
			hql.append(param.getUserId().intValue());
		}
		if(param.getForumId()!=null){
			hql.append(" and forumId=");
			hql.append(param.getForumId().intValue());
		}
		hql.append(" order by favoriteForumId desc ");
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		facade.createQuery(hql);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		List<FavoriteForum> list = facade.executeQuery();
		return list;
	}

	public long countByParameter(FavoriteParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(favoriteForumId) from FavoriteForum where favoriteForumId>0 ");
		if(param.getUserId()!=null){
			hql.append(" and userId=");
			hql.append(param.getUserId().intValue());
		}
		if(param.getForumId()!=null){
			hql.append(" and forumId=");
			hql.append(param.getForumId().intValue());
		}
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		facade.createQuery(hql);
		facade.setCacheable(true);
		long c = facade.resultTotal();
		return c;
	}

	public FavoriteForum findOnly(int userId, int forumId) {
		HibernateFacade<FavoriteForum> facade = new HibernateFacade<FavoriteForum>();
		facade.createQuery(FIND_USERID_FORUMID);
		facade.setInt(0,userId);
		facade.setInt(1, forumId);
		facade.setMaxResults(1);
		FavoriteForum item = facade.uniqueResult();
		return item;
	}
}