1. 配置Druid
讀音(Dzu::id)跛蛋,也讀作德魯伊
(1) 導(dǎo)入pom
<!-- druid -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.17</version>
</dependency>
(2) yml配置
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://39.100.144.125:3306/hospital-test?autoReconnect=true &useSSL=false &serverTimezone=GMT%2B8 &useUnicode=true&characterEncoding=UTF-8
username: root
password: cpsmysql
#從這下面開始復(fù)制
druid:
#開啟監(jiān)控頁面
stat-view-servlet:
enabled: true
url-pattern: '/druid/*'
#是否可以重置統(tǒng)計(jì)頁面
reset-enable: false
#控制臺(tái)管理用戶
# login-username: yang
# login-password: test
#開啟sql監(jiān)控
web-stat-filter:
#添加過濾規(guī)則
url-pattern: '/*'
#排除一些不必要的url
exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'
enabled: true
#配置profileEnable能夠監(jiān)控單個(gè)url調(diào)用的sql列表
profile-enable: true
#session統(tǒng)計(jì)功能
session-stat-enable: true
filter:
#sql監(jiān)控,不開這個(gè)sql信息出不來
stat:
enabled: true
log-slow-sql: true
slow-sql-millis: 1000
#防止sql注入的
wall:
enabled: false
不過目前好用的配置:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://39.100.144.125:3306/hospital-test?autoReconnect=true &useSSL=false &serverTimezone=GMT%2B8 &useUnicode=true&characterEncoding=UTF-8
username: root
password: 9DZElav^Hf6$qS%2
druid:
stat-view-servlet:
enabled: true
allow:
deny:
(3) 訪問
(4) 官方文檔
https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
https://github.com/alibaba/druid/wiki/%E5%B8%B8%E8%A7%81%E9%97%AE%E9%A2%98