这可行吗?
我想使用 JPARepository 获取所有具有特定 CCC.incidentAssessmentResultId ID 的 AAA 对象。这可行吗?
@Entity
@Table(schema = "aaa", name = "table")
public class AAA {
@Column(name = "kryterium")
private String criterion;
@OneToMany(fetch = FetchType.LAZY, cascade = CascadeType.ALL, orphanRemoval = true)
@JoinColumn(name = "id_kryterium_naruszen")
private List<BBB> violationFactors;
}
public class BBB {
@Column(name = "czynnik")
private String factor;
@Column(name = "stopien")
private float degree;
@JsonManagedReference
@OneToOne(mappedBy = "violationFactor")
private CCC incidentAssessmentFactor;
}
public class CCC {
@Column(name="komentarz")
private String comment;
@Column(name="ocena_naruszenia_wynik_id", updatable=false, insertable=false)
private Long incidentAssessmentResultId; //-> I'd like to find AAA objects with a specific incidentAssessmentResultId ID
@Column(name="czynnik_wybrany")
private Boolean factorIsSelected;
@Column(name = "wartosc_wybrana")
private float value;
@Repository
public interface ViolationCriterionRepository extends JpaRepository<AAA, Long> {
// @Query("select vc from AAA vc left join vc.violationFactors vf left join vf.incidentAssessmentFactor iaf where iaf.incidentAssessmentResultId = ?1")
List<AAA> findByViolationFactors_IncidentAssessmentFactor_IncidentAssessmentResultId(Long incidentId);
}
现在,当我调用ViolationCriterionRepository.findAll()时,我会得到所有的数据,但是我想得到所有的数据,但是带有某些CCC对象。我已经在我的存储库中尝试了下面的方法,但我没有得到任何结果。
更新
我的存储库:
@Repository
public interface ViolationCriterionRepository extends JpaRepository<ViolationCriterion, Long> {
@Query("select vc from AAA vc join vc.violationFactors vf join vf.incidentAssessmentFactor iaf where iaf.incidentAssessmentResultId = ?1")
List<AAA> findByIncidentAssessmentResultId(Long incidentId);
}
select cv
,然后是from ViolationCriterion vc
。请保持一致,要么用 vc,要么用 cv。 - JB Nizet