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

Question

最近在学jdbc，想把resultSet里列值放到map集合，但运行报错Parameter index out of range (2 > number of parameters, which is 1)，求大神解决一下，

Answer 1

pstmt.setString(2,name);
改成

pstmt.setString(1,name);