From d95f78488e734c1defcad4af8b7e79c712937111 Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期二, 15 八月 2023 16:00:26 +0800
Subject: [PATCH] 多表联查改为用join on
---
src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java | 10 ++++------
1 files changed, 4 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java b/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java
index 74826e9..f42960a 100644
--- a/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java
+++ b/src/main/java/com/job/zsc/mapper/Vue3FumeMapper.java
@@ -16,8 +16,7 @@
//涓ゅ紶琛ㄨ仈鍚堟煡璇�
@Select("select a.MV_ID,a.MV_Stat_Code,b.DI_Name,a.MV_Create_Time,a.MV_Data_Time,a.MV_Fume_Concentration2\n" +
- "from fd_t_minutevalue as a ,ea_t_device_info as b\n" +
- "where a.MV_Stat_Code = b.DI_Code ")
+ "from fd_t_minutevalue as a join ea_t_device_info as b on a.MV_Stat_Code = b.DI_Code ")
List<FumeHistoryData> findall();
List<FumeHistoryData> conditionQuery(String devId, String beginTime, String endTime);
@@ -31,8 +30,7 @@
List<DeviceInfo> allDeviceInfo();
@Select("select a1.dev_id,b.DI_Name,a1.exception,a1.exception_type,a1.region,a1.begin_time,a1.end_time\n" +
- "from abnormal_data as a1,ea_t_device_info as b\n" +
- "where a1.dev_id = b.DI_Code")
+ "from abnormal_data as a1 join ea_t_device_info as b on a1.dev_id = b.DI_Code\n")
List<FumeAbnormalData> allAbnormalData();
List<FumeAbnormalData> conditonQueryAbnormalData(String devId, String beginTime, String endTime);
@@ -41,8 +39,8 @@
//杩斿洖璇ュ紓甯哥被鍨嬪搴旂殑搴楅摵鍚嶅拰璁惧缂栧彿
@Select("select DISTINCT b1.DI_Name,a1.dev_id\n" +
- "from abnormal_data as a1,ea_t_device_info as b1\n" +
- "where a1.dev_id = b1.DI_Code and a1.exception_type = #{exceptionType} ")
+ "from abnormal_data as a1 join ea_t_device_info as b1 on a1.dev_id = b1.DI_Code\n" +
+ "where a1.exception_type = #{exceptionType}")
List<FumeAbnormalData> findShopName(String exceptionType);
List<FumeHistoryData> exportByShopName(@Param("a") String[] shops, String exportBeginTime, String exportEndTime);
--
Gitblit v1.9.3