Hibernate Criteria / Query对象属性 [英] Hibernate Criteria / Query on object properties

问题描述

我有一个类 AppUser ;

  class AppUser {
 private String firstName; 
 private String lastName; 
 //  -  getters和setters 
} 
  

我还有另一个类学生;

  class Student {
 private AppUser appUser; 
私人日期dateOfBirth; 
 //  -  getters和setters 
} 
  

我会如何搜索学生 John Doe ，名字John，姓氏Doe？

如果是出生日期属性，我会创建a Criteria 并在日期中添加一个相等限制（ Restristions.eq ）。

解决方案

查询：

$我如何为AppName对象中的lastName和firstName？ b $ b'pre> 查询q = session.createQuery（
SELECT期从学生S其中s.appUser.firstName =：FirstName和s.appUser.lastName =：名字）;
q.setParameter（firstName，John）;
q.setParameter（lastName，Doe）;


要使用Criteria，请选择此线程

此外看一看 hibernate文档中的这个页面

I have a class AppUser;

class AppUser {
   private String firstName;
   private String lastName;
   //-- getters and setters
}

I also have another class Student;

class Student {
   private AppUser appUser;
   private Date dateOfBirth;
   //-- getters and setters
}

How would i search for Student John Doe, firstName John, lastName Doe?

Had it been the date of birth property, i would create a Criteria and add an equality Restriction (Restristions.eq) on the date. How would i do it for lastName and firstName in the AppUser object?

解决方案

Query:

Query q = session.createQuery(
    "SELECT s from Student s WHERE s.appUser.firstName=:firstName AND s.appUser.lastName=:lastName");
q.setParameter("firstName", "John");
q.setParameter("lastName", "Doe");

For using Criteria, check this thread

Also take a look at this page from hibernate docs

这篇关于Hibernate Criteria / Query对象属性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！