jobsdao.java

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

package com.ktv.dao;

import java.util.List;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.LockMode;
import org.hibernate.Query;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.Order;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;


import com.ktv.entity.Jobs;



public  class JobsDAO extends HibernateDaoSupport implements IBasicDAO{
  public List getList(int startRow, int pageSize, String str) {
	// TODO Auto-generated method stub
	return null;
}
  public List getAllSinger(int startRow, int pageSize) {
	// TODO Auto-generated method stub
	return null;
}
  public List getList(int startRow, int pageSize, int str) {
	// TODO Auto-generated method stub
	return null;
}
  public List querySongList(String str) {
	// TODO Auto-generated method stub
	return null;
}
  public int getSize(int condition) {
	// TODO Auto-generated method stub
	return 0;
}
  public List querySongList(int str) {
	// TODO Auto-generated method stub
	return null;
}
	public int getSize(String strTable) {
	// TODO Auto-generated method stub
	return 0;
}
	public void add(Object object) {
		// TODO Auto-generated method stub
		
	}

	public List getAll() {
		// TODO Auto-generated method stub
		return this.getHibernateTemplate().loadAll(Jobs.class);
	}

	public List getList(int startRow, int pageSize) {
		// TODO Auto-generated method stub
		try{
			//System.out.println("cccccccccccccccccccccccccc");
			List list=

		 getHibernateTemplate().findByCriteria(
		 			DetachedCriteria.forClass(Jobs.class).addOrder(Order.desc("jobs_id")),
		 			startRow,
		 			pageSize) ; 
		///	System.out.println("ddddddddddddddddddddddddddd");
			return list;
		}catch(Exception ex){
			ex.printStackTrace();
			return null;
		}
		 
//			return getHibernateTemplate().findByCriteria(
//	                DetachedCriteria.forClass(Company.class).addOrder(Order.desc("id")),
//	                startRow,
//	                pageSize);     
	}

	public int getSize() {
		// TODO Auto-generated method stub
		
		String sql = "select count(*) from Jobs";
        return Integer.parseInt(((List)getHibernateTemplate().find(sql)).get(0).toString());

		
		//return 0;
	}
//	public int getPageCount() {
//		// TODO Auto-generated method stub
//		return this.getHibernateTemplate().loadAll(Jobs.class).size();
//	}


	
	 private static final Log log = LogFactory.getLog(JobsDAO.class);

		//property constants
	

	    
	    public void save(Object jobs) {    	
	        getHibernateTemplate().saveOrUpdate(jobs);
	    }
	    
		public void delete(Jobs jobs) {
			this.getHibernateTemplate().delete(jobs);
	    }
		
//		public List getList(Class c, int start, int size) {		
//			
//			 return getHibernateTemplate()
//			 	.findByCriteria(
//			 			DetachedCriteria.forClass(Jobs.class).addOrder(Order.desc("jobs_id")),
//		                start,
//		                size) ;      
//	    }
	    
	    public Jobs findById(java.lang.Integer id) {
	    	
	        log.debug("getting Jobs instance with id: " + id);
	        return (Jobs)this.getHibernateTemplate().get("com.pagedivtest.entity.Jobs", id);
	       
	    }
	    
	    
	    public List findByExample(Jobs jobs) {
	        log.debug("finding Jobs instance by example");

	       return this.getHibernateTemplate().findByCriteria(DetachedCriteria.forClass(jobs.getClass()).add(Example.create(jobs)));
	      
	    }    
	    
	    public List findByProperty(String propertyName, Object value) {
	      log.debug("finding jobs instance with property: " + propertyName
	            + ", value: " + value);
	     try{
	      String queryString = "from jobs as model where model." 
				+ propertyName + "= ?";  
	      Query queryObject =this.getHibernateTemplate().getSessionFactory().openSession()
	      						.createQuery(queryString);
	      queryObject.setParameter(0, value);
	      return queryObject.list();
	     }catch(RuntimeException re){
	    	 log.error("find by property name failed", re);
	       throw re;
	     }
	      //      try {
//	         String queryString = "from Jobs as model where model." 
//	         						+ propertyName + "= ?";
//	         Query queryObject = getSession().createQuery(queryString);
//			 queryObject.setParameter(0, value);
//			 return queryObject.list();
//	      } catch (RuntimeException re) {
//	         log.error("find by property name failed", re);
//	         throw re;
//	      }
		}

//		public List findByName(Object name) {
//			return	this.getHibernateTemplate().findByNamedQuery( name);
////			return findByProperty(NAME, name);
//		}
		
		
		 public void merge(Jobs jobs) {
		        log.debug("attaching dirty jobs instance");
		        this.getHibernateTemplate().merge(jobs);
		       
		    }


	    public void attachClean(Jobs instance) {
	        log.debug("attaching clean jobs instance");
	        this.getHibernateTemplate().lock(instance,LockMode.NONE);
//	        try {
//	            getSession().lock(instance, LockMode.NONE);
//	            log.debug("attach successful");
//	        } catch (RuntimeException re) {
//	            log.error("attach failed", re);
//	            throw re;
//	        }
	   }

		public void delete(int id) {
			// TODO Auto-generated method stub
			this.getHibernateTemplate().delete(get(id));
			
		}

		public Object get(int id) {
			// TODO Auto-generated method stub
			
			Object oo=(Object) this.getHibernateTemplate().get(Jobs.class,new Integer(id));
			return oo;
		}
		public List getAll(int startRow, int pageSize) {
			// TODO Auto-generated method stub
			return null;
		}

	

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