模糊查询

数据库模糊查询报错

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语句运用错误

select * from record
            
		  
                     MERCHANT_NO like '%#{merchantNo}%'
                 



修改为



select * from record
            
		  
                     MERCHANT_NO like CONCAT('%','${merchantNo}','%' ) 
                 

--------------------- 

原文：https://blog.csdn.net/kingo0/article/details/41821333