d334173ea57e819dd04178f76c3e0c3d22b145c5.svn-base 1.1 KB

1234567891011121314151617181920
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  3. <mapper namespace="org.jeecg.modules.demo.hzz.shjsgc.lhgc.xjb.mapper.RmXjbqktjbMapper">
  4. <insert id="insertshxm" parameterType="Object">
  5. 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})
  6. </insert>
  7. <delete id="deshxm" parameterType="String">
  8. delete from rm_shxmxxb where xmid=#{xmid}
  9. </delete>
  10. <update id="updateshxm" parameterType="String">
  11. 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}
  12. </update>
  13. <delete id="deleteMany" parameterType="java.lang.String">
  14. delete from rm_shxmxxb where xmid in
  15. <foreach item="ids" collection="array" index="no" open="(" separator="," close=")">
  16. #{ids}
  17. </foreach>
  18. </delete>
  19. </mapper>