orderitemhibernatedao.java

在线图书管理系统,所有框架struts2,hibernate,spring 希望有所帮助!

/**
 * 
 */
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.bID = ? 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();
		}
	}

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


}