将 @EmbeddedId 与 JpaRepository 一起使用

2022-01-18 00:00:00 spring java jpql jpa spring-data

我有一个简单的 Entitly 类，其中包含 @EmbeddedId(Integer 和 String 字段在单独的类中).我使用 Spring Data (org.springframework.data.jpa.repository.JpaRepository) 访问数据库 (MySql)，使用正常的 Id 查询工作正常，由 Spring 和我自己写的.使用 EmbeddedId 我没有设法创建正确的查询.我想要做的是选择所有 id(发生某些条件的 embeddedId 字段之一)这里有一些代码示例，也许有人会知道如何解决它.
实体类:

I have simple Entitly class with the @EmbeddedId (Integer and String fields in separate class). And I use the Spring Data (org.springframework.data.jpa.repository.JpaRepository) to access the database (MySql), with the normal Id the queries are working fine, both the generated by Spring and the ones wrote by myself. With the EmbeddedId I didnt manage to create the correct query. What I want to do is to select all the id (one of the fields of embeddedId for which some condition occurs) Here you have some code samples, maybe somebody will have an idea how to solve it.
The entity class:

@Entity
@Table(name="table_name")
public class EntityClass {

    @EmbeddedId
    private EmbeddedIdClass id;
    private String  someField;
    //rest of implemetation
}

EmbeddedId 类:

the EmbeddedId class:

@Embeddable
public class EmbeddedIdClass implements Serializable {

public EmbeddedIdClass(Long id, String language) {
    super();
    this.id = id;
    this.language = language;
}

public UserAdTextId() {}        

@Column(name="ad_id", nullable=false)
    private Integer id;

    @Column(name="language_code", nullable=false)
    private String  language;
    //rest of implemetation
}

和存储库:

@Transactional(readOnly=true)
public interface MyRepository extends JpaRepository<EntityClass, EmbeddedIdClass> {
    @Query("select distinct ad_id from EntityClass where userId = :userId and (/*here the conditions*/)")
    public Page<Integer> findUserAdsWithSearchString(@Param("userId") Integer userId, @Param("searchString") String searchString, Pageable page);
//rest of implemetation
}

我没有找到任何文档如何创建支持 @EmbeddedId 的方法，我尝试了许多不同的方法名称，但我总是从方法解析器中得到异常..

I didn't find any documentation how to create the methods for supporting the @EmbeddedId, I was trying many different method names, but I always get exceptions from the method parser..

推荐答案

您的查询似乎使用了列名.它应该包含属性名称，包括嵌入对象的导航.这里还有一个相关的问题:How to write JPQL SELECT with embedded id?

It seems your query is using column names. It should contain the property names, including navigation into embedded objects. There's also a related question here on SO: How to write JPQL SELECT with embedded id?

select distinct id.id from EntityClass where userId = :userId and (...)

第一个id是指EntityClass(类型为EmbeddedIdClass)的属性id，第二个是指EntityClass的属性id指 EmbeddedIdClass 的 id 属性.

The first id refers to attribute id of EntityClass (of type EmbeddedIdClass), and the second one refers to the id property of EmbeddedIdClass.

另外，请确保 EntityClass 中有 userId 属性.

Also, make sure there's a userId property in EntityClass.

相关文章