用Spring DATA JPA创建自定义查询？

Question

我正在用Spring Data JPA做一个项目。我在数据库中有一个表为my_query。

我想创建一个以字符串作为参数的方法，然后将其作为数据库中的查询执行。

executeMyQuery(queryString)

queryString= "SELECT * FROM my_query"

public interface MyQueryRepository extends JpaRepository<MyQuery, Long>{
    public MyQuery findById(long id);

    @Modifying(clearAutomatically = true)
    @Transactional
    @Query(value = "?1", nativeQuery = true)
    public void executeMyQuery(String query);

}

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''select * from my_query;'' at line 1

Answer 1

其中唯一可以参数化的部分是WHERE子句中使用的值。请考虑官方文档中的以下示例：

public interface UserRepository extends JpaRepository<User, Long> {
  @Query(value = "SELECT * FROM USERS WHERE EMAIL_ADDRESS = ?1", nativeQuery = true)
  User findByEmailAddress(String emailAddress);
}