如何使用 JPA 命名查询在查询参数中设置类似值

Question

我有一个 JPA 查询如下

 public interface MyRepository extends JpaRepository<User, String> {

  @Query(value = "select * from User where code like 'PER%'", 

  nativeQuery= true)

  public List<User> findAllUsers(String param);

 }

如何将“PER%”替换为 ?1

提前致谢。

Answer 1

public interface MyRepository extends JpaRepository<User, String> {&nbsp; @Query(value = "select * from User where code like CONCAT(:param,'%')",&nbsp;&nbsp; nativeQuery= true)&nbsp; public List<User> findAllUsers(@Param("param") String param);&nbsp;}

Answer 2

您可以将查询参数与索引?1 查询创建和Spring Data JPA一起使用@Query(value = "select * from User where code like ?1%", nativeQuery= true)public List<User> findAllUsers(String param);或者通过名称传递参数。@Query(value = "select * from User where code like :param%", nativeQuery= true)public List<User> findAllUsers(@Param("param")  String param);