mapper的xml文件中,语句中的参数如何编写
参数只有一个
<select id="countRegisterDay" resultType="java.lang.Integer">
SELECT COUNT(*) FROM ucenter_member uc WHERE DATE(uc.gmt_create) = #{day}
</select>
Integer countRegisterDay(String day);
参数有多个
<select id="countRegisterDay" resultType="java.lang.Integer">
SELECT COUNT(*) FROM ucenter_member uc WHERE DATE(uc.gmt_create) = #{0} or DATE(uc.gmt_create) = #{1}
</select>
Integer countRegisterDay(String day,String day2);
<select id="countRegisterDay" resultType="java.lang.Integer">
SELECT COUNT(*) FROM ucenter_member uc WHERE DATE(uc.gmt_create) = #{day1} or DATE(uc.gmt_create) = #{day2}
</select>
Integer countRegisterDay(@Param("day1")String day,@Param("day2")String day2);
本文来自博客园,作者:NeverLateThanBetter,转载请注明原文链接:https://www.cnblogs.com/do-it-520/p/16614368.html
韶华易逝,不能虚度年华。
浙公网安备 33010602011771号