代码拉取完成,页面将自动刷新
删除角色报错
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'role' in 'field list'
### The error may exist in com/mdd/common/mapper/system/SystemAuthAdminMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id,role,nickname FROM la_system_auth_admin WHERE (role = ? AND is_delete = ?)
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'role' in 'field list'
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'role' in 'field list'
错误代码
Assert.isNull(systemAuthAdminMapper.selectOne(new QueryWrapper<SystemAuthAdmin>()
.select("id", "role", "nickname")
.eq("role", id)
.eq("is_delete", 0)),
"角色已被管理员使用,请先移除");
正确代码:
Assert.isNull(systemAuthAdminMapper.selectOne(new QueryWrapper<SystemAuthAdmin>()
.select("id", "role", "nickname")
.apply("find_in_set({0}, role_ids)", id)
.eq("is_delete", 0)),
"角色已被管理员使用,请先移除");
另外:建议role表也加上逻辑删除,现在直接是物理删除。岗位和部门都采用逻辑删除,角色直接物理删除,后期排查问题也没法追溯