出现Parameter index out of range (1 > number of parameters, which is 0)怎么解决?

Question

package tongxunluguanlixitong;

import java.sql.SQLException;

import tongxunluguanlixitong.dao.UserDao;
import tongxunluguanlixitong.entity.User;

public class JDBCTest{
public static void main(String[] args) throws SQLException{
User user = new User();
user.setUsername("032020704");
user.setNickname("风清扬");
user.setPassword("123456");
UserDao userDao = UserDao.getInstance();
if(userDao.insert(user)) {
System.out.println("插入成功");
}
else {
System.out.println("插入失败");
}
}
}

Answer 1

UserDao实现的有问题吧，参数下标越界，因为你传递了0个参数，看看你的数据库语句生成代码吧