1、加载druid依赖和数据库的相关依赖
例:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.6</version>
</dependency>
2、在application.yml中设置数据源:
spring:
datasource:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123123
url: jdbc:mysql://localhost:3306/user?serverTimezone=UTC
type: com.alibaba.druid.pool.DruidDataSource
# 在该文件中还可设置多个数据源的配置,此处就不细说了
3、在config中创建druid配置类
package com.springboot02.config;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import javax.sql.DataSource;
import java.util.HashMap;
@Configuration
public class DruidConfig {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource druidDataSource(){
return new DruidDataSource();
}
//设置后台监控,需要加载进容器中
@Bean
public ServletRegistrationBean servletRegistrationBean(){
ServletRegistrationBean<StatViewServlet> servletRegistrationBean
= new ServletRegistrationBean<>(new StatViewServlet(),"/druid/*");
//后台需要登录,进行账号密码的配置
HashMap<String, String> map = new HashMap<>();
//设置用户名和密码(map的key是固定的)
map.put("loginUsername","admin");
map.put("loginPassword","admin");
//允许访问的用户--->""为所有人都可
map.put("allow","");
//加载
servletRegistrationBean.setInitParameters(map);
return servletRegistrationBean;
}
}
4、在地址栏中输入http://localhost:8080/druid/
将会进入druid监控页面,进行登录即可: