如何将列动态添加到 Spring Data JPA @Query

问题描述：

在 Spring Data JPA 接口上考虑以下方法:

Consider the following method on a Spring Data JPA interface:

@Query("select distinct :columnName from Item i")
List<Item> findByName(@Param("columnName") String columnName);

我想使用这种方法在同一实体上使用不同的列名动态执行查询.这怎么办?

I would like to use such a method for performing queries dynamically using different column names on the same entity. How can this be done?

答

您可以使用 Spring Data 中内置的 QueryDSL 支持.请参阅本教程开始吧.

You can use QueryDSL support built into Spring Data. See this tutorial to get started.