Parameter index out of range (1 > number of parameters,which is 0) 哪位遇见过,
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/21 07:17:54
![Parameter index out of range (1 > number of parameters,which is 0) 哪位遇见过,](/uploads/image/z/13092853-13-3.jpg?t=Parameter+index+out+of+range+%281+%3E+number+of+parameters%2Cwhich+is+0%29+%E5%93%AA%E4%BD%8D%E9%81%87%E8%A7%81%E8%BF%87%2C)
Parameter index out of range (1 > number of parameters,which is 0) 哪位遇见过,
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个)
一般是 sql语句少了问号
是sql语句有问题
还可能是 :Parameter index out of range (2 > number of parameters,which is 1).错误是预插入语句少了两个问号导致的,原因可能是sql语句'号使用不当导致的 String sql = "select * from t_mobile_picture where PIC_STATUS = '1" + "' and IMEI_ID != " + " and (POW(ADJUST_JINGDU-?,2)+POW(ADJUST_WEIDU-?,2)
将ps=(PreparedStatement) connection.prepareStatement("sql");中的“”去掉