連接數(shù)據(jù)庫認(rèn)證

• 前邊的例子我們是將用戶信息存儲(chǔ)在內(nèi)存中，實(shí)際項(xiàng)目中用戶信息存儲(chǔ)在數(shù)據(jù)庫中，本節(jié)實(shí)現(xiàn)從數(shù)據(jù)庫讀取用戶信息。根據(jù)前邊對(duì)認(rèn)證流程研究，只需要重新定義UserDetailService即可實(shí)現(xiàn)根據(jù)用戶賬號(hào)查詢數(shù)據(jù)庫。

創(chuàng)建數(shù)據(jù)庫

• 創(chuàng)建user_db數(shù)據(jù)庫

CREATE DATABASE `user_db` CHARACTER set `utf8` COLLTE `utf8_general_ci`;

• 創(chuàng)建t_user表

CREATE TABLE `t_user` (
  `id` bigint(20) NOT NULL COMMENT '用戶id',
  `username` varchar(64) NOT NULL,
  `password` varchar(64) NOT NULL,
  `fullname` varchar(255) NOT NULL COMMENT '用戶姓名',
  `mobile` varchar(11) DEFAULT NULL COMMENT '手機(jī)號(hào)',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

代碼實(shí)現(xiàn)

• 1）定義dataSource
• 在application.yml配置

spring:
  datasource:
    driver-class-name:
    username: root
    password: 123456
    url: jdbc:mysql://localhost:3306/user_db

• 2）添加依賴

<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.47</version>
</dependency>

• 3）定義Dao
• 定義模型類型，在model包定義UserDao

@Repository
public class UserDao {

    @Autowired
    JdbcTemplate jdbcTemplate;

    //根據(jù)賬號(hào)查詢用戶信息
    public UserDto getUserByUsername(String username){
        String sql="select id,username,password,fullname,mobile from t_user where username=?";
        //連接數(shù)據(jù)庫查詢用戶
        List<UserDto> list = jdbcTemplate.query(sql, new Object[]{username}, new BeanPropertyRowMapper<>(UserDto.class));
        if (list!=null && list.size()==1){
            return list.get(0);
        }
        return null;
    }
}

定義UserDetailService

• 在service包下定義SpringDataUserDetailsService：

@Service
public class SpringDataUserDetailsService implements UserDetailsService {

    @Autowired
    UserDao userDao;

    @Override
    public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
        //登錄賬號(hào)
        System.out.println("username="+username);
        //根據(jù)賬號(hào)去數(shù)據(jù)庫查詢
        UserDto user = userDao.getUserByUsername(username);
        if (user==null){
            //如果用戶查不到，返回null，由provider拋出異常
            return null;
        }
        //暫時(shí)采用模擬方式
        UserDetails userDetails = User.withUsername(user.getUsername()).password(user.getPassword()).authorities("p1").build();
        return userDetails;
    }
}

WebSecurityConfig配置userDetailsService

@Autowired
public void configureGlobal(AuthenticationManagerBuilder auth) throws Exception {
    auth.userDetailsService(userDetailsService).passwordEncoder(passwordEncoder());
    /* 向DaoAuthenticationProvider提交用戶信息 */
}