带有参数属性的Spring data JPA查询

Question

声明使用输入参数属性作为查询参数的Spring data JPA查询的最简单方法是什么？

public class Person {
    @Id
    private long id;

    @Column
    private String forename;

    @Column
    private String surname;
}

public class Name {
    private String forename;
    private String surname;

    [constructor and getters]
}

public interface PersonRepository extends CrudRepository<Person, Long> {
    @Query("select p from Person p where p.forename = ?1.forename and p.surname = ?1.surname")
    findByName(Name name);
}

...但Spring data/JPA不喜欢我在？1参数上指定属性名。

最合适的选择是什么？

Answer 1

此链接将帮助您：支持SpEL表达式的Spring Data JPA M1。类似的例子是：

@Query("select u from User u where u.firstname = :#{#customer.firstname}")
List<User> findUsersByCustomersFirstname(@Param("customer") Customer customer);

https://spring.io/blog/2014/07/15/spel-support-in-spring-data-jpa-query-definitions