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

最新推荐文章于 2022-11-12 21:11:29 发布

请告诉他

最新推荐文章于 2022-11-12 21:11:29 发布

阅读量4.6k

点赞数

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

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

版权

java 专栏收录该内容

56 篇文章 0 订阅

订阅专栏

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();