dao中定義方法:
List<KeyValueEntity> groupByDay(Date startDate, Date endDate);
在早期,參數(shù)沒(méi)做注解時(shí)默認(rèn)是按順序獲取,以0、1等為索引,所以Mapper是這樣寫(xiě)的:
<select id="groupByDay" resultType="io.renren.modules.business.entity.template.KeyValueEntity">
select DATE_FORMAT(create_time, '%Y/%m/%d') as keyText, count(*) as value
from question_answer
where create_time BETWEEN #{0, jdbcType=DATE} AND #{1, jdbcType=DATE}
group by keyText
order by keyText
</select>
后來(lái)由0、1改為用arg0、arg1代替:
<select id="groupByDay" resultType="io.renren.modules.business.entity.template.KeyValueEntity">
select DATE_FORMAT(create_time, '%Y/%m/%d') as keyText, count(*) as value
from question_answer
where create_time BETWEEN #{arg0, jdbcType=DATE} AND #{arg1, jdbcType=DATE}
group by keyText
order by keyText
</select>
而新版的又改成以參數(shù)名使用:
<select id="groupByDay" resultType="io.renren.modules.business.entity.template.KeyValueEntity">
select DATE_FORMAT(create_time, '%Y/%m/%d') as keyText, count(*) as value
from question_answer
where create_time BETWEEN #{startDate, jdbcType=DATE} AND #{endDate, jdbcType=DATE}
group by keyText
order by keyText
</select>
對(duì)于當(dāng)前庫(kù)的強(qiáng)制更新,可以使用命令:
mvn clean install -U
對(duì)于下面打包命令,也是會(huì)使用新庫(kù):
mvn clean package