holsapplydao.java

spring+hibernate+struts开发的校务oa系统

package com.yondor.oa.db.holsapply.dao;

import java.util.Date;
import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Expression;
import org.springframework.context.ApplicationContext;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.yondor.oa.db.holsapply.iface.Iholsapply;

/**
 * Data access object (DAO) for domain model class Holsapply.
 * 
 * @see com.yondor.oa.db.Holsapply
 * @author MyEclipse - Hibernate Tools
 */
public class HolsapplyDAO extends HibernateDaoSupport implements Iholsapply {

	private static final Log log = LogFactory.getLog(HolsapplyDAO.class);

	protected void initDao() {
		// do nothing
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#save(com.yondor.oa.db.holsapply.dao.Holsapply)
	 */
	public Long save(Holsapply transientInstance) {
		log.debug("saving Holsapply instance");
		try {
			log.debug("save successful");
			return (Long) getHibernateTemplate().save(transientInstance);
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#delete(com.yondor.oa.db.holsapply.dao.Holsapply)
	 */
	public void delete(Holsapply persistentInstance) {
		log.debug("deleting Holsapply instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findById(java.lang.Long)
	 */
	public Holsapply findById(java.lang.Long id) {
		log.debug("getting Holsapply instance with id: " + id);
		try {
			Holsapply instance = (Holsapply) getHibernateTemplate().get(
					Holsapply.class, id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#getCriteria(org.hibernate.criterion.DetachedCriteria)
	 */
	public List getCriteria(DetachedCriteria detachedCriteria)
			throws DataAccessException {
		return getHibernateTemplate().findByCriteria(detachedCriteria);
	}

	public List getCriteria(DetachedCriteria detachedCriteria, int firstResult,
			int maxResults) {
		return getHibernateTemplate().findByCriteria(detachedCriteria,
				firstResult, maxResults);
	}

	/**
	 * 查询方法
	 * 
	 * @param paramVO
	 * @return
	 */
	public List query(HolsapplyVO paramVO) {
		DetachedCriteria dc = DetachedCriteria.forClass(Holsapply.class);
		if (null != paramVO.getApplytime()) {
			dc.add(Expression.eq("applytime", paramVO.getApplytime()));
		}

		if (null != paramVO.getStarttime()) {
			dc.add(Expression.eq("starttime", paramVO.getStarttime()));
		}

		if (null != paramVO.getEndtime()) {
			dc.add(Expression.eq("endtime", paramVO.getEndtime()));
		}

		if (null != paramVO.getCount()) {
			dc.add(Expression.eq("count", paramVO.getCount()));
		}

		if (null != paramVO.getApplyop()) {
			dc.createAlias(Iholsapply.APPLYOP, "applyop").add(
					Expression.eq("applyop.operatorid", paramVO.getApplyop()
							.getOperatorid()));
		}

		if (null != paramVO.getReplyop()) {
			dc.createAlias(Iholsapply.REPLYOP, "replyop").add(
					Expression.eq("replyop.operatorid", paramVO.getReplyop()
							.getOperatorid()));
		}

		if (null != paramVO.getIsread()) {
			dc.createAlias(Iholsapply.ISREAD, "isread").add(
					Expression.eq("isread.greensysparamid", paramVO.getIsread()
							.getGreensysparamid()));
		}

		if (null != paramVO.getType()) {
			dc.createAlias(Iholsapply.TYPE, "type").add(
					Expression.eq("type.greensysparamid", paramVO.getType()
							.getGreensysparamid()));
		}
		if (null != paramVO.getIscheck()) {
			dc.createAlias(Iholsapply.ISCHECK, "ischeck").add(
					Expression.eq("ischeck.greensysparamid", paramVO
							.getIscheck().getGreensysparamid()));
		}

		if (null != paramVO.getSflag()) {
			dc.createAlias(Iholsapply.SFALG, "sflag").add(
					Expression.eq("sflag.greensysparamid", paramVO.getSflag()
							.getGreensysparamid()));
		}

		if (null != paramVO.getPreid()) {
			dc.add(Expression.eq("preid", paramVO.getPreid()));
		}

		return getCriteria(dc);
	}

	/**
	 * 查询方法
	 * 
	 * @param paramVO
	 * @param firstResult
	 * @param maxResult
	 * @return
	 */
	public List query(HolsapplyVO paramVO, int firstResult, int maxResult) {
		DetachedCriteria dc = DetachedCriteria.forClass(Holsapply.class);

		if (null != paramVO.getApplytime()) {
			dc.add(Expression.eq("applytime", paramVO.getApplytime()));
		}

		if (null != paramVO.getStarttime()) {
			dc.add(Expression.eq("starttime", paramVO.getStarttime()));
		}

		if (null != paramVO.getEndtime()) {
			dc.add(Expression.eq("endtime", paramVO.getEndtime()));
		}

		if (null != paramVO.getCount()) {
			dc.add(Expression.eq("count", paramVO.getCount()));
		}

		if (null != paramVO.getApplyop()) {
			dc.createAlias(Iholsapply.APPLYOP, "applyop").add(
					Expression.eq("applyop.operatorid", paramVO.getApplyop()
							.getOperatorid()));
		}

		if (null != paramVO.getReplyop()) {
			dc.createAlias(Iholsapply.REPLYOP, "replyop").add(
					Expression.eq("replyop.operatorid", paramVO.getReplyop()
							.getOperatorid()));
		}

		if (null != paramVO.getIsread()) {
			dc.createAlias(Iholsapply.ISREAD, "isread").add(
					Expression.eq("isread.greensysparamid", paramVO.getIsread()
							.getGreensysparamid()));
		}

		if (null != paramVO.getType()) {
			dc.createAlias(Iholsapply.TYPE, "type").add(
					Expression.eq("type.greensysparamid", paramVO.getType()
							.getGreensysparamid()));
		}
		if (null != paramVO.getIscheck()) {
			dc.createAlias(Iholsapply.ISCHECK, "ischeck").add(
					Expression.eq("ischeck.greensysparamid", paramVO
							.getIscheck().getGreensysparamid()));
		}
		if (null != paramVO.getSflag()) {
			dc.createAlias(Iholsapply.SFALG, "sflag").add(
					Expression.eq("sflag.greensysparamid", paramVO.getSflag()
							.getGreensysparamid()));
		}
		if (null != paramVO.getPreid()) {
			dc.add(Expression.eq("preid", paramVO.getPreid()));
		}
		return getCriteria(dc, firstResult, maxResult);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByHql(java.lang.StringBuffer)
	 */
	public List findByHql(StringBuffer hql) {
		return getHibernateTemplate().find(hql.toString());
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByExample(com.yondor.oa.db.holsapply.dao.Holsapply)
	 */
	public List findByExample(Holsapply instance) {
		log.debug("finding Holsapply instance by example");
		try {
			List results = getHibernateTemplate().findByExample(instance);
			log.debug("find by example successful, result size: "
					+ results.size());
			return results;
		} catch (RuntimeException re) {
			log.error("find by example failed", re);
			throw re;
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByProperty(java.lang.String,
	 *      java.lang.Object)
	 */
	public List findByProperty(String propertyName, Object value) {
		log.debug("finding Holsapply instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from Holsapply as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByType(java.lang.Object)
	 */
	public List findByType(Object type) {
		return findByProperty(TYPE, type);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByApplycause(java.lang.Object)
	 */
	public List findByApplycause(Object applycause) {
		return findByProperty(APPLYCAUSE, applycause);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByCount(java.lang.Object)
	 */
	public List findByCount(Object count) {
		return findByProperty(COUNT, count);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByApplyop(java.lang.Object)
	 */
	public List findByApplyop(Object applyop) {
		return findByProperty(APPLYOP, applyop);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByReplyop(java.lang.Object)
	 */
	public List findByReplyop(Object replyop) {
		return findByProperty(REPLYOP, replyop);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByIsread(java.lang.Object)
	 */
	public List findByIsread(Object isread) {
		return findByProperty(ISREAD, isread);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#findByIscheck(java.lang.Object)
	 */
	public List findByIscheck(Object ischeck) {
		return findByProperty(ISCHECK, ischeck);
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#merge(com.yondor.oa.db.holsapply.dao.Holsapply)
	 */
	public Holsapply merge(Holsapply detachedInstance) {
		log.debug("merging Holsapply instance");
		try {
			Holsapply result = (Holsapply) getHibernateTemplate().merge(
					detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#attachDirty(com.yondor.oa.db.holsapply.dao.Holsapply)
	 */
	public void attachDirty(Holsapply instance) {
		log.debug("attaching dirty Holsapply instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	/*
	 * (non-Javadoc)
	 * 
	 * @see com.yondor.oa.db.holsapply.dao.Iholsapply#attachClean(com.yondor.oa.db.holsapply.dao.Holsapply)
	 */
	public void attachClean(Holsapply instance) {
		log.debug("attaching clean Holsapply instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public static Iholsapply getFromApplicationContext(ApplicationContext ctx) {
		return (Iholsapply) ctx.getBean("HolsapplyDAO");
	}
}