用于多语言支持的 Hibernate 映射

Question

我有一个 Category 类，其中包含 id、name、description 属性。

我希望用户可以输入多语言名称和描述并保存它们。

类的结构和 hibernate 映射应该是什么？

这是我的带注释的代码。但我无法向数据库插入任何内容：

@Entity
@Table(name = "category")
public class Category {
@Id
@GeneratedValue
public Integer getId() {
    return id;
}
public void setId(Integer id) {
    this.id = id;
}
private Integer id;
private Map<String, TranslatedString> name;
private Map<String, TranslatedString> description;



@ElementCollection
@CollectionTable(name = "translated_string")
@MapKeyJoinColumn(name = "langCode")
public Map<String, TranslatedString> getName() {
    return this.name;
}

public void setName(Map<String, TranslatedString> name) {
    this.name = name;
}

@ElementCollection
@CollectionTable(name = "translated_string")
@MapKeyJoinColumn(name = "langCode")
public Map<String, TranslatedString> getDescription() {
    return this.description;
}

public void setDescription(Map<String, TranslatedString> description) {
    this.description = description;
}



}


@Embeddable
public class TranslatedString {

public Integer getTid() {
    return tid;
}

public void setTid(Integer tid) {
    this.tid = tid;
}

private Integer tid;



private String langCode;

@Column(name = "langCode")
public String getLangCode() {
    return langCode;
}

public void setLangCode(String langCode) {
    this.langCode = langCode;
}

private String text;

@Column(name = "text")
public String getText() {
    return text;
}

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

}

我有两个表： 翻译后的字符串：tid、文本、语言代码 类别：id、name_id、description_id

我收到此信息消息： Hibernate：插入类别值 ( ) 当我想通过 hibernateTemplate 保存类别时。

当我想按 id 查找类别时，它会执行

select 

name0_.Category_id as Category1_0_0_, 
name0_.langCode as langCode0_, 
name0_.text as text0_, 
name0_.tid as tid0_, 
name0_.name_KEY as name5_0_ 

from translated_string name0_ 

where name0_.Category_id=?

由于我的translated_string表没有Category_id或name_KEY字段，我认为我的映射有问题。

我哪里错了？

Answer 1

class Category {
    public int Id;
    public Map<Language, String> names;
    public Map<Language, String> descriptions;

    public String getCurrentName()
    {
        // get current Language from somewhere
        return names.GetValue(currentLanguage);
    }
}

我的java的映射

<map name="names" table="names">
  <key column="categoryid" />
  <index column="language_id" />
  <element column="value"/>
</map>

<map name="descriptions" table="descriptions">
  <key column="categoryid" />
  <index column="language_id" />
  <element column="value" length="whatever"/>
</map>

有点生疏，请随意纠正语法

更新：简单字符串映射的注释，这应该足够了

@ElementCollection
@CollectionTable(name="TranslatedStrings", joinColumns=@JoinColumn(name="names_category_id"))
@Column(name="value")
public Map<String, String> getNames()

@ElementCollection
@CollectionTable(name="TranslatedStrings", joinColumns=@JoinColumn(name="descriptions_category_id"))
@Column(name="value")
public Map<String, String> getDescriptions()


public String getCurrentName()
{
    // get current Language from somewhere
    return names.GetValue(currentLanguage.getCode());
}