修改了sql语句，能同时返回站点名称和设备编号

zmc

2023-11-15 c47bac207b1f49d4cfe8cd98202a96865345a94f

修改了sql语句，能同时返回站点名称和设备编号

 src/main/java/com/flightfeather/monitor/mapper/FugitiveDustMapper.java

@@ -16,7 +16,7 @@
    @Select("select DISTINCT typename from ja_t_dust_site_info")
    List<DustSiteData> scenarioData();

    @Select("select DISTINCT name from ja_t_dust_site_info  ")
    @Select("select DISTINCT name,mn_code from ja_t_dust_site_info  ")
    List<DustSiteData> allSiteName();

    List<AnalysisDustData> analysisdata(String siteName, String beginTime, String endTime,String type);

 src/main/resources/application.yml

@@ -3,9 +3,9 @@
    ds1:
      driver-class-name: com.mysql.cj.jdbc.Driver
#      生产环境
      url: jdbc:mysql://localhost:3306/fume
      username: fume
      password: fume_feiyu2023
#      url: jdbc:mysql://localhost:3306/fume
#      username: fume
#      password: fume_feiyu2023

#      url: jdbc:mysql://localhost:3306/qianduan_sql
#      username: root
@@ -15,9 +15,9 @@
#      username: root
#      password: 123456

#      url: jdbc:mysql://114.215.109.124:3306/fume
#      username: fumeRemote
#      password: feiyu2023
      url: jdbc:mysql://114.215.109.124:3306/fume
      username: fumeRemote
      password: feiyu2023

mybatis:
  configuration: