hibernate中实现真分页和假分页技术

package com.bluedot.persist.impl; import java.io.Serializable; import java.util.ArrayList; import java.util.List; import org.hibernate.Criteria; import org.hibernate.Hibernate; import org.hibernate.Query; import org.hibernate.Session; import org.hibernate.criterion.DetachedCriteria; import org.hibernate.criterion.Example; import org.hibernate.criterion.Restrictions; import com.bluedot.commons.BaseDaoImpl; import com.bluedot.commons.HibernateSessionFactory; import com.bluedot.domain.Customer; import com.bluedot.domain.Page; import com.bluedot.persist.CustomerDao; public class CustomerDaoImpl extends BaseDaoImpl<Customer, Serializable> implements CustomerDao { public CustomerDaoImpl(){ this.entity = Customer.class; } @Override public List findCustomerByName(String name) { Session s = HibernateSessionFactory.getSession(); String hql = "from Customer c where c.name like '%"+name+"%'"; //String hql = "select c.name,c.id,c.orderses from Customer c where c.name like '%"+name+"%'"; Query query = s.createQuery(hql); return query.list(); } @Override public Customer findCustomerByNameWithEq(String name) { Session s = HibernateSessionFactory.getSession(); //在hql语句中，通过用户传入的某个值进行查询拼值结构如下 String hql = "from Customer c where c.name = :abc"; /*Query query = s.createQuery(hql); query.setString("abc", name); return (Customer)query.uniqueResult();*/ return (Customer)s.createQuery(hql).setString("abc", name).uniqueResult(); } @Override public List<Customer> findCustomerByNameWithQBC(String name) { Session s = HibernateSessionFactory.getSession(); Criteria c = s.createCriteria(Customer.class); //注释部分的前两句表示and关系，光第三句代表or关系 /*c.add(Restrictions.like("name", "%"+name+"%")); c.add(Restrictions.eq("id", new Long(10)));*/ //c.add(Restrictions.or(Restrictions.like("name", "%"+name+"%"),Restrictions.eq("id", new Long(10)))); /*String[] arr = new String[]{"aa","bb","张飞"}; c.add(Restrictions.in("name", arr));*/ /*List<String> list = new ArrayList<String>(); list.add("aa");*/ List<Long> list = new ArrayList<Long>(); list.add(new Long(1)); list.add(new Long(2)); c.add(Restrictions.in("id", list)); return c.list(); } @Override public List<Customer> findCustomerByNameWithQBE(Customer cc) { Session s = HibernateSessionFactory.getSession(); Criteria c = s.createCriteria(Customer.class); c.add(Example.create(cc).enableLike()); return c.list(); } @Override public List<Customer> findCustomerByNameWithSQL(String name) { Session s = HibernateSessionFactory.getSession(); String sql = "select * from customer c where c.name like :abc"; Query q = s.createSQLQuery(sql).addEntity(Customer.class); q.setString("abc", "%"+name+"%"); return q.list(); } @Override public Page findCustomerByPropertyWithHQL(Customer c, int currentPage) { StringBuffer sb = new StringBuffer(" where 1=1 "); if(c.getId() != null){ sb.append(" and id=").append(c.getId()); } if(c.getName() != null && c.getName().length() >0){ sb.append(" and name like '%").append(c.getName()).append("%'"); } return this.findPageByPrepertyWithHQL(null, "Customer", sb.toString(), currentPage); } @Override public Page findCustomerByPropertyWithQBC(Customer c, int currentPage) { DetachedCriteria dc = DetachedCriteria.forClass(Customer.class); if(c.getId() != null){ dc.add(Restrictions.eq("id", c.getId())); } if(c.getName() != null && c.getName().length() >0){ dc.add(Restrictions.like("name", "%"+c.getName()+"%")); } return this.findPageByPrepertyWithQBC(dc, currentPage); } }