81,092
社区成员
发帖
与我相关
我的任务
分享
<update id="updateWagesFrame" parameterType="java.util.List">
<foreach collection="list" item="info" index="index" open="" close="" separator=";">
update abc
<set>
<if test="info.userId != null and info.userId != ''">
UserId = #{info.userId},
</if>
<if test="info.departmentId != null and info.departmentId != ''">
DepartmentId = #{info.departmentId},
</if>
<if test="info.departmentId != null and info.departmentId != ''">
DepartmentId = #{info.departmentId},
</if>
<if test="info.userName != null and info.userName != ''">
UserName = #{info.userName},
</if>
<if test="info.type != null and info.type != ''">
Type = #{info.type},
</if>
<if test="info.value != null and info.value != ''">
Value = #{info.value},
</if>
<if test="info.updateDate != null and info.updateDate != ''">
UpdateDate = #{info.updateDate},
</if>
<if test="info.updateByUserId != null and info.updateByUserId != ''">
UpdateByUserId = #{info.updateByUserId},
</if>
</set>
where UserId = ${info.userId}
</foreach>
</update>