Spring Boot JPA中@ManyToOne与@OneToMany关联及查询问题求助

问题核心现象 #

• 添加带多辆Car的Owner时，Car表的owner_id字段为null
• 关联已有Owner添加Car时，Car的owner_id仍为null
• 查询Owner接口无响应（双向关联循环序列化导致）

问题原因分析 #

1. 实体字段与数据库列映射不匹配：字段名、大小写和@Column注解的name属性不一致，导致JSON参数无法正确绑定，关联关系无法维护
2. 双向关联未维护双方关系：仅设置Owner的Car列表，未给每个Car设置对应的Owner实例
3. 游离态实体未转换为持久态：添加Car时传入的Owner仅含id，属于游离态，JPA无法识别关联关系
4. 双向关联导致循环序列化：查询Owner时，JSON序列化递归遍历Owner和Car，引发栈溢出或无响应

修复步骤 #

1. 修正实体类映射与序列化问题 #

Car.java

@Entity
@Table(name="Car")
@Data
public class Car {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "car_id")
    private Long id;

    @Column(name = "car_name") // 修正列名与实体字段一致
    private String car_name;

    @Column(name = "model") // 实体字段名改为model，与列名匹配
    private String model;

    @Column(name = "firsty") // 修正列名与JSON参数一致
    private String firsty;

    @ManyToOne
    @JoinColumn(name="owner_id", referencedColumnName = "owner_id")
    @JsonBackReference // 避免循环序列化
    private Owner owner;
}

Owner.java

@Entity
@Table(name="Owner")
@Data
public class Owner {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    @Column(name = "owner_id", nullable = false)
    private Long id;

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

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

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

    @OneToMany(mappedBy = "owner", cascade = CascadeType.ALL, orphanRemoval = true)
    @JsonManagedReference // 配合@JsonBackReference解决循环序列化
    private List<Car> cars; // 字段名改为复数cars更规范

    // 手动维护双向关联关系
    public void addCar(Car car) {
        if (cars == null) {
            cars = new ArrayList<>();
        }
        cars.add(car);
        car.setOwner(this);
    }
}

2. 修正业务逻辑层（Service） #

OwnerService.addOwner 方法

@Service
public class OwnerService {

    @Autowired
    private OwnerRepository ownerRepository;

    public void addOwner(Owner owner) {
        // 给每辆Car绑定当前Owner，维护双向关联
        if (owner.getCars() != null && !owner.getCars().isEmpty()) {
            owner.getCars().forEach(car -> car.setOwner(owner));
        }
        ownerRepository.save(owner);
    }

    // 其他业务方法...
}

CarService.addCar 方法

@Service
public class CarService {

    @Autowired
    private CarRepository carRepository;

    @Autowired
    private OwnerRepository ownerRepository;

    public void addCar(Car car) {
        // 查询数据库中的持久态Owner，替换传入的游离态对象
        if (car.getOwner() != null && car.getOwner().getId() != null) {
            Owner persistentOwner = ownerRepository.findById(car.getOwner().getId())
                    .orElseThrow(() -> new RuntimeException("指定的Owner不存在"));
            car.setOwner(persistentOwner);
        }
        carRepository.save(car);
    }

    // 其他业务方法...
}

3. 调整JSON请求参数（匹配实体字段） #

添加Owner的JSON请求体

{
  "first_name": "John",
  "last_name": "Doe",
  "address": "123 Main Street",
  "cars": [
    {
      "car_name": "BMW",
      "model": "Model 3",
      "firsty": "2022"
    },
    {
      "car_name": "Mercedes",
      "model": "C-Class",
      "firsty": "2021"
    }
  ]
}

添加Car的JSON请求体

{
  "car_name": "Toyota",
  "model": "Camry",
  "firsty": "2023",
  "owner": {
    "id": 1
  }
}

4. 修复查询Owner无响应问题 #

通过在实体类添加@JsonManagedReference和@JsonBackReference，已解决双向关联的循环序列化问题，此时调用GET /Owner/{id}可正常返回包含关联Cars的Owner数据。

测试验证 #

1. 调用POST /Owner传入修正后的JSON，检查数据库中Owner和Car数据，Car的owner_id应正确关联Owner的id
2. 调用POST /Car传入修正后的JSON，检查Car的owner_id是否正确设置
3. 调用GET /Owner/{id}，验证返回的Owner对象包含关联的Cars列表

内容的提问来源于stack exchange，提问作者Cyclone