Spring Boot 3中实体类能否作为原生查询的Repository方法参数？

在Spring Boot 2.7中，我可以直接将实体类作为CrudRepository原生查询的参数，框架会自动提取实体的ID值传入查询（若实体为null则传入null）。但升级到Spring Boot 3后该方式失效，报错如下：

Could not resolve NativeQuery parameter type : `org.hibernate.query.internal.QueryParameterNamedImpl@aaba12d3`

原代码示例 #

Repository定义：

@Repository
interface DataValueRepository extends CrudRepository<DataValue, Long> {

    @Query(value="""
        select .......
        from data_value dv
        where
            (:neighborhood is null or neighborhood_id = :neighborhood) and
            (:property is null or property_id = :property) and
            (:building is null or building_id = :building) and
            (:household is null or household_id = :household) and
            datetime_local >= :dateLocalFrom and
            datetime_local < :dateLocalToExclusive and
            type in (:types) and
            level = :level
        """, nativeQuery = true)
    List<Object[]> getAggregatedDataValuesWithoutTime(Neighborhood neighborhood, Property property, Building building, Household household, List<String> types, String level, LocalDate dateLocalFrom, LocalDate dateLocalToExclusive);

}

调用方式（Spring Boot 2.7有效）：

dataValueRepository.getAggregatedDataValuesWithoutTime(neighborhood, property, building, household, dataValueTypes.stream().map(DataValueType::name).toList(), level.name(), dateLocalFrom, dateLocalToExclusive);

目前我通过将Repository参数改为Integer/Long类型、手动处理null并传入ID的方式解决了问题，但大量的null判断过于繁琐，想知道Spring Boot 3中是否有更优雅的替代方案。

可行解决方案 #

1. 使用SpEL表达式提取实体ID

在Repository方法参数上添加@Param注解，并在原生查询中通过SpEL表达式#{#参数名?.id}获取实体ID，框架会自动处理null情况（实体为null时表达式返回null）。

修改后的Repository代码：

@Repository
interface DataValueRepository extends CrudRepository<DataValue, Long> {

    @Query(value="""
        select .......
        from data_value dv
        where
            (:neighborhood is null or neighborhood_id = :#{#neighborhood?.id}) and
            (:property is null or property_id = :#{#property?.id}) and
            (:building is null or building_id = :#{#building?.id}) and
            (:household is null or household_id = :#{#household?.id}) and
            datetime_local >= :dateLocalFrom and
            datetime_local < :dateLocalToExclusive and
            type in (:types) and
            level = :level
        """, nativeQuery = true)
    List<Object[]> getAggregatedDataValuesWithoutTime(
            @Param("neighborhood") Neighborhood neighborhood,
            @Param("property") Property property,
            @Param("building") Building building,
            @Param("household") Household household,
            @Param("types") List<String> types,
            @Param("level") String level,
            @Param("dateLocalFrom") LocalDate dateLocalFrom,
            @Param("dateLocalToExclusive") LocalDate dateLocalToExclusive);

}

调用方式和之前完全一致，无需手动处理null，框架会自动解析实体ID。

2. 全局实体转ID转换器

如果多个Repository都需要类似转换，可以实现Converter接口，注册为Spring Bean，让框架自动将实体类转换为对应的ID类型。

示例转换器：

@Component
public class NeighborhoodToIdConverter implements Converter<Neighborhood, Long> {
    @Override
    public Long convert(Neighborhood source) {
        return source != null ? source.getId() : null;
    }
}

同理可以为Property、Building、Household分别实现转换器。注册后，原生查询中直接传入实体类参数即可，框架会自动调用转换器获取ID，null时返回null。

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