全网最新 SpringBoo 2.6.2 集成 Druid 1.2.8
Springboot 2.6.2
druid-spring-boot-starter 1.2.8
不讲太多,直接撸码
项目结构
pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.6.2</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<groupId>com.xing.admin.base</groupId>
<artifactId>admin-base</artifactId>
<packaging>jar</packaging>
<version>0.0.1-SNAPSHOT</version>
<name>admin-base</name>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<java-version>1.8</java-version>
<druid-version>1.2.8</druid-version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<!-- 数据库连接 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>${druid-version}</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!-- 数据库连接 -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.1</version>
<configuration>
<source>1.8</source>
<target>1.8</target>
</configuration>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
</plugin>
</plugins>
</build>
<!-- 阿里云maven仓库 -->
<repositories>
<repository>
<id>public</id>
<name>aliyun nexus</name>
<url>http://maven.aliyun.com/nexus/content/groups/public/</url>
<releases>
<enabled>true</enabled>
</releases>
</repository>
</repositories>
<pluginRepositories>
<pluginRepository>
<id>public</id>
<name>aliyun nexus</name>
<url>http://maven.aliyun.com/nexus/content/groups/public/</url>
<releases>
<enabled>true</enabled>
</releases>
<snapshots>
<enabled>false</enabled>
</snapshots>
</pluginRepository>
</pluginRepositories>
</project>
AdminBaseApplication
package com.xing.admin.base;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
/**
*
* <p>Title: AdminBaseApplication</p>
* <p>
* Description: 主启动类
* </p>
*
* @version 1.0.0
* @date 2022/1/10 15:22
*/
@SpringBootApplication
public class AdminBaseApplication {
public static void main(String[] args) {
SpringApplication.run(AdminBaseApplication.class, args);
}
}
application.yml
# application.yml
server:
port: 8080
servlet:
context-path: /
spring:
profiles:
active: local
application:
name: admin-base
datasource:
druid:
# 获取链接等待超时时间
max-wait: 60000
pool-prepared-statements: true
#
validation-query: SELECT 1
test-on-borrow: false
test-on-return: false
test-while-idle: true
# 间隔多久进行一次检测,检测须要关闭的空闲链接
time-between-eviction-runs-millis: 60000
# 一个链接在链接池中最小的生存时间
min-evictable-idle-time-millis: 300000
max-pool-prepared-statement-per-connection-size: 20
# 合并多个DruidDataSource的监控数据
use-global-data-source-stat: true
filters: stat
filter:
# 慢SQL记录(sql语句执行时间超过某个界限就记录下来)
stat:
slow-sql-millis: 200
log-slow-sql: true
# 监控配置
# Druid WebStatFilter配置
web-stat-filter:
enabled: true
url-pattern: /*
exclusions: /druid/*,*.gif,*.png,*.jpg,*.html,*.js,*.css,*.ico
# Druid StatViewServlet配置
stat-view-servlet:
enabled: true
url-pattern: /druid/*
# 登陆监控界面的用户名以及密码,登陆url为localhost:8080/druid
login-username: admin
login-password: admin
allow:
deny:
application-local.yml
spring:
###数据源配置
datasource:
type: com.alibaba.druid.pool.DruidDataSource
druid:
url: jdbc:mysql://localhost:3306/ywx_base?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
username: root
password: 123456
driver-class-name: com.mysql.cj.jdbc.Driver
# 链接池配置
# 配置初始化大小、最小、最大
initial-size: 5
max-active: 20
min-idle: 5
Druid 访问地址:http://localhost:8080/druid/index.html,admin/admin