ordersdao.java

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

package tarena.dao;

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

import tarena.entity.Orders;

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

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

	// property constants
	public static final String STATE = "state";

	public static final String DESCRIPTION = "description";

	public static final String PRODUCTMONEY = "productmoney";

	public static final String FARE = "fare";

	public static final String FEES = "fees";

	public static final String ORDERMONEY = "ordermoney";

	public static final String DOUNUM = "dounum";

	public static final String PAYMONEY = "paymoney";

	public static final String INVOICE = "invoice";

	public static final String RECEIVEDATE = "receivedate";

	public static final String INVOICENAME = "invoicename";

	public static final String INVOICEDESC = "invoicedesc";

	public static final String LOGISTICSCOMPANY = "logisticscompany";

	public static final String LOGISTICSNUMBER = "logisticsnumber";

	public void save(Orders transientInstance) {
		Session session = getSession();
		try {
			session.beginTransaction();
			getSession().save(transientInstance);
			session.getTransaction().commit();			
		} catch (RuntimeException re) {
			session.getTransaction().rollback();
		}finally{
			closeSession();
		}
	}

	public void delete(Orders persistentInstance) {
		Session session = getSession();
		try {
			session.beginTransaction();
			getSession().delete(persistentInstance);
			session.getTransaction().commit();
		} catch (RuntimeException re) {
			session.getTransaction().rollback();
		}finally{
			closeSession();
		}
	}

	public Orders findById(java.lang.Integer id) {		
		try {			
			Orders instance = (Orders) getSession().get("tarena.entity.Orders",id);			
			return instance;
		} catch (RuntimeException re) {			
			return null;
		} finally{
			closeSession();
		}
	}

	public List findByExample(Orders instance) {
		log.debug("finding Orders instance by example");
		try {
			List results = getSession().createCriteria("tarena.entity.Orders")
					.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 Orders instance with property: " + propertyName
				+ ", value: " + value);
		try {
			String queryString = "from Orders 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 findByState(Object state) {
		return findByProperty(STATE, state);
	}

	public List findByDescription(Object description) {
		return findByProperty(DESCRIPTION, description);
	}

	public List findByProductmoney(Object productmoney) {
		return findByProperty(PRODUCTMONEY, productmoney);
	}

	public List findByFare(Object fare) {
		return findByProperty(FARE, fare);
	}

	public List findByFees(Object fees) {
		return findByProperty(FEES, fees);
	}

	public List findByOrdermoney(Object ordermoney) {
		return findByProperty(ORDERMONEY, ordermoney);
	}

	public List findByDounum(Object dounum) {
		return findByProperty(DOUNUM, dounum);
	}

	public List findByPaymoney(Object paymoney) {
		return findByProperty(PAYMONEY, paymoney);
	}

	public List findByInvoice(Object invoice) {
		return findByProperty(INVOICE, invoice);
	}

	public List findByReceivedate(Object receivedate) {
		return findByProperty(RECEIVEDATE, receivedate);
	}

	public List findByInvoicename(Object invoicename) {
		return findByProperty(INVOICENAME, invoicename);
	}

	public List findByInvoicedesc(Object invoicedesc) {
		return findByProperty(INVOICEDESC, invoicedesc);
	}

	public List findByLogisticscompany(Object logisticscompany) {
		return findByProperty(LOGISTICSCOMPANY, logisticscompany);
	}

	public List findByLogisticsnumber(Object logisticsnumber) {
		return findByProperty(LOGISTICSNUMBER, logisticsnumber);
	}

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

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

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

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