无法设置映射参数ParameterMapping{property,modeIN,javaTypeclass java.util.date

Question

嵌套异常为org.apache.ibatis.type.TypeException：无法为映射设置>Parameters：ParameterMapping{property='sign',mode=in,>javatype=class java.util.date,jdbctype=null,numericscale=null,>resultmapid='null',jdbctypename='null',expression='null'}。原因：org.apache.ibatis.type.TypeException：使用JdbcType null为参数#4设置非null时出错。尝试为此参数设置不同的JdbcType或不同的配置属性。原因：java.sql.sqlexception：参数索引超出范围(4>参数数，即3）。

XML

    <select id="selectSignRecordList" parameterType="SignRecord" resultMap="SignRecordResult">
        <include refid="selectSignRecordVo"/>
        <where>  
            <if test="id != null  and id != '' "> and id_ = #{id}</if>
             <if test="promiseId != null  and promiseId != '' "> and promise_id = #{promiseId}</if>
             <if test="userId != null  and userId != '' "> and user_id = #{userId}</if>
             <if test="signIn != null">
              and sign_in =#{signIn,jdbcType=DATE}
                 --and sign_in  = date_format(  #{signIn}  , '%Y-%m-%d' )
--                  AND date_format(sign_in,'%y%m%d') = date_format(#{signIn},'%y%m%d')
--                  <![CDATA[   and DATE_FORMAT(sign_in, '%Y-%m-%d')=  DATE_FORMAT(#{signIn}, '%Y-%m-%d')   ]]>
--                  AND date(sign_in) = date(#{signIn,jdbcType=DATE})
              </if>
             <if test="signStatus != null  and signStatus != '' "> and sign_status = #{signStatus}</if>
             <if test="createBy != null  and createBy != '' "> and create_by = #{createBy}</if>
             <if test="createTime != null "> and create_time = #{createTime}</if>
             <if test="updateBy != null  and updateBy != '' "> and update_by = #{updateBy}</if>
             <if test="updateTime != null "> and update_time = #{updateTime}</if>
             <if test="remark != null  and remark != '' "> and remark = #{remark}</if>
         </where>
    </select>

登录名为java.util.date

Answer 1

最可能的问题是--是SQL中的注释开头，但mybatis并不知道这一点。这一行（以及所有类似的）：

--           AND date(sign_in) = date(#{signIn,jdbcType=DATE})

导致一个问题，因为mybatis试图在此处准备好的语句中设置参数，但您的RDBMS忽略了查询的这一部分，因此该参数不存在。因此会出现错误消息，即参数的实际数量（DB已知）小于客户机（mybatis）试图设置的数量。

要解决此问题,请使用xml注释而不是SQL注释,如下所示：

    <select id="selectSignRecordList" parameterType="SignRecord" resultMap="SignRecordResult">
    <include refid="selectSignRecordVo"/>
    <where>  
        <if test="id != null  and id != '' "> and id_ = #{id}</if>
         <if test="promiseId != null  and promiseId != '' "> and promise_id = #{promiseId}</if>
         <if test="userId != null  and userId != '' "> and user_id = #{userId}</if>
         <if test="signIn != null">
          and sign_in =#{signIn,jdbcType=DATE}
             <!-- and sign_in  = date_format(  #{signIn}  , '%Y-%m-%d' )
              AND date_format(sign_in,'%y%m%d') = date_format(#{signIn},'%y%m%d')
              <![CDATA[   and DATE_FORMAT(sign_in, '%Y-%m-%d')=  DATE_FORMAT(#{signIn}, '%Y-%m-%d')   ]]>
              AND date(sign_in) = date(#{signIn,jdbcType=DATE})
             --> 
          </if>
         <if test="signStatus != null  and signStatus != '' "> and sign_status = #{signStatus}</if>
         <if test="createBy != null  and createBy != '' "> and create_by = #{createBy}</if>
         <if test="createTime != null "> and create_time = #{createTime}</if>
         <if test="updateBy != null  and updateBy != '' "> and update_by = #{updateBy}</if>
         <if test="updateTime != null "> and update_time = #{updateTime}</if>
         <if test="remark != null  and remark != '' "> and remark = #{remark}</if>
     </where>
</select>