1234567891011121314151617181920 |
- <?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.xjb.mapper.RmXjbqktjbMapper">
- <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>
|