Hibernate HQL-将PK中的列包含到查询中

Question

我使用Spring Roo对现有数据库进行反向工程，以便对现有数据库进行hibernate建模，在存在复合主键的情况下，它会生成XyzClass和XYZClasspk。

String hql = "select o from XyxClass o where primaryKey1 = :key1 and nonPrimaryKey = :key2";
    TypedQuery<XyzClass> query = entityManager().createQuery(hql, XyzClass.class);
    query.setParameter(......
    query.setParameter(......
    query.getResultList()

@RooJavaBean
@RooToString
@RooJpaActiveRecord(identifierType = XyzClassPK.class, versionField = "", table = "XYZ_CLASS")
@RooDbManaged(automaticallyDelete = true)
public class XyzClass {

@RooIdentifier(dbManaged = true)
public final class XyzClassPK {

    @Column(name = "PRIMARY_KEY1", nullable = false)
    private Integer primaryKey1;

    @Column(name = "PRIMARY_KEY2", nullable = false)
    private Integer primaryKey2;

Answer 1

您的HQL应该如下所示：

String hql = "select o from XyxClass o where o.xyz.primaryKey1 = :key1 and o.nonPrimaryKey = :key2";

其中xyz是您在XyxClass中的Id字段的名称（我在您的代码中看不到它..）希望这有帮助！