mybatis 遍历map

mybatis 遍历map

java

Map<String,Object> filem = new HashMap<String,Object>();

filem.put("param", fileMap);

//tbCusFirmChgMapper.saveDataMapAFFIX2(filem);

tbCusFirmWebMapper.saveDataMapWeb(filem);

 

<insert id="saveDataMapWeb" parameterType="map" >

    INSERT INTO TB_CUS_FIRM_AFFIX_CHG

    <foreach collection="param.keys" item="k" open="(" close=")" separator=",">   

        ${k} 

   </foreach> 

     VALUES 

    <foreach collection="param.keys" item="k" open="(" close=")" separator=",">   

    <if test="null != param[k]">    

        #{param[${k}]}  

    </if>  

   </foreach> 

  

  </insert>

  <update id="updateDataMapWeb" parameterType="map">

    update TB_CUS_FIRM_WEB set

    <foreach collection="param.keys" item="k" separator=","> 

       ${k}=#{param[${k}]}

    </foreach>

     where CUSTOMER_KEY=#{cusKey}

  </update>