DELETE FROM rm_pmtxx WHERE rvid = #{mainId} SELECT * FROM rm_pmtxx WHERE rvid = #{mainId} insert into rm_hdmzxdgeo(geom,zh,zbid) values (ST_Transform(st_geometryfromtext(#{geom}, 4548),4490),#{zh},#{zbid}); insert into rm_hdmzxdgeo(geom,zh,zbid) values (st_geometryfromtext(#{geom},4490),#{zh},#{zbid}); insert into rm_hdmzxdgeo(geom,zh,zbid) values (ST_Transform(st_geometryfromtext(#{geom}, 4527),4490),#{zh},#{zbid}); update rm_hdmzxdgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4548),4490)),zh=#{zh} where zbid=#{zbid}; update rm_hdmzxdgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4527),4490)),zh=#{zh} where zbid=#{zbid}; update rm_hdmzxdgeo set geom=(st_geometryfromtext(#{geom},4490)),zh=#{zh} where zbid=#{zbid}; select st_asGeojson(geom) from rm_hdmzxdgeo where zbid = #{relId}; delete from rm_hdmzxdgeo where zbid=#{id};