SpringBoot 集成 SpringSecurity + MySQL + JWT 无太多理论，直接盘一般用于Web管理系统可以先看 SpringBoot SpringSecurity 基于内存的使用介绍本文介绍如何整合 SpringSecurity + MySQL + JWT
(相关资料图)
数据库脚本：https://gitee.com/VipSoft/VipBoot/blob/develop/vipsoft-security/sql/Security.sql常规权限管理数据结构设计，三张常规表：用户、角色、菜单，通过用户和角色的关系，角色和菜单（权限）的关系，实现用户和菜单（按钮）的访问控制权
用户登录SecurityConfig 中添加登录接口匿名访问配置POST 登录接口
.antMatchers("/auth/login", "/captchaImage").anonymous()BCryptPasswordEncoder密码加密方式
/auth/login实现调用
AuthorizationController.login用户登录接口做入参、图形验证码等验证。
UserDetailsService接口密码验证根据用户名，去数据库获取用户信息、权限获取等
通过JWT 生成 Token
AuthorizationService.login调用authenticationManager.authenticate(authenticationToken)看密码是否正确可以在此集合 Redis 做失败次数逻辑处理
返回Map对象给前端接口权限认证获取调用
jwtUtil.generateToken(userId)生成Token令牌将 用户信息放入 Redis剔除其它已登录的用户（如果需要）
request.getHeader中的token信息接口权限配置AuthenticationTokenFilter.doFilterInternal解析 Token 中的用户ID 去 Redis 缓存中获取用户信息将信息赋到
SecurityContextHolder.getContext().setAuthentication(authenticationToken)中，供权限验证获取用户信息使用, SecurityContextHolder使用了ThreadLocal机制来保存每个使用者的安全上下文
访问权限控制
UserController类的方法上，加了@PreAuthorize("@ps.hasAnyPermi("system:user:list")")用来做权限控制
用户登录代码
PermissionService.hasAnyPermi判断，用户所拥有的权限，是否包含@PreAuthorize("@ps.hasAnyPermi("system:user:list")")中配置的权限，包含则有权访问
SecurityConfig
package com.vipsoft.web.config;import com.vipsoft.web.security.AuthenticationEntryPointImpl;import com.vipsoft.web.security.AuthenticationTokenFilter;import com.vipsoft.web.security.LogoutSuccessHandlerImpl;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.context.annotation.Bean;import org.springframework.context.annotation.Configuration;import org.springframework.http.HttpMethod;import org.springframework.security.authentication.AuthenticationManager;import org.springframework.security.config.annotation.authentication.builders.AuthenticationManagerBuilder;import org.springframework.security.config.annotation.method.configuration.EnableGlobalMethodSecurity;import org.springframework.security.config.annotation.web.builders.HttpSecurity;import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;import org.springframework.security.config.annotation.web.configuration.WebSecurityConfigurerAdapter;import org.springframework.security.config.http.SessionCreationPolicy;import org.springframework.security.core.userdetails.UserDetailsService;import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;import org.springframework.security.web.authentication.UsernamePasswordAuthenticationFilter;@Configuration@EnableWebSecurity@EnableGlobalMethodSecurity(prePostEnabled = true, securedEnabled = true)public class SecurityConfig extends WebSecurityConfigurerAdapter { /** * 自定义用户认证逻辑 */ @Autowired private UserDetailsService userDetailsService; /** * 认证失败处理类 */ @Autowired private AuthenticationEntryPointImpl unauthorizedHandler; /** * 退出处理类 */ @Autowired private LogoutSuccessHandlerImpl logoutSuccessHandler; /** * token认证过滤器 */ @Autowired private AuthenticationTokenFilter authenticationTokenFilter; /** * 解决 无法直接注入 AuthenticationManager * * @return * @throws Exception */ @Bean @Override public AuthenticationManager authenticationManagerBean() throws Exception { return super.authenticationManagerBean(); } /** * 强散列哈希加密实现 * 必须 Bean 的形式实例化，否则会报 ：Encoded password does not look like BCrypt */ @Bean public BCryptPasswordEncoder bCryptPasswordEncoder() { return new BCryptPasswordEncoder(); } /** * 配置用户身份的configure()方法 * * @param auth * @throws Exception */ @Override protected void configure(AuthenticationManagerBuilder auth) throws Exception { auth.userDetailsService(userDetailsService).passwordEncoder(bCryptPasswordEncoder()); } /** * 配置用户权限的configure()方法 * * @param httpSecurity * @throws Exception */ @Override protected void configure(HttpSecurity httpSecurity) throws Exception { httpSecurity // 禁用 CSRF，因为不使用session .csrf().disable() // 认证失败处理类 .exceptionHandling().authenticationEntryPoint(unauthorizedHandler).and() // 基于token，所以不需要session .sessionManagement().sessionCreationPolicy(SessionCreationPolicy.STATELESS).and() // 过滤请求 .authorizeRequests() // 对于登录login 验证码captchaImage 允许匿名访问 .antMatchers("/auth/login", "/captchaImage").anonymous() .antMatchers( HttpMethod.GET, "/*.html", "/**/*.html", "/**/*.css", "/**/*.js", "/webSocket/**" ).permitAll() // swagger 文档 .antMatchers("/swagger-ui.html").permitAll() .antMatchers("/swagger-resources/**").permitAll() .antMatchers("/webjars/**").permitAll() .antMatchers("/*/api-docs").permitAll() .antMatchers("/druid/**").permitAll() // 放行OPTIONS请求 .antMatchers(HttpMethod.OPTIONS, "/**").permitAll() // 所有请求都需要认证 .anyRequest().authenticated() // .and().apply(this.securityConfigurerAdapter()); .and() //设置跨域, 如果不设置, 即使配置了filter, 也不会生效 .cors() .and() .headers().frameOptions().disable(); httpSecurity.logout().logoutUrl("/logout").logoutSuccessHandler(logoutSuccessHandler); // 添加JWT filter httpSecurity.addFilterBefore(authenticationTokenFilter, UsernamePasswordAuthenticationFilter.class); }}AuthenticationController.login
public Map login(SysUser user) { String username = user.getUserName(); String password = user.getPassword(); Authentication authentication; try { //该方法会去调用UserDetailsServiceImpl.loadUserByUsername UsernamePasswordAuthenticationToken authenticationToken = new UsernamePasswordAuthenticationToken(username, password); authentication = authenticationManager.authenticate(authenticationToken); } catch (AuthenticationException ex) { Long incr = 3L; // Redis 实现 if (incr > 5) { logger.error("{} 账户连续{}次登录失败，账户被锁定30分钟", username, incr); throw new LockedException("密码连续输入错误次数过多，账户已被锁定!"); } throw new BadCredentialsException("您输入的用户名、密码或验证码不正确，为保证账户安全，连续5次输入错误，系统将锁定您的账户30分钟，当前剩余:" + (PASSOWRD_MAX_ERROR_COUNT - incr) + "次", ex); } SecurityContextHolder.getContext().setAuthentication(authentication); LoginUser loginUser = (LoginUser) authentication.getPrincipal(); String userId = loginUser.getUser().getUserId().toString(); // 生成令牌 String token = jwtUtil.generateToken(userId); Map resultMap = new HashMap(); resultMap.put("AccessToken", token); resultMap.put("UserId", userId); // Redis 保存上线信息 // UserAgent userAgent // 踢掉已登录用户 return resultMap;} UserDetailsServiceImpl
@Servicepublic class UserDetailsServiceImpl implements UserDetailsService { Logger logger = LoggerFactory.getLogger(this.getClass()); @Autowired private ISysUserService userService; @Autowired private ISysMenuService menuService; @Override public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException { SysUser user = userService.selectUserByUserName(username); if (user == null) { logger.info("登录用户：{} 不存在.", username); throw new UsernameNotFoundException("登录用户：" + username + " 不存在"); } else if ("1".equals(user.getDelFlag())) { logger.info("登录用户：{} 已被删除.", username); throw new CustomException("对不起，您的账号：" + username + " 已被删除"); } else if ("1".equals(user.getStatus())) { logger.info("登录用户：{} 已被停用.", username); throw new CustomException("对不起，您的账号：" + username + " 已停用"); } Set perms = new HashSet<>(); // 管理员拥有所有权限 if (user.isAdmin()) { perms.add("*:*:*"); } else { perms.addAll(menuService.selectMenuPermsByUserId(user.getUserId())); } return new LoginUser(user, perms); }} @Overrideprotected void doFilterInternal(HttpServletRequest request, HttpServletResponse response, FilterChain chain) throws ServletException, IOException { LoginUser loginUser = jwtUtil.getLoginUser(request); if (loginUser != null && SecurityUtils.getAuthentication() == null) { jwtUtil.verifyToken(loginUser); UsernamePasswordAuthenticationToken authenticationToken = new UsernamePasswordAuthenticationToken(loginUser, null, loginUser.getAuthorities()); authenticationToken.setDetails(new WebAuthenticationDetailsSource().buildDetails(request)); //SecurityContextHolder使用了ThreadLocal机制来保存每个使用者的安全上下文，确保PermissionService判断权限时可以获得当前LoginUser信息 SecurityUtils.setAuthentication(authenticationToken); } chain.doFilter(request, response);}}
定义权限验证类 `PermissionService````javapackage com.vipsoft.web.security;import cn.hutool.core.util.StrUtil;import com.vipsoft.web.utils.SecurityUtils;import org.springframework.stereotype.Service;import org.springframework.util.CollectionUtils;import java.util.Arrays;import java.util.Set;/** * 自定义权限实现 */@Service("ps")public class PermissionService { /** * 所有权限标识 */ private static final String ALL_PERMISSION = "*:*:*"; /** * 管理员角色权限标识 */ private static final String SUPER_ADMIN = "admin"; private static final String ROLE_DELIMETER = ","; private static final String PERMISSION_DELIMETER = ","; /** * 对用户请求的接口进行验证，看接口所需要的权限，当前用户是否包括 * * @param permissions 以 PERMISSION_NAMES_DELIMETER 为分隔符的权限列表，如：system:user:add,system:user:edit * @return 用户是否具有以下任意一个权限 */ public boolean hasAnyPermi(String permissions) { if (StrUtil.isEmpty(permissions)) { return false; } LoginUser loginUser = SecurityUtils.getCurrentUser(); //去SecurityContextHolder.getContext()中获取登录用户信息 if (loginUser == null || CollectionUtils.isEmpty(loginUser.getPermissions())) { return false; } Set authorities = loginUser.getPermissions(); String[] perms = permissions.split(PERMISSION_DELIMETER); boolean hasPerms = Arrays.stream(perms).anyMatch(authorities::contains); //是Admin权限 或者 拥有接口所需权限时 return permissions.contains(ALL_PERMISSION) || hasPerms; }} 详细代码见：https://gitee.com/VipSoft/VipBoot/tree/develop/vipsoft-security源代码摘自：若依后台管理系统