Spring JPA+Thymeleaf：带EmbeddedId的一对多表单绑定异常

我做了一个支持多选的Thymeleaf表单，尝试将多选字段映射到带EmbeddedId的JPA实体时，持续出现类型转换错误：

default message [Failed to convert property value of type 'java.lang.String' to required type 'java.util.List' for property 'equipmentExerciseList'; nested exception is java.lang.IllegalStateException: Cannot convert value of type 'java.lang.String' to required type 'myproject.model.EquipmentExercise' for property 'equipmentExerciseList[0]': no matching editors or conversion strategy found

我的需求是插入新的Exercise实体，关联数据库中已存在的多个Equipment，通过中间表EquipmentExercise维护一对多/多对一关联。涉及的实体包括Exercise、带EmbeddedId的EquipmentExercise、EquipmentExerciseId、Equipment四类。

试过两种表单绑定方案：先通过Equipment列表填充下拉框，后改用EquipmentExercise对象，但均触发类似错误。确认问题源于复合ID，尝试自定义转换器后仅能生成Exercise对象，EquipmentExercise的其他字段未正确映射，求完整解决方案。

实体代码 #

Exercise.java #

@Data
@Entity
@Table(name = "Exercise")
@NoArgsConstructor
@AllArgsConstructor
@EqualsAndHashCode
public class Exercise implements Serializable {

    @Id
    @Column(name = "exercise_name")
    private String exerciseName;

    // 其他字段省略  

    @OneToMany(mappedBy = "exercise")
    private List<EquipmentExercise> equipmentExerciseList; 
}

EquipmentExercise.java #

@Getter
@Setter
@Entity
@Table(name = "EquipmentExercise")
@ToString
public class EquipmentExercise implements Serializable {

    @EmbeddedId
    EquipmentExerciseId equipmentExerciseId;

    @ManyToOne
    @MapsId("exerciseName")
    @JoinColumn(name = "exercise_name")
    Exercise exercise;

    @ManyToOne
    @MapsId("equipmentName")
    @JoinColumn(name = "equipment_name")
    Equipment equipment;

}

EquipmentExerciseId.java #

@Embeddable
@Getter
@Setter
@EqualsAndHashCode
@ToString
public class EquipmentExerciseId implements Serializable {
    
    @Column(name = "equipment_name")
    String equipmentName;

    @Column(name = "exercise_name")
    String exercise_name;
}

Equipment.java #

@Entity
@Table(name = "Equipment")
@Getter
@Setter
@EqualsAndHashCode
public class Equipment {
    
    @Id
    @Column(name = "equipment_name")
    String equipmentName;

    @OneToMany(mappedBy = "equipment", cascade = CascadeType.ALL)
    private List<EquipmentExercise> equipmentExerciseList;

}

已尝试的方案（仅保留自定义转换器） #

@Override
public EquipmentExercise convert(String equipmentName){
    
    EquipmentExercise equipmentExercise = new EquipmentExercise();
    EquipmentExerciseId equipmentExerciseId = new EquipmentExerciseId();
    equipmentExerciseId.setEquipmentName(equipmentName);
    equipmentExercise.setEquipmentExerciseId(equipmentExerciseId);
       
    return equipmentExercise;
}

1. 调整表单绑定逻辑 #

Thymeleaf表单的多选框直接提交已存在Equipment的equipmentName字符串列表，而非试图直接绑定EquipmentExercise对象。示例代码：

<form th:object="${exercise}" method="post">
    <!-- Exercise基础字段 -->
    <input type="text" th:field="*{exerciseName}" placeholder="运动名称"/>
    
    <!-- 多选设备下拉框 -->
    <select multiple="multiple" th:field="*{selectedEquipmentNames}">
        <option th:each="eq : ${allEquipments}" th:value="${eq.equipmentName}" th:text="${eq.equipmentName}"></option>
    </select>
    
    <button type="submit">提交</button>
</form>

同时在Exercise实体（或单独创建表单DTO）中添加临时字段接收多选值：

// 在Exercise类中添加，标记为非持久化字段
@Transient
private List<String> selectedEquipmentNames;

// 生成对应的getter和setter方法

2. 在Controller层手动构建关联关系 #

由于EquipmentExercise的复合ID需要新保存的Exercise的exerciseName，而SpringMVC转换时无法自动填充该值，因此在Controller中完成关联构建：

@PostMapping("/exercise")
public String saveExercise(@ModelAttribute Exercise exercise, 
                           @Autowired EquipmentRepository equipmentRepo,
                           @Autowired ExerciseRepository exerciseRepo,
                           @Autowired EquipmentExerciseRepository eeRepo) {
    // 1. 先保存Exercise实体，获取其exerciseName
    exerciseRepo.save(exercise);
    
    // 2. 遍历选中的设备名称，构建中间表实体
    for (String eqName : exercise.getSelectedEquipmentNames()) {
        // 从数据库查询已存在的Equipment
        Equipment equipment = equipmentRepo.findById(eqName)
                .orElseThrow(() -> new RuntimeException("指定设备不存在"));
        
        // 构建复合ID
        EquipmentExerciseId eeId = new EquipmentExerciseId();
        eeId.setEquipmentName(eqName);
        eeId.setExercise_name(exercise.getExerciseName());
        
        // 构建EquipmentExercise并设置关联
        EquipmentExercise ee = new EquipmentExercise();
        ee.setEquipmentExerciseId(eeId);
        ee.setExercise(exercise);
        ee.setEquipment(equipment);
        
        // 保存中间表记录
        eeRepo.save(ee);
    }
    
    return "redirect:/exercises";
}

3. 优化实体关联配置 #

为避免后续操作异常，给EquipmentExercise的关联字段添加必要配置：

// EquipmentExercise类中修改关联注解
@ManyToOne(fetch = FetchType.LAZY)
@MapsId("exerciseName")
@JoinColumn(name = "exercise_name", nullable = false)
Exercise exercise;

@ManyToOne(fetch = FetchType.LAZY)
@MapsId("equipmentName")
@JoinColumn(name = "equipment_name", nullable = false)
Equipment equipment;

问题根源说明 #

之前的自定义转换器仅填充了equipmentName，但复合ID中的exercise_name为空——该值必须与新保存的Exercise的exerciseName一致，而SpringMVC在转换阶段还未保存Exercise，无法自动填充该值，因此必须在Controller层手动处理关联构建。

内容的提问来源于stack exchange，提问作者stretch-a-lot