更新用户是报错

Question

更新用户时报错

Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘operator’ cannot be null

The error may involve com.cole.dao.SysUserMapper.updateByPrimaryKey-Inline

The error occurred while setting parameters

SQL: update sys_user set username = ?, telephone = ?, mail = ?, password = ?, dept_id = ?, status = ?, remark = ?, operator = ?, operate_time = ?, operate_ip = ? where id = ?

Cause: java.sql.SQLIntegrityConstraintViolationException: Column ‘operator’ cannot be null

; SQL []; Column ‘operator’ cannot be null; nested exception is java.sql.SQLIntegrityConstraintViolationException: Column ‘operator’ cannot be null

网页上测试的地址：
http://localhost:8080/sys/user/update.json?username=Admin&telephone=767985664711&mail=[e-mail]&deptId=1&status=1&remark=u&id=1

Answer 1

Jimin 2020-07-12 00:26:08

你好，你可以把更新的operator这个字段赋值一个值，比如当前登录的用户名，也可以将数据库里该字段设置为允许为null，就可以了

• 提问者 weixin_慕标4370201 #1

  非常感谢！我将三个关于operator的值设置为NOT NULL就可以了