具有参数属性的Spring数据JPA查询 [英] Spring data JPA query with parameter properties

问题描述

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

What is the simplest way of declaring a Spring data JPA query that uses properties of an input parameter as query parameters?

例如，假设我有一个实体类:

For example, suppose I have an entity class:

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]
}

...然后我想编写一个Spring数据存储库，如下所示:

... then I would like to write a Spring data repository as follows:

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数据/JPA不喜欢我在?1参数上指定属性名称.

... but Spring data / JPA doesn't like me specifying property names on the ?1 parameter.

什么是最巧妙的选择?

推荐答案

此链接将为您提供帮助:支持SpEL表达式的Spring Data JPA M1.类似的示例是:

This link will help you: Spring Data JPA M1 with SpEL expressions supported. The similar example would be:

@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

这篇关于具有参数属性的Spring数据JPA查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！