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)<1)"
+" order by CREATE_TIME desc limit ?,?";
如果不小心写成
String sql = "select * from t_mobile_picture where PIC_STATUS = '1"
+ "' and IMEI_ID != ?"
+ "' and (POW(ADJUST_JINGDU-?,2)+POW(ADJUST_WEIDU-?,2)<1)"
+" order by CREATE_TIME desc limit ?,?";
就会报上面的错误,"' and (POW 就这里的'导致的。