orderdaoimpl.java

一个J2EE 做的 网上图书销售管理系统

package com.briup.dao.imp;

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.BookForm;
import com.briup.bean.Orderform;
import com.briup.bean.Orderline;
import com.briup.common.HibernateSessionFactory;
import com.briup.dao.IOrderDao;

public class OrderDaoImpl implements IOrderDao {

	public void deleteOrder(int 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 findAllOrder(int customerid) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from Orderform o where o.customer.id = ?");
		query.setInteger(0, customerid);
		List list = query.list();
		Map map = new TreeMap();
		Iterator iter = list.iterator();
		while(iter.hasNext()){
			Orderform order = (Orderform)iter.next();
			map.put(order.getId(), order);
		}
		return map;
	}

	public Orderform findOrderById(int orderid) throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from Orderform where id = ?");
		query.setInteger(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 findAllBook() throws Exception {
		// TODO Auto-generated method stub
		Session session = HibernateSessionFactory.getSession();
		Query query = session.createQuery("from BookForm");
		List list = query.list();
		Map map = new TreeMap();
		Iterator iter = list.iterator();
		while(iter.hasNext()){
			BookForm book = (BookForm)iter.next();
			map.put(book.getId(), book);
		}
		return map;
	}

}