songdao.java

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

package com.ktv.dao.front;

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.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Example;
import org.hibernate.criterion.Order;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;
import org.hibernate.criterion.Expression;
import com.ktv.dao.IsongDAO;


import com.ktv.entity.Song;

public  class SongDAO extends HibernateDaoSupport implements IsongDAO{

	public void add(Object object) {
		// TODO Auto-generated method stub
		
	}

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

	public List getList(int startRow, int pageSize) {
		// TODO Auto-generated method stub
		try{
			
			List list=

		 getHibernateTemplate().findByCriteria(
		 			DetachedCriteria.forClass(Song.class).addOrder(Order.desc("songId")),
		 			startRow,
		 			pageSize) ; 
	
			return list;
		}catch(Exception ex){
			ex.printStackTrace();
			return null;
		}

	}

	public List getNumberList(String letternum,int startRow, int pageSize) {
		// TODO Auto-generated method stub
		try{
//			String sql = "select * from Song where songNumber="+letternum;
		
				DetachedCriteria nd=DetachedCriteria.forClass(Song.class);
				nd.add(Expression.eq("songNumber", letternum));
				List list =(List)getHibernateTemplate().findByCriteria(nd,startRow,pageSize);
			return list;
		}catch(Exception ex){
			ex.printStackTrace();
			return null;
		}

	}

	
	public List getLetterList(String letternum,int startRow, int pageSize) {
		// TODO Auto-generated method stub
		try{
//			String sql = "select * from Song where songNumber="+letternum;
		
				DetachedCriteria nd=DetachedCriteria.forClass(Song.class);
				nd.add(Expression.like("songNameLetter", letternum+"%"));
				
				List list =(List)getHibernateTemplate().findByCriteria(nd,startRow,pageSize);
			return list;
		}catch(Exception ex){
			ex.printStackTrace();
			return null;
		}

	}
	public int getSize(String contition,String sql) {
		// TODO Auto-generated method stub
		
		
		Session s = getHibernateTemplate().getSessionFactory().openSession();
		
		Query q = s.createQuery(sql).setString(0, contition);
		int i = (Integer)q.list().get(0);
		s.close();
		System.out.println("i================="+i);
		return i;
		// return Integer.parseInt(((List)getHibernateTemplate().find(sql)).get(0).toString());
	}

	public int getSize() {
		// TODO Auto-generated method stub
		String sql = "select count(*) from Song";
		 return Integer.parseInt(((List)getHibernateTemplate().find(sql)).get(0).toString());
	
	}
	   public List findSongName() {
	    	String sql = "select songNameLetter from Song";
			 return getHibernateTemplate().find(sql);
	    }  
	
	 private static final Log log = LogFactory.getLog(SongDAO.class);
		//property constants

	    public void save(Object song) {    	
	        getHibernateTemplate().saveOrUpdate(song);
	        
	    }
	    
		public void delete(Song song) {
			this.getHibernateTemplate().delete(song);
	    }

	    
	    public Object findById(java.lang.Integer id) {
	    	System.out.println("aaa");
	        log.debug("getting Jobs instance with id: " + id);
	        return (Song)this.getHibernateTemplate().get(Song.class, id);
	       
	    }
	    
	    
	    public List findByExample(Song song) {
	        log.debug("finding Jobs instance by example");

	       return this.getHibernateTemplate().findByCriteria(DetachedCriteria
	    		   .forClass(song.getClass()).add(Example.create(song)));
	      
	    }    
	  
	    public List findByProperty(String propertyName, Object value) {
	      log.debug("finding song instance with property: " + propertyName
	            + ", value: " + value);
	     try{
	      String queryString = "from song 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;
	     }
	    }
		
		
		 public void merge(Song song) {
		        log.debug("attaching dirty jobs instance");
		        this.getHibernateTemplate().merge(song);
		       
		    }

	    public void attachClean(Song instance) {
	        log.debug("attaching clean jobs instance");
	        this.getHibernateTemplate().lock(instance,LockMode.NONE);
	   }

		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(Song.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;
		}

	
}