Springboot使用druid数据源

引入druid stater

<dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.21</version>
        </dependency>

配置数据库连接必要参数

spring:
  datasource:
    username: root
    password: root
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/test

以上配置好就可以直接使用。当然关于druid的其他功能配置还有很多。参考官方github:
druid stater github地址
druid datasource github地址
druid datasource配置参数详情地址

Spring Boot中druid配置数据库密码加密

找到druid的jar包所在位置

/usr/local/apache-maven-3.6.1/repository/com/alibaba/druid/1.1.21

执行加密

java -cp druid-1.1.21.jar com.alibaba.druid.filter.config.ConfigTools 123(123为数据库的密码)

生成加密信息,privateKey、publicKey、password

privateKey:MIIBVAIBADANBgkqhkiG9w0BAQEFAASCAT4wggE6AgEAAkEAhIm/RmuaWFn5QCeO9E3cD5JVmcDUgs+2as2uRpP9MjV3T1bwiXIhxNnHN6Bu5I5A48enn4NVACoifGr6AQUkEwIDAQABAkBTqHrioVLoR8qLkyypymeIMK71gQDinOeg3LkPdaQRR0LXiC8l3MLY9pfxBlYDYsnmoL+EOvGPvqUF/1HX+nWxAiEAyUK7MJ1NtpOTIJkB0r3IQkUR4BMzzNqVIC1+fMenHgkCIQColglTTSwkzlzBvXFb/zYlrE1dt/L9e5tz42C110V4OwIgWQ9/mFaz0gxh+fXbea9j0/eOnnLA5HEBtriLFZqgGEkCIQCRTQdqkZgbfPU7UnEyrmtX2wKvZMz8pp2cK3x+HbVVYwIgOLLUzTKk49YgTxIS+nAbUKvVR+OaofnMefeN1FtD5Zc=
publicKey:MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAISJv0ZrmlhZ+UAnjvRN3A+SVZnA1ILPtmrNrkaT/TI1d09W8IlyIcTZxzegbuSOQOPHp5+DVQAqInxq+gEFJBMCAwEAAQ==
password:T2a77rZHnfvpHoBKXq+Notdnp5hVSB0DFnO/g/DkJPHFb7qGOAk6uj9JoXRGU8F0IscffYVCMhGYFETJAZuKmw==

在yaml文件中配置加密信息

spring:
  datasource:
    username: root
    #这里的password为上一步加密生成的密码
    password: T2a77rZHnfvpHoBKXq+Notdnp5hVSB0DFnO/g/DkJPHFb7qGOAk6uj9JoXRGU8F0IscffYVCMhGYFETJAZuKmw==
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/test
    druid:
    #这里config.decrypt.key为上一步生成的公钥
      connection-properties: config.decrypt=true;config.decrypt.key=MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAISJv0ZrmlhZ+UAnjvRN3A+SVZnA1ILPtmrNrkaT/TI1d09W8IlyIcTZxzegbuSOQOPHp5+DVQAqInxq+gEFJBMCAwEAAQ==
      filter:
        config:
          enabled: true

参考链接：https://github.com/alibaba/druid/wiki/%E5%A6%82%E4%BD%95%E5%9C%A8Spring-Boot%E4%B8%AD%E9%85%8D%E7%BD%AE%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AF%86%E7%A0%81%E5%8A%A0%E5%AF%86%EF%BC%9F

Spring boot配置监控

      web-stat-filter:
        enabled: true
        exclusions: /druid/*,*.js,*.gif,*.jpg,*.png,*.css,*.ico
        url-pattern: /*
      stat-view-servlet:
        url-pattern: /druid/*
        login-username: druid
        login-password: druid
        reset-enable: true
        enabled: true
      filters: stat,wall,log4j2

然后打开http://localhost:8080/druid/index.html监控台页面
参考官方文档:https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
或
https://blog.csdn.net/justlpf/article/details/80728529