npm install canvas@2.9.3  --canvas_binary_host_mirror=https://registry.npmmirror.com/-/binary/canvas

1、canvas@2.9.3 依赖安装失败解决方案

先执行

npm install canvas@2.9.3  --canvas_binary_host_mirror=https://registry.npmmirror.com/-/binary/canvas

再下载其他依赖

npm install --registry=https://registry.npmmirror.com

2、MyBatisPlus报错 BindingException: Invalid bound statement

原因是该SSM项目之前的包名前缀是 com

要改成 com.example

3、前端跨域问题

在其拦截器里添加代码

package com.example.interceptor;

import com.alibaba.fastjson.JSONObject;
import com.example.annotation.IgnoreAuth;
import com.example.entity.TokenEntity;
import com.example.service.TokenService;
import com.example.utils.R;
import org.apache.commons.lang3.StringUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.web.method.HandlerMethod;
import org.springframework.web.servlet.HandlerInterceptor;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.PrintWriter;

/**
 * 权限(Token)验证
 */
@Component
public class AuthorizationInterceptor implements HandlerInterceptor {

    public static final String LOGIN_TOKEN_KEY = "Token";

    @Autowired
    private TokenService tokenService;

	@Override

    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        System.out.println(request.getRequestURI());

        // 1. 优先处理 OPTIONS 请求 (对于所有需要CORS的路径)
        if (request.getMethod().equalsIgnoreCase("OPTIONS")) {
            response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE, PUT, PATCH"); // 包含你所有支持的方法
            response.setHeader("Access-Control-Max-Age", "3600");
            response.setHeader("Access-Control-Allow-Credentials", "true");
            // 注意这里的 Token (移除了反引号)
            response.setHeader("Access-Control-Allow-Headers", "x-requested-with,request-source,Token,Origin,imgType,Content-Type,cache-control,postman-token,Cookie,Accept,authorization");
            response.setHeader("Access-Control-Allow-Origin", request.getHeader("Origin"));
            response.setStatus(HttpServletResponse.SC_OK); // 返回 200 OK
            return false; // 结束请求处理，不继续向下执行
        }


        String servletPath = request.getServletPath();
        if("/dictionary/page".equals(request.getServletPath())  || "/file/upload".equals(request.getServletPath()) || "/yonghu/register".equals(request.getServletPath()) ){//请求路径是字典表或者文件上传 直接放行
            return true;
        }
        //支持跨域请求
        response.setHeader("Access-Control-Allow-Methods", "POST, GET, OPTIONS, DELETE, PUT, PATCH");
        response.setHeader("Access-Control-Max-Age", "3600");
        response.setHeader("Access-Control-Allow-Credentials", "true");
        response.setHeader("Access-Control-Allow-Headers", "x-requested-with,request-source,`Token`, Origin,imgType, Content-Type, cache-control,postman-token,Cookie, Accept,authorization");
        response.setHeader("Access-Control-Allow-Origin", request.getHeader("Origin"));

        IgnoreAuth annotation;
        if (handler instanceof HandlerMethod) {
            annotation = ((HandlerMethod) handler).getMethodAnnotation(IgnoreAuth.class);
        } else {
            return true;
        }

        //从header中获取token
        String token = request.getHeader(LOGIN_TOKEN_KEY);

        /**
         * 不需要验证权限的方法直接放过
         */
        if(annotation!=null) {
        	return true;
        }

        TokenEntity tokenEntity = null;
        if(StringUtils.isNotBlank(token)) {
        	tokenEntity = tokenService.getTokenEntity(token);
        }

        if(tokenEntity != null) {
        	request.getSession().setAttribute("userId", tokenEntity.getUserid());
        	request.getSession().setAttribute("role", tokenEntity.getRole());
        	request.getSession().setAttribute("tableName", tokenEntity.getTablename());
        	request.getSession().setAttribute("username", tokenEntity.getUsername());
        	return true;
        }

		PrintWriter writer = null;
		response.setCharacterEncoding("UTF-8");
		response.setContentType("application/json; charset=utf-8");
		try {
		    writer = response.getWriter();
		    writer.print(JSONObject.toJSONString(R.error(401, "请先登录")));
		} finally {
		    if(writer != null){
		        writer.close();
		    }
		}
//				throw new EIException("请先登录", 401);
		return false;
    }
}

4、HTML+jQuery项目怎么在VsCode里运行到8081端口

• 在 VS Code 左侧扩展栏搜索 Live Server，点击 Install 安装。
• 打开 VS Code 设置，搜索 Live Server Settings
• 点击 Edit in setting.json
• 添加一行     "liveServer.settings.port": 8081,