Mybatis时update报错：SQL: UPDATE menu_info WHERE menuId = ?-优快云博客

本文链接：https://blog.youkuaiyun.com/qq3434569/article/details/88717700

博客指出state为int类型时，若值为0会被判定为‘ ’的问题。给出的解决方案是删掉 state!= ''，修改后的代码为 <if test=\state!= null >state=#{state},</if> 。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'WHERE menuId = 1' at line 3\r\n### The error may involve com.centerm.usermanager.mapper.MenuMapper.updateMenu-Inline\r\n### The error occurred while setting parameters\r\n### SQL: UPDATE menu_info        WHERE menuId = ?\r\n### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'WHERE menuId = 1' at line 3\n; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'WHERE menuId = 1' at line 3",

<if test="state != null and state != ''">state=#{state},</if>

原因：state为int类型，如果state的值为0，会被判定为‘ ’。

解决方案：删掉 state != ''" 结果如下

<if test="state != null >state=#{state},</if>