dzhh-backend/.svn/pristine/e5/e5da3cc6104459fdef42985afc91d46979497000.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.gsp.geo.mapper.RmGgpgeoMapper">
    <insert id="addGsp" parameterType="Object">
        insert into rm_ggpgeo(geom,gspid,gspbm) values (ST_Transform(st_geometryfromtext(#{wkt}, 4548),4490),#{id},#{gspbm});
    </insert>
    <insert id="addGsp2" parameterType="Object">
        insert into rm_ggpgeo(geom,gspid,gspbm) values (ST_Transform(st_geometryfromtext(#{wkt}, 4527),4490),#{id},#{gspbm});
    </insert>
    <insert id="addGsp3" parameterType="Object">
        insert into rm_ggpgeo(geom,gspid,gspbm) values (st_geometryfromtext(#{wkt},4490),#{id},#{gspbm});
    </insert>
    <update id="updGsp" parameterType="Object">
        update rm_ggpgeo set geom=(ST_Transform(st_geometryfromtext(#{wkt}, 4548),4490)),gspbm=#{gspbm} where gspid=#{id};
    </update>
    <update id="updGsp2" parameterType="Object">
        update rm_ggpgeo set geom=(ST_Transform(st_geometryfromtext(#{wkt}, 4527),4490)),gspbm=#{gspbm} where gspid=#{id};
    </update>
    <update id="updGsp3" parameterType="Object">
        update rm_ggpgeo set geom=(st_geometryfromtext(#{wkt},4490)),gspbm=#{gspbm} where gspid=#{id};
    </update>
    <delete id="delGsp" parameterType="String">
        delete from rm_ggpgeo where gspid=#{id};
    </delete>
    <select id="getGeojson" parameterType="java.lang.String" resultType="String">
        select st_asGeojson(geom) from rm_ggpgeo where gspid = #{relId};
    </select>
</mapper>