merchandiseinfodaoimpl.java

Struts+Spring+Hibernate实现的在线拍卖系统,去掉了这些组件自身的jar包

package org.bestteam.dao.impl;

import java.util.List;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.bestteam.dao.MerchandiseInfoDao;
import org.bestteam.domain.AuctionItems;
import org.bestteam.domain.Catalog;
import org.bestteam.domain.MerchandiseInfo;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

public class MerchandiseInfoDaoImpl extends HibernateDaoSupport implements MerchandiseInfoDao {

	private static final Log log = LogFactory.getLog(MerchandiseInfoDaoImpl.class);	
	public void delete(MerchandiseInfo merchandiseInfo) {
		log.debug("deleting merchandiseInfo instance");
        try {
            getHibernateTemplate().delete(merchandiseInfo);
            log.debug("delete successful");
        } catch (RuntimeException re) {
            log.error("delete failed", re);
            throw re;
        }

	}

	
	public List findByProperty(String propertyName, Object value) {
	      log.debug("finding merchandiseInfo instance with property: " + propertyName
	            + ", value: " + value);
	      try {
	         String queryString = "from MerchandiseInfo where " 
	         						+ propertyName + "= ?";
			 return getHibernateTemplate().find(queryString, value);
	      } catch (RuntimeException re) {
	         log.error("find by property name failed", re);
	         throw re;
	      }
	}
	
	public List findAuction(int catalogID){
		String query="from MerchandiseInfo as mer where mer.auctionItems.state='T' and mer.catalog.catalogId=" + catalogID;
		return getHibernateTemplate().find(query);
	}

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

	}

	public MerchandiseInfo saveOrUpdate(MerchandiseInfo merchandiseInfo) {
		log.debug("saveOrUpdate MerchandiseInfo instance");
        try {
        	MerchandiseInfo result = (MerchandiseInfo) getHibernateTemplate()
                    .merge(merchandiseInfo);
            log.debug("saveOrUpdate successful");
            return result;
        } catch (RuntimeException re) {
            log.error("saveOrUpdate failed", re);
            throw re;
        }
	}
	
	public List getAllMerchandiseInfo(){
		log.debug("finding merchandiseInfo instance");
	      try {
	         String queryString = "from MerchandiseInfo"; 
			 return getHibernateTemplate().find(queryString);
	      } catch (RuntimeException re) {
	         log.error("find by property name failed", re);
	         throw re;
	      }
	}
	
	public List getAllMerchandiseInfo(int from, int size,String key,String value) {
		List list = getSession().createCriteria(MerchandiseInfo.class)
		.add(Restrictions.like(key, value))
		.setFirstResult(from)
		.setMaxResults(size)
		.list();
		return list;
	} 

}