步驟一:先生成加密的密碼:
步驟二:配置application.yaml文件:
spring:datasource:driver-class-name: com.mysql.cj.jdbc.Drivertype: com.alibaba.druid.pool.DruidDataSourcedruid:username: rootpassword: aPJ35s+aFz6ASmnmNtW2F8ttxru9mNCuX0upxY8N4dpT/vY//4rDRpClt784GtP5wXm2tRUQgbMNudQryvCR+A==url: jdbc:mysql://xx.xx.xxx.xxx:3306/cityinfo?useUnicode=true&characterEncoding=utf8&serverTimezone=UTCinitial-size: 5min-idle: 5max-active: 20max-wait: 60000time-between-eviction-runs-millis: 60000min-evictable-idle-time-millis: 300000validation-query: SELECT 1 FROM DUALtest-while-idle: truetest-on-borrow: falsetest-on-return: falsepool-prepared-statements: false#配置監控統計攔截的filters,stat:監控統計、log4j:?志記錄、wall:防御sql注入#如果允許時報錯 java.lang.ClassNotFoundException: org.apache.log4j.Priority#則導入 log4j 依賴即可,Maven 地址:https://mvnrepository.com/artifact/log4j/log4jfilters: stat,wall,log4j,config#指定每個連接上PSCache的大小max-pool-prepared-statement-per-connection-size: 20#合并多個DruidDataSource的監控數據,多數據源做主從時使用use-global-data-source-stat: true#通過connectProperties屬性來打開mergeSql功能;慢SQL記錄connect-properties:druid.stat.logSlowSql: truedruid.stat.slowSqlMillis: 5000config.decrypt: trueconfig.decrypt.key: MFwwDQYJKoZIhvcNAQEBBQADSwAwSAJBAJAg7cxPhDRczpTuqjnHgZlfztB4gwCxso+Ysz+Ohw4tshdDLmP9ziTj3DEyWkBbsR3Dte4X10xa6oh1nvZkyj0CAwEAAQ==
# config.decrypt.key: ${your_public_key}