mvn archetype:generate -DgroupId=org.seckill -DartifactId=seckill -DarchetypeArtifactId=maven-archetype-webapp -DarchetypeCatalog=local
2016-05-08
SeckillDao.xml有2個(gè)地方要改,當(dāng)sql有多個(gè)參數(shù)變量綁定時(shí)的方式要寫成#{0},#{1}而不能直接寫接口的參數(shù)名稱,否則報(bào)錯(cuò)(2):
<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>
<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>
2016-05-08
SeckillDao.xml有2個(gè)地方要改,當(dāng)sql有多個(gè)參數(shù)變量綁定時(shí)的方式要寫成#{0},#{1}而不能直接寫接口的參數(shù)名稱,否則報(bào)錯(cuò)(1):
<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>
<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>
2016-05-08