使用@Query 从 SPRING BOOT 中的文件中获取查询

2022-01-14 00:00:00 yaml spring oracle java

我有一个用于加载查询的项目:

I have a proyect that use to load queries this:

@Query(value = SELECT_BY_USER_ID, nativeQuery = true)
Employee findByUserId(@Param("userId") String userId);

在SELECT_BY_USER_ID"上是一个普通的字符串查询.

On "SELECT_BY_USER_ID" is a normal String query.

我在 jar 外有一个 YML 配置，我用它来加载不同的配置，我也想使用这个 YML 来加载查询.

I have a YML configuration outside jar, that I use to load differents configurations, and I want to use this YML, to load queries too.

示例 YML:

file:
    query1: SELECT * FROM DUAL;

但我不知道如何在@Query 值中直接从我的文件中加载，我试过这样:

But I don't know how to load directly from my file in @Query value, I tried like that:

@Query(value = ("${file.query1}"), nativeQuery = true)
List<Employee> findByCost();

我该怎么办?谢谢.

推荐答案

如果需要从resources文件夹加载SQL，可以试试spring-data-sqlfile 库.它支持从资源加载 SQL 查询.因此，您只需要将 SQL 查询放到资源文件夹中，然后就可以在 SqlFromResource 注释中引用它们:

If you need to load SQL from resources folder, you can try spring-data-sqlfile library. It supports loading SQL queries from resources. So you just need to put your SQL queries to the resources folder and than you can reference them in SqlFromResource annotation:

@Repository
public interface UserRepository extends JpaRepository<User, Integer> {
    @SqlFromResource(path = "select_user_by_id.sql")
    User findById(int userId);
}

输出会是这样的:

@Repository
public interface UserRepositoryGenerated extends JpaRepository<User, Integer> {    
  @Query(
      value = "SELECT *     FROM users     WHERE id = :userId",
      nativeQuery = true
  )
  User findById(int userId);
}

相关文章