参数索引超出范围（2>参数数量为1）

Question

String query = "insert into dept values(?,'?','?'))"; 
PreparedStatement pu=con.prepareStatement(query); 
pu.setInt(1, 2); 
pu.setString(2, "a"); 
pu.setString(3, "ss"); 
pu.execute(query); 

Answer 1

删除问号周围的引号。

Answer 2

单引号围绕占位符字符引起此错误。删除它们：

String query = "insert into dept values(?,?,?))";