import java.sql.Connection;
import java.sql.SQLException;
import com.zaxxer.hikari.HikariConfig;
import com.zaxxer.hikari.HikariDataSource;
/**
* @author Administrator
* @date 2015年12月16日 下午2:14:27
* @description Hikari数据源
*/
public class DBSource {
<span style="white-space:pre"> </span>private static HikariDataSource dataSource;
<span style="white-space:pre"> </span>/**
<span style="white-space:pre"> </span>* @author Administrator
<span style="white-space:pre"> </span>* @date 2015年12月17日 下午3:03:52
<span style="white-space:pre"> </span>* @description 获取Hikari数据连接
<span style="white-space:pre"> </span>* @parameter null
<span style="white-space:pre"> </span>* @return dataSource
<span style="white-space:pre"> </span>* @throws SQLException
<span style="white-space:pre"> </span>*/
<span style="white-space:pre"> </span>public static synchronized Connection getConnection() throws SQLException {
<span style="white-space:pre"> </span>if(dataSource == null ){
<span style="white-space:pre"> </span>HikariConfig config = new HikariConfig();
<span style="white-space:pre"> </span>String url = "jdbc:mysql://localhost:3306/bstockv2"; //IP地址和数据库要修改
<span style="white-space:pre"> </span>String username = "root";
<span style="white-space:pre"> </span>String password = "";
<span style="white-space:pre"> </span>config.setDriverClassName("com.mysql.jdbc.Driver");
<span style="white-space:pre"> </span>config.setJdbcUrl(url);
<span style="white-space:pre"> </span>config.setUsername(username);
<span style="white-space:pre"> </span>config.setPassword(password);
<span style="white-space:pre"> </span>config.setMaximumPoolSize(100);
<span style="white-space:pre"> </span>config.addDataSourceProperty("cachePrepStmts", "true");
<span style="white-space:pre"> </span>config.addDataSourceProperty("prepStmtCacheSize", "250");
<span style="white-space:pre"> </span>config.addDataSourceProperty("prepStmtCacheSqlLimit", "2048");
<span style="white-space:pre"> </span>config.setConnectionTimeout(20 * 1000);
<span style="white-space:pre"> </span>dataSource = new HikariDataSource(config);
<span style="white-space:pre"> </span>}
<span style="white-space:pre"> </span>return dataSource.getConnection();
<span style="white-space:pre"> </span>}
}
Hikari连接池DEMO
最新推荐文章于 2024-05-03 14:21:59 发布