java.sql.SQLException: Parameter index out of range

数据库模糊查询报错

Error querying database. Cause: java.sql.SQLException: Parameter index 


out of range (5 > number of parameters, which is 4). ### The error may involve MisQueryShiftRecordDTO.queryQueryDownloadResult-Inline ### The error 


occurred while setting parameters ### Cause: java.sql.SQLException: Parameter index out of range (5 > number of parameters, which is 4). ; SQL []; 


Parameter index out of range (5 > number of parameters, which is 4).; nested exception is java.sql.SQLException: Parameter index out of range (5 > 


number of parameters, which is 4).

查询原因  mybatis的like语句运用错误

<pre name="code" class="sql">select * from record
            <where>
		<if test="merchantNo != null and merchantNo != ''">  
                     MERCHANT_NO like '%#{merchantNo}%'
                </if> 

修改为

select * from record
            <where>
		<if test="merchantNo != null and merchantNo != ''">  
                     MERCHANT_NO like CONCAT('%','${merchantNo}','%' ) 
                </if>