Spring Boot AOP记录用户操作日志，通联数据java面试

ojdbc6

11.2.0.4

com.alibaba

druid-spring-boot-starter

1.1.6

application.yml

---

server:

context-path: /web

port: 7002

spring:

datasource:

druid:

数据库访问配置, 使用druid数据源

type: com.alibaba.druid.pool.DruidDataSource

driver-class-name: oracle.jdbc.driver.OracleDriver

url: jdbc:oracle:thin:@localhost:49161:XE

username: boot

password: 123456

连接池配置

initial-size: 5

min-idle: 5

max-active: 20

连接等待超时时间

max-wait: 30000

配置检测可以关闭的空闲连接间隔时间

time-between-eviction-runs-millis: 60000

配置连接在池中的最小生存时间

min-evictable-idle-time-millis: 300000

validation-query: select ‘1’ from dual

test-while-idle: true

test-on-borrow: false

test-on-return: false