有可能有两个班吗
Template
和
TemplateItem
template
和
template_item
,使用
Map<String, TemplateItem>
? 如果是这样的话,可以使用注释来完成吗?
@Entity
@Table(name = "template")
public class Template {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="id")
private long id = 0;
@Column(name="name")
private String name = "";
// Left side of map maps to name field of the item on the right side of the map.
@OneToMany(cascade=CascadeType.ALL, fetch=FetchType.LAZY)
@MapKey(name = "name")
private Map<String, TemplateItem> items = new HashMap<String, TemplateItem>();
}
@Entity
@Table(name = "template_item")
public class TemplateItem {
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
@Column(name="id")
private long id = 0;
// The name field is the unique key for the Template.items Map
@Column(name="name")
private String name = "";
@ManyToOne(cascade=CascadeType.ALL, fetch=FetchType.LAZY)
private Template template;
@Column(name="content")
private String content = "";
}
在mysql中,我们得到三个表,映射表包含从TemplateItem表复制出来的两列:
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| name | varchar(100) | NO | UNI | NULL | |
+-------------+--------------+------+-----+---------+----------------+
+-------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+----------------+
| id | bigint(20) | NO | PRI | NULL | auto_increment |
| content | longtext | NO | | NULL | |
| name | varchar(120) | NO | | NULL | |
| template_id | bigint(20) | YES | MUL | NULL | |
+-------------+--------------+------+-----+---------+----------------+
+----------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------+------+-----+---------+-------+
| at_template_id | bigint(20) | NO | PRI | NULL | |
| items_id | bigint(20) | NO | PRI | NULL | |
+----------------+------------+------+-----+---------+-------+