BUG : HTTP Status 500 - Request Parameter ‘xxxxXxx‘ not found. Available parameters are [qo, param1]

错误信息

HTTP Status 500 - Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘plotId’ not found. Available parameters are [qo, param1]
type Exception report

message Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.binding.BindingException: Parameter ‘plotId’ not found. Available parameters are [qo, param1]

description The server encountered an internal error that prevented it from fulfilling this request.

exception

…

错误截图

错误代码

 <sql id="mySQL">
    <where>
      <if test="qo.id != null">
        and id = #{qo.id}
      </if>
      <if test="qo.plotId != null and qo.plotId !=-1">
      	<!-- 错误代码 -->
        and plotId=#{plotId}
      </if>
    </where>
  </sql>

解决办法

其实就是本应从 qo(条件查询的工具类) 中取出的, 但是上面的代码中忘记写了,这也是一个低级的错误.

• 将 {plotId} 改成 {qo.plotId},如下图所示:

 <if test="qo.plotId != null and qo.plotId !=-1">
      	<!-- 更改代码 -->
        and plotId=#{qo.plotId}
 </if>

如有错误请各位大神指导,叩谢了 ! !