从@ElementCollection搜索对象

Question

我使用的是Spring Data JPA。

public class A {

    @CollectionTable(name = "B_ITEMS", joinColumns = @JoinColumn(name = "B_ID"))
    @ElementCollection
    private List<B> bs;

}

@Embeddable
public class B { 

private String prop1


private String prop2


private String prop3

}

public interface ARepo extends PagingAndSortingRepository<Clinic, Long> {

}

Answer 1

@ElementCollection只是映射@OneTomany关系的一种简单方法。

因此,您可以像往常一样加入它们：

public interface ARepo extends PagingAndSortingRepository<A, Long> {
    @Query("select a from A a join a.bs b where b.prop1 = :prop1 and ...")
    A findByProps(@Param("prop1") String prop1)
}