orderserviceimpl.java

网上商店

package service.impl;

import java.util.List;

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

import service.OrderService;
import domain.Account;
import domain.Order;

public class OrderServiceImpl implements OrderService {

	public void cancelOrder(Order order) {
		Session session = HibernateSessionFactory.getSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			session.delete(order);
			tx.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			tx.rollback();
		} finally {
			session.close();
		}

	}

	public void createOrder(Order order) {
		Session session = HibernateSessionFactory.getSession();
		Transaction tx = null;
		try {
			tx = session.beginTransaction();
			session.save(order);
			tx.commit();
		} catch (HibernateException e) {
			e.printStackTrace();
			tx.rollback();
		} finally {
			session.close();
		}

	}

	public List findByAccount(Account account) {
		Session session = HibernateSessionFactory.getSession();
		Query query = session.getNamedQuery("findOrderByAccount");
		query.setParameter(0, account);
		List list = query.list();
		session.close();
		return list;
	}

	public Order findById(String id) {
		Session session = HibernateSessionFactory.getSession();
		Query query = session.getNamedQuery("findOrderById");
		query.setParameter(0, id);
		List list = query.list();
		session.close();
		return (Order) list.get(0);
	}

}