SpringSecurity使用提供的UserDetailService实现连接数据库认证

配置MybatisPlus基础环境

1. 配置pom文件

<!--mysql驱动-->
<dependency>
	<groupId>mysql</groupId>
	<artifactId>mysql-connector-java</artifactId>
	<version>8.0.29</version>
</dependency>

<!--druid数据源-->
<dependency>
	<groupId>com.alibaba</groupId>
	<artifactId>druid</artifactId>
	<version>1.2.5</version>
</dependency>

<!--MybatisPlus映射框架-->
<dependency>
	<groupId>com.baomidou</groupId>
	<artifactId>mybatis-plus-boot-starter</artifactId>
	<version>3.5.1</version>
</dependency>

2. 配置yml文件

server:
  port: 8090
  servlet:
    encoding:
      charset: UTF-8
spring:
  application:
    name: auth
  datasource:
    url: jdbc:mysql://localhost:3306/authdb?serverTimezone=UTC&useUnicode=true&characterEncoding=utf-8&AllowPublicKeyRetrieval=True
    username: root
    password: spy167935842687
mybatis-plus:
  mapper-locations: mapper/*.xml
  configuration:
    log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    map-underscore-to-camel-case: true
  type-aliases-package: com.spyu.auth.entity

3. 用户表

CREATE TABLE `per_user` (
  `user_id` bigint unsigned NOT NULL COMMENT '用户id',
  `user_code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户编码',
  `login_name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '登录名称',
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '用户名称',
  `password` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
  `phone` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '电话',
  `salt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '盐值',
  `pic_url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '头像路径',
  `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '备注',
  `user_create` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户创建时间',
  `user_update` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '用户更新时间',
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC;

4. 生成对应的Mapper文件

# PerUserInfoMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.spyu.auth.dao.PerUserInfoMapper">

</mapper>

# PerUserInfoMapper.java
/**
 * 用户dao
 * @author sunpeiyu
 * @since 2023-06-19
 */
@Mapper
public interface PerUserInfoMapper extends BaseMapper<PerUserInfoEntity> {

}

编写实现了UserDetailService接口的实现类

/**
 * spring security获取数据库返回的结果UserDetail
 * @author sunpeiyu
 * @since 2023-06-19
 */
@Component
public class LoginUserDetailImpl implements UserDetailsService {
    @Autowired
    private PerUserInfoMapper perUserInfoMapper;

    @Override
    public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
        String tip = "用户" + username + "不存在";

        if (StringUtils.isEmpty(username)) {
            throw new CommonException(tip);
        }

        LambdaQueryWrapper<PerUserInfoEntity> queryWrapper = new LambdaQueryWrapper<>();
        queryWrapper.eq(PerUserInfoEntity::getUsername, username);
        PerUserInfoEntity userInfoEntity = perUserInfoMapper.selectOne(queryWrapper);

        if (Objects.isNull(userInfoEntity)) {
            throw new CommonException("用户不存在！");
        }

        PerUserInfoBO perUserInfoBO = new PerUserInfoBO();
        BeanUtils.copyProperties(userInfoEntity, perUserInfoBO);
        return new LoginUserBO(perUserInfoBO);
    }
}

配置一个无加密的编码器

注意：如果不配置编码器，那么就会抛出异常，There is no PasswordEncoder mapped for id “null”

@Configuration
public class SecurityConfig extends WebSecurityConfigurerAdapter {

    /**
     * 注册解码器
     * @return
     */
    @Bean
    public PasswordEncoder passwordEncoder(){
        // return new BCryptPasswordEncoder();
        return NoOpPasswordEncoder.getInstance();
    }
}

测试

数据库：

访问http://localhost:8090/test/boot

登录失败：

---

此处在登录成功后，就返回了业务测试接口的数据，如果失败返回错误提示，要求重新登录

---