主页 / 问题 / 1318259
Accepted
Дядя Фёдор
Asked:2022-08-17 03:18:51 +0000 UTC2022-08-17 03:18:51 +0000 UTC

从两个表中查询 Spring 原生查询

  • 772

查询本身可以从控制台运行并给出正确的结果，但是一旦我将此查询复制到 @Query 注释中，它就会停止理解变量，无论我如何编写它们（即使通过完整路径）

@Query (value = "select  new  analytics77j.analytics77j.dto.IncomingRequestByUtmDTO (name, whatsapp, utm_source)" +
        "from client\n" +
        "inner join incoming_request\n" +
        "on client.id = incoming_request.client_id;")

有效的查询

select analytics.public.client.name, analytics.public.client.whatsapp, analytics.public.incoming_request.utm_source
from client
inner join incoming_request
on client.id = incoming_request.client_id;

错误

在此处输入图像描述

java

1 个回答

  1. Best Answer

    变量必须用冒号指定

    @Query (value = "select  new  analytics77j.analytics77j.dto.IncomingRequestByUtmDTO (:name, :whatsapp, :utm_source) " +
            "from client " +
            "inner join incoming_request " +
            "on client.id = incoming_request.client_id")
    • 2

相关问题