数据库模糊查询报错
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>