springboot jpa自定义原生sql 接收SELECT count(*) 的返回long类型结果

万事功到自然成 2020-12-06 01:26:24

104

分类专栏： java 文章标签： java spring boot jpa

最后发布:2020-12-06 01:26:24首次发布:2020-12-06 01:26:24

本文链接：https://blog.csdn.net/fly19920602/article/details/110729484

版权

Long total = null;
Object singleResult=null;
try {
   String sqlStr = "SELECT count(*) from order_product op, `order` o WHERE  op.PRODUCT_UUID =:PRODUCTUUID and o.ORDER_UUID = op.ORDER_UUID and ( (:STARTINGTIME between o.STARTING_TIME and o.ENDING_TIME ) or ( :ENDINGTIME between o.STARTING_TIME and o.ENDING_TIME ) ) and o.IS_DELETED=:isDeleted ";
    singleResult = em.createNativeQuery(sqlStr)
         .setParameter("STARTINGTIME", startingTime)
         .setParameter("ENDINGTIME", endingTime)
         .setParameter("PRODUCTUUID", productUUid)
         .setParameter("isDeleted", Boolean.FALSE)
         .getSingleResult();
      total=Long.parseLong(singleResult.toString());

} catch (NoResultException e) {
   logger.info("No record found");
}
return total == null ? 0 : total.intValue();