1. list循环
<!--close=")"和open="("是mybatis的固定写法,separator是ids实例间用逗号分隔, -->
<update id="batchUpdateSellStatus">
update imooc_mall_product
set status=#{sellStatus}
-- 下面一行是数据库里面的id
where id in
-- item="id" 是遍历的id
<foreach collection="ids" close=")" item="id" open="(" separator=",">
#{id}
</foreach>
</update>
2. 选择,返回list列表,并按倒序进行排列;
<!--order by :排序-->
<!--desc :倒序-->
<select id="selectListForAdmin" resultMap="BaseResultMap">
select
<include refid="Base_Column_List"/>
from imooc_mall_product
order by update_time desc
</select>