dzhh-backend/.svn/pristine/b3/b3f425920b681c8cd6cd0e27b8e29f16d5b62202.svn-base

<?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="org.jeecg.modules.demo.hzz.hhhj.jzd.geo.mapper.RmJzdgeoMapper">
<!-- -->
    <insert id="addJzd" parameterType="Object">
        insert into rm_jzdgeo(geom,jzdid,jzbh) values (ST_Transform(st_geometryfromtext(#{wkt}, 4548),4490),#{id},#{jzbh});
    </insert>
    <insert id="addJzd2" parameterType="Object">
        insert into rm_jzdgeo(geom,jzdid,jzbh) values (ST_Transform(st_geometryfromtext(#{wkt}, 4527),4490),#{id},#{jzbh});
    </insert>
    <insert id="addJzd3" parameterType="Object">
        insert into rm_jzdgeo(geom,jzdid,jzbh) values (st_geometryfromtext(#{wkt},4490),#{id},#{jzbh});
    </insert>
    <update id="updJzd" parameterType="Object">
        update rm_jzdgeo set geom=(ST_Transform(st_geometryfromtext(#{wkt}, 4548),4490)),jzbh=#{jzbh} where jzdid=#{id};
    </update>
    <update id="updJzd2" parameterType="Object">
        update rm_jzdgeo set geom=(ST_Transform(st_geometryfromtext(#{wkt}, 4527),4490)),jzbh=#{jzbh} where jzdid=#{id};
    </update>
    <update id="updJzd3" parameterType="Object">
        update rm_jzdgeo set geom=(st_geometryfromtext(#{wkt},4490)),jzbh=#{jzbh} where jzdid=#{id};
    </update>
    <select id="getGeojson" parameterType="java.lang.String" resultType="String">
        select st_asGeojson(geom) from rm_jzdgeo where jzdid = #{relId};
    </select>
    <delete id="delJzd" parameterType="String">
        delete from rm_jzdgeo where jzdid=#{id};
    </delete>
</mapper>