druid java示例_SpringBoot集成Druid的最简单的小示例

参考网页

建立maven工程

Pom文件

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

org.springframework.boot

spring-boot-starter-parent

1.4.1.RELEASE

4.0.0

springboot-6

org.springframework.boot

spring-boot-starter

org.springframework.boot

spring-boot-starter-web

org.springframework.boot

spring-boot-starter-test

test

org.springframework.boot

spring-boot-starter-jdbc

mysql

mysql-connector-java

5.1.39

com.alibaba

druid

1.0.26

org.springframework.boot

spring-boot-maven-plugin

1.4.1.RELEASE

true

主启动类

packagecom.richfit.ruiche.DruidExample;

importjava.sql.SQLException;

importjava.util.HashMap;

importjava.util.Map;

importjavax.sql.DataSource;

importorg.springframework.boot.SpringApplication;

importorg.springframework.boot.autoconfigure.SpringBootApplication;

importorg.springframework.boot.web.servlet.FilterRegistrationBean;

importorg.springframework.boot.web.servlet.ServletRegistrationBean;

importorg.springframework.context.annotation.Bean;

importcom.alibaba.druid.pool.DruidDataSource;

importcom.alibaba.druid.support.http.StatViewServlet;

importcom.alibaba.druid.support.http.WebStatFilter;

@SpringBootApplication

public classDruidExampleApp {

public static voidmain(String[] args)throwsException {

SpringApplication.run(DruidExampleApp.class, args);

}

/**

* 注册DruidServlet

*

*/

publicServletRegistrationBean druidServletRegistrationBean() {

ServletRegistrationBean servletRegistrationBean =newServletRegistrationBean();

servletRegistrationBean.setServlet(newStatViewServlet());

servletRegistrationBean.addUrlMappings("/druid/*");

Map params =newHashMap();

//账号密码，是否允许重置数据

params.put("loginUsername","admin");

params.put("loginPassword","admin");

params.put("resetEnable","true");

servletRegistrationBean.setInitParameters(params);

returnservletRegistrationBean;

}

/**

* 注册DruidFilter拦截

*

*/

publicFilterRegistrationBean duridFilterRegistrationBean() {

FilterRegistrationBean filterRegistrationBean =newFilterRegistrationBean();

filterRegistrationBean.setFilter(newWebStatFilter());

Map initParams =newHashMap();

//设置忽略请求

initParams.put("exclusions","*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*");

filterRegistrationBean.setInitParameters(initParams);

filterRegistrationBean.addUrlPatterns("/*");

returnfilterRegistrationBean;

}

/**

* 配置DataSource

*@return

*@throwsSQLException

*/

@Bean

publicDataSource druidDataSource()throwsSQLException {

DruidDataSource druidDataSource =newDruidDataSource();

druidDataSource.setUsername("root");

druidDataSource.setPassword("root");

druidDataSource.setUrl("jdbc:mysql://localhost:3306/springbootdb_master");

druidDataSource.setMaxActive(100);

druidDataSource.setFilters("stat,wall");

druidDataSource.setInitialSize(10);

returndruidDataSource;

}

}

运行主启动类并测试

登录后

★SpringBoot集成Druid的关键要点--以下3点在主启动类中都有所体现

注册DruidServlet

注册DruidFilter拦截

配置DataSource