<!--根据唯一键修改-->
<update id="commonEdit" parameterType="pd">
update ${table}
set
<foreach collection="map.keys" index="index" item="key" open="" close="" separator="," >
${key}= #{map.${key}}
</foreach>
where ${pkey}=#{pvalue}
</update>
<!--保存 -->
<insert id="commonSave" parameterType="pd">
insert into ${table}
<foreach collection="map.keys" index="index" item="key" open="(" close=")" separator=",">
${key}
</foreach>
values
<foreach collection="map.values" index="index" item="value" open="(" close=")" separator=",">
#{value}
</foreach>
</insert>
mybatis foreach循环map
最新推荐文章于 2024-04-02 22:20:36 发布