historydao.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.Expression;
import org.hibernate.criterion.Order;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.ktv.entity.Box;
import com.ktv.entity.History;

public  class historyDAO extends HibernateDaoSupport implements  IhistoryDAO{
	
	/* (non-Javadoc)
	 * @see com.ktv.dao.IhistoryDAO#save(com.ktv.entity.History)
	 */
	public void save(History history) {
    	getHibernateTemplate().saveOrUpdate(history);
    }
	
	 //开包房
    /* (non-Javadoc)
	 * @see com.ktv.dao.IhistoryDAO#openBox(com.ktv.entity.History)
	 */
    public void openBox(History history){
    	
    	getHibernateTemplate().saveOrUpdate(history);
    	
    } 
    
    public List getAll(int startRow, int pageSize){
    	return getHibernateTemplate().findByCriteria(DetachedCriteria.
    			forClass(History.class).addOrder(Order.desc("id"))
    			,startRow,
                pageSize);
    }
    
    public boolean getHistoryStatus(final int boxId){
  	    
    	//查看纪录表中是否有一条 boxId 的纪录。
    	String queryString =
	        "from History as boxId where boxId=" + boxId;
    	return (boolean)getHibernateTemplate().iterate(queryString).next().equals(boxId);
    }
    
    //把包房的状态该为 《使用中》
    public void UpdateBoxPrice(final int boxId){
    	
    	 getHibernateTemplate().execute(new HibernateCallback() {

    	    	public Object doInHibernate(Session session) throws HibernateException { 
    	    		Query query = session.createQuery(
    	    				"update Box set boxStatus = :boxStatus where boxId = :boxId"); 
    	    		String boxStatus="使用中";
    	    		query.setParameter("boxStatus", boxStatus); 
    	    	  query.setParameter("boxId", boxId); 
    	    	  query.executeUpdate();
    	    	  return null;
    	    	}     	    	
    	    	}    	 
    	 );   	
    }
    
    /*
     * 修改包房的状态为 《闲置》。
     */
    public void UpdateBoxStauts(final int boxId){
    	
   	 getHibernateTemplate().execute(new HibernateCallback() {

   	    	public Object doInHibernate(Session session) throws HibernateException { 
   	    		Query query = session.createQuery(
   	    				"update Box set boxStatus = :boxStatus where boxId = :boxId"); 
   	    		String boxStatus="闲置";
   	    		query.setParameter("boxStatus", boxStatus); 
   	    	  query.setParameter("boxId", boxId); 
   	    	  query.executeUpdate();
   	    	  return null;
   	    	}     	    	
   	    	}    	 
   	 );   	
   }
    /*
     * (non-Javadoc)
     * @see com.ktv.dao.IhistoryDAO#getHisByCon(java.lang.String, int)
     * 此方法没有用到
     */
    public Object getHisByCon(String column,int key)
	{
		return getHibernateTemplate()
		.findByCriteria(DetachedCriteria
				.forClass(History.class)
				.add(Expression.eq(column, key)));
	}
	
    /*
	 * 用一条SQL 语句根据 Id 取得一条包房信息
	 */
	public Object find(final int boxId) {		
	
		String queryString1="from History where boxId="+boxId+" order by historyId desc";
		
		  return (History)(getHibernateTemplate().find(queryString1).get(0));
		 }
	/*
	 * 取得最后一条记录
	 */
//	public History getLastInfo(int boxId) throws Exception {
//	    Iterator iterator = null;
//	    History history = null;
//	    String queryString = "from History  where boxId="+boxId+" order by historyId asc";
//	   // Query query = getHibernateTemplate().createQuery(getSession(), queryString);   
//	   Query query= (History)getHibernateTemplate().find(queryString);
//	    //记录生成
//	    List list = query.list();
//	    //把查询到的结果放入迭代器
//	    iterator = list.iterator();
//	    if (iterator.hasNext()) {
//	      history = (History) iterator.next();
//	    }
//	    return history;
//
//	  }
	
	
	
	
	/*
	 * 结账功能修改记录表中结束时间。
	 */
	public void updateEndTime(final int boxId ,final java.util.Date endTime){
		getHibernateTemplate().execute(new HibernateCallback(){			
			public Object doInHibernate(Session session )throws HibernateException{
				Query queryString=session.createQuery("" +
						"update History set endTime=:endTime where boxId=:boxId");
				queryString.setParameter("endTime", endTime);
				queryString.setParameter("boxId", boxId);
				queryString.executeUpdate();
				return null;
			}
		});
		
	} 
	
	/*
     * 修改记录里面的总价
     */
	public void updateZongPrice(final int historyId ,final double historyAllPrice){
		getHibernateTemplate().execute(new HibernateCallback(){			
			public Object doInHibernate(Session session )throws HibernateException{
				Query queryString=session.createQuery("" +
						"update History set historyAllPrice=:historyAllPrice where historyId=:historyId");
				queryString.setParameter("historyAllPrice", historyAllPrice);
				queryString.setParameter("historyId", historyId);
				queryString.executeUpdate();
				return null;
			}
		});
		
	} 
    
     
     /* (non-Javadoc)
	 * @see com.ktv.dao.IhistoryDAO#getAll()
	 * 取得所有的记录信息
	 */
    public List getAll(){
    	 
    	 return getHibernateTemplate().loadAll(History.class);
     }

 
    /* (non-Javadoc)
	 * @//根据Id取得一条记录信息
	 */
    public Object get(int id){
    	
        getHibernateTemplate().setCacheQueries(true);
     
        History history = (History)(getHibernateTemplate().get(History.class, new Integer(id)));       
       
        return history;
     }

    //根据Id取得一条包房的信息
     public Object getBox(int id){
    	
        getHibernateTemplate().setCacheQueries(true);
     
        Box box = (Box)(getHibernateTemplate().get(Box.class, new Integer(id)));       
        return box;
     }

	/* (non-Javadoc)
	 * @see com.ktv.dao.IhistoryDAO#add(java.lang.Object)
	 */
	public void add(Object object) {
		// TODO Auto-generated method stub
		
	}


	/* (non-Javadoc)
	 * @see com.ktv.dao.IhistoryDAO#getList(int, int)
	 */
	public List getList(int startRow, int pageSize) {
		// TODO Auto-generated method stub
		return null;
	}


	/* (non-Javadoc)
	 * @see com.ktv.dao.IhistoryDAO#getSize()
	 */
	public int getSize() {
		// TODO Auto-generated method stub
		return 0;
	}
    

}