Druid是Java语言中最好的数据库连接池,提供强大的监控和扩展功能。
配置完成后,访问 项目地址/
+druid/
+login.html
application.yaml 文件配置
# 本地开发
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/tqj_sys?useUnicode=true&characterEncoding=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=UTC&allowMultiQueries=true
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
配置代码
package com.lzby.tqj.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 javax.sql.DataSource;
import java.util.HashMap;
import java.util.Map;
/**
* Druid数据源配置
*
* @Author: TangHX
* @date 2021/11/26 20:52
**/
public class DruidConfig {
/**
* 读取 application.yaml 里面数据源的配置
*/
@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druidDataSource() {
return new DruidDataSource();
}
@Bean
public ServletRegistrationBean statViewServlet() {
ServletRegistrationBean<StatViewServlet> statViewServlet = new ServletRegistrationBean<>(new StatViewServlet());
// 初始化参数设置
Map<String, String> initParameters = new HashMap<>();
initParameters.put("loginUsername", "admin");
initParameters.put("loginPassword", "123456");
// 白名单
initParameters.put("allow", "");
statViewServlet.setInitParameters(initParameters);
return statViewServlet;
}
}