[SpringBoot]2. mysql+mybatis+druid整合

application.yml

spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource
    # https://github.com/alibaba/druid/tree/master/druid-spring-boot-starter
    druid:
      # JDBC配置
      url: jdbc:mysql://localhost/demo?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai&useSSL=false&autoReconnect=true
      username: root
      password: 
      # 连接池配置
      # 连接池建立时创建的初始化连接数
      initial-size: 5
      # 连接池中最大的活跃连接数
      max-active: 20
      # 连接池中最小的活跃连接数
      min-idle: 10
      max-wait: 10
      filters: stat,wall,slf4j
      filter:
        stat:
          log-slow-sql: true
          slow-sql-millis: 2000
      # Druid WebStatFilter配置，说明请参考Druid Wiki，配置_WebStatFilter配置
      web-stat-filter.enabled: true
      web-stat-filter.url-pattern: /*
      web-stat-filter.exclusions: '*.gif,*.png,*.jpg,*.html,*.js,*.css,*.ico,/druid/*'
      # Druid StatViewServlet配置，说明请参考Druid Wiki，配置_StatViewServlet配置
      stat-view-servlet.enabled: true
      stat-view-servlet.url-pattern: /druid/*
      stat-view-servlet.reset-enable: true
      stat-view-servlet.login-username: admin
      stat-view-servlet.login-password: 123456
      stat-view-servlet.allow:
      stat-view-servlet.deny:
      # Spring监控配置，说明请参考Druid Github Wiki，配置_Druid和Spring关联监控配置
      # Spring监控AOP切入点，如x.y.z.service.*,配置多个英文逗号分隔
      #aop-patterns:

mybatis:
  configuration:
    # 开启下划线到驼峰的自动转换. 作用：将数据库字段根据驼峰规则自动注入到对象属性。
    map-underscore-to-camel-case: true

logging:
  level:
    # 打印SQL语句
    com.example.demo.mapper: debug

entity -> mapper -> Done!