Hikari连接池DEMO

来源：互联网发布：杭州网络营销策划编辑：程序博客网时间：2024/04/28 16:40
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>}}
0 0