SpringBoot集成 druid

使用java类配置bean
一：引包

 <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.9</version>
    </dependency>
    <dependency>
		<groupId>log4j</groupId>
		<artifactId>log4j</artifactId>
		<version>1.2.5</version>
	</dependency>

二：手动配置bean 并且读取资源 产生DruidDataSource
java代码

package cm.pjj.controller;

import java.sql.SQLException;

import javax.sql.DataSource;

import org.springframework.beans.factory.annotation.Value;
import org.springframework.boot.web.servlet.FilterRegistrationBean;
import org.springframework.boot.web.servlet.ServletRegistrationBean;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.support.http.StatViewServlet;
import com.alibaba.druid.support.http.WebStatFilter;

@Configuration
public class DruidBean{

	@Value("${spring.datasource.url}")
	String url;
	@Value("${spring.datasource.username}")
	String username;
	@Value("${spring.datasource.password}")
	String password;
	@Value("${spring.datasource.driver-class-name}")
	String driver;
	@Bean
	public DataSource dataSource() {
		DruidDataSource ds =null;
		
		try {
			 ds =new DruidDataSource();
			ds.setUrl(url);
			ds.setPassword(password);
			ds.setDriverClassName(driver);
			ds.setUsername(username);
			ds.addFilters("stat, wall, log4j");//打印到监控Sql网页
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return ds;
		
	}  
	 @Bean
	    public ServletRegistrationBean statViewServlet(){
	        //创建servlet注册实体
	        ServletRegistrationBean servletRegistrationBean = new ServletRegistrationBean(new StatViewServlet(),"/druid/*");
	        //设置ip白名单
	        servletRegistrationBean.addInitParameter("allow","127.0.0.1");
	        //设置ip黑名单，如果allow与deny共同存在时,deny优先于allow
	        servletRegistrationBean.addInitParameter("deny","192.168.0.19");
	        //设置控制台管理用户
	        servletRegistrationBean.addInitParameter("loginUsername","oooo");
	        servletRegistrationBean.addInitParameter("loginPassword","123456");
	        //是否可以重置数据
	        servletRegistrationBean.addInitParameter("resetEnable","false");
	        return servletRegistrationBean;
	    }

	    @Bean
	    public FilterRegistrationBean statFilter(){
	        //创建过滤器
	        FilterRegistrationBean filterRegistrationBean = new FilterRegistrationBean(new WebStatFilter());
	        //设置过滤器过滤路径
	        filterRegistrationBean.addUrlPatterns("/*");
	        //忽略过滤的形式
	        filterRegistrationBean.addInitParameter("exclusions","*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*");
	        return filterRegistrationBean;
	    }
	
} 

输入网址查看监控SqL信息：

在https://github.com/search?q=druid
有使用方法
第一引入pom

	 <dependency>
	   <groupId>com.alibaba</groupId>
	   <artifactId>druid-spring-boot-starter</artifactId>
	   <version>1.1.10</version>
	</dependency>

第二引用Druid连接池在application.properties文件中

设置账号，密码

spring.datasource.druid.stat-view-servlet.login-username=tttt
spring.datasource.druid.stat-view-servlet.login-password=1111

设置慢查询单位毫秒

spring.datasource.druid.filter.stat.slow-sql-millis=1000

就可以打开http://127.0.0.1:8080/druid/sql.html