From 4e318439d8f5c8020c6cf25afb55b3a4e98de40e Mon Sep 17 00:00:00 2001
From: jinpengyong <jpy123456>
Date: Thu, 27 Aug 2020 13:55:50 +0800
Subject: [PATCH] update
---
src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java | 8 ++++----
src/main/resources/mapper/RealWeatherMapper.xml | 2 +-
2 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java b/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java
index 4bbbbfa..db4c25a 100644
--- a/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java
+++ b/src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java
@@ -233,13 +233,13 @@
String nextDayTemp = dataMap.get("temp").toString();
String nextDayCloud = dataMap.get("cloud").toString();
Integer condition = Integer.valueOf(dataMap.get("condition").toString());
- String value="";
+ Integer value=0;
if (condition >= 80) {
- value = "80";
+ value = 80;
} else if (condition >= 40) {
- value = "40";
+ value = 40;
} else if (condition >= 0) {
- value = "0";
+ value = 0;
}
map.put("condition", value);
List<Map<String, Object>> tempAndCloudList = realWeatherMapper.getTempAndCloud(map);
diff --git a/src/main/resources/mapper/RealWeatherMapper.xml b/src/main/resources/mapper/RealWeatherMapper.xml
index b4ee00e..ad5777a 100644
--- a/src/main/resources/mapper/RealWeatherMapper.xml
+++ b/src/main/resources/mapper/RealWeatherMapper.xml
@@ -22,6 +22,6 @@
and time >= #{startTime}
AND time <![CDATA[<]]> #{endTime}
and DATE_FORMAT(time,'%H:%i:%s')=#{time}
- and json->'$.condition'>=#{condition}
+ and cast(json->'$.condition' as UNSIGNED INTEGER)>=#{condition}
</select>
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0