topictypeinfoimpl.java

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

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

import java.util.List;

import com.yeqiangwei.club.dao.TopicTypeInfoDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.dao.model.TopicTypeInfo;
import com.yeqiangwei.club.param.TopicParameter;

public class TopicTypeInfoImpl implements TopicTypeInfoDAO {
	
	private static final String DELETE_TYPEINFOID = "delete from TopicTypeInfo where typeInfoId=?";
	
	private static final String DELETES_TYPEINFOID = "delete from TopicTypeInfo where typeInfoId in (:ids)";
	
	private static final String FIND_TYPEINFOID = "from TopicTypeInfo where typeInfoId=?";
	
	public TopicTypeInfo create(TopicTypeInfo item) {
		HibernateFacade<TopicTypeInfo> facade = new HibernateFacade<TopicTypeInfo>();
		item = facade.save(item);		
		return item;
	}

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

	public int delete(TopicTypeInfo item) {
		HibernateFacade<TopicTypeInfo> facade = new HibernateFacade<TopicTypeInfo>();
		facade.createQuery(DELETE_TYPEINFOID);
		facade.setInt(0, item.getTypeInfoId());
		int c = facade.executeUpdate();
		return c;
	}

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

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

	public List<TopicTypeInfo> findByParameter(TopicParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from TopicTypeInfo where typeInfoId>0 ");
		if(param.getTopicId()!=null){
			hql.append(" and topicId=");
			hql.append(param.getTopicId().intValue());
		}
		if(param.getReplyId()!=null){
			hql.append(" and replyId=");
			hql.append(param.getReplyId().intValue());
		}
		HibernateFacade<TopicTypeInfo> facade = new HibernateFacade<TopicTypeInfo>();
		facade.createQuery(hql);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		List<TopicTypeInfo> list =  facade.executeQuery();
		return list; 
	}

	public long countByParameter(TopicParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(typeInfoId) from TopicTypeInfo where typeInfoId>0 ");
		if(param.getTopicId()!=null){
			hql.append(" and topicId=");
			hql.append(param.getTopicId().intValue());
		}
		if(param.getReplyId()!=null){
			hql.append(" and replyId=");
			hql.append(param.getReplyId().intValue());
		}
		HibernateFacade<TopicTypeInfo> facade = new HibernateFacade<TopicTypeInfo>();
		facade.createQuery(hql);
		long c = facade.resultTotal();
		return c;
	}

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

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

}