基于不同子类型属性的Hibernate查询父

// 定义父类实体
@Entity
@Inheritance(strategy = InheritanceType.TABLE_PER_CLASS)
public class Parent {
    @Id
    @GeneratedValue(strategy = GenerationType.TABLE)
    private Long id;
    private String commonProperty;
    // 省略其他属性和方法
}

// 定义子类实体
@Entity
public class Child1 extends Parent {
    private String child1Property;
    // 省略其他属性和方法
}

@Entity
public class Child2 extends Parent {
    private String child2Property;
    // 省略其他属性和方法
}

// 进行查询
Session session = sessionFactory.openSession();
Transaction tx = session.beginTransaction();

// 使用HQL进行查询
String hql = "from Parent p where p instanceof Child1 and p.commonProperty = :commonProperty";
Query query = session.createQuery(hql);
query.setParameter("commonProperty", "value");
List<Parent> result = query.list();

// 使用Criteria API进行查询
CriteriaBuilder builder = session.getCriteriaBuilder();
CriteriaQuery<Parent> criteria = builder.createQuery(Parent.class);
Root<Parent> root = criteria.from(Parent.class);
criteria.select(root);
criteria.where(builder.and(builder.equal(root.get("commonProperty"), "value"),
        builder.isInstanceOf(root, Child1.class)));
List<Parent> result = session.createQuery(criteria).getResultList();

tx.commit();
session.close();