看完这篇文章你还感觉SpringSecurity整合OAuth2自定义查询用户复杂吗？

我们在登录时用户名对应su_login_name字段，而密码则是对应su_password字段，yuqiyu这个用户的密码初始化为123456，密码的格式必须为BCryptPasswordEncoder加密后的密文。

针对system_user表我们需要来创建一个ApiBoot MyBatis Enhance使用的实体，创建一个名为SystemUser的实体如下所示：

@Data
@Table(name = "system_user")
public class SystemUser implements UserDetails {
    
    @Id(generatorType = KeyGeneratorTypeEnum.UUID)
    @Column(name = "su_id")
    private String userId;
    
    @Column(name = "su_login_name")
    private String loginName;
    
    @Column(name = "su_nick_name")
    private String nickName;
    
    @Column(name = "su_password")
    private String password;
    
    @Column(name = "su_create_time")
    private String createTime;
    
    @Column(name = "su_status")
    private Integer status;

    @Override
    public Collection getAuthorities() {
 return Collections.EMPTY_LIST;
    }

    @Override
    public String getUsername() {
 return this.loginName;
    }

    @Override
    public String getPassword() {
 return this.password;
    }

    
    @Override
    public boolean isAccountNonExpired() {
 return true;
    }

    
    @Override
    public boolean isAccountNonLocked() {
 return true;
    }

    
    @Override
    public boolean isCredentialsNonExpired() {
 return true;
    }

    
    @Override
    public boolean isEnabled() {
 return this.status == 1;
    }
}

public interface SystemUserEnhanceMapper extends EnhanceMapper {
    
    SystemUser findByLoginName(@Param("loginName") String loginName);
}

@Service
public class UserService implements ApiBootStoreDelegate {
    
    static Logger logger = LoggerFactory.getLogger(UserService.class);
    
    @Autowired
    private SystemUserEnhanceMapper mapper;

    @Override
    public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
 UserDetails userDetails = mapper.findByLoginName(username);
 if (ObjectUtils.isEmpty(userDetails)) {
     throw new UsernameNotFoundException("用户：" + username + "，不存在.");
 }
 logger.info("登录用户的信息：{}", JSON.toJSONString(userDetails));
 return userDetails;
    }
}

➜ ~ curl hengboy:chapter@localhost:9090/oauth/token -d 'grant_type=password&username=yuqiyu&password=123456'
{"access_token":"3beb1bee-9ca6-45e1-9fb8-5fc181670f63","token_type":"bearer","refresh_token":"d2243e18-8ab3-4842-a98f-ebd79da94e2e","expires_in":7199,"scope":"api"}

➜ ~ curl hengboy:chapter@localhost:9090/oauth/token -d 'grant_type=refresh_token&refresh_token=d2243e18-8ab3-4842-a98f-ebd79da94e2e'
{"access_token":"e842c2ee-5672-49db-a530-329186f36492","token_type":"bearer","refresh_token":"d2243e18-8ab3-4842-a98f-ebd79da94e2e","expires_in":7199,"scope":"api"}