如下所示:Java实体对象中有如下一个属性
/**
* 系统员工ID集合(批量修改登录时间用)
*/
private long[] sysEmpIds;
则对应配置文件为(配置中<foreach>标签):
<update id="batchUpdateLoginTime" parameterType="pubUserEmployee">
UPDATE pub_user_employee SET startHour=#{startHour},startMinute=#{startMinute},
endHour=#{endHour},endMinute=#{endMinute},loginCycle=#{loginCycle}
WHERE sysEmpId IN (
<foreach item="p" collection="sysEmpIds" separator=",">
#{p}
</foreach>
) AND comId = #{comId};
</update>
总结:对于遍历对象中的属性,用<foreach>标签,collection直接写对象属性名,不用加#{}