orderitemhibernatedao.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.Orderitem;
import com.ascent.dao.IOrderItemDAO;

public class OrderItemHibernateDAO extends HibernateDaoSupport implements
		IOrderItemDAO {

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

	private static final String LOAD_ALL = "from Orderitem oi order by oi.orderItemId desc";

	private static final String LOAD_BY_BOOK = "from Orderitem oi where oi.bookId = ? order by oi.orderItemId desc";

	private static final String LOAD_BY_ORDERID = "from Orderitem oi where oi.orderId = ? order by oi.orderItemId desc";

	/**
	 * 
	 */
	public OrderItemHibernateDAO() {
		super();
		// TODO Auto-generated constructor stub
	}

	/**
	 * 
	 * @param Orderitem
	 * @return Orderitem
	 */
	public Orderitem saveOrderitem(Orderitem orderitem) {
		try {
			LOGGER.debug("保存订单明显项到数据库！");
			this.getHibernateTemplate().save(orderitem);
			return orderitem;
		} catch (Exception ex) {
			LOGGER.error("保存订单明细项到数据库失败！");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param id
	 *            Integer
	 * 
	 * @return Orderitem
	 */
	public Orderitem getOrderitem(Integer id) {
		LOGGER.debug("根据订单明细项ID获取该订单项信息！");
		return (Orderitem) this.getHibernateTemplate().get(Orderitem.class, id);
	}

	/**
	 * 
	 * @return List
	 */
	public List findOrderitemAll() {
		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 findOrderitemByBook(Integer bookId) {
		try {
			LOGGER.debug("根据书籍ID获取对应该书的所有订单明细项列表！");
			return this.getHibernateTemplate().find(LOAD_BY_BOOK, bookId);
		} catch (Exception ex) {
			LOGGER.error("根据书籍ID获取对应该书的所有订单明细项列表失败！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	public List findOrderitemByOrderId(Integer orderId) {
		try {
			LOGGER.debug("根据订单ID获取对应该书的所有订单明细项列表！");
			return this.getHibernateTemplate().find(LOAD_BY_ORDERID, orderId);
		} catch (Exception ex) {
			LOGGER.error("根据订单ID获取对应该书的所有订单明细项列表失败！");
			ex.printStackTrace();
			return new ArrayList();
		}
	}

	/**
	 * 
	 * @param Orderitem
	 * 
	 */
	public void removeOrderItem(Orderitem orderitem) {
		LOGGER.debug("删除指定的订单明细项");
		this.getHibernateTemplate().delete(orderitem);
	}

}