Springboot Consolidating Druid data sources

Source: Internet
Author: User
Tags maven central

For springboot data Sources please refer to my previous post: https://www.cnblogs.com/yueshutong/p/9409295.html

One: Druid Introduction 1. What is Druid?

Druid is the best database connection pool in the Java language. The Druid provides powerful monitoring and extension capabilities.

2. Where to download Druid
    • Official version Download:
      Maven Central Warehouse: Http://central.maven.org/maven2/com/alibaba/druid/
3. How to get Druid source code

Druid is an open source project, source is hosted on GitHub, source code warehouse address is https://github.com/alibaba/druid. At the same time each Druid release of the official version and snapshot, will be the source packaging, you can find the relevant version of the source code from the above

II: Springboot Integration

Start by importing dependencies on your Springboot project

1. Import dependencies
<dependency>    <groupId>com.alibaba</groupId>    <artifactId>druid</artifactId>    <version>1.1.10</version></dependency><dependency>    <groupId>mysql</groupId>    <artifactId>mysql-connector-java</artifactId>    <scope>runtime</scope></dependency>
2. Configure the data source and connection pool
spring:  datasource:    driver-class-name: com.mysql.jdbc.Driver    url: jdbc:mysql://localhost:3306/user?useUnicode=true&characterEncoding=utf-8&useSSL=false    username: root    password: 123456    type: com.alibaba.druid.pool.DruidDataSource#   数据源其他配置    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,去掉后监控界面sql无法统计,'wall'用于防火墙    filters: stat,wall,log4j    maxPoolPreparedStatementPerConnectionSize: 20    useGlobalDataSourceStat: true    connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=500
3. Inject DataSource
@Configurationpublic class Druidconfig {@ConfigurationProperties (prefix = "Spring.datasource") @Bean public Data    Source Druid () {return new Druiddatasource (); }//Configure Druid Monitoring//1, configure a management background servlet @Bean public Servletregistrationbean Statviewservlet () {//configuration parameter Reference R        Esourceservlet class Servletregistrationbean Bean = new Servletregistrationbean (new Statviewservlet (), "/druid/*");        map<string, string> initparams = new hashmap<> ();        Initparams.put ("Loginusername", "admin");        Initparams.put ("Loginpassword", "123456"); Initparams.put ("Allow", "");//default is to permit all access to Initparams.put ("Deny", "192.168.15.21");//Reject who Bean.setinitparameter        S (initparams);    return bean;  }//2, configure a Web monitoring filter @Bean public Filterregistrationbean webstatfilter () {Filterregistrationbean Bean =        New Filterregistrationbean ();        Bean.setfilter (New Webstatfilter ()); map<string, string> initparams = new Hashmap<> ();        Initparams.put ("Exclusions", "*.js,*.css,/druid/*");        Bean.setinitparameters (InitParams);        Bean.seturlpatterns (Arrays.aslist ("/*"));    return bean; }}
4. Launch the App

Visit Http://localhost:8080/druid to experience the powerful druid!

Springboot Consolidating Druid data sources

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.