@ManyToOne @ManyToMany使用

✿ﾟ卡笨卡

于 2024-05-16 10:24:10 发布

阅读量306

点赞数 3

分类专栏： java 笔记 sql 文章标签： java 数据库

本文链接：https://blog.csdn.net/tian__c/article/details/138949671

版权

笔记同时被 3 个专栏收录

22 篇文章 0 订阅

订阅专栏

java

18 篇文章 1 订阅

订阅专栏

sql

2 篇文章 0 订阅

订阅专栏

1、@ManyToOne

@ManyToOne(fetch = FetchType.EAGER)
@NotFound(action= NotFoundAction.IGNORE)
@JoinColumn(name = "country", insertable = false, updatable = false)
private StdPowerDict country;

主表的country字段
对应 StdPowerDict 实体的表

2、@ManyToMany

@ManyToMany(cascade = CascadeType.MERGE, fetch = FetchType.EAGER)
@JoinTable(name = "idb_std_power_engin_cate_v1", joinColumns = {
          @JoinColumn(name = "project_id", referencedColumnName = "id")}, inverseJoinColumns = {
          @JoinColumn(name = "cate_id", referencedColumnName = "id")})
private Set<StdPowerDict> cates;

@JoinTable ：里面填写中间表名称
@JoinColumn(name = “project_id”, referencedColumnName = “id”)：主表的id对应中间表的project_id
inverseJoinColumns = {@JoinColumn(name = “cate_id”, referencedColumnName = “id”)}：StdPowerDict表对应中间表cate_id

数据库关系图例