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 字段值在·