springboot 整合druid

springboot 整合druid数据源

1. 在pom文件中引入druid

2.   <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.16</version>
       </dependency>
   

3. 配置applicatuion.yml

4. spring:
     datasource:
       username: root
       password: 123456
       url: jdbc:mysql:///springboot?characterEncoding=utf8&useSSL=false
       driver-class-name: com.mysql.jdbc.Driver
       type: com.alibaba.druid.pool.DruidDataSource
       initialSize: 5
       minIdle: 5
       maxActive: 20
       maxWait: 60000
       timeBetweenEvictionRunsMillis: 60000
       minEvictableIdleTimeMillis: 300000
       validationQuery: SELECT 1 FROM DUAL
       testWhileIdle: true
       testOnBorrow: false
       testOnReturn: false
       poolPreparedStatements: true
   

5. 上面虽然定义了druid的初始化内容，但是springbooot默认的datasource还不能识别，所以，新建一个DruidConfig.java类，作为Druid的配置类

6. @Configuration
   public class DruidConfig { //druid配置类
       //把配置文件里spring.datasource下面的配置读取到DruidDatasource中，并把这个DataSource注入容器即可
       @ConfigurationProperties(prefix = "spring.datasource")
       @Bean
       public DataSource druid() { 
           return new DruidDataSource();
       }
   }
   

7. 现在就可以使用JdbcTemplate了