orderhibernatedao.java

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

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

import java.util.ArrayList;
import java.util.HashSet;
import java.util.Iterator;
import java.util.List;

import net.sf.hibernate.HibernateException;
import net.sf.hibernate.Session;
import net.sf.hibernate.Transaction;

import org.apache.log4j.LogManager;
import org.apache.log4j.Logger;
import org.springframework.orm.hibernate.support.HibernateDaoSupport;

import com.ascent.bean.Orders;
import com.ascent.bean.Orderitem;
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.CustId = ? order by ord.orderId desc";


	/**
	 * 
	 */
	public OrderHibernateDAO() {
		super();
	}
	
	/**
	 * 
	 * @param Order
	 * @return Order
	 */
	public Orders saveOrder(Orders order){

		try{
	        LOGGER.debug("保存订单信息到数据库！");
			this.getHibernateTemplate().save(order);
	        Iterator it = order.getOrderItems().iterator();
	        while(it.hasNext()){
	        	LOGGER.debug("保存订单明细项到数据库！");
	        	Orderitem item = (Orderitem)it.next();
	        	this.getHibernateTemplate().save(item);
	        }
	        
			return order;
		}catch(Exception ex){
			LOGGER.error("保存订单和订单明细失败!");
			ex.printStackTrace();
			return null;
		}
	}

	/**
	 * 
	 * @param id Integer
	 *            
	 * @return Order
	 */
	public Orders getOrder(Integer id){
		LOGGER.debug("根据订单ID取得订单对象！");
		return (Orders)this.getHibernateTemplate().get(Orders.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 findOrderByCust(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(Orders order){
		LOGGER.debug("从数据库中删除指定订单");
		this.getHibernateTemplate().delete(order);
	}

}