HikariCP資料庫連接配接池配置步驟

spring boot項目中，spring boot 2.0內建資料庫連接配接池步驟：

1）依賴包

//HikariCP 資料庫連接配接池

compile ‘com.zaxxer:HikariCP:3.1.0’

2）配置資訊

在spirng boot項目的application.properties配置檔案中，

#Hikari will use the above plus the following to setup connection poolingHikari will use the above plus the following to setup connection pooling

#spring.datasource.type=com.zaxxer.hikari.HikariDataSource

spring.datasource.hikari.minimum-idle=10

spring.datasource.hikari.maximum-pool-size=150

spring.datasource.hikari.auto-commit=true

spring.datasource.hikari.idle-timeout=30000

spring.datasource.hikari.pool-name=DatebookHikariCP

spring.datasource.hikari.max-lifetime=1800000

spring.datasource.hikari.connection-timeout=30000

spring.datasource.hikari.connection-test-query=SELECT 1