Question

Mybatis sql报错Parameter index out of range (3 > number of parameters, which is 2).

<select id="selectChildBaseCount" parameterType="map" resultType="int">
select count(*) from lx_operate_info_log ts
<where>
<if test="schoolId !=null and schoolId !=''">
ts.school_id=#{schoolId}
</if>
<if test="operateName !=null and operateName !=''">
and ts.user_name like '%#{operateName}%'
</if>
<if test="targetType !=null and targetType !=''">
and ts.target_type = #{targetType}
</if>
</where>
</select>

Answer 1

就错误来看的话，应该是你在你传入的map里只put了两个key和value,而你的mapper中却使用了3个参数