假设我有两个实体:
class User {
@Id private int id;
private String name;
private int addressId;
}
class Address {
@Id private int id;
private String street;
}
是否可以这样做:
interface UserRepository extends CrudRepository<User, Integer> {
@Query(nativeQuery=true,
value=
"select * from user "
+ "inner join address a on a.id = u.addressId "
+ "where a.street = :address.street")
List<User> findByAddress(@Param("address") Address address);
}
也就是说:接受一个实体(在本例中为Address
(作为参数,但在本机查询中引用其属性之一(在本例中为Address.street
(?
由于各种原因,我不能对这两个实体使用"正常"@ManyToMany
和 JPA 查询。
在这里找到答案:
https://spring.io/blog/2014/07/15/spel-support-in-spring-data-jpa-query-definitions
这可用于:
+ "where a.street = :#{#address.street}")
奖金 - 对于a.street in(...)
,使用集合投影:
https://docs.spring.io/spring/docs/4.3.10.RELEASE/spring-framework-reference/html/expressions.html#expressions-collection-projection
那是:
+ "where a.street in(:#{#address.![street]})")