cg-market

本项目原本是python项目，现在转成java项目，很多语法不太熟悉，本项目是为了熟悉java语法而生。 记录一下忘记的点

project framework

cg-java-api是web项目

package	version	remark
java SDK	17
springboot	3.2.12-SNAPSHOT	web框架
mybatis-plus	3.5.9	操作数据库
httpclient5	5.2.1	http请求
fastjson2	2.0.53	JSON操作
jjwt	0.12.5	jwt加密，（注意：JDK17不支持0.9以前的版本，以及代码有差异）

实现的功能

1. Jwt加密解密
2. 拦截器

Question Set

Mybatis mapper中如何传入List和接收使用这个List

e.g.

// UserPermissionMapper.class

public interface UserPermissionMapper extends BaseMapper<AuthPermission> {

    List<UserPermissionBase> getUserPermissionListByRoleId(List<String> roleIds);
}

<!-- UserPermissionMapper.xml -->
 <select id="getUserPermissionListByRoleId"  resultMap="UserPermissionMap">
        SELECT auth_permission.permission_id as permission_id, auth_permission.permission_name as permission_name
        FROM role_permission
        LEFT JOIN auth_permission ON role_permission.permission_id = auth_permission.permission_id
        WHERE role_permission.role_id IN (
        <foreach collection="roleIds" item="roleId" separator=",">
            #{roleId}
        </foreach>
        )
    </select>

实现拦截器

1. 实现HandlerInterceptor

public class AuthInterceptor implements HandlerInterceptor {
    @Autowired
    GlobalConfiguration globalConfiguration;

    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        String token = request.getHeader("Auth-Token");
        // 向controller传入参数， controller使用 RequestAttribute("token") String token接收
        request.setAttribute("token", token);
        return true;
    }
}

2. 注册Interceptor

@Configuration
public class WebConfiguration implements WebMvcConfigurer {

    @Autowired
    private AuthInterceptor authInterceptor;

    @Override
    public void addInterceptors(InterceptorRegistry registry) {
        registry.addInterceptor(authInterceptor)
                .addPathPatterns("/**")
                .excludePathPatterns("/user/wechat/login");
    }
}