复合Id JPA2和Spring数据不工作

Question

我使用JPA2映射了以下实体：

@Entity
public class Translation {

@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name = "id")
private Long id;

private String locale;

@Column(name = "business_code",insertable = true,updatable = false,length = 200,nullable = false)
private String code;

private String text;

// Gettets and setters
....
}

然后我意识到than对（locale,code）应该是唯一的，所以我将实体更改为由locale,code组成的embeddedId，并从映射中删除了列id。这样，这一对将充当主键，它们不能重复：

结果：

@Entity 
public class Translation {

@EmbeddedId
private TranslationId translationId;

private String text;

public String getText() {
    return text;
}

public void setText(String text) {
    this.text = text;
}

public TranslationId getTranslationId() {
    return translationId;
}

public void setTranslationId(TranslationId translationId) {
    this.translationId = translationId;
}

@Override
public boolean equals(Object obj) {
    return EqualsBuilder.reflectionEquals(this, obj);
}

@Override
public int hashCode() {
    return HashCodeBuilder.reflectionHashCode(this);
}
}

@Embeddable
public class TranslationId implements Serializable{

private static final long serialVersionUID = 1L;

private String locale;

@Column(name = "business_code",insertable = true,updatable = false,length = 200,nullable = false)
private String code;

@Override
public boolean equals(Object obj){
    return EqualsBuilder.reflectionEquals(this, obj);
}

@Override
public int hashCode(){
    return HashCodeBuilder.reflectionHashCode(this);
}

public String getLocale() {
    return locale;
}

public void setLocale(String locale) {
    this.locale = locale;
}

public String getCode() {
    return code;
}

public void setCode(String code) {
    this.code = code;
}
}

@Repository
public interface TranslationRepository extends   JpaRepository<Translation,TranslationId> {

}

Answer 1

既然你的第一个问题已经解决了，我来回答第二个问题

我想让Spring数据只按区域设置（而不是按代码）查询所有翻译，我怎么做？

locale仍然可以通过translationid作为单个属性访问。在JPQL中，您可以编写

SELECT t FROM Translation t WHERE t.translationId.locale = :locale

@Query("SELECT t FROM Translation t WHERE t.translationId.locale = :locale")
public List<Translation> findByLocale(@Param("locale") String locale)

public List<Translation> findByTranslationIdLocale(String locale)