boxdao.java

ktv点歌系统前台收银有开包房

package com.ktv.dao;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Order;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.ktv.entity.Box;

public  class boxDAO extends HibernateDaoSupport implements Ibox{

	public void save(Box box) {
    	getHibernateTemplate().saveOrUpdate(box);
    }
    
   
    public List getAll(int startRow, int pageSize){
    	return getHibernateTemplate().findByCriteria(DetachedCriteria.
    			forClass(Box.class).addOrder(Order.desc("id"))
    			,startRow,
                pageSize);
    }
    
  
     
     public List getAll(){
    	 
    	 return getHibernateTemplate().loadAll(Box.class);
     }

 
    public Object get(int id){
    	
        getHibernateTemplate().setCacheQueries(true);
     
        Box box = (Box)(getHibernateTemplate().get(Box.class, new Integer(id)));       
        return box;
     }
    
    
    public void delete(int id){

        getHibernateTemplate().delete(get(id));
       
    }
    
    public int UpdatePrices(final String boxType , final Double boxUnitPrice) 
    { 
    	//批量修改包房价格。
    return (Integer)getHibernateTemplate().execute(new HibernateCallback() {

    	public Object doInHibernate(Session session) throws HibernateException { 
    		Query query = session.createQuery(
    				"update Box set boxUnitPrice = :boxUnitPrice where boxType = :boxType"); 
    		query.setParameter("boxUnitPrice", boxUnitPrice); 
    		query.setParameter("boxType", boxType); 
    		return query.executeUpdate(); 
    	} 
    	}); 
    }

	public List search(List sList) {
		// TODO Auto-generated method stub
		return null;
	}  
}