根据算法预测明天O3,插入数据库

jinpengyong

2020-08-13 c75b4210328b98913de7eeef507e6d88069bcecc

根据算法预测明天O3,插入数据库

 src/main/java/com/moral/mapper/AQIMapper.java

@@ -4,7 +4,11 @@
import java.util.Map;

public interface AQIMapper {

    List<Map<String, Object>> getCityAqiConfig();

    int insertAQIData(Map<String, Object> parameters);

    List<Map<String,Object>> getO3(Map<String,Object> params);

}

 src/main/java/com/moral/mapper/RealWeatherMapper.java

@@ -6,4 +6,6 @@
public interface RealWeatherMapper {

    int insertRealWeather(List<Map<String,Object>> list);

    List<Map<String,Object>> getTemp(Map<String,Object> params);
}

 src/main/java/com/moral/service/impl/ForecastWeatherServiceImpl.java

@@ -17,17 +17,17 @@
import org.springframework.stereotype.Service;
import org.springframework.web.client.RestTemplate;

import com.alibaba.fastjson.JSON;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.moral.entity.Area;
import com.moral.entity.City;
import com.moral.entity.MonitorPoint;
import com.moral.mapper.AQIMapper;
import com.moral.mapper.AreaMapper;
import com.moral.mapper.CityMapper;
import com.moral.mapper.ForecastWeatherMapper;
import com.moral.mapper.MonitorPointMapper;
import com.moral.mapper.ProvinceMapper;
import com.moral.mapper.RealWeatherMapper;
import com.moral.service.ForecastWeatherService;
import com.moral.util.Dom4jUtils;

@@ -48,6 +48,12 @@

    @Resource
    private ProvinceMapper provinceMapper;

    @Resource
    private RealWeatherMapper realWeatherMapper;

    @Resource
    private AQIMapper aqiMapper;

    @Override
    public int insertForecastWeather() throws ParseException {
@@ -71,32 +77,32 @@
            Integer provinceCode = monitorPoint.getProvinceCode();
            String parentName = "";
            String name1 = "";
            Integer code=0;
            Integer code = 0;
            if (areaCode != null) {
                Area area = areaMapper.getAreaByAreaCode(areaCode);
                City city = cityMapper.getCityByCityCode(cityCode);
                name1 = area.getAreaName();
                parentName = city.getCityName();
                code=areaCode;
                code = areaCode;
                if ("市辖区".equals(name1)) {
                    name1 = parentName;
                    parentName = provinceMapper.getProvinceByProvinceCode(provinceCode).getProvinceName();
                    code=cityCode;
                    code = cityCode;
                }
            } else {
                City city = cityMapper.getCityByCityCode(cityCode);
                name1 = city.getCityName();
                parentName = provinceMapper.getProvinceByProvinceCode(provinceCode).getProvinceName();
                code=cityCode;
                code = cityCode;
                if ("市辖区".equals(name1)) {
                    name1 = parentName;
                    parentName = "";
                    code=provinceCode;
                    code = provinceCode;
                }
            }
            hashMap.put("name1", name1);
            hashMap.put("parentName", parentName);
            hashMap.put("cityCode",code);
            hashMap.put("cityCode", code);
            hashSet.add(hashMap);
        }
        List<Element> elements = Dom4jUtils.readDocument();
@@ -124,7 +130,91 @@
            }
        }

        int count=0;
        c.setTime(new Date());
        Date endTime = sdf.parse(sdf.format(c.getTime()));
        c.add(Calendar.MONTH, -2);
        Date startTime = sdf.parse(sdf.format(c.getTime()));

        for (Map<String, Object> hashmap : hashSet) {
            hashmap.put("typeFormat", "%Y-%m-%d %H:%i:%s");
            hashmap.put("startTime", startTime);
            hashmap.put("endTime", endTime);
            List<List<Map<String, Object>>> list1 = new ArrayList<>();
            List<List<Map<String, Object>>> list2 = new ArrayList<>();

            for (int i = 0; i < 24; i++) {
                List<Map<String, Object>> list3 = new ArrayList<>();
                List<Map<String, Object>> list4 = new ArrayList<>();
                if (i < 10) {
                    hashmap.put("time", "0" + i + ":00:00");
                } else {
                    hashmap.put("time", i + ":00:00");
                }
                List<Map<String, Object>> tempList = realWeatherMapper.getTemp(hashmap);
                List<Map<String, Object>> O3List = aqiMapper.getO3(hashmap);
                list3.addAll(tempList);
                list4.addAll(O3List);
                list1.add(list3);
                list2.add(list4);
            }

            List<List<Map<String, Object>>> list = new ArrayList<>();
            if (list2.get(0).size() == 0) {
                list = list1;
            } else {
                for (List<Map<String, Object>> tempList : list1) {
                    List<Map<String, Object>> list3 = new ArrayList<>();
                    for (List<Map<String, Object>> O3List : list2) {
                        for (Map<String, Object> tempMap : tempList) {
                            for (Map<String, Object> O3Map : O3List) {
                                if (O3Map.get("O3") != null) {
                                    if (tempMap.get("time").equals(O3Map.get("time"))) {
                                        Map<String, Object> map = new HashMap<>();
                                        map.put("time", tempMap.get("time"));
                                        map.put("temp", tempMap.get("temp").toString());
                                        map.put("O3", O3Map.get("O3").toString());
                                        list3.add(map);
                                    }
                                }
                            }
                        }
                    }
                    list.add(list3);
                }
            }

            if (list.get(0).get(0).size() > 2) {
                List<Map<String, Object>> constantList = new ArrayList<>();
                for (int i = 0; i < list.size(); i++) {
                    List<Map<String, Object>> mapList = list.get(i);
                    double tempSum = 0;//温度和
                    double O3Sum = 0;//O3和
                    double sum = 0;//
                    double sum1 = 0;
                    int length = mapList.size();
                    Map<String, Object> cmap = new HashMap<>();
                    cmap.put("time", i);
                    for (Map<String, Object> map : mapList) {
                        double temp = Double.valueOf(map.get("temp").toString().replace("\"", "").split("\\.")[0]);
                        double O3 = Double.valueOf(map.get("O3").toString().replace("\"", "").split("\\.")[0]);
                        tempSum = tempSum + temp;
                        O3Sum = O3Sum + O3;
                        sum = sum + temp * O3;
                        sum1 = sum1 + temp * temp;
                    }
                    double tempAvg = tempSum / length;
                    double O3Avg = O3Sum / length;
                    double b = (sum - length * tempAvg * O3Avg) / (sum1 - length * tempAvg * tempAvg);
                    double a = O3Avg - (b * tempAvg);
                    cmap.put("a", a);
                    cmap.put("b", b);
                    constantList.add(cmap);
                }
                hashmap.put("constants", constantList);
            }
        }

        int count = 0;
        for (Map<String, Object> map : hashSet) {
            String id = map.get("cityID").toString();
            Map<String, Object> dataMap = restTemplate.getForObject("https://api.heweather.net/v7/weather/72h?key=da05c6c4852d4f7aa3364a9236ee9e26&gzip=n&location={1}", Map.class, id);
@@ -141,23 +231,41 @@
                String hour1 = hourlyMap.get("fxTime").toString().split("\\+")[0].split(":")[0].replace("T", " ");
                if (hour.equals(nextDay)) {
                    nextDayList.add(hourlyMap);

                }
                if (hour1.equals(nextNextDay)) {
                    nextDayList.add(hourlyMap);
                }

                map.put("data", nextDayList);
            }
        }

        for (Map<String, Object> map : hashSet) {
            List<Map<String,Object>> resultList=new ArrayList<>();
            String cityCode = map.get("cityCode").toString();
            List<Map<String, Object>> resultList = new ArrayList<>();
            ArrayList<Map<String, Object>> dataList = (ArrayList<Map<String, Object>>) map.get("data");
            for (Map<String, Object> dataMap : dataList) {
                Map<String,Object> hashMap=new HashMap<>();
                hashMap.put("cityCode",map.get("cityCode").toString());
                Map<String, Object> hashMap = new HashMap<>();
                hashMap.put("cityCode", cityCode);
                String time = dataMap.get("fxTime").toString().split("\\+")[0].replace("T", " ") + ":00";
                hashMap.put("time",sdf1.parse(time));
                hashMap.put("json",JSONObject.toJSONString(dataMap));
                hashMap.put("time", sdf1.parse(time));

                String temp = dataMap.get("temp").toString();
                int hour = Integer.valueOf(time.substring(11, 13));
                if (map.get("constants") != null) {
                    List<Map<String, Object>> list = (List<Map<String, Object>>) map.get("constants");
                    for (Map<String, Object> listMap : list) {
                        int value = Integer.valueOf(listMap.get("time").toString());
                        Double a = Double.valueOf(listMap.get("a").toString());
                        Double b = Double.valueOf(listMap.get("b").toString());
                        if (hour == value) {
                            double O3C = b * Double.valueOf(temp) + a;
                            dataMap.put("O3C", String.valueOf(Math.round(O3C)));
                        }
                    }
                }
                hashMap.put("json", JSONObject.toJSONString(dataMap));
                resultList.add(hashMap);
            }
            resultList.remove(0);
@@ -170,9 +278,9 @@
            Map<String, Object> parameters = new HashMap<>();
            parameters.put("start", start);
            parameters.put("end", end);
            parameters.put("cityCode", map.get("cityCode").toString());
            parameters.put("cityCode", cityCode);
            forecastWeatherMapper.deleteByTime(parameters);
            count = count+forecastWeatherMapper.insertForecastWeather(resultList);
            count = count + forecastWeatherMapper.insertForecastWeather(resultList);
        }
        return count;
    }

 src/main/java/com/moral/task/ForecastWeatherInsertTask.java

@@ -25,7 +25,7 @@
        if (count > 0) {
            return new ReturnT(200, "插入成功");
        }else {
            return new ReturnT(200, "插入失败");
            return new ReturnT(500, "插入失败");
        }
    }
}

 src/main/java/com/moral/task/RealWeatherInsertTask.java

@@ -25,7 +25,7 @@
        if (count > 0) {
            return new ReturnT(200, "插入成功");
        }else {
            return new ReturnT(200, "插入失败");
            return new ReturnT(500, "插入失败");
        }
    }
}

 src/main/resources/mapper/AQIMapper.xml

@@ -12,4 +12,14 @@
        #{code}
        )
    </insert>

    <select id="getO3" resultType="java.util.Map">
        select DATE_FORMAT(time, #{typeFormat}) time,
        ifnull(aqi_json->'$.O3C',aqi_json->'$.O3') 'O3'
        from hangzhou_aqi
        where city_code=#{cityCode}
        and time >= #{startTime}
        AND time <![CDATA[<]]> #{endTime}
         and DATE_FORMAT(time, #{typeFormat}) like '%${time}'
    </select>
</mapper>

 src/main/resources/mapper/ForecastWeatherMapper.xml

@@ -7,7 +7,6 @@
    <insert id="insertForecastWeather">
        insert into
        forecast_weather
        (city_code,time,json)
        values
        <foreach collection="list" item="item" separator=",">
            (#{item.cityCode},#{item.time},#{item.json})

 src/main/resources/mapper/RealWeatherMapper.xml

@@ -12,4 +12,14 @@
            (#{item.cityCode},#{item.time},#{item.json})
        </foreach>
    </insert>

    <select id="getTemp" resultType="java.util.Map">
        select DATE_FORMAT(time, #{typeFormat}) time,
        json->'$.temp' 'temp'
        from real_weather
        where city_code=#{cityCode}
        and time >= #{startTime}
        AND time <![CDATA[<]]> #{endTime}
        and DATE_FORMAT(time, #{typeFormat}) like '%${time}'
    </select>
</mapper>