Error updating database. Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'status = 1 where id = 4' at line 17 ### The error may exist in file [D:\Graduation_project\Java-sport\target\classes\mapper\SysMenuMapper.xml] ### The error may involve com.example.javasport.mapper.SysMenuMapper.update-Inline ### The error occurred while setting parameters ### SQL: update sys_menu SET path = ?, icon = ?, title = ?, component = ?, parent_id = ? status = ? where id = ? ### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'status = 1 where id = 4' at line 17 ; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'status = 1 where id = 4' at line 17

这个错误是由于SQL语法错误引起的。根据错误信息，问题出在以下这段SQL语句中：

update sys_menu SET path = ?, icon = ?, title = ?, component = ?, parent_id = ? status = ? where id = ?

在这段SQL语句中，缺少了逗号(,)将`parent_id`和`status`字段分隔开，导致了SQL语法错误。正确的SQL语句应该是：

update sys_menu SET path = ?, icon = ?, title = ?, component = ?, parent_id = ?, status = ? where id = ?

请在`SysMenuMapper.xml`文件中找到这段SQL语句并进行修正，添加逗号(,)分隔`parent_id`和`status`字段即可解决这个问题。