orderhibernatedao.java

利用Java开发的网上书店系统

/**
 * 
 */
package com.ascent.dao.hibernate;

import java.util.ArrayList;

import java.util.List;

import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;
import com.ascent.bean.Order;
import com.ascent.dao.IOrderDAO;

public class OrderHibernateDAO extends HibernateDaoSupport implements IOrderDAO {

	private static final Logger LOGGER = LogManager
			.getLogger(OrderHibernateDAO.class);

	private static final String LOAD_ALL = "from Order ord  order by ord.orderId desc ";

	private static final String LOAD_BY_CUST = "from Order ord where ore.CustomerId = ? order by ord.orderId desc";

	/**
	 * 
	 */
	public OrderHibernateDAO() {
		super();
	}

	/**
	 * 
	 * @param Order
	 * @return Order
	 */
	public Order saveNewOrder(Order order) {

		try {
			LOGGER.debug("保存订单信息到数据库！");
			this.getHibernateTemplate().save(order);
			return order;
		} catch (Exception ex) {
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param id
	 *            Integer
	 * 
	 * @return Order
	 */
	public Order getOrder(Integer id) {
		LOGGER.debug("根据订单ID取得订单对象！");
		return (Order) this.getHibernateTemplate().get(Order.class, id);
	}

	/**
	 * 
	 * @return List
	 */
	public List findOrderAll() {
		try {
			LOGGER.debug("获取所有订单信息列表！");
			return this.getHibernateTemplate().find(LOAD_ALL);
		} catch (Exception ex) {
			LOGGER.error("获取所有订单信息列表失败！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param type
	 *            String
	 * 
	 * @return List
	 */
	public List findOrderByCustomer(Integer custId) {
		try {
			LOGGER.debug("根据用户ID获取用户相应的订单列表！");
			return this.getHibernateTemplate().find(LOAD_BY_CUST, custId);
		} catch (Exception ex) {
			LOGGER.error("根据用户ID获取用户订单列表失败！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param Order
	 * 
	 */
	public void removeOrder(Order order) {
		LOGGER.debug("从数据库中删除指定订单");
		this.getHibernateTemplate().delete(order);
	}

}