Mybatis之foreach遍历Map

话不多说,直接上代码:

方式一:利用map的entrySet()方法

 <insert id="XXX" parameterType="java.util.Map">
    INSERT INTO table(a, b)
    VALUES
    <foreach collection="param.entrySet()" open="(" separator="," close=")" index="key" item="val">
        #{key}, #{val}
    </foreach>
  </insert>
</mapper>

方式二:

<insert id="XXX" parameterType="java.util.Map">
    INSERT INTO table
    <foreach collection="params.keys" item="key" open="(" separator="," close=")">
        获取值:#{param[key]}
        键:#{key}
    </foreach>
    VALUES
    <foreach collection="param.value" item="val" open="(" separator="," close=")">
       值:#{val}
   </foreach>
</insert>

版权声明:本文为m0_54861649原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。