spring-boot之（9） jdbc

　　集成Spring-Security后下面就是连接数据库了，Spring-Boot给了默认连接数据的方式。

• 增加依赖

　　<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.21</version>
    </dependency>

• 增加数据库配置

spring:
  datasource:
    url: jdbc:mysql://ip:port/databaseName?useUnicode=true&characterEncoding=utf-8
    username: dbusername
    password: dbpassword
    driver-class-name: com.mysql.jdbc.Driver

• 获取JdbcTemplate

@Component
public class MyJdbcTemplate {

    private JdbcTemplate jdbcTemplate;

    @Autowired
    public void setJdbcTemplate(JdbcTemplate jdbcTemplate){
        this.jdbcTemplate = jdbcTemplate;
    }

    public JdbcTemplate getJdbcTemplate() {
        return jdbcTemplate;
    }
}

• 在登陆验证密码的时候查询用户

@Service
public class SimpleUserDetailService implements UserDetailsService {

    @Autowired
    private MyJdbcTemplate myJdbcTemplate;

    @Override
    public UserDetails loadUserByUsername(String s) throws UsernameNotFoundException {
        Map map = myJdbcTemplate.getJdbcTemplate().queryForMap("select * from user where username='" + s + "'");
        System.out.println(map.get("USERID"));
        return new User("root", "root");
    }
}

• 测试验证

2017-05-03 16:21:17.846  INFO 8980 --- [p-nio-80-exec-1] o.s.web.servlet.DispatcherServlet        : FrameworkServlet 'dispatcherServlet': initialization completed in 102 ms
10000083778910

• 最后参考资料

https://docs.spring.io/spring-boot/docs/current-SNAPSHOT/reference/htmlsingle/#boot-features-sql