friendlabelimpl.java

来自「详细的建站源码 详细的建站源码 详细的建站源码 详细的建站源码」· Java 代码 · 共 110 行

/* 
 * Created on 2007-4-26
 * Last modified on 2007-9-8
 * Powered by YeQiangWei.com
 */
package com.yeqiangwei.club.dao.hibernate.impl;

import java.util.List;

import org.apache.log4j.Logger;

import com.yeqiangwei.club.dao.FriendLabelDAO;
import com.yeqiangwei.club.dao.hibernate.ConnectionProvider;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.hibernate.support.HibernateProvider;
import com.yeqiangwei.club.dao.hibernate.support.HibernateUserFacade;
import com.yeqiangwei.club.dao.model.FriendLabel;
import com.yeqiangwei.club.param.FriendParameter;

public class FriendLabelImpl implements FriendLabelDAO{
	
	private static final Logger logger = Logger.getLogger(FriendLabelImpl.class);
	
	private static final String DELETE_LABELID = "delete from FriendLabel where labelId=?";
	
	private static final String DELETE_LABELIDS = "delete from FriendLabel where labelId in (:ids)";
	
	private static final String FIND_labelId = "from FriendLabel where labelId=?";
		
	private HibernateProvider<FriendLabel> getHibernateProvider(){
		if(ConnectionProvider.whichConnection==0){
			logger.info("HibernateFacade...");
			return new HibernateFacade<FriendLabel>();
		}else{
			logger.info("HibernateUserFacade...");
			return new HibernateUserFacade<FriendLabel>();
		}
	}
	
	public FriendLabel create(FriendLabel item) {
		HibernateProvider<FriendLabel> hibernateProvider = this.getHibernateProvider();
		item = hibernateProvider.save(item);
		return item;
	}

	public FriendLabel update(FriendLabel item) {
		HibernateProvider<FriendLabel> hibernateProvider = this.getHibernateProvider();
		item = hibernateProvider.update(item);		
		return item;
	}

	public int delete(FriendLabel item) {
		HibernateProvider<FriendLabel> hibernateProvider = this.getHibernateProvider();
		hibernateProvider.createQuery(DELETE_LABELID);
		hibernateProvider.setInt(0,item.getLabelId());
		return hibernateProvider.executeUpdate();
	}

	public int delete(List ids) {
		HibernateProvider<FriendLabel> hibernateProvider = this.getHibernateProvider();
		hibernateProvider.createQuery(DELETE_LABELIDS);
		hibernateProvider.setParameterList("ids", ids);
		return hibernateProvider.executeUpdate();
	}

	public FriendLabel findById(int id) {
		HibernateProvider<FriendLabel> hibernateProvider = this.getHibernateProvider();
		hibernateProvider.createQuery(FIND_labelId);
		hibernateProvider.setInt(0,id);
	    hibernateProvider.setCacheable(true); 
	    hibernateProvider.setMaxResults(1);
	    return hibernateProvider.uniqueResult();
	}

	public List<FriendLabel> findByParameter(FriendParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from FriendLabel where labelId>0");
		if(param.getMyUserId()!=null){
			hql.append(" and myUserId=");
			hql.append(param.getMyUserId());
		}
		HibernateProvider<FriendLabel> hibernateProvider = this.getHibernateProvider();
		hibernateProvider.createQuery(hql);
		List<FriendLabel> list = hibernateProvider.executeQuery();
		return list;
	}

	public long countByParameter(FriendParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(labelId) from FriendLabel where labelId>0");
		if(param.getMyUserId()!=null){
			hql.append(" and myUserId=");
			hql.append(param.getMyUserId());
		}
		HibernateProvider<FriendLabel> hibernateProvider = this.getHibernateProvider();
		hibernateProvider.createQuery(hql);
		hibernateProvider.setCacheable(true);
		return hibernateProvider.resultTotal();
	}

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

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

}