Spring boot 整合mybtais和druid

一. 整合druid

druid官方指南

pom.xml配置

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid-spring-boot-starter</artifactId>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

yml配置

spring:
    datasource:
        # 使用druid数据源
        druid:
            url: jdbc:mysql://url/database?useUnicode=true&characterEncoding=utf-8
            username: xx
            password: 123456
            driver-class-name: com.mysql.jdbc.Driver
            filters: stat
            maxActive: 300
            initialSize: 5
            maxWait: 60000
            minIdle: 5
            timeBetweenEvictionRunsMillis: 60000
            minEvictableIdleTimeMillis: 300000
            validationQuery: select 'x'
            testWhileIdle: true
            testOnBorrow: false
            testOnReturn: false
            poolPreparedStatements: true
            maxOpenPreparedStatements: 20
            WebStatFilter:
              enabled: true #是否启用StatFilter默认值true
              urlPattern: /*
              exclusions: '*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*'
              StatViewServlet:
              enabled: true # 是否启用StatViewServlet默认值true
              urlPattern: /druid/*
            #Spring监控AOP切入点，如x.y.z.service.*,配置多个英文逗号分隔
            aop-patterns: 

二. 整合mybatis

官方指南

pom.xml配置

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
</dependency>

yml配置

mybatis:
    config-location: classpath:mybatis-config.xml
    mapper-locations: classpath*:mapper/**/*.xml