spring boot整合数据库（一）

spring boot整合druid以及druid监控

查看版本并获取pom内容

https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter

添加进pom.xml文件中 

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

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

application.yml添加配置

server:
  context-path: /wxapp
  port: 8080
debug: false
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/demo?useUnicode=true&characterEncoding=utf8&autoReconnect=true&failOverReadOnly=false
    username: root
    password: 123456
    #监控配置
    druid:
      initial-size: 1
      max-active: 20
      min-idle: 10
      max-wait: 60000
      max-open-prepared-statements: 20
      validation-query: SELECT 'x'
      validation-query-timeout: 2000
      test-on-borrow: false
      test-on-return: false
      test-while-idle: true
      time-between-eviction-runs-millis: 60000
      min-evictable-idle-time-millis: 300000
      max-evictable-idle-time-millis: 600000

 配置监控拦截器

package com.demo.webfilter;

import javax.servlet.annotation.WebFilter;
import javax.servlet.annotation.WebInitParam;

import com.alibaba.druid.support.http.WebStatFilter;


/**
 *   druid监控拦截器
  * Created by zzf
 *  * 2018-04-10 11:54
  */
@WebFilter(filterName="druidWebStatFilter",
        urlPatterns="/*",
        initParams={
                @WebInitParam(name="exclusions",value="*.js,*.gif,*.jpg,*.bmp,*.png,*.css,*.ico,/druid/*")// 忽略资源
})
public class DruidStatFilter extends WebStatFilter {


}

 配置监控

package com.demo.webservlet;


import javax.servlet.annotation.WebInitParam;
import javax.servlet.annotation.WebServlet;

import com.alibaba.druid.support.http.StatViewServlet;

/**
 * druid监控Servlet
 * Created by zzf
 * 2018-04-10 11:57
 */
@WebServlet(urlPatterns = "/druid/*", initParams={
        @WebInitParam(name="allow",value="127.0.0.1"),// IP白名单 (没有配置或者为空，则允许所有访问)
        @WebInitParam(name="deny",value="127.0.0.2"),// IP黑名单 (存在共同时，deny优先于allow)
        @WebInitParam(name="loginUsername",value="zzf"),// 用户名
        @WebInitParam(name="loginPassword",value="QQ:648895145"),// 密码
        @WebInitParam(name="resetEnable",value="false")// 禁用HTML页面上的“Reset All”功能
})
public class DruidStatViewServlet extends StatViewServlet {


}

 配置完成。启动后即可访问