servicedao.java

关于ssh的整合,希望对大家有帮助

package crm.dao.cst;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Criteria;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.MatchMode;
import org.hibernate.criterion.Order;
import org.hibernate.criterion.Restrictions;
import org.springframework.context.ApplicationContext;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import crm.entity.cst.ServiceEntity;

/**
 * Data access object (DAO) for domain model class ServiceEntity.
 * 
 * @see crm.entity.cst.ServiceEntity
 * @author MyEclipse Persistence Tools
 */

public class ServiceDAO extends HibernateDaoSupport {
	private static final Log log = LogFactory.getLog(ServiceDAO.class);

	// property constants
	public static final String SVR_TYPE = "svrType";

	public static final String SVR_TITLE = "svrTitle";

	public static final String SVR_CUST_NAME = "svrCustName";

	public static final String SVR_STATUS = "svrStatus";

	public static final String SVR_REQUEST = "svrRequest";

	public static final String SVR_CREATE_ID = "svrCreateId";

	public static final String SVR_CREATE_BY = "svrCreateBy";

	public static final String SVR_DUE_ID = "svrDueId";

	public static final String SVR_DUE_TO = "svrDueTo";

	public static final String SVR_DEAL = "svrDeal";

	public static final String SVR_DEAL_ID = "svrDealId";

	public static final String SVR_DEAL_BY = "svrDealBy";

	public static final String SVR_RESULT = "svrResult";

	public static final String SVR_SATISFY = "svrSatisfy";

	protected void initDao() {
		// do nothing
	}

	public void save(ServiceEntity transientInstance) {
		log.debug("saving ServiceEntity instance");
		try {
			getHibernateTemplate().save(transientInstance);
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

	public void delete(ServiceEntity persistentInstance) {
		log.debug("deleting ServiceEntity instance");
		try {
			getHibernateTemplate().delete(persistentInstance);
			log.debug("delete successful");
		} catch (RuntimeException re) {
			log.error("delete failed", re);
			throw re;
		}
	}

	/**
	 * 删除方法(根据id删除)
	 */
	public void delete(int id)
	{
		long lid=id;    //将int型转换成long型
		this.delete(this.findById(lid));
	}
	/**
	 * 使用Criteria进行模糊查询
	 */
	public List findCriteria(ServiceEntity conditions) {
		System.out.println("进入模糊查询方法！！！！"+conditions.getSvrCustName()+"*********");
		Session session = this.getSession();
		Criteria criteria = session.createCriteria(ServiceEntity.class);
        if(null!=conditions)
        {
        	//按客户名称查询
        	System.out.println("条件查询！");
        	if(conditions.getSvrCustName()!=null&&!(conditions.getSvrCustName().equals("")))
        	{
        		criteria.add(Restrictions.like("svrCustName", conditions.getSvrCustName(), MatchMode.ANYWHERE));
        	}
           // 按照概要查询
			if (conditions.getSvrTitle() != null&&!(conditions.getSvrTitle().equals(""))) {
				criteria.add(Restrictions.like("svrTitle", conditions.getSvrTitle(),MatchMode.ANYWHERE));
			}
              // 按照服务类型查询
			if (conditions.getSvrType()!= null) {
				System.out.println("........"+conditions.getSvrType()); 
				criteria.add(Restrictions.eq("svrType", conditions.getSvrType()));
			}
            //	 按照服务状态查询
			if (conditions.getSvrStatus() != null) {
				criteria.add(Restrictions.eq("svrStatus", conditions.getSvrStatus()));
			}
			// 按照日期范围查询
        }
		criteria.addOrder(Order.asc("svrId"));
		return criteria.list();
	}
	/**
	 * 分页查询
	 */
	public List search(int pageId ,int pagecount)//pageId为第pageId页，pagecount为每页显示记录的数量
	{
		Session session=this.getSession();
		String hql="from ServiceEntity order by ServiceEntity.svrId asc";
		Query query=session.createQuery(hql);
		int firstpage=pagecount*(pageId-1);
		query.setFirstResult(firstpage);
		query.setMaxResults(pagecount);
		return query.list();
	}
    //模糊查询分配分页
	public List dispatch(ServiceEntity instance,int pageId,int pagecount) {
		try {
			System.out.println("进入查询客户分页");
			int  first = pagecount *(pageId - 1);
			System.out.println(first);
			DetachedCriteria c=DetachedCriteria.forClass(ServiceEntity.class);
			if(instance.getSvrCustName()!=null && !(instance.getSvrCustName().equals("")))
			{
				System.out.println(instance.getSvrCustName()+"1111111111111");
				c.add(Restrictions.like("svrCustName", instance.getSvrCustName(), MatchMode.ANYWHERE));
			}
			if(instance.getSvrTitle()!=null && !(instance.getSvrTitle().equals("")))
			{
				c.add(Restrictions.like("svrTitle", instance.getSvrTitle(), MatchMode.ANYWHERE));
			}
			return this.getHibernateTemplate().findByCriteria(c, first, pagecount);
			
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}
	public ServiceEntity findById(java.lang.Long id) {
		log.debug("getting ServiceEntity instance with id: " + id);
		try {
			ServiceEntity instance = (ServiceEntity) getHibernateTemplate()
					.get("crm.entity.cst.ServiceEntity", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(ServiceEntity instance) {
		log.debug("finding ServiceEntity 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;
		}
	}

	public List findByProperty(String propertyName, Object value) {
		log.debug("finding ServiceEntity instance with property: "
				+ propertyName + ", value: " + value);
		try {
			String queryString = "from ServiceEntity as model where model."
					+ propertyName + "= ?";
			return getHibernateTemplate().find(queryString, value);
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	public List findBySvrType(Object svrType) {
		return findByProperty(SVR_TYPE, svrType);
	}

	public List findBySvrTitle(Object svrTitle) {
		return findByProperty(SVR_TITLE, svrTitle);
	}

	public List findBySvrCustName(Object svrCustName) {
		return findByProperty(SVR_CUST_NAME, svrCustName);
	}

	public List findBySvrStatus(Object svrStatus) {
		return findByProperty(SVR_STATUS, svrStatus);
	}

	public List findBySvrRequest(Object svrRequest) {
		return findByProperty(SVR_REQUEST, svrRequest);
	}

	public List findBySvrCreateId(Object svrCreateId) {
		return findByProperty(SVR_CREATE_ID, svrCreateId);
	}

	public List findBySvrCreateBy(Object svrCreateBy) {
		return findByProperty(SVR_CREATE_BY, svrCreateBy);
	}

	public List findBySvrDueId(Object svrDueId) {
		return findByProperty(SVR_DUE_ID, svrDueId);
	}

	public List findBySvrDueTo(Object svrDueTo) {
		return findByProperty(SVR_DUE_TO, svrDueTo);
	}

	public List findBySvrDeal(Object svrDeal) {
		return findByProperty(SVR_DEAL, svrDeal);
	}

	public List findBySvrDealId(Object svrDealId) {
		return findByProperty(SVR_DEAL_ID, svrDealId);
	}

	public List findBySvrDealBy(Object svrDealBy) {
		return findByProperty(SVR_DEAL_BY, svrDealBy);
	}

	public List findBySvrResult(Object svrResult) {
		return findByProperty(SVR_RESULT, svrResult);
	}

	public List findBySvrSatisfy(Object svrSatisfy) {
		return findByProperty(SVR_SATISFY, svrSatisfy);
	}

	public List findAll() {
		log.debug("finding all ServiceEntity instances");
		try {
			String queryString = "from ServiceEntity";
			return getHibernateTemplate().find(queryString);
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

	public ServiceEntity merge(ServiceEntity detachedInstance) {
		log.debug("merging ServiceEntity instance");
		try {
			ServiceEntity result = (ServiceEntity) getHibernateTemplate()
					.merge(detachedInstance);
			log.debug("merge successful");
			return result;
		} catch (RuntimeException re) {
			log.error("merge failed", re);
			throw re;
		}
	}

	public void attachDirty(ServiceEntity instance) {
		log.debug("attaching dirty ServiceEntity instance");
		try {
			getHibernateTemplate().saveOrUpdate(instance);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public void attachClean(ServiceEntity instance) {
		log.debug("attaching clean ServiceEntity instance");
		try {
			getHibernateTemplate().lock(instance, LockMode.NONE);
			log.debug("attach successful");
		} catch (RuntimeException re) {
			log.error("attach failed", re);
			throw re;
		}
	}

	public static ServiceDAO getFromApplicationContext(
			ApplicationContext ctx) {
		return (ServiceDAO) ctx.getBean("ServiceEntityDAO");
	}
}