<selectid="getUserInfo"parameterMap="map"resultType="Map">
select u.* from sys_user as u
<where><iftest="sex != null ">
and u.sex = #{sex}
</if><iftest="name != '' and name != null">
and u.name like '%${name}%'
</if></where></select>
foreach
update car_use set is_del = 1,update_time = sysdate() where id in
<foreachitem="id"collection="ids"open="("separator=","close=")">
#{id}
</foreach>
说明:
collection: 传进来得数组。
open:开始遍历时拼接。
separator:两个对象之间的拼接。
close:结束时拼接。