Druid是一个非常好用的数据库连接池,但是他的好并不止体现在作为一个连接池加快数据访问性能上和连接管理上,他带有一个强大的监控工具:Druid Monitor。不仅可以监控数据源和慢查询,还可以监控Web应用、URI监控、Session监控、Spring监控。
1.添加依赖
<!--druid-spring-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>1.1.10</version>
</dependency>
2.配置文件
spring:
# Druid数据源配置(Oracle版本)
datasource:
url: jdbc:oracle:thin:@www.jyglxt.com:1521:xe
username: JYGLXT
password: oracle
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: oracle.jdbc.driver.OracleDriver
druid:
max-active: 100
initial-size: 3
min-idle: 3
max-wait: 30000
time-between-eviction-runs-millis: 60000
min-evictable-idle-time-millis: 30000
pool-prepared-statements: true
max-open-prepared-statements: 30
test-while-idle: true
test-on-borrow: false
test-on-return: false
filter:
wall:
enabled: true
stat:
enabled: true
log-slow-sql: true
slow-sql-millis: 10000
merge-sql: true
web-stat-filter:
enabled: true
url-pattern: /*
exclusions: /*.js,/*.gif,/*.jpg,/*.bmp,/*.png,/*.css,/*.ico,/druid/*
session-stat-enable: true
profile-enable: true
stat-view-servlet:
login-password: caixibei
login-username: caixibei
3.启动类修改
@SpringBootApplication(scanBasePackages = "cn.jxd.caixibei")
@ComponentScan(basePackages = "cn.jxd.caixibei")
@MapperScan(basePackages = "cn.jxd.caixibei.mapper")
@EnableOpenApi
@Slf4j
public class JyglxtApplication {
public static void main(String[] args) {
ConfigurableApplicationContext context = SpringApplication.run(JyglxtApplication.class, args);
Environment environment = context.getBean(Environment.class);
log.info("---------------------------------------------------------");
log.info("系统访问路径:http://localhost:"+environment.getProperty("server.port")+"/jyglxt/index/");
log.info("Swagger访问路径:http://localhost:"+environment.getProperty("server.port")+"/swagger-ui/");
log.info("WebSocket测试路径:ws://localhost:"+environment.getProperty("server.port")+"/ws/api/10/");
log.info("SQL监控平台:http://localhost:"+environment.getProperty("server.port")+"/druid/");
log.info("---------------------------------------------------------");
}
}
启动类其实没动啥,就是把访问地址打印了一下.🤣