Spring JPA查询结果转CarDto失败：无可用转换器问题求助

首先先修正你代码里的两个小问题，避免额外报错：

• Repository中@Param("identification ")的参数名多了末尾空格，改为@Param("identification")
• 查询语句中cr_1.subComponentIdentification是笔误，应该是cr_1.subCarIdentification（对应CarRelationEntity的字段）

下面是几种可行的转换方案：

方案1：JPQL构造函数直接实例化CarDto #

这是最直接的方式，通过JPQL的new关键字调用CarDto的全参构造函数，要求查询字段的顺序和构造函数参数顺序完全一致，且必须指定CarDto的完整类路径。

修改后的Repository代码：

@Repository
public interface JpaCarRepository extends JpaRepository<CarEntity, String>
{
   @Query("""
         SELECT new path.to.object.CarDto(
            c.identification, c.attribute_2, c.attribute_3, c.attribute_4,
            c.attribute_5, c.attribute_6, cr.subCarIdentification, cr_1.carIdentification
         )
         FROM Car c 
         LEFT OUTER JOIN CarRelation cr ON cr.carIdentification = c.identification 
         LEFT OUTER JOIN CarRelation cr_1 ON c.identification = cr_1.subCarIdentification
         WHERE c.identification = :identification
    """)
   Optional<CarDto> findByIdentification(@Param("identification") String identification);
}

注意：你的CarDto使用了@RequiredArgsConstructor且所有字段都是final，会自动生成全参构造函数，刚好匹配查询返回的字段顺序，无需额外修改CarDto。

方案2：手动转换（灵活适配复杂场景） #

如果查询逻辑复杂，或者需要对字段做额外处理，可以先返回Tuple，再在业务层手动映射为CarDto。

修改Repository方法 #

@Repository
public interface JpaCarRepository extends JpaRepository<CarEntity, String>
{
   @Query("""
         SELECT        c.identification, c.attribute_2, c.attribute_3, c.attribute_4,
            c.attribute_5, c.attribute_6, cr.subCarIdentification, cr_1.carIdentification
         FROM            Car c LEFT OUTER JOIN
                                  CarRelation cr ON cr.carIdentification = c.identification LEFT OUTER JOIN
                                  CarRelation cr_1 ON c.identification = cr_1.subCarIdentification
         WHERE        c.identification = :identification
    """)
   Optional<Tuple> findCarTupleByIdentification(@Param("identification") String identification);
}

业务层转换示例 #

@Service
public class CarService {
    private final JpaCarRepository carRepository;

    public CarService(JpaCarRepository carRepository) {
        this.carRepository = carRepository;
    }

    public Optional<CarDto> getCarDtoById(String id) {
        return carRepository.findCarTupleByIdentification(id)
                .map(tuple -> CarDto.builder()
                        .identification(tuple.get(0, String.class))
                        .attribute_2(tuple.get(1, String.class))
                        .attribute_3(tuple.get(2, String.class))
                        .attribute_4(tuple.get(3, String.class))
                        .attribute_5(tuple.get(4, String.class))
                        .attribute_6(tuple.get(5, String.class))
                        .childCarIdentification(tuple.get(6, String.class))
                        .parentCarIdentification(tuple.get(7, String.class))
                        .build());
    }
}

方案3：使用Spring Data Projection（投影接口） #

定义一个和CarDto字段匹配的投影接口，Spring JPA会自动生成代理类实现映射：

定义投影接口 #

public interface CarProjection {
    String getIdentification();
    String getAttribute_2();
    String getAttribute_3();
    String getAttribute_4();
    String getAttribute_5();
    String getAttribute_6();
    String getChildCarIdentification();
    String getParentCarIdentification();
}

修改Repository方法 #

@Repository
public interface JpaCarRepository extends JpaRepository<CarEntity, String>
{
   @Query("""
         SELECT        c.identification, c.attribute_2, c.attribute_3, c.attribute_4,
            c.attribute_5, c.attribute_6, cr.subCarIdentification AS childCarIdentification, cr_1.carIdentification AS parentCarIdentification
         FROM            Car c LEFT OUTER JOIN
                                  CarRelation cr ON cr.carIdentification = c.identification LEFT OUTER JOIN
                                  CarRelation cr_1 ON c.identification = cr_1.subCarIdentification
         WHERE        c.identification = :identification
    """)
   Optional<CarProjection> findByIdentification(@Param("identification") String identification);
}

之后可以在业务层把CarProjection转换为CarDto，或者直接使用投影接口。

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