SpringBoot之整合Druid数据源

SpringBoot之整合Druid数据源

1.导入Druid数据源pom依赖

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.23</version>
        </dependency>

2.更改默认数据源

springboot2默认数据源使用HikariCP, 我们可以在springboot配置文件中更改这个配置

spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

3.配置连接数据库的必备参数

spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis
spring.datasource.driver-class-name=com.mysql.jdbc.Driver

4.整合Druid数据源

1. 导入Druid数据源

       @ConfigurationProperties(prefix = "spring.datasource")
       @Bean
       public DataSource dataSource(){
           return new DruidDataSource();
       }
   

2. 配置Druid监控

   1. 配置一个管理后台的Servlet

          @Bean
          public ServletRegistrationBean statViewServlet(){
              ServletRegistrationBean bean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
              Map<String,String> initParams = new HashMap<>();
              initParams.put("loginUsername","admin");
              initParams.put("loginPassword","123456");
              initParams.put("allow","");//默认就是允许所有访问
              initParams.put("deny","192.168.15.21");
              bean.setInitParameters(initParams);
              return bean;
          }
      
      

   2. 配置一个web监控的filter

          @Bean
          public FilterRegistrationBean webStatFilter(){
              FilterRegistrationBean bean = new FilterRegistrationBean();
              bean.setFilter(new WebStatFilter());
              Map<String,String> initParams = new HashMap<>();
              initParams.put("exclusions","*.js,*.css,/druid/*");
              bean.setInitParameters(initParams);
              bean.setUrlPatterns(Arrays.asList("/*"));
              return  bean;
          }
      }