ClienteDao.java

package javagurus.curso.frameworks.dao;

import java.util.List;

import javagurus.curso.frameworks.model.Cliente;
import javagurus.curso.frameworks.util.HibernateUtil;

import org.hibernate.Criteria;
import org.hibernate.Query;
import org.hibernate.Session;
import org.hibernate.criterion.Projections;

public class ClienteDao {	
	public List<Cliente> buscarClientesPorNombre(String nombre){
		Session session = HibernateUtil.getSessionFactory()
				.openSession();
		
		Query query = session.createQuery(
				"from Cliente where nombre like :param");

		query.setString("param", "%"+nombre+"%");
		
		return (List<Cliente>) query.list();		
	}
	
	public Integer contarClientes(){
		Session session = HibernateUtil.getSessionFactory()
				.openSession();
		
		Query query = session.createQuery(
				"select count(*) from Cliente");
		
		return ((Long) query.list().get(0)).intValue();

//		Criteria criter = session.createCriteria(Cliente.class)
//				.setProjection(Projections.rowCount());
//		
//		return criter.uniqueResult();
	}
	
	public List<Cliente> listarClientesPaginado(int from, int rows){
		Session session = HibernateUtil.getSessionFactory()
				.openSession();
		
		Query query = session.createQuery(
				"from Cliente");
		
		query.setFirstResult(from);
		query.setMaxResults(rows);

		return (List<Cliente>) query.list();
	}
}