songfrontdao.java

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

package com.ktv.dao.front;

import java.util.List;

import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.DetachedCriteria;
import org.hibernate.criterion.Expression;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.ktv.dao.IBasicDAO;
import com.ktv.entity.Singer;
import com.ktv.entity.Song;

public class SongFrontDAO extends HibernateDaoSupport implements IBasicDAO{
	
	public List getList(int startRow, int pageSize) {
		// TODO Auto-generated method stub
		return null;
	}
	public List getAll(int startRow, int pageSize) {
		// 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, String str) {
		// TODO Auto-generated method stub
		return null;
	}
	public List querySongList(String str) {
		// TODO Auto-generated method stub
		return null;
	}
	public int getSize(String condition) {
		// TODO Auto-generated method stub
		return 0;
	}
	public int getSize(int condition) {
		// TODO Auto-generated method stub
		
		String sql = "select count(*) from Song where singerId=?";
		
	   Session sess=this.getHibernateTemplate().getSessionFactory().openSession();
       
      Query q = sess.createQuery(sql);
       q.setCacheable(true);
		q.setInteger(0, condition);//为第一个参数给值
		
	//	sess.close();
		int i=(Integer)q.list().get(0);
	//	System.out.println("zong ye shu shi:"+i);
		return i;
		
		
		

       

		
	}
	

	public void add(Object object) {
		// TODO Auto-generated method stub
		
	}
	
	
	
	public List getList(int startRow, int pageSize,int str) {
		try{
			
			DetachedCriteria dc=DetachedCriteria.forClass(Song.class);
			dc.add(Expression.eq("singerId",str));//添加查找条件
			List list=getHibernateTemplate().findByCriteria(
		 			dc,startRow,pageSize) ; 
	
			return list;
		}catch(Exception ex){
			ex.printStackTrace();
			return null;
		}
	}
	public List getAll() {
		// TODO Auto-generated method stub
		return null;
	}
	public int getSize() {
		
	return 0;
	}

}