orderdaoimpl.java

网上售书电子商务网站

package com.briup.dao.impl;

import java.util.Iterator;
import java.util.List;
import java.util.Map;
import java.util.TreeMap;

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

import com.briup.bean.Book;
import com.briup.bean.Orderform;
import com.briup.common.HibernateSessionFactory;
import com.briup.dao.IOrderDao;

public class OrderDaoImpl implements IOrderDao {

	public void deleteOrder(Long orderid) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Orderform order = (Orderform)session.get(Orderform.class, orderid);
		session.delete(order);
	}

	public Map<Long,Orderform> findAllOrder(Long customerid) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from Orderform o where o.customer.id = ?");
		query.setLong(0, customerid);
		List<Orderform> list = query.list();
		Map<Long,Orderform> map = new TreeMap<Long,Orderform>();
		for(Orderform order : list){
			map.put(order.getId(), order);
		}
		return map;
	}

	public Orderform findOrderById(Long orderid) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from Orderform where id = ?");
		query.setLong(0, orderid);
		return (Orderform)query.uniqueResult();
	}

	public void saveOrder(Orderform order) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		session.save(order);
	}

	public Map<Long,Book> findAllBook() throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from Book");
		List<Book> list = query.list();
		Map<Long,Book> map = new TreeMap<Long,Book>();
		for(Book book : list){
			map.put(book.getId(), book);
		}
		return map;
	}

}