favoriteimpl.java

详细的建站源码 详细的建站源码 详细的建站源码 详细的建站源码

/* 
 * Created on 2005-11-30
 * Last modified on 2007-1-21
 * Powered by YeQiangWei.com
 */
package com.yeqiangwei.club.dao.hibernate.impl;

import java.util.List;

import com.yeqiangwei.club.dao.FavoriteDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.model.Favorite;
import com.yeqiangwei.club.param.FavoriteParameter;

public class FavoriteImpl implements FavoriteDAO{
	
	private static final String FIND_FAVORITEID = "from Favorite where favoriteId=?";

	private static final String DELETE_FAVORITEID = "delete from Favorite where favoriteId=?";
	
	private static final String DELETES_FAVORITEID = "delete from Favorite where favoriteId in (:ids)";
	
	public Favorite create(Favorite item) {
		HibernateFacade<Favorite> facade = new HibernateFacade<Favorite>();
		facade.save(item);
		return item;
	}

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

	public int delete(Favorite item) {
		HibernateFacade<Favorite> facade = new HibernateFacade<Favorite>();
		facade.createQuery(DELETE_FAVORITEID);
		facade.setInt(0, item.getFavoriteId());
		int c = facade.executeUpdate();
		return c;
	}

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

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

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

	public long countByParameter(FavoriteParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(favoriteId) from Favorite where favoriteId>0");
		if(param.getForumId()!=null){
			hql.append(" and forumId=");
			hql.append(param.getForumId().intValue());
		}
		if(param.getMyUserId()!=null){
			hql.append(" and myUserId=");
			hql.append(param.getMyUserId().intValue());
		}
		if(param.getTopicId()!=null){
			hql.append(" and topicId=");
			hql.append(param.getTopicId().intValue());
		}
		if(param.getUserId()!=null){
			hql.append(" and userId=");
			hql.append(param.getUserId().intValue());
		}
		HibernateFacade<Favorite> facade = new HibernateFacade<Favorite>();
		facade.createQuery(hql);
		long c = facade.resultTotal();
		return c;
	}

	public List findAll(FavoriteParameter param) {
		return null;
	}

	public long countAll(FavoriteParameter param) {
		return 0;
	}
	




}