根据城市获取数据增加海拔，植被，水系

jinpengyong

2020-08-25 8dbbc6981e91231455273ae25bd8b25bef534a0d

根据城市获取数据增加海拔，植被，水系

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

@@ -7,6 +7,6 @@

public interface ShAreaMapper extends BaseMapper<Area> {

    Map<String,Object> getLngAndLat(String name);
    Map<String,Object> getgeography(String name);

}

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

@@ -709,12 +709,15 @@
            }

        }



        Map<String, Object> point = shAreaMapper.getLngAndLat(name);

        Map<String, Object> point = shAreaMapper.getgeography(name);

        for (Map<String, Object> map : resultList) {

            double longitude = Double.valueOf(point.get("lng").toString());

            double latitude = Double.valueOf(point.get("lat").toString());

            map.put("longitude",df.format(longitude));

            map.put("latitude",df.format(latitude));

            map.put("altitude",point.get("altitude").toString());

            map.put("vegetation",point.get("vegetation").toString());

            map.put("river",point.get("river").toString());

        }

        return resultList;

    }


 src/main/resources/mapper/ShAreaMapper.xml

@@ -1,8 +1,8 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.moral.mapper.ShAreaMapper" >
  <select id="getLngAndLat" resultType="java.util.Map">
    select lng,lat from sh_area
  <select id="getgeography" resultType="java.util.Map">
    select lng,lat,altitude,vegetation,river from sh_area
    where name=#{name}
  </select>
</mapper>