Hibernate 查询方法

1、简单查询：
 public User select(User user) {
        User newUser;
        try {
            newUser = (User) session.get(User.class,user.getId());
            return newUser;
        } catch (Exception e) {
            log.error("查询失败", e);
            return null;
        } finally {
            HibernateUtil.closeSession();
        }
    }
2、 用?：  
 public List<User>select(User user){  
  String hql = "from user where emails= ? and password= ?";  
  Query query = session.createQuery(hql);  
  query.setString(0, user.getEmails());  
  query.setString(1, user.getPassword());  
  List<User> list = query.list();  
  session.close();  
  return list;  
 }  
  
3、用":+命名":  
 public List<User> select(User user){  
  Session session = HibernateSessionFactory.getSession();  
  String hql = "from user where emails= :e and password= :p";  
  Query query = session.createQuery(hql);  
{
  query.setString("e", user.getEmails());  
  query.setString("p", user.getPassword());  
}else{
 query.setParameter("e", user.getEmails());  
  query.setParameter("p", user.getPassword());  
}else{
 query.setProperties(user);  
}
  List<User> list = query.list();  
  session.close();  
  return list;  
 }  
4、使用条件查询(Criteria) 没有hql语句 :
 public List<User> select(User user){  
  Criteria cri = session.createCriteria(User.class);  
  cri.add(Restrictions.eq("emails", user.getEmails()));  
  cri.add(Restrictions.eq("password", user.getPassword()));  
  List<User> list = cri.list();  
  session.close();  
  return list;  
 }  
   
   
5、离线条件查询:
 public List<User> select(User user){  
  DetachedCriteria dc = DetachedCriteria.forClass(User.class);  
  dc .add(Restrictions.eq("emails", user.getEmails()));  
  dc .add(Restrictions.eq("password", user.getPassword()));  
  Criteria cri = dc.getExecutableCriteria(session);  
  List<User> list = cri.list();  
  session.close();  
  return list;  
 }   
6、分页查询:
1)  setFirstResult(int):指定从指定的位置开始查询
2)  setMaxResult(int):指定一次查询的对象数量。