demo测试
import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import com.zaxxer.hikari.HikariConfig;import com.zaxxer.hikari.HikariDataSource;/*** hikaricp 连接池示例* @author wanghonggang* -10-29*/public class HikariDemo {public static void main(String[] args) {//配置文件HikariConfig hikariConfig = new HikariConfig();// hikariConfig.setJdbcUrl("jdbc:mysql://localhost:3306/mydata");//mysqlhikariConfig.setJdbcUrl("jdbc:oracle:thin:@localhost:1521:orcl");//oraclehikariConfig.setDriverClassName("oracle.jdbc.driver.OracleDriver");hikariConfig.setUsername("whg");hikariConfig.setPassword("whg");hikariConfig.addDataSourceProperty("cachePrepStmts", "true");hikariConfig.addDataSourceProperty("prepStmtCacheSize", "250");hikariConfig.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");HikariDataSource ds = new HikariDataSource(hikariConfig);Connection conn = null;Statement statement = null;ResultSet rs = null;try{//创建connectionconn = ds.getConnection();statement = conn.createStatement();//执行sqlrs = statement.executeQuery("select 100 s from dual");//取数据if (rs.next()){System.out.println(rs.getString("s"));}//关闭connectionconn.close();}catch (SQLException e){e.printStackTrace();}}}
一般配置文件配置
## 数据库配置spring.datasource.type=com.zaxxer.hikari.HikariDataSourcespring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.url = jdbc:mysql://localhost:3306/ssm?useUnicode=true&characterEncoding=utf-8&useSSL=falsespring.datasource.username = rootspring.datasource.password = root## Hikari 连接池配置 ------ 详细配置请访问：/brettwooldridge/HikariCP## 最小空闲连接数量spring.datasource.hikari.minimum-idle=5## 空闲连接存活最大时间，默认600000（10分钟）spring.datasource.hikari.idle-timeout=180000## 连接池最大连接数，默认是10spring.datasource.hikari.maximum-pool-size=10## 此属性控制从池返回的连接的默认自动提交行为,默认值：truespring.datasource.hikari.auto-commit=true## 连接池母子spring.datasource.hikari.pool-name=MyHikariCP## 此属性控制池中连接的最长生命周期，值0表示无限生命周期，默认1800000即30分钟spring.datasource.hikari.max-lifetime=1800000## 数据库连接超时时间,默认30秒，即30000spring.datasource.hikari.connection-timeout=30000spring.datasource.hikari.connection-test-query=SELECT 1
常规配置定义
