MySQL通过实体经纬度字段插入数据库point类型的经纬度字段

说明：
数据库：表中没有经度跟纬度字段，只有location字段（point类型）         POINT(经度 纬度)
实体类：只有经度 lng 字段、纬度 lat 字段  没有location字段

<!--添加一个小区-->
<insert id="insertOneDistrict" parameterType="com.diantijiang.saas.order.entity.District"
        keyProperty="id" useGeneratedKeys="true">
  insert
  into
    oc_district(
    <if test="null != name">
      name,
    </if>
    <if test="null != shortName">
      short_name,
    </if>
    <if test="null != cityId">
      city_id,
    </if>
    <if test="null != city">
      city,
    </if>
    <if test="null != areaId">
      area_id,
    </if>
    <if test="null != area">
      area,
    </if>
    <if test="null != address">
      address,
    </if>
    <if test="null != tel">
      tel,
    </if>
    location
      )
  values (
    <if test="null != name">
      #{name},
    </if>
    <if test="null != shortName">
      #{shortName},
    </if>
    <if test="null != cityId">
      #{cityId},
    </if>
    <if test="null != city">
      #{city},
    </if>
    <if test="null != areaId">
      #{areaId},
    </if>
    <if test="null != area">
      #{area},
    </if>
    <if test="null != address">
      #{address},
    </if>
    <if test="null != tel">
      #{tel},
    </if>
  GeomFromText ('POINT(${lng} ${lat})')
  )
</insert>

转载于:https://www.cnblogs.com/Soy-technology/p/10985860.html