groupofforumimpl.java

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

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

import java.util.List;

import com.yeqiangwei.club.dao.GroupOfForumDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.model.GroupOfForum;
import com.yeqiangwei.club.param.GroupOfForumParameter;


public class GroupOfForumImpl implements GroupOfForumDAO {
	
	private static final String FIND_ALL = "from GroupOfForum";
	
	private static final String FIND_USERID_FORUMID = "from GroupOfForum where userId=? and forumId=?";
	
	private static final String FIND_ID = "from GroupOfForum where groupOfForumId=?";
	
	private static final String DELETE_ID = "delete from GroupOfForum where groupOfForumId=?";
	
	private static final String DELETES_ID = "delete from GroupOfForum where groupOfForumId in(:ids)";
	
	public GroupOfForum create(GroupOfForum item) {
		HibernateFacade<GroupOfForum> facade = new HibernateFacade<GroupOfForum>();
		item = facade.save(item);		
		return item;
	}

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

	public int delete(GroupOfForum item) {
    	HibernateFacade<GroupOfForum> facade = new HibernateFacade<GroupOfForum>();
		facade.createQuery(DELETE_ID);
		facade.setInt(0, item.getGroupOfForumId());
		int c = facade.executeUpdate();
		return c;
	}

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

	public GroupOfForum findById(int id) {
		GroupOfForum item = null;
        HibernateFacade<GroupOfForum> facade = new HibernateFacade<GroupOfForum>(FIND_ID);
        facade.setInt(0, id);
        facade.setCacheable(true); 
        facade.setMaxResults(1);
        item = facade.uniqueResult();
        return item;
	}

	public GroupOfForum findByUserIdAndForumId(int userId, int forumId) {
		HibernateFacade facade = new HibernateFacade();
    	facade.createQuery(FIND_USERID_FORUMID);
        facade.setInt(0, userId);
        facade.setInt(1, forumId);
        facade.setCacheable(true); 
        facade.setMaxResults(1);
        GroupOfForum item = (GroupOfForum)facade.uniqueResult();
		return item;
	}

	public List<GroupOfForum> findByParameter(GroupOfForumParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from GroupOfForum ");
		if(param.getForumId()!=null){
			hql.append(" where forumId=");
			hql.append(param.getForumId().intValue());
			if(param.getUserId()!=null){
				hql.append(" and userId=");
				hql.append(param.getUserId().intValue());
			}
		}
		else if(param.getUserId()!=null){
			hql.append(" where userId=");
			hql.append(param.getUserId().intValue());
			if(param.getForumId()!=null){
				hql.append(" and forumId=");
				hql.append(param.getForumId().intValue());
			}
		}
		if(param.getGroupId()!=null){
			hql.append(" and groupId=");
			hql.append(param.getGroupId().intValue());
		}
		HibernateFacade<GroupOfForum> facade = new HibernateFacade<GroupOfForum>();
    	facade.createQuery(hql);
    	facade.setFirstResult(param.getPagination().getStartRow());
    	facade.setMaxResults(param.getPagination().getEndRow());
    	List<GroupOfForum> list = facade.executeQuery();  
		return list;
	}

	public long countByParameter(GroupOfForumParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count (groupOfForumId) from GroupOfForum ");
		if(param.getForumId()!=null){
			hql.append(" where forumId=");
			hql.append(param.getForumId().intValue());
			if(param.getUserId()!=null){
				hql.append(" and userId=");
				hql.append(param.getUserId().intValue());
			}
		}
		else if(param.getUserId()!=null){
			hql.append(" where userId=");
			hql.append(param.getUserId().intValue());
			if(param.getForumId()!=null){
				hql.append(" and forumId=");
				hql.append(param.getForumId().intValue());
			}
		}
		if(param.getGroupId()!=null){
			hql.append(" and groupId=");
			hql.append(param.getGroupId().intValue());
		}
		HibernateFacade facade = new HibernateFacade();
    	facade.createQuery(hql);
    	long c = facade.resultTotal();
    	return c;
	}

	public List findAll(GroupOfForumParameter param) {
		List list = null;
		HibernateFacade facade = new HibernateFacade();
    	facade.createQuery(FIND_ALL);
        list = facade.executeQuery();  
		return list;
	}

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

	public Object findByForumId(int forumId) {
		GroupOfForumParameter param = new GroupOfForumParameter();
		param.setForumId(new Integer(forumId));
		return this.findByParameter(param);
	}
	
}