Question

请问这句mybatis问题出在哪里

<select id="selectScheduleCount" resultType="int" parameterType="int">
select count(serverid) from schedule
<where>
<if test="accountID != 1">
accountid = #{accountID,jdbcType=INTEGER}
</if>
</where>
</select>

<if test="accountID != 1">这样写不对吗

Answer 1

<if test="accountID != 1">这个没问题
下面的写法有问题吧，parameterType="int"这边已经说了参数类型了
accountid = #{accountID,jdbcType=INTEGER}这种用法没见过
直接写accountid = #{accountID}

Answer 2

accountid = ${accountID}