报错SQL异常:Parameter index out of range (1 > number of parameters, which is 0).
异常:Parameter index out of range (1 > number of parameters, which is 0).
意思是:参数索引超出范围(1>参数数,即0)
sql语句错误导致的原因如下:
- 第一种:在问号旁边加了单引号
例1.select* from User where name = ’ ? ’ ;
这时问号会被当做参数传入
解决方法:去掉引号,改为:select* from User where name = ? ;