JPA查询修改

CxToBj

于 2024-11-26 15:09:19 发布

阅读量116

点赞数 1

文章标签： java 前端开发语言

本文链接：https://blog.youkuaiyun.com/lang09/article/details/144059584

版权

 /** 根据点位id查询数据 */
    @Query(value = "SELECT it FROM IotPoint it WHERE  it.pointId = :#{#iotPointParam.pointId} ")
    IotPoint getObjectByid(@RequestParam("iotPointParam") IotPointParam iotPointParam);

  /** 根据多个字段查询数据 */
    @Transactional
    @Modifying(clearAutomatically = true)
    @Query(value = "UPDATE IotSubPoint isp SET isp.address = :#{#iotSubPoint.address}, isp.dataType = :#{#iotSubPoint.dataType} WHERE  isp.iotPointId = :#{#iotSubPoint.iotPointId}")
    int updataByPointId(@RequestParam("iotSubPoint") IotSubPoint iotSubPoint);