Hibernate中ManyToOne,OneToMany,On

2017-08-07  本文已影响261人  jiangadam

有3个表:
News:新闻表
NewsResource:新闻附件表
Resource:资源表

表关系:
1个新闻(News)对应多条新闻附件(NewsResource)
News:ID <---> NewsResource:news_id

1个新闻附件(NewsResource)对应1个资源(Resource)。
NewsResource:resource_id <---> Resource:ID

实体类如下:

@Entity  
@Table(name="news")  
public class NewsEntity implements Serializable{  
    private static final long serialVersionUID = 48L;  
  
    @Id   
    @GeneratedValue  
    @Column(name="ID")  
    private Long id;  
  
    @OneToMany(cascade=CascadeType.ALL,fetch=FetchType.LAZY,mappedBy="news")  
    private Set<NewsResourceEntity> newsResource;  
  
    //其他内容省略  
}  

NewsResource:
关于NewsResource表,有两种写法:
方法1:
这种写法用于不想和news表做级联更新,只想做级联查询的情况。news_id和resource_id都定义了2次,上面@Column用于自己表的更新,下面的@JoinColumn用于级联查询的时候的Join列。

@Entity  
@Table(name="newsresource")  
public class NewsResourceEntity implements Serializable{  
    private static final long serialVersionUID = 48L;  
  
    @Id  
    @GeneratedValue  
    @Column(name="ID")  
    private Long id;  
  
    @Column(name = "news_id")  
    private Long newsId;  
  
    @Column(name = "resource_id")  
    private Long resourceId;  
  
    @ManyToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)  
    @JoinColumn(name="news_id", insertable = false,updatable = false)  
    private NewsEntity news;  
  
    @OneToOne(optional = false, cascade = CascadeType.MERGE)  
    @JoinColumn(name = "resource_id", referencedColumnName = "id", unique = true, insertable = false,updatable = false)  
    private ResourceEntity resource;  
  
    //其他内容省略  
}  

方法2:
这种写法就是典型的级联查询+级联更新。

@Entity  
@Table(name="newsresource")  
public class NewsResourceEntity implements Serializable{  
    private static final long serialVersionUID = 48L;  
  
    @Id   
    @GeneratedValue  
    @Column(name="ID")  
    private Long id;  
  
    @ManyToOne(cascade=CascadeType.ALL,fetch=FetchType.LAZY)  
    @JoinColumn(name="news_id")  
    private NewsEntity news;  
  
    @OneToOne(optional = false, cascade = CascadeType.MERGE)  
    @JoinColumn(name = "resource_id", referencedColumnName = "id", unique = true)  
    private ResourceEntity resource;  
  
        //其他内容省略  
}  

Resource:

@Entity  
@Table(name="resource")  
public class ResourceEntity implements Serializable {  
    private static final long serialVersionUID = 48L;  
  
    @Id   
    @GeneratedValue  
    @Column(name="ID")  
    private Long id;  
  
    @OneToOne(optional = true, cascade = CascadeType.ALL, fetch=FetchType.LAZY, mappedBy = "resource")  
    private NewsResourceEntity newsResource;  
  
        //其他内容省略  
}  
manyToOne 示例
上一篇下一篇

猜你喜欢

热点阅读