关于druid的一些设置(idea版本)
1、首先是加入依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.4</version>
</dependency>
2、applocation.properties
spring.datasource.username=root//账号密码根据自己需求来
spring.datasource.password=z1314520
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis?useSSL=true&serverTimezone=GMT%2B8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
#Spring Boot默认是不注入这些属性值的,需要自己绑定
#druid数据源专有配固
spring.datasource.initialsize=5
spring.datasource.minIdle=5
spring.datasource.maxActive= 20
spring.datasource.maxwait= 60000
spring.datasource.timeBetweenEvictionRunsMillis= 60000
spring.datasource.minEvictableIdleTimeMillis= 300000
spring.datasource.validationQuery= SELECT 1 FROM DUAL
spring.datasource.testWhileIdle= true
spring.datasource.testOnBorrow= false
spring.datasource.testOnReturn= false
spring.datasource.poolPreparedStatements= true
#配置监控统计拦截的filters,stat: 监控统计、log4j: 日志记录、wall: 防御sql注入
#如果允许时报错java. lang. ClassNotFoundException: org. apache. log4j. Priority
#则导入Log4j 依赖即可,Maven 地址: https://mvnrepository. com/artifact/log4j/log4j
spring.datasource.filters= stat, wall, log4j
spring.datasource.maxPoolPreparedStatementPerConnectionSize= 20
spring.datasource.useGlobalDataSourceStat= true
spring.datasource.connectionProperties= druid.stat.mergeSql=true; druid.stat.slowSqlMillis=500
3、MyDuridConfig.java
package com.biubiu.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;
/**
* @author z2424
*/
@Configuration
public class MyDruidConfig {
@Bean
@ConfigurationProperties(prefix = "spring.datasource")
public DataSource druiddatasource(){
return new DruidDataSource();
}
//后台监控
@Bean
public ServletRegistrationBean statViewServletServletRegistrationBean (){
ServletRegistrationBean<StatViewServlet> Bean = new ServletRegistrationBean<>(new StatViewServlet(), "/druid/*");
//配置后台账号密码
HashMap<String, String> Map = new HashMap<>();
//loginUsername是固定的
Map.put("loginUsername","admin");
//loginPassword是固定的
Map.put("loginPassword","admin");
// 访问权限
// map.put("allow","localhost");
// 只允许本机访问
Map.put("allow", "");
// 所有人都可以访问
// deny拒绝访问
// map.put("deny","192.168.1.1"); // ip会被拒绝访问
//设置servlet的初始化参数
Bean.setInitParameters(Map);
return Bean;
}
}