dzhh-backend/.svn/pristine/19/1930571f6d3c2f3771e94df447c54c9fecc4ef42.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.shjsgc.lhgc.gx.mapper.RmGxqktjbMapper">
    <insert id="insertshxm" parameterType="Object">
        insert into rm_shxmxxb(id, xmmc, xzqh, xmid, xmlx, gldw, zgbm, bz, geoinfo, sfwpgblxm, szhl, spzt)
        values (#{id}, #{xmmc}, #{xzqh}, #{xmid}, #{xmlx}, #{gldw}, #{zgbm}, #{bz}, #{geoinfo}, #{sfwpgblxm}, #{szhl},
                #{spzt})
    </insert>
    <delete id="deshxm" parameterType="String">
        delete
        from rm_shxmxxb
        where xmid = #{xmid}
    </delete>
    <update id="updateshxm" parameterType="String">
        update rm_shxmxxb
        set xmmc=#{xmmc},
            xzqh=#{xzqh},
            gldw=#{gldw},
            zgbm=#{zgbm},
            bz=#{bz},
            geoinfo=#{geoinfo},
            sfwpgblxm=#{sfwpgblxm},
            szhl=#{szhl},
            spzt=#{spzt}where xmid=#{id}
    </update>
    <delete id="deleteMany" parameterType="java.lang.String">
        delete from rm_shxmxxb where xmid in
        <foreach item="ids" collection="array" index="no" open="(" separator="," close=")">
            #{ids}
        </foreach>
    </delete>

</mapper>