orderdaoimp1.java

老师给的购物车

package com.tarena.shopcart.entity.daoImp1;

import java.util.Iterator;
import java.util.List;
import java.util.Set;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.Transaction;

import com.tarena.shopcart.entity.OrderLine;
import com.tarena.shopcart.entity.OrderStatus;
import com.tarena.shopcart.entity.Orders;
import com.tarena.shopcart.entity.Payway;
import com.tarena.shopcart.entity.dao.IOrderDAO;
import com.tarena.shopcart.util.HibernateSessionFactory;


public class OrderDAOImp1 implements IOrderDAO {

	public boolean buildOrder(Orders order) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			session.save(order);
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return true;
	}

	public List getAllOrderByUid(String uid) {
		List list = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			list = session.createQuery("from Orders o where o.user=?")
					.setString(0, uid).list();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return list;
	}

	public Payway getPaywayByPyid(int paywayId) {
		Payway payway = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			payway = (Payway) session.createQuery(
					"from Payway p where p.paywayId=?").setInteger(0, paywayId)
					.uniqueResult();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return payway;
	}

	public List getAllPayway() {
		List list = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			list = session.createQuery("from Payway").list();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return list;
	}

	public boolean deleteOrderByUid(int oid) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			Query query = session.createQuery(
					"delete from Orders o where o.orderId=?")
					.setInteger(0, oid);
			int flag = query.executeUpdate();
			tran.commit();
			return flag > 0;
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		} finally {
			if (session != null) {
				session.close();
			}
		}
	}

	public Orders getOrderByUid(int oid) {
		Orders order = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			order = (Orders) session.createQuery(
					"from Orders o where o.orderId=?").setInteger(0, oid)
					.uniqueResult();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return order;
	}

	public OrderStatus getStatusByid(int statusId) {
		OrderStatus status = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			status = (OrderStatus) session.createQuery(
					"from OrderStatus s where s.statusId=?").setInteger(0, statusId)
					.uniqueResult();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return status;
	}


	public boolean deleteOrder(Orders order) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			session.delete(order);
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return true;
	}
	
	public static void main(String[] args) {
		
		System.out.println(new OrderDAOImp1().getOrdersByStatus("等待处理"));


	}

	public boolean modifyOrderStatus(Orders order) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			session.update(order);
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return true;
	}

	public List getOrdersByStatus(String status) {
		int i=1;
		if(status.equals("等待处理")){
			i=1;
		}else if(status.equals("处理中")){
			i=2;
		}else{            //已发货
			i=3;
		}
		List list = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			list = session.createQuery("from Orders o where o.status=?").setInteger(0, i).list();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return list;
	}

	public List getAllStatus() {
		List list = null;
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			list = session.createQuery("from OrderStatus").list();
			tran.commit();
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return null;
		} finally {
			if (session != null) {
				session.close();
			}
		}
		return list;
	}

	public boolean deleteOrderByuserid(String userId) {
		Session session = null;
		Transaction tran = null;
		try {
			session = HibernateSessionFactory.getSession();
			tran = session.beginTransaction();
			Query query=session.createQuery(" delete from Orders o where o.user=?").setString(0, userId);
			int flag=query.executeUpdate();
			tran.commit();
			return flag>0;
		} catch (Exception e) {
			tran.rollback();
			e.printStackTrace();
			return false;
		} finally {
			if (session != null) {
				session.close();
			}
		}
	}

	
}