roadlogdao.java

这是一个物流管理系统

package dao;

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

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

import util.HibernateSessionFactory;

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

public class RoadlogDAO {
/*	private Long roadlogid;
	private Outgrowth outgrowth;
	private Date vehicletime;
	private String remark;*/
	public boolean addOutGrowth(Roadlog rl){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		session.save(rl);
		tr.commit();
//		session.close();
		return true;
	}
	
	public List<Roadlog> allRoadlog(){
	    Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
	    tr.begin();
	    List<Roadlog> list = session.createQuery("from Roadlog").list();
	    tr.commit();
	    //session.close();
	    return list;
	}
	
	public Outgrowth quaryByOutgrowthid(Long outgrowthid){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		Outgrowth outg = new Outgrowth();
		List li = session.createQuery("from Outgrowth o where o.outgrowthid = :outgrowthid")
			.setLong("outgrowthid", outgrowthid)
			.list();
		for(Iterator pit = li.iterator();pit.hasNext();){
			outg = (Outgrowth)pit.next();
		}
		tr.commit();
//		session.close();
		return outg;
	}
	
	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 boolean updateOutgrowth(Outgrowth outg){
		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();
		}

		outg.setState(state);
		session.save(outg);
		
		tr.commit();
//		session.close();
		
		return true;
	}
	
	public boolean updateVehicle(Vehicle v){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		tr.begin();
		v.setVehiclestate(0l);
		session.save(v);		
		tr.commit();
		
		return true;
	}
	public List quaryVechile(){
		Session session = HibernateSessionFactory.getSession();
	    Transaction tr = session.beginTransaction();
		List list = null;
		list = session.createQuery("from Outgrowth outg where outg.state.stateid= :stateid")
				.setLong("stateid", 1005)
				.list();
		System.out.println(list);
		return list;
	}
	
}