dutyinfodao.java

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

package dao;

import java.util.List;

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

import util.HibernateSessionFactory;
import bean.Dutyinfo;



  public class DutyinfoDAO {
      
	    Session s = null;
		Transaction tr = null;
		
		public List<Dutyinfo> allDuty(){
			s=HibernateSessionFactory.getSession();
			tr=s.beginTransaction();
			String hql="from Dutyinfo dutyinfo";
			Query q=s.createQuery(hql);
			List<Dutyinfo> sps=q.list();
			tr.commit();		
			return sps;
		}
	  
	  public List<Dutyinfo> selectById(long id){
			s=HibernateSessionFactory.getSession();
			tr=s.beginTransaction();
			String hql="from Dutyinfo dutyinfo where dutyinfo.dutyid="+id;
			Query q=s.createQuery(hql);
			List<Dutyinfo> sps=q.list();
			tr.commit();		
			return sps;
		} 
		
		public List<Dutyinfo> selectByName(String name){
			s=HibernateSessionFactory.getSession();
			tr=s.beginTransaction();
			String hql="select distinct dutyinfo from Dutyinfo dutyinfo where dutyinfo.duty='"+name+"'";
			Query q=s.createQuery(hql);
			List id=q.list();
			tr.commit();		
			return id;
		} 
		public List<Dutyinfo> search(long id,String name){
			s=HibernateSessionFactory.getSession();
			tr=s.beginTransaction();
			String hql="from Dutyinfo dutyinfo where dutyinfo.dutyid="+id+"and dutyinfo.duty='"+name+"'";
			Query q=s.createQuery(hql);
			List<Dutyinfo> sps=q.list();
			tr.commit();		
			return sps;
		} 
		
		public void updateDuty(long id,Dutyinfo d){		
			s =HibernateSessionFactory.getSession();
			tr=s.beginTransaction();
			//String hql="update Dutyinfo dutyinfo set dutyinfo.duty=?,dutyinfo.department=? where dutyinfo.dutyid="+id;
			//Query q=s.createQuery(hql);
			//q.setString(0, d.getDuty());
			//q.setString(1, d.getDepartment());
			//int index=q.executeUpdate();
			Dutyinfo dutyinfo=(Dutyinfo)s.get("bean.Dutyinfo", id);
			System.out.println(s.toString());
			dutyinfo.setDuty(d.getDuty());
			dutyinfo.setDepartment(d.getDepartment());
	        s.update(dutyinfo);
			tr.commit();
			s.close();
		}
		
		public void delDuty(long id){		
			s =HibernateSessionFactory.getSession();
			tr=s.beginTransaction();
			String hql="delete from Dutyinfo dutyinfo where dutyinfo.dutyid="+id;
			int q=s.createQuery(hql).executeUpdate();
			tr.commit();
		}
		public void sessionClose(){
	    	if(s!=null)
	    		s.close();
	    }
		
		
		
}