From 7af11da07988e252a0e6d8aefef1c575aab3764a Mon Sep 17 00:00:00 2001
From: YYC <1833023622@qq.com>
Date: 星期四, 07 九月 2023 18:08:48 +0800
Subject: [PATCH] 上海同步数据---视频监控信息
---
src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java | 25 +++++++++++++++++++++++++
1 files changed, 25 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java b/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java
index fce7ebf..30d012d 100644
--- a/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java
+++ b/src/main/java/com/fzzy/api/view/repository/ApiInfoDataRep.java
@@ -3,8 +3,11 @@
import com.fzzy.api.entity.ApiInfoData;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
+import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
+import org.springframework.transaction.annotation.Transactional;
+
import java.util.List;
public interface ApiInfoDataRep extends JpaRepository<ApiInfoData, String>, JpaSpecificationExecutor<ApiInfoData> {
@@ -12,6 +15,7 @@
/**
* 鏍规嵁鏁版嵁鍐呭ID鏌ヨ鏁版嵁
+ *
* @param dataId
* @return
*/
@@ -20,10 +24,31 @@
/**
* 鏍规嵁鎺ュ彛缂栫爜鏌ヨ鏁版嵁
+ *
* @param inteId
* @return
*/
@Query("from ApiInfoData where inteId=:inteId ")
List<ApiInfoData> getDataByInteId(@Param("inteId") String inteId);
+ /**
+ * 鏍规嵁琛ㄥ崟涓婚敭鏇存柊鎿嶄綔鏍囧織鐘舵��
+ *
+ * @param id 涓婚敭ID
+ * @param czbz 鎿嶄綔鏍囧織
+ * @return
+ */
+ @Transactional
+ @Modifying
+ @Query(value = "update ApiInfoData set czbz=:czbz ,data=:data where id=:id ")
+ int updateStatus(@Param("id") String id, @Param("data") String data, @Param("czbz") String czbz);
+
+ /**
+ * 鏍规嵁鎺ュ彛缂栫爜鍜屾暟鎹唴瀹笽D鏌ヨ鏁版嵁
+ *
+ * @param inteId
+ * @return
+ */
+ @Query("from ApiInfoData where inteId=:inteId and dataId=:dataId ")
+ List<ApiInfoData> getDataByInteAndData(@Param("inteId") String inteId, @Param("dataId") String dataId);
}
\ No newline at end of file
--
Gitblit v1.9.3