singerfrontdao.java

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

package com.ktv.dao.front;

import java.util.List;

import javax.transaction.Transaction;

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;

public class SingerFrontDAO extends HibernateDaoSupport implements IBasicDAO{
	public List getList(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
		String sql = "select count(*) from Singer";
         
        int iTotal=Integer.parseInt(((List)getHibernateTemplate().find(sql)).get(0).toString());
        System.out.println("all totalPageSize:"+iTotal);
        return iTotal;
        
        
	}
	public List querySongList(int str) {
		// TODO Auto-generated method stub
		return null;
	}
	public int getSize(String condition) {
		// TODO Auto-generated method stub
		
		String sql = "select count(*) from Singer where singerType=?";
		
	   Session sess=this.getHibernateTemplate().getSessionFactory().openSession();
       
      Query q = sess.createQuery(sql);
       q.setCacheable(true);
		q.setString(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,String str) {
		//有条件的查询歌手列表
		try{
			
			DetachedCriteria dc=DetachedCriteria.forClass(Singer.class);
			dc.add(Expression.eq("singerType",str));//添加查找条件
			List list=getHibernateTemplate().findByCriteria(
		 			dc,
		 			startRow,
		 			pageSize) ; 
	
			return list;
		}catch(Exception ex){
			ex.printStackTrace();
			return null;
		}
	}
	
	public List getAll(int startRow, int pageSize){
		
		List list=this.getHibernateTemplate().findByCriteria(DetachedCriteria.forClass(Singer.class), startRow, pageSize);
		System.out.println("sui ji cha xun ge shou lie bao cheng gong!");		
		return list;
	
	}
//	public List getSingerSongs(String str) {
//		try{
//			
//			DetachedCriteria dc=DetachedCriteria.forClass(Singer.class);
//			dc.add(Expression.eq("singerType",str));//添加查找条件
//			List list=getHibernateTemplate().findByCriteria(
//		 			dc) ; 
//	
//			return list;
//		}catch(Exception ex){
//			ex.printStackTrace();
//			return null;
//		}
//	}
	public List getAll() {
		// TODO Auto-generated method stub
		return null;
	}
	public int getSize() {
		
	return 0;
	}

}