我定义了以下自定义数据库查询。
@Query("select po.* from purchase_order po where po.purchase_order_number = :purchaseOrderNumber")
List<PurchaseOrder> findByPurchaseOrderNumber(String purchaseOrderNumber);
无论purchas的值如何,此查询始终返回null。另一方面,如果我将查询中的动态参数purchaseOrderNumber替换为硬编码的值(如下所示(,它将非常有效。
@Query("select po.* from purchase_order po where po.purchase_order_number = "10")
List<PurchaseOrder> findByPurchaseOrderNumber(String purchaseOrderNumber);
如果有人能帮助我理解为什么我的动态PurchaseOrderNumber查询不起作用,我将不胜感激?
指定查询参数的名称
@Query("select po.* from purchase_order po where po.purchase_order_number = :purchaseOrderNumber")
List<PurchaseOrder> findByPurchaseOrderNumber(@Param("purchaseOrderNumber") String purchaseOrderNumber);