From a836dc12b19f090a1f0e16504f5ea9f0c39cb96f Mon Sep 17 00:00:00 2001 From: YYC <1833023622@qq.com> Date: 星期六, 05 八月 2023 16:12:04 +0800 Subject: [PATCH] 基础信息页面 --- src/main/java/com/fzzy/api/view/repository/Api1202Rep.java | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java b/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java index 283f2b1..1a0442a 100644 --- a/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java +++ b/src/main/java/com/fzzy/api/view/repository/Api1202Rep.java @@ -2,6 +2,7 @@ import com.fzzy.api.entity.Api1202; +import com.fzzy.api.entity.Api1208; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.JpaSpecificationExecutor; import org.springframework.data.jpa.repository.Modifying; @@ -9,6 +10,8 @@ import org.springframework.data.repository.query.Param; import org.springframework.transaction.annotation.Transactional; +import javax.xml.crypto.Data; +import java.util.Date; import java.util.List; @@ -21,4 +24,10 @@ @Modifying @Query("update Api1202 set czbz =:czbz where rkywdh=:rkywdh") int updateStatus(@Param("rkywdh") String rkywdh, @Param("czbz") String czbz); + + @Query("from Api1202 where rkywdh=:rkywdh ") + List<Api1202> getDataById(@Param("rkywdh") String rkywdh); + + @Query("from Api1202 where cmsj>:start and cmsj<:end") + List<Api1202> getDataByTime(@Param("start") Date start, @Param("end") Date end); } -- Gitblit v1.9.3