transactiondao.java

基于struts+hibernate的电子商务网站。可运行。数据库mysql

package tarena.dao;

import java.util.List;
import java.util.Vector;

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.criterion.Example;

import tarena.data.AbractProduct;
import tarena.entity.Transaction;

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

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

	// property constants
	public static final String AMOUNT = "amount";

	public static final String MONEY = "money";
	
	private Session session = null;
	private org.hibernate.Transaction transaction = null;
	
	public TransactionDAO() {
		session = getSession();
		transaction = session.beginTransaction();
	}

	
	 /**
	   * 列出本周销售排行商品
	   * @param number -指定列出本周销售排行较高的商品的数目
	   * @param type -指定查询类型 0：全部版块中 1：顶级版块中 2：2级版块中 3：3级版块中
	   * @param id -指定分类的id 0：全部分类
	   * @return Vector<AbractProduct>
	   * @roseuid 49056C540177
	 */
	public Vector<AbractProduct> ListSaleProductThisWeek(Integer number,int type, int id) {
		return null;
	}
	
	public void save(Transaction transientInstance) {
		log.debug("saving Transaction instance");
		try {
			transaction.begin();
			session.save(transientInstance);
			transaction.commit();
			log.debug("save successful");
		} catch (RuntimeException re) {
			log.error("save failed", re);
			throw re;
		}
	}

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

	public Transaction findById(java.lang.Integer id) {
		log.debug("getting Transaction instance with id: " + id);
		try {
			Transaction instance = (Transaction) session.get(
					"tarena.entity.Transaction", id);
			return instance;
		} catch (RuntimeException re) {
			log.error("get failed", re);
			throw re;
		}
	}

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

	public List findByAmount(Object amount) {
		return findByProperty(AMOUNT, amount);
	}

	public List findByMoney(Object money) {
		return findByProperty(MONEY, money);
	}

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

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

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

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