数据库连接池-HikariCP-配置和使用

1. hikari.properties文件

jdbcUrl=jdbc:mysql://localhost:3306/testusername=testpassword=123456maximumPoolSize=30minimumIdle=5connectionTestQuery=SELECT 1autoCommit=truedataSource.cachePrepStmts=truedataSource.prepStmtCacheSize=250dataSource.prepStmtCacheSqlLimit=2048dataSource.useServerPrepStmts=truedataSource.useLocalSessionState=truedataSource.useLocalTransactionState=truedataSource.rewriteBatchedStatements=truedataSource.cacheResultSetMetadata=truedataSource.cacheServerConfiguration=truedataSource.elideSetAutoCommits=truedataSource.maintainTimeStats=false

2. 创建连接

HikariConfig config = new HikariConfig("src/hikari.properties");System.out.println(config.getJdbcUrl());System.out.println(config.getConnectionTimeout());System.out.println(config.getMaximumPoolSize());System.out.println(config.getMinimumIdle());System.out.println(config.getUsername());System.out.println(config.getPassword());HikariDataSource ds = new HikariDataSource(config);