java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

绿林寻猫
2021-12-08 / 0 评论 / 248 阅读 / 正在检测是否收录...

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).

原因如下:
@Select("select count(*) from pro_mac where id like'%#{val}%' or mac like'%#{val}%'")

where id like'%#{val}%' or mac like'%#{val}%'"中#{val}是带‘’的,显示结果可能为where id like'%‘123’%' ​​​​​​​

所以改为${val}就好了

@Select("select count(*) from pro_mac where id like'%${val}%' or mac like'%${val}%'")

 

0

评论 (0)

取消