集合数据修改sql语句

 <update id="putaway" parameterType="cn.itsource.product.domain.Product">
     update t_product
     <trim prefix="set" suffixOverrides=",">
         <trim prefix="state =case" suffix="end,">
             <foreach collection="list" item="item" index="index">
                     when id=#{item.id} then 1
             </foreach>
         </trim>
         <trim prefix="onsaletime =case" suffix="end,">
             <foreach collection="list" item="item" index="index">
                 when id=#{item.id} then  sysdate()
             </foreach>
         </trim>
     </trim>
     where id in
     <foreach collection="list" separator="," item="item" index="index"  open="(" close=")">
         #{item.id}
     </foreach>
 </update>
<!-- 下架-->
 <update id="soldout" parameterType="cn.itsource.product.domain.Product">
     update t_product
     <trim prefix="set" suffixOverrides=",">
         <trim prefix="state =case" suffix="end,">
             <foreach collection="list" item="item" index="index">
                 when id=#{item.id} then 0
             </foreach>
         </trim>
         <trim prefix="offsaletime =case" suffix="end,">
             <foreach collection="list" item="item" index="index">
                 when id=#{item.id} then sysdate()
             </foreach>
         </trim>
     </trim>
     where id in
     <foreach collection="list" separator="," item="item" index="index"  open="(" close=")">
         #{item.id}
     </foreach>
 </update>