delivermissiondao.java

这是一个物流管理系统

package dao;

import java.util.*;

import org.hibernate.Session;
import org.hibernate.Transaction;
import bean.Delivermission;
import bean.Depotmission;
import bean.Orderinfo;
import bean.State;

import util.HibernateSessionFactory;

public class DelivermissionDAO {
	private Session session;
	private Transaction tr;	
	public DelivermissionDAO() {
		session = HibernateSessionFactory.getSession();
	}
	public void close() {
		session.close();
	}
	public void addDelivermission(Long orderid){
		tr=session.beginTransaction();
		Delivermission del=new Delivermission();
		Orderinfo ord=new Orderinfo();
		ord.setOrderid(orderid);
		del.setOrderinfo(ord);
		Date missiontime=new Date();
		del.setMissiontime(missiontime);
		State sta=new State();
		sta.setStateid(new Long(1004));
		del.setState(sta);
		session.save(del);
		tr.commit();
	}
	public List<Delivermission> allDeliverMission(){
	    tr = session.beginTransaction();
	    tr.begin();
	    List<Delivermission> list = session.createQuery("from Delivermission").list();
	    tr.commit();
	    return list;
	}
	public List<Delivermission> uncheckedDeliverMission(){
	    tr = session.beginTransaction();
	    tr.begin();
	    List<Delivermission> list = session.createQuery("from Delivermission dm where dm.state.statename = :statename")
	    	.setString("statename", "未执行").list();
	    tr.commit();
	    return list;
	}
	public Orderinfo quaryByOrderid(Long orderid){
		tr = session.beginTransaction();
		tr.begin();
		Orderinfo outg = new Orderinfo();
		List li = session.createQuery("from Orderinfo o where o.orderid = :orderid")
			.setLong("orderid", orderid)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			outg = (Orderinfo)pit.next();
		}
		tr.commit();
		return outg;
	}
	public Delivermission quaryByMissionid(long missionid){
		tr = session.beginTransaction();
		tr.begin();
		Delivermission dm = new Delivermission();
		List li = session.createQuery("from Delivermission d where d.missionid = :missionid")
									.setLong("missionid", missionid).list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			dm = (Delivermission)pit.next();
		}
		tr.commit();
		return dm;
	}
	

}