mvn archetype:generate -DgroupId=org.seckill -DartifactId=seckill -DarchetypeArtifactId=maven-archetype-webapp -DarchetypeCatalog=local
2016-05-08
講師回答 / 益軍
頁面是在后面web課程里,慕課禁止發(fā)源碼,直接看源碼學(xué)習(xí)效果不太好。主要是寫代碼的過程和思路。課程所有代碼都會(huì)在視頻里體現(xiàn)。
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