Parameter index out of range (3 > number of parameters, which is 2)

Question

PreparedStatementCallback; SQL [select * from user where 1=1 limit ?,? ]; Parameter index out of range (3 > number of parameters, which is 2).; nested exception is java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
这是说我参数问题吗？

Answer 1

翻译过来的意思是“参数索引超出范围”，一个问号代表一个参数，你只传了2个参数。