我可以在 JpaRepository nativeQuery 中使用枚举参数吗? [英] Can I use enum parameter into JpaRepository nativeQuery?
问题描述
实体看起来像这样:
@Getter
@Setter
@Entity
public class Application {
@Id
private Long id;
@Enumerated(EnumType.STRING)
private ApplicationStatus status;
}
代码是这样工作的:
public interface ApplicationRepository extends JpaRepository<Application, Long> {
@Query("SELECT app FROM #{#entityName} AS app WHERE app.status LIKE :status")
List<Application> find(@Param("status") ApplicationStatus status);
但与 nativeQuery 相同的片段 - 没有:
But the same snippet with nativeQuery - doesn't:
@Query(value = "SELECT app.* FROM application AS app WHERE app.status LIKE :status", nativeQuery = true)
List<Application> findNative(@Param("status") ApplicationStatus status);
}
而且我没有任何异常,只是空列表.
And I don`t have any exception, just empty list.
我该如何解决这个问题?是否可以将 enum
与 nativeQuery
一起使用?
How can I fix this? Is it possible to use enum
with nativeQuery
?
P.S 我可以将 String
传递给方法而不是 ApplicationStatus
但也许还有另一种选择?
P.S I can pass String
into method instead of ApplicationStatus
but maybe there are another option?
推荐答案
Following similar question 和href="https://stackoverflow.com/a/54650103/906265">其中一个答案指向Spring 表达式语言 (SpEL) 您可以使用:
Following similar question with similar requirement and one of the answers pointing to Spring Expression Language (SpEL) you could use:
public interface ApplicationRepository extends JpaRepository<Application, Long> {
@Query(nativeQuery = true, value = "SELECT app FROM #{#entityName} AS app WHERE app.status=:#{#status.name()}")
List<Application> find(@Param("status") ApplicationStatus status);
}
以上重要部分是app.status=:#{#status.name()}
这篇关于我可以在 JpaRepository nativeQuery 中使用枚举参数吗?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!