goodsdao.java

C2C购物网站 含有数据库 解压后readme.txt里有详细说明

package com.shop;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;
import org.hibernate.criterion.Example;

/**
 * Data access object (DAO) for domain model class Goods.
 * 
 * @see com.shop.Goods
 * @author MyEclipse Persistence Tools
 */

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

	// property constants
	public static final String MID = "mid";

	public static final String KIND = "kind";

	public static final String BRAND = "brand";

	public static final String TYPE = "type";

	public static final String INTRODUCE = "introduce";

	public static final String PRICE = "price";

	public static final String NOWPRICE = "nowprice";

	public static final String PICTURE = "picture";

	public static final String INTIME = "intime";

	public static final String SALETOL = "saletol";

	public void save(Goods goods) {
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();		
		session.save(goods);
		tx.commit();
		HibernateSessionFactory.closeSession();
	}
	
	public void saveorUpdate(Goods goods) {
		Session session=HibernateSessionFactory.getSession();
		Transaction tx=session.beginTransaction();
		session.merge(goods);
		tx.commit();
		HibernateSessionFactory.closeSession();
	}

	public void delete(int id) {
		try {
			Session session=HibernateSessionFactory.getSession();
			Transaction tx=session.beginTransaction();
			Goods goods = (Goods) session.get(Goods.class, new Integer(id));
			session.delete(goods);
			tx.commit();
		} catch (RuntimeException re) {
			throw re;
		}	
	}

	public List selectAll() {		
		try {
			String queryString = "from Goods";
			Query queryObject = getSession().createQuery(queryString);
			return queryObject.list();
		} catch (RuntimeException re) {
			throw re;
		}		
	}
	
	public Goods findById(java.lang.Integer id) {
		log.debug("getting Goods instance with id: " + id);
		try {
			Goods instance = (Goods) getSession().get("com.shop.Goods", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

	public List findByExample(Goods instance) {
		log.debug("finding Goods instance by example");
		try {
			List results = getSession().createCriteria("com.shop.Goods").add(
					Example.create(instance)).list();
			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 Goods instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from Goods as model where model."
					+ propertyName + "= ?";
			Query queryObject = getSession().createQuery(queryString);
			queryObject.setParameter(0, value);
			return queryObject.list();
		} catch (RuntimeException re) {
			log.error("find by property name failed", re);
			throw re;
		}
	}

	public List findByMid(Object mid) {
		return findByProperty(MID, mid);
	}

	public List findByKind(String kind) { //Object
		return findByProperty(KIND, kind);
	}

	public List findByBrand(Object brand) {
		return findByProperty(BRAND, brand);
	}

	public List findByType(Object type) {
		return findByProperty(TYPE, type);
	}

	public List findByIntroduce(Object introduce) {
		return findByProperty(INTRODUCE, introduce);
	}

	public List findByPrice(Object price) {
		return findByProperty(PRICE, price);
	}

	public List findByNowprice(Object nowprice) {
		return findByProperty(NOWPRICE, nowprice);
	}

	public List findByPicture(Object picture) {
		return findByProperty(PICTURE, picture);
	}

	public List findByIntime(Object intime) {
		return findByProperty(INTIME, intime);
	}

	public List findBySaletol(Object saletol) {
		return findByProperty(SALETOL, saletol);
	}

	public List findAll() {
		log.debug("finding all Goods instances");
		try {
			String queryString = "from Goods";
			Query queryObject = getSession().createQuery(queryString);
			return queryObject.list();
		} catch (RuntimeException re) {
			log.error("find all failed", re);
			throw re;
		}
	}

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

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

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