JAVA | JPA 自定义返回对象

应用场景应该不多，记录一下。

poHeader 订单头，poInfo 单身。

原生 SQL

@Query(value =
        "select poHeader.po_num as poNum, poHeader.id as poId, sum(poInfo.po_price) as total " +
        "from sc_po_header as poHeader " +
        "left join sc_po_info as poInfo on poHeader.id = poInfo.po_header_id " +
        "where poHeader.po_num in (?1) group by poHeader.po_num, poHeader.id", nativeQuery = true)
    List<Map<String, Object>> sumPoPriceByPoHeaderPoNums(Set<String> poNums);

结果：

  "poHeaderNoMap": [
    {
      "poId": 100093,
      "poNum": "20200729",
      "total": 1000.00
    },
    {
      "poId": 100095,
      "total": null,
      "poNum": "20200730"
    }
  ],

ps：因为现在业务可能有多个数据源的情况 sum null 不做处理

参考：

https://blog.csdn.net/ii19910410/article/details/89885328