错误位置:
String sql="update YICHAN_USER set USER_NAME=?,USER_PASSWORD=?,USER_SEX=?,USER_BIRTHDAY=DATE_FORMAT(?,'%Y-%m-%d'),USER_IDENITY_CODE=?,USER_EMAIL=?,USER_MOBILE=?,USER_ADDRESS=?,USER_STATE=? where USER_ID=?";
Object[] params= {
u.getUSER_NAME(),
u.getUSER_PASSWORD(),
u.getUSER_SEX(),
u.getUSER_BIRTHDAY(),
u.getUSER_IDENITY_CODE(),
u.getUSER_EMAIL(),
u.getUSER_MOBILE(),
u.getUSER_ADDRESS(),
u.getUSER_STATE(),
};
return Basedao.exectuIUD(sql, params);
报错:
java.sql.SQLException: No value specified for parameter 10
原因:
update语句含10个字段,最后一个字段为USER_DI,参数中只含9个字段,无USER_ID
改正:
String sql="update YICHAN_USER set USER_NAME=?,USER_PASSWORD=?,USER_SEX=?,USER_BIRTHDAY=DATE_FORMAT(?,'%Y-%m-%d'),USER_IDENITY_CODE=?,USER_EMA