使用Hibernate对多个属性进行动态查询(Dynamic Query on multiple properties with Hibernate)

 我有一个有几个属性的模型。 属性可以是原始（String）或复杂（Object）。 用户可以对每个原始属性进行查询。 我想知道是否有一种简单的方法来动态构建查询。 我使用Java和Hibernate。 
 
 该模型 
 
public class Model {
  String prop1;
  Point prop2;
  List<Shape> prop3;
}
 
 Point和Shape是可以包含基元或对象的对象。 查询的示例将是prop1 =“A”且坐标为x = 3且y = 8并且其中一个形状为圆的所有实例。 
 
 prop1 =“A”和prop2.x = 3和prop2.y和prop3.get（i）.type =“Circle”; 我们必须迭代prop3的所有实例。 
 
 我的第一个想法是不可维护和低效的。 它包括对所有基本属性进行查询，然后合并结果。 
 
 
 
 获取prop1 =“A”的所有实例 
 
 
 获取prop2.x = 3和prop3 = y的所有实例; 
 
 
 获取其中一个Shape.type =“Circle”的所有实例; 
 
 
 得到所有3集的交集 
 
 
 是否有任何现有的库或算法能够以更好（更聪明）的方式解决这个问题？ 
 
 谢谢 

I have a model that has several properties. The properties can be primitive (String) or complex (Object). The user can make a query on each primitive property. I would like to know if there is an easy way to build dynamically the query. I use Java and Hibernate.
 
The model
 
public class Model {
  String prop1;
  Point prop2;
  List<Shape> prop3;
}
 
Point and Shape are object that can contains primitives or objects. An example of a query would be all instances where prop1 = "A" and the coordinates are x = 3 and y = 8 and one of the shape is a circle.
 
prop1 = "A" and prop2.x = 3 and prop2.y and prop3.get(i).type = "Circle"; we would have to iterate on all instances of prop3.
 
My first idea was unmaintainable and inefficient. It consists in doing queries on all the primitive properties and then merge the results.
 
 
 
Get all instances where prop1 = "A"
 
 
Get all instances where prop2.x = 3 and prop3 = y;
 
 
Get all instances where one of the Shape.type = "Circle";
 
 
Get the intersection of all 3 sets
 
 
Is there any existing library or algorithm that can solve this problem in a better (smarter) way?
 
Thanks

原文：https://stackoverflow.com/questions/3463813