- 可看出是sql语句字段格式不对写Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘userId’ in ‘where clause’
- 解决方法:
<delete id="deleteUserAndRoleById" parameterType="Integer"> delete from t_base_user_role where userId=#{id} </delete>
3. <delete id="deleteUserAndRoleById" parameterType="Integer"> delete from t_base_user_role where USER_ID=#{id} </delete>
4.数据库字段名为USER_ID,而不是userId。