mybatis 根据Map字段对应值更新

Mapper.xml

  <update id="updateFields">
    update tablename
    <set>
      <foreach collection="fields.entrySet()" index="key" item="value" separator=",">
        <if test="key != 'id'.toString()">

          ${key} = #{value}

        </if>
      </foreach>
    </set>
    WHERE
    id = #{id}
  </update>

dao操作

<pre name="code" class="java">    public void updateFields(Map<String, Object> fieldMap, String id, String sqlName) {

        Map<String, Object> params = Maps.newHashMap();
        params.put("fields", fieldMap);
        params.put("id", id);
        this.getSqlSession().update(sqlName, params);
    }

fieldMap里 key是字段名  value 字段值在·