replyusersimpl.java

来自「社区文章采用的是平板、树形自由选择的两种展示方式」· Java 代码 · 共 116 行

/* 
 * Created on 2005-11-29
 * Last modified on 2007-12-20
 * Powered by YeQiangWei.com
 */
package com.yeqiangwei.club.dao.hibernate.impl;

import java.util.List;

import com.yeqiangwei.club.dao.ReplyUsersDAO;
import com.yeqiangwei.club.dao.hibernate.support.HibernateFacade;
import com.yeqiangwei.club.model.ReplyUsers;
import com.yeqiangwei.club.param.TopicParameter;


public class ReplyUsersImpl implements ReplyUsersDAO{
	
	private static final String FIND_REPLYUSERSID = "from ReplyUsers where replyUsersId=?";
	
	private static final String DELETES_REPLYUSERSID = "delete from ReplyUsers where replyUsersId in (:ids)";
	
	private static final String DELETE_REPLYUSERSID = "delete from ReplyUsers where replyUsersId=?";
	
	private static final String DELETE_TOPICID = "delete from ReplyUsers where topicId=?";
	
	private static final String DELETE_REPLYID = "delete from ReplyUsers where replyId=?";

	public int deleteByTopicId(int topicId) {
		HibernateFacade<ReplyUsers> facade = new HibernateFacade<ReplyUsers>();
		facade.createQuery(DELETE_TOPICID);
		facade.setInt(0, topicId);
		return facade.executeUpdate();
	}

	public int deleteByReplyId(int replyId) {
		HibernateFacade<ReplyUsers> facade = new HibernateFacade<ReplyUsers>();
		facade.createQuery(DELETE_REPLYID);
		facade.setInt(0, replyId);
		return facade.executeUpdate();
	}

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

	public void update(ReplyUsers item) {
		HibernateFacade<ReplyUsers> facade = new HibernateFacade<ReplyUsers>();
		facade.update(item);
	}

	public int delete(ReplyUsers item) {
		HibernateFacade<ReplyUsers> facade = new HibernateFacade<ReplyUsers>();
		facade.createQuery(DELETE_REPLYUSERSID);
		facade.setInt(0, item.getReplyUsersId());
		return facade.executeUpdate();
	}

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

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

	public List<ReplyUsers> findByParameter(TopicParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("from ReplyUsers where replyUsersId>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<ReplyUsers> facade = new HibernateFacade<ReplyUsers>();
		facade.createQuery(hql);
		facade.setFirstResult(param.getPagination().getStartRow());
		facade.setMaxResults(param.getPagination().getEndRow());
		return facade.executeQuery();
	}

	public long countByParameter(TopicParameter param) {
		StringBuffer hql = new StringBuffer();
		hql.append("select count(replyUsersId) from ReplyUsers where replyUsersId>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<ReplyUsers> facade = new HibernateFacade<ReplyUsers>();
		facade.createQuery(hql);
		facade.setCacheable(true);
		return facade.resultTotal();
	}

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

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