outgrowthdao.java

这是一个物流管理系统

package dao;

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

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

import bean.Delivermission;
import bean.Employeeinfo;
import bean.Orderinfo;
import bean.Outgrowth;
import bean.Roadlog;
import bean.State;
import bean.Vehicle;

import util.HibernateSessionFactory;

public class OutGrowthDAO {
	
	public List<Outgrowth> allOutgrowth(){
	    Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
	    tr.begin();
	    List<Outgrowth> list = session.createQuery("from Outgrowth").list();
	    tr.commit();
	    //session.close();
	    return list;
	}
	
	public boolean addOutGrowth(Outgrowth outg){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		session.save(outg);
		tr.commit();
//		session.close();
		return true;
	}
	public Orderinfo quaryByOrderid(Long orderid){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		Orderinfo order = new Orderinfo();
		List li = session.createQuery("from Orderinfo o where o.orderid = :orderid")
			.setLong("orderid", orderid)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			order = (Orderinfo)pit.next();
		}
		tr.commit();
//		session.close();
		return order;
	}
	
	public Delivermission quaryByMissionid(long missionid){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		Delivermission mission = new Delivermission();
		List li = session.createQuery("from Delivermission dm where dm.missionid = :missionid")
			.setLong("missionid", missionid)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			mission = (Delivermission)pit.next();
		}
		tr.commit();
//		session.close();
		return mission;
	}
	
	public Employeeinfo quaryByEmployeeid(long employeeid){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		Employeeinfo emp = new Employeeinfo();
		List li = session.createQuery("from Employeeinfo emp where emp.employeeid = :employeeid")
			.setLong("employeeid", employeeid)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			emp = (Employeeinfo)pit.next();
		}
		tr.commit();
//		session.close();
		return emp;
	}
	
	public Vehicle quaryByVehicleid(long vehicleid){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		Vehicle vh = new Vehicle();
		List li = session.createQuery("from Vehicle v where v.vehicleid = :vehicleid")
			.setLong("vehicleid", vehicleid)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			vh = (Vehicle)pit.next();
		}
		tr.commit();
//		session.close();
		return vh;
	}
	
	public boolean updateDeliverMission(Delivermission dm){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
//		tr.begin();
		
	    State state = new State();
		List li = session.createQuery("from State s where s.statename = :statename")
			.setString("statename", "正在执行")
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			state = (State)pit.next();
		}

		dm.setState(state);
		session.save(dm);
		
		tr.commit();
//		session.close();
		
		return true;
	}
	
	public State quaryByStatename(String statename){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		State state = new State();
		List li = session.createQuery("from State s where s.statename = :statename")
			.setString("statename", statename)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			state = (State)pit.next();
		}
		tr.commit();
//		session.close();
		return state;
	}
	public boolean updateVehicle(Vehicle v){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		v.setVehiclestate(1l);
		session.save(v);		
		tr.commit();
		
		return true;
	}
	public boolean checkByEmpid(long id){
		Session session=HibernateSessionFactory.getSession();
		Transaction tr=session.beginTransaction();
		String hql="from Outgrowth out where out.employeeinfo.employeeid="+id;
		Query q=session.createQuery(hql);
		List<Outgrowth> sps=q.list();	
		tr.commit();
		if(sps.size()!= 0)
		{
			return true;
		}		
		    return false;
	}
}