如何使用注释在列不是主键的两个实体之间连接？

Question

我有两张员工和地址表。每个都有通过序列生成的主键empId和addressId。

员工类别：

public class Employee {
    @Id
    @Column(name = "sequence_id")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "emp_seq")
    @SequenceGenerator(sequenceName = "emp_seq", allocationSize = 1, name = "emp_seq")
    private Long sequenceId;

    @Column(name = "emp_id")
    private String empId;

    @Column(name = "joiningDate")
    private Date businessDate;

    @OneToOne(mappedBy = "employee", cascade = CascadeType.ALL)
    private Address address;
}

地址类

公共课堂演讲{

@Id
@Column(name = "address_id")
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "address_seq")
@SequenceGenerator(sequenceName = "address_seq", allocationSize = 1, name = "address_seq")
private Long addressID;

@Column(name = "street")
private String street;

@OneToOne
@JoinColumn(name = "emp_id")
@JsonIgnore
private Employee employee;

}

我正在使用JPARepository来保存这两个实体。这是我的主类。

Employee e = Employee.builder().businessDate(new Date())
        .empId("thinkerId").build();
Address a = Address.builder().street("32nd Street")
        .employee(e).build();
e.setAddress(a);
empRepository.save(e);

代码成功运行。但在我的地址表中，emp\u Id列包含主键，而不是emp\u Id列。

如何将“thinkerId”作为地址表中的值？

非常感谢。

Answer 1

在Address实体中，您必须显式指定您所引用的列：

public class Address {

    @Id
    @Column(name = "address_id")
    @GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "address_seq")
    @SequenceGenerator(sequenceName = "address_seq", allocationSize = 1, name = "address_seq")
    private Long addressID;

    @Column(name = "street")
    private String street;

    @OneToOne
    @JoinColumn(name = "emp_id", referencedColumnName = "emp_id")
    @JsonIgnore
    private Employee employee;
}