vehicledao.java

来自「这是一个物流管理系统」· Java 代码 · 共 76 行

package dao;

import java.util.List;

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

import bean.*;

import util.HibernateSessionFactory;

public class VehicleDAO {
	private Session session;
	private Transaction tr;
	public VehicleDAO() {
		session = HibernateSessionFactory.getSession();
	}
	public void close() {
		session.close();
	}
	public Object checkVehicleAmount(){
		List list = null;
		List list2=null;
		String hql=null;
		hql="SELECT COUNT(*) FROM Vehicle as veh WHERE veh.vehiclestate=0";
		Query q = session.createQuery(hql);
		list= q.list();
		list2 = session.createQuery("from Vehicle v where v.employeeinfo.dutyinfo.dutyid=1003")
		.list();
        System.out.println(list2);
		Object o=list.get(0);
		return o;
		
	}
	public List getAllVehicle() {
		List list=null;
		String hql="FROM Vehicle";
		Query q=session.createQuery(hql);
		list=q.list();
		return list;
	}
	
	public List quarySpecilVechile(){
		List list = null;
		list = session.createQuery("from Vehicle v where v.vehiclestate=0 and v.employeeinfo.dutyinfo.dutyid= :vechileid")
				.setLong("vechileid", 1006)
				.list();
		//System.out.println(list);
		return list;
	}
	public boolean checkByEmpid(long id){
		session=HibernateSessionFactory.getSession();
		tr=session.beginTransaction();
		String hql="from Vehicle v where v.employeeinfo.employeeid="+id;
		Query q=session.createQuery(hql);
		List<Vehicle> sps=q.list();	
		tr.commit();
		if(sps.size()!= 0)
		{
			return true;
		}		
		    return false;
	} 
	public List quaryVechile(){
		List list = null;
		list = session.createQuery("from Employeeinfo emp where emp.dutyinfo.dutyid= :vechileid")
				.setLong("vechileid", 1005)
				.list();
		System.out.println(list);
		return list;
	}


}