1. pom引入Druid和log4j的依赖**
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.17</version>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.2.3</version>
</dependency>
2.yaml中进行如下配置
spring:
datasource:
password: root
username: root
url: jdbc:mysql://localhost:3306/mybatis_ikun
driver-class-name: com.mysql.cj.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
#druid数据源专有配置
initialSize: 5
minIdle: 5
maxActive: 20
maxWait: 60000
timeBetweenEvictionRunsMillis: 60000
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1 FROM DUAL
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
poolPreparedStatements: true
#配置监控统计拦截的filters,stat:监控统计、log4j:日志记录、wall:防御sql注入
#如果允许报错,java.lang.ClassNotFoundException: org.apache.Log4j.Properity
#则导入log4j 依赖就行
filters: stat,wall,log4j
maxPoolPreparedStatementPerConnectionSize: 20
useGlobalDataSourceStat: true
connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
3.DruidConfig类
@Configuration
public class DruidConfig {
@ConfigurationProperties(prefix = "spring.datasource")
@Bean
public DataSource druidDataSource(){
return new DruidDataSource();
}
//后台监控
@Bean
public ServletRegistrationBean statViewServlet(){
ServletRegistrationBean<StatViewServlet> bean =new ServletRegistrationBean<>(new StatViewServlet(),"/druid/*");
//后台登录操作,账号密码设置
HashMap<String,String> initParameters =new HashMap<>();
//增加配置,key是固定的不能修改
initParameters.put("loginUsername","admin");
initParameters.put("loginPassword","123456");
//允许xx能访问
initParameters.put("allow","localhost");//后面为空则允许所有人访问
bean.setInitParameters(initParameters);
return bean;
}
}
4.配置成功后启动项目访问 http://localhost:8080/druid
访问地址是自己写的,注意
5.访问成功登录界面
使用设定的账号密码登录
6.登陆后可查看到后台数据的操作
注意yaml配置文件复制时,一定要在同一列,否则会报错。