From a15f3dccec3c370f90005068350173768a5e222d Mon Sep 17 00:00:00 2001
From: zmc <zmc_li@foxmail.com>
Date: 星期四, 23 十一月 2023 16:07:53 +0800
Subject: [PATCH] 新增了根据点位名称查询设备编号的接口
---
src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java | 2 ++
src/main/java/com/flightfeather/monitor/service/impl/DustSiteInfoServiceImpl.java | 10 ++++++++++
src/main/java/com/flightfeather/monitor/controller/dust/DustSiteInfoController.java | 9 +++++++++
src/main/resources/application.yml | 12 ++++++------
src/main/java/com/flightfeather/monitor/service/DustSiteInfoService.java | 2 ++
5 files changed, 29 insertions(+), 6 deletions(-)
diff --git a/src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java b/src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java
index 5a63bf0..545c595 100644
--- a/src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java
+++ b/src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java
@@ -190,4 +190,6 @@
}
+
+
}
diff --git a/src/main/java/com/flightfeather/monitor/controller/dust/DustSiteInfoController.java b/src/main/java/com/flightfeather/monitor/controller/dust/DustSiteInfoController.java
index 59320a0..9f0b2a4 100644
--- a/src/main/java/com/flightfeather/monitor/controller/dust/DustSiteInfoController.java
+++ b/src/main/java/com/flightfeather/monitor/controller/dust/DustSiteInfoController.java
@@ -56,4 +56,13 @@
List<DustSiteInfo> list = dustSiteInfoService.queryStreet(street);
return Result.success(list);
}
+
+ /*鏍规嵁鐐逛綅鍚嶅瓧鏌ヨ瀵瑰簲鐨勮澶囩紪鍙�*/
+ @GetMapping("/mncode")
+ public Result queryMncodeBySiteName(String siteName) {
+
+ List<DustSiteInfo> list = dustSiteInfoService.queryMncodeBySiteName(siteName);
+ return Result.success(list);
+ }
+
}
diff --git a/src/main/java/com/flightfeather/monitor/service/DustSiteInfoService.java b/src/main/java/com/flightfeather/monitor/service/DustSiteInfoService.java
index ba4acec..34c22d5 100644
--- a/src/main/java/com/flightfeather/monitor/service/DustSiteInfoService.java
+++ b/src/main/java/com/flightfeather/monitor/service/DustSiteInfoService.java
@@ -16,4 +16,6 @@
List<DustSiteInfo> queryAllDutyCompany();
List<DustSiteInfo> queryStreet(String street);
+
+ List<DustSiteInfo> queryMncodeBySiteName(String siteName);
}
diff --git a/src/main/java/com/flightfeather/monitor/service/impl/DustSiteInfoServiceImpl.java b/src/main/java/com/flightfeather/monitor/service/impl/DustSiteInfoServiceImpl.java
index 4025c5e..b2d3e82 100644
--- a/src/main/java/com/flightfeather/monitor/service/impl/DustSiteInfoServiceImpl.java
+++ b/src/main/java/com/flightfeather/monitor/service/impl/DustSiteInfoServiceImpl.java
@@ -42,4 +42,14 @@
return list;
}
+ @Override
+ public List<DustSiteInfo> queryMncodeBySiteName(String siteName) {
+ Example example = new Example(DustSiteInfo.class);
+ example.createCriteria().andEqualTo("name",siteName);
+ List<DustSiteInfo> list = dustSiteInfoMapper.selectByExample(example);
+ return list;
+ }
+
+
+
}
diff --git a/src/main/resources/application.yml b/src/main/resources/application.yml
index 4ffadab..358ae74 100644
--- a/src/main/resources/application.yml
+++ b/src/main/resources/application.yml
@@ -3,9 +3,9 @@
ds1:
driver-class-name: com.mysql.cj.jdbc.Driver
# 鐢熶骇鐜
-# url: jdbc:mysql://localhost:3306/fume?serverTimezone=Asia/Shanghai&prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&allowMultiQueries=true&useSSL=false
-# username: fume
-# password: fume_feiyu2023
+ url: jdbc:mysql://localhost:3306/fume?serverTimezone=Asia/Shanghai&prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&allowMultiQueries=true&useSSL=false
+ username: fume
+ password: fume_feiyu2023
# url: jdbc:mysql://localhost:3306/qianduan_sql?serverTimezone=Asia/Shanghai&prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&allowMultiQueries=true&useSSL=false
# username: root
@@ -15,9 +15,9 @@
# username: root
# password: 123456
- url: jdbc:mysql://114.215.109.124:3306/fume?serverTimezone=Asia/Shanghai&prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&allowMultiQueries=true&useSSL=false
- username: fumeRemote
- password: feiyu2023
+# url: jdbc:mysql://114.215.109.124:3306/fume?serverTimezone=Asia/Shanghai&prepStmtCacheSize=517&cachePrepStmts=true&autoReconnect=true&allowMultiQueries=true&useSSL=false
+# username: fumeRemote
+# password: feiyu2023
mybatis:
configuration:
--
Gitblit v1.9.3