orderhibernatedao.java

一个订单系统

package cn.hxex.order.dao.hibernate;

import java.sql.SQLException;
import java.util.List;
import java.util.Iterator;
import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import cn.hxex.order.bo.Order;
import cn.hxex.order.dao.IOrderDAO;

/**
 * 订单DAO的Hibernate实现，包含了数据处理逻辑
 */
public class OrderHibernateDAO
	extends HibernateDaoSupport
	implements IOrderDAO {

	/**
	 * 通过ID得到订单的信息
	 *
	 * @param id 订单的ID
	 * @return Order 订单信息
	 */
	public Order findOrderById(final int id) {

		Order order =
			(Order) getHibernateTemplate().load(Order.class, Integer.valueOf( id ));
			
		return order;

	}

	/**
	 * 通过下订单的用户得到订单的信息
	 *
	 * @param placedBy 下订单的用户名
	 * @return List 订单信息列表
	 */
	@SuppressWarnings("unchecked")
	public List<Order> findOrdersPlaceByUser(final String placedBy) {

		return getHibernateTemplate().executeFind(new HibernateCallback() {
			public Object doInHibernate(Session session)
				throws HibernateException, SQLException {

				/*StringBuffer sb = new StringBuffer(100);
				//sb.append("select distinct order ");
				sb.append("select ");
				sb.append("from Order order ");
				sb.append("join order.orderLineItems lineItems ");
				sb.append("where order.userName = :placedBy");

				sb.append(" order by order.id");

				Query query = session.createQuery(sb.toString());
				**/
				Query query = session.createQuery("from Order where userName = ?" );//where id = 2
				query.setString(0, placedBy);
				//query.setString("placedBy", placedBy);
                
				List<Order> list = query.list();
				if(list.isEmpty())System.out.println("list null");
				System.out.println(placedBy);
				Iterator it = list.iterator(); 
				while (it.hasNext()) {   Order order=(Order)it.next();System.out.println(order.getId()+","+order.getUserName()); } 

				return list;

			}
		});
	}

	/**
	 * 保存一个订单信息
	 *
	 * @param order 订单信息
	 */
	public Order saveOrder(final Order order) {

		getHibernateTemplate().save(order);

		return order;
	}

}