DELETE FROM rm_axshbfgcxxb WHERE main_id = #{mainId} SELECT * FROM rm_axshbfgcxxb WHERE main_id = #{mainId} insert into rm_axfxjszycgb(id,gcmc,main_id) values (#{id},#{gcmc},#{main_id}) select main_id from rm_axshbfgcxxb where id=#{id} insert into rm_axhdzyzb(id,hqmc,main_id)values (#{id},#{hqmc},#{main_id}) insert into rm_shbfgcxxgeo(geom,gcid,gcmc) values (ST_Transform(st_geometryfromtext(#{geom}, 4548),4490),#{id},#{gcmc}); insert into rm_shbfgcxxgeo(geom,gcid,gcmc) values (st_geometryfromtext(#{geom},4490),#{id},#{gcmc}); insert into rm_shbfgcxxgeo(geom,gcid,gcmc) values (ST_Transform(st_geometryfromtext(#{geom}, 4527),4490),#{id},#{gcmc}); update rm_shbfgcxxgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4548),4490)),gcmc=#{gcmc} where gcid=#{id}; update rm_shbfgcxxgeo set geom=(ST_Transform(st_geometryfromtext(#{geom}, 4527),4490)),gcmc=#{gcmc} where gcid=#{id}; update rm_shbfgcxxgeo set geom=(st_geometryfromtext(#{geom},4490)),gcmc=#{gcmc} where gcid=#{id}; select st_asGeojson(geom) from rm_shbfgcxxgeo where gcid = #{relId}; delete from rm_shbfgcxxgeo where gcid=#{id}; select id,gcmc,shlx,sjhd,jd,wd from rm_axshbfgcxxb where main_id=#{id}