Hibernate/JPA:foreign key=null

Question

下面是我的2个实体：

package dev.proj.project.application.model;

import com.fasterxml.jackson.annotation.JsonIgnore;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import javax.persistence.*;
import javax.validation.constraints.NotNull;
import java.util.List;

@Getter
@Setter
@NoArgsConstructor
@Entity
@Table(name = "user")
public class User {

    @Id
    @NotNull
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", updatable = false, nullable = false)
    public int id;

    @NotNull
    @Column(name="firstname")
    private String firstname;

    @NotNull
    @Column(name="lastname")
    private String lastname;

    @NotNull
    @Column(name="email")
    private String email;

    @NotNull
    @Column(name="password")
    private String password;

    @JsonIgnore
    @OneToMany(mappedBy="user", cascade = CascadeType.ALL)
    private List<Address> address;
}

package dev.proj.project.application.model;

import com.fasterxml.jackson.annotation.JsonIgnore;
import com.fasterxml.jackson.annotation.JsonManagedReference;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import javax.persistence.*;
import javax.validation.constraints.NotNull;
import java.util.List;

@Getter
@Setter
@NoArgsConstructor
@Entity
@Table(name = "address")
public class Address {

    @Id
    @NotNull
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "id", updatable = false, nullable = false)
    private int id;

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

    @NotNull
    @Column(name="house")
    private String house;

    @NotNull
    @Column(name="flat")
    private String flat;

    @NotNull
    @Column(name="code")
    private String code;

    @NotNull
    @Column(name="city")
    private String city;

    @ManyToOne(optional = false)
    @JoinColumn(name = "user_id",nullable = false,updatable = true,insertable = true)
    private User user;

}

我想创建用户-

{“street”：“Ulicanew”，“house”：“5”，“flat”：“2”，“code”：“20-001”，“city”：“warsaw”，“user_id”：1}

我的地址表中的用户id为空：

为什么地址表中的外键总是空的？你知道这是怎么回事吗？通过直接向db插入sql，一切正常

Answer 1

import java.util.List;
import java.util.Set;
import javax.persistence.*;
import javax.validation.constraints.Email;
import javax.validation.constraints.NotNull;
import org.hibernate.validator.constraints.Length; 

@Entity
@Table(name = "customer")
public class Customer {
     ...
     @Id
     @GeneratedValue(strategy = GenerationType.AUTO)
     @Column(name = "user_id")
     private int id;

     @OneToMany(mappedBy = "customer", cascade = CascadeType.ALL, fetch = FetchType.LAZY)
     private List<DatabaseTable> databaseTables;
     ...
}
...
...
import org.hibernate.validator.constraints.Length;
import javax.persistence.*;

@Entity
@Table(name = "databasetable")
public class DatabaseTable {
    ...
    @ManyToOne
    @JoinColumn(name = "user_idFK")
    private Customer customer;
    ....
}

这对我很有用。

Answer 2

尝试将以下更改添加到您的地址实体。

@JoinColumn(name = "user_id")
@ManyToOne(targetEntity = User.class, fetch = FetchType.LAZY)
private User user;

Answer 3

我将请求更改为：

    {
        "street": "dyr",
        "house": "5",
        "flat": "2",
        "code": "20-001",
        "city": "warsaw",
        "user": {
        	"id": 50
        }
    }