java.sql.SQLException: 索引中丢失 IN 或 OUT 参数:: 4

package com.cn.lnz.dao;import java.util.List;import javax.annotation.Resource;import javax.sql.DataSource;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.stereotype.Repository;import com.cn.lnz.model.User;@Repository("userJdbcDao")public class UserDao implements IUserDao{private JdbcTemplate jdbcTemplate;//public void setJdbcTemplate(jdbcTemplate jdbcTemplate)//{//this.jdbcTemplate = jdbcTemplate;//}@Resourcepublic void setDateSource(DataSource dataSource){jdbcTemplate = new JdbcTemplate(dataSource);}@Overridepublic void add(User user){//error1： value  ---> values//error2: params//jdbcTemplate.update("insert into t_user(id, username, password, nickname) value(?, ?, ?, ?)", user.getUsername(), user.getPassword(), user.getNickname());// 新增的SQL语句String sqlInsert = "INSERT INTO t_user(id, username, password, nickname) VALUES(?, ?, ?, ?)";// SQL中参数int id = user != null ? user.getId() : -1;String username = user != null ? user.getUsername() : "";String password = user != null ? user.getPassword() : "";String nickname = user != null ? user.getNickname() : "";// 执行SQLjdbcTemplate.update(sqlInsert, id, username, password, nickname);}@Overridepublic void update(User user){}@Overridepublic void delete(int id){}@Overridepublic User load(int id){return null;}@Overridepublic List<User> list(String sql){return null;}}