From 48959b0b908dd57bf9dd991b75756ac2698f2b4d Mon Sep 17 00:00:00 2001 From: zmc <zmc_li@foxmail.com> Date: 星期四, 12 十月 2023 10:48:11 +0800 Subject: [PATCH] 修改了数据排名清单的sql语句 --- src/test/java/com/job/zsc/QianduanApplicationTests.java | 37 +++++++++++++++++++++++++++++++++++-- 1 files changed, 35 insertions(+), 2 deletions(-) diff --git a/src/test/java/com/job/zsc/QianduanApplicationTests.java b/src/test/java/com/job/zsc/QianduanApplicationTests.java index 44ed527..ea4cea2 100644 --- a/src/test/java/com/job/zsc/QianduanApplicationTests.java +++ b/src/test/java/com/job/zsc/QianduanApplicationTests.java @@ -1,12 +1,19 @@ package com.job.zsc; +import com.job.zsc.dustexceptionanalysis.analysis.Exceeding; +import com.job.zsc.dustexceptionanalysis.database.DustRepository; +import com.job.zsc.mapper.dustexception.OnlineAnalysisMapper; +import com.job.zsc.pojo.DustExceptionSetting; +import com.job.zsc.pojo.DustSiteData; import org.junit.jupiter.api.Test; +import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.test.context.SpringBootTest; +import java.sql.SQLOutput; import java.text.ParseException; import java.text.SimpleDateFormat; -import java.util.Date; -import java.util.Locale; +import java.util.*; + @SpringBootTest class QianduanApplicationTests { @@ -28,5 +35,31 @@ //return df2.format(date1); } + @Autowired + private DustRepository dustRepository; + @Test + void readSiteData(){ +// DustExceptionSetting dustExceptionSetting = DustExceptionSetting.getInstance(); +// 璇诲彇寮傚父鍒嗘瀽鍒ゅ畾鐨勯厤缃� + List<DustExceptionSetting> list= dustRepository.readExceptionSetting(); + System.out.println("11111"); + + System.out.println(list.size()); + System.out.println(list.get(0)); + + +// List<DustSiteData> dustData = dustRepository.getDustData("2023-10-01 00:00:00","2023-10-01 01:00:00"); +//// System.out.println(dustData.get(0).getMnCode()); +// int a = Exceeding.main(dustData); +// System.out.println(a); + + + } + + +// @Test +// void exceeding(){ +// +// } } -- Gitblit v1.9.3