可看出是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。