<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mapper

PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="org.seckill.dao.SeckillDao">

<!-- 目的：為dao接口方法提供sql語句配置 -->

<update id="reduceNumber">

<!-- 具體sql -->

update

seckillId

set

number = number - 1

where seckill_id = #{seckillId}

and start_time <![CDATA[ <= ]] #{killTime},

and end_time >= #{killTime}

and number > 0;

</update>

<select id="queryById" resultType="Seckill" parameterType="long">

select seckill_id,name,number,start_time,end_time,create_time

from seckill

where seckill_id =#{seckillId}

</select>

<select id ="querAll" resultType="Seckill">

select seckill_id,name,number,start_time,end_time,create_time

from seckill

oder by create_time desc

limit #{offset},#{limit}

</select>

</mapper>