java.sql.SQLException: 无效的列索引

Question

public int adduser(Users u) {
JDBCUtils utils = new JDBCUtils();
StringBuffer sql = new StringBuffer();
sql.append("insert into u_user(")
.append("u_id,u_name,")
.append("u_pwd,u_sex,")
.append("u_age,u_telephone,")
.append("u_address,u_jurisdiction)")
.append("values(seq_user.nextval,?,?,?,?,?,?,?)");
try {
return utils.executeUpdate(sql.toString(), new Object[]{
u.getAddress(),
u.getAge(),
u.getJurisdiction(),
u.getPwd(),
u.getSex(),
u.getTelephone(),
u.getUserId(),
u.getUserName()
});
} catch (Exception e) {
e.printStackTrace();
}
return 0;
}

Answer 1

占位符 和 字段 个数不匹配啊