新增了根据点位名称查询设备编号的接口

zmc

2023-11-23 a15f3dccec3c370f90005068350173768a5e222d

新增了根据点位名称查询设备编号的接口

 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: