src/main/java/com/flightfeather/monitor/controller/FugitiveDustController.java
@@ -190,4 +190,6 @@ } } 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); } } 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); } 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; } } 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: