<select id="queryAll" resultType="Seckill">
select seckill_id,name,number,start_time,end_time,create_time
from seckill
order by create_time desc
limit #{0},#{1}
</select>
<update id="reduceNumber">
update seckill
set number=number-1
where number > 0
and seckill_id=#{0}
and start_time <![CDATA[ <= ]]> #{1}
and end_time <![CDATA[ >= ]]> #{1}
</update>
