Mybatis Druid sql监控不打印sql Druid yml 配置
引入druid依赖
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.23</version>
</dependency>
注入Druid相关配置
@Configuration
public class DruidConfig {
private Logger logger= LoggerFactory.getLogger(DruidConfig.class);
/**
* 初始化:注意在这如果不是从SpringProperties中读取配置信息,那么有可能注入不完整
*/
@Bean(destroyMethod = "close", initMethod = "init")
@ConfigurationProperties(prefix = "spring.datasource")
public DruidDataSource druidDataSource() {
logger.info("Druid初始化开始==========");
DruidDataSource druidDataSource = new DruidDataSource();
logger.info("Druid初始化完成==========");
return druidDataSource;
}
@Bean
public ServletRegistrationBean druidServlet(){
ServletRegistrationBean servletRegistartionBean=new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
// 白名单,多个用逗号分割, 如果allow没有配置或者为空,则允许所有访问
servletRegistartionBean.addInitParameter("allow", "127.0.0.1,172.29.32.54");
// 黑名单,多个用逗号分割 (共同存在时,deny优先于allow)
servletRegistartionBean.addInitParameter("deny", "192.168.1.110");
// 控制台管理用户名
servletRegistartionBean.addInitParameter("loginUsername", "admin");
// 控制台管理密码
servletRegistartionBean.addInitParameter("loginPassword", "admin");
// 是否可以重置数据源,禁用HTML页面上的“Reset All”功能
servletRegistartionBean.addInitParameter("resetEnable", "false");
return servletRegistartionBean;
}
/**
* 定义Druid过滤规则
*/
@Bean
public FilterRegistrationBean filterRegistrationBean() {
FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean() ;
filterRegistrationBean.setFilter(new WebStatFilter());
//所有请求进行监控处理
filterRegistrationBean.addUrlPatterns("/*");
//添加不需要忽略的格式信息
filterRegistrationBean.addInitParameter("exclusions", "*.js,*.gif,*.jpg,*.css,/druid/*");
return filterRegistrationBean ;
}
}
Springboot yml配置文件
spring:
application:
name: os_coreserver
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/shop?characterEncoding=utf-8&useSSl=false
driver-class-name: com.mysql.jdbc.Driver
type: com.alibaba.druid.pool.DruidDataSource
#监控统计拦截的filters,如果启用log4j记得添加依赖
filters: stat,wall,log4j
#druid配置
#配置初始化大小/最小/最大
initialSize: 5
minIdle: 5
maxActive: 20
#获取连接等待超时时间
maxWait: 60000
#间隔多久进行一次检测,检测需要关闭的空闲连接
timeBetweenEvictionRunsMillis: 60000
#一个连接在池中最小生存的时间
minEvictableIdleTimeMillis: 300000
validationQuery: SELECT 1
testWhileIdle: true
testOnBorrow: false
testOnReturn: false
#打开PSCache,并指定每个连接上PSCache的大小。oracle设为true,mysql设为false。分库分表较多推荐设置为false
poolPreparedStatements: false
maxPoolPreparedStatementPerConnectionSize: 20
# 通过connectProperties属性来打开mergeSql功能;慢SQL记录
connectionProperties:
druid:
stat:
mergeSql: true
slowSqlMillis: 5000
注入DruidDatasource不正确的写法
从配置文件中拿到配置信息,然后setter方式注入,虽然DruidDataSource是拿到了,但是Sql打印不了,Filter也没有,查看页面如下,Filter类名为空,这个属性是从配置文件读的时候注入的,下面的写法没办法配置。
@Autowired
MysqlProperties mysqlProperties;
/**
* 初始化
*/
@Bean
public DruidDataSource getDruiddatasource(){
try{
logger.info("Druid初始化开始==========");
DruidDataSource druidDataSource=new DruidDataSource();
druidDataSource.setUrl(mysqlProperties.getJdbcurl());
druidDataSource.setUsername(mysqlProperties.getUsername());
druidDataSource.setPassword(mysqlProperties.getPassword());
druidDataSource.setMaxActive(mysqlProperties.getMaximumPoolSize());
druidDataSource.setDriverClassName(mysqlProperties.getDrivername());
DruidPooledConnection connection = druidDataSource.getConnection();
logger.info("Druid初始化结束==========");
return druidDataSource;
}catch (Exception e){
e.printStackTrace();
return null;
}
}
查看Druid页面:输入账号密码
当采用以一种方式的时候,配置正确,可以查看sql。