列名作为 Spring Data JPA Query 的参数

2022-01-18 00:00:00 java spring-boot spring-data spring-data-jpa

有没有办法将实体属性动态注入到@Query?我的需要是实现如下方法:

Is there a way to inject an Entity property dynamically to @Query? My need is to implement a method like follows:

@Query("select e from #{#entityName} e where e.***columnName*** = ?2")
List<T> findAll(String ***columnName***, String value);

还有其他简单的方法吗?

Any other simple ways of doing this?

推荐答案

你可以使用 Spring Specification 来实现.

You can do it using Spring Specification.

您的规范方法将类似于以下一种:

Your specification method will be similar to the following one:

public static Specification<Entity> byColumnNameAndValue(String columnName, String value) {
    return new Specification<Entity>() {
        @Override
        public Predicate toPredicate(Root<Entity> root,
                CriteriaQuery<?> query, CriteriaBuilder builder) {
            return builder.equal(root.<String>get(columnName), value);
        }
    };
}

请阅读一下规范，这是一个很棒的工具.

Please read a little about Specification, it's a great tool.

https://spring.io/blog/2011/04/26/advanced-spring-data-jpa-specifications-and-querydsl/

和

http://docs.spring.io/spring-data/jpa/docs/current/api/org/springframework/data/jpa/domain/Specifications.html

相关文章