我有一个从数据库更新用户的服务方法:
const updateUser = async (user) => {
const {firstName, lastName, email, password, phone, dob, countryid, gender, address, role, id} = user;
const sql = `UPDATE user set user_firstName = ?, user_lastName = ?, user_email = ?, user_password = ?, user_phoneNumber = ?, user_dob= ?, user_countryId = ?, user_gender = ?, user_address = ?, user_role= ? WHERE client_id = ?`;
try {
await db.query(sql, [firstName, lastName, email, password, phone, dob, countryid, gender, address, role, id]);
return { message: "records updated successfully." }
} catch (error) {
return { message: "Failed to updated" }
}
}
每当我单独登录用户时,它都可以读取它,但它没有读取任何其他属性(FirstName等),并收到以下错误:绑定参数不得包含未定义的.要传递SQL NULL,请指定JS NULL.
console.log(user)
预览版:
我的路由工作得很好,同样的功能以前也用过,没有任何问题