2、代碼實現 package com.study;
import com.jolbox.bonecp.BoneCP;
import com.jolbox.bonecp.BoneCPConfig;
import com.jolbox.bonecp.BoneCPDataSource;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import java.sql.*;
/**
* Boncp 純java處理
* @CreateTime 2018/3/14 14:31
*/
public class BonecpJdbcManager {
private static final Logger LOGGER = LoggerFactory.getLogger(BonecpJdbcManager.class);
private static BonecpJdbcManager instance;
//第一種方式
private BoneCP connectionPool;
//第二種方式
private BoneCPDataSource dataSourcePool;
private BonecpJdbcManager() {
}
private BonecpJdbcManager(String driverName, String jdbcUrl, String userName, String passwd) {
try {
Class.forName(driverName);
//設置連接池配置信息
BoneCPConfig config = new BoneCPConfig();
config.setJdbcUrl(jdbcUrl);
config.setUsername(userName);
config.setPassword(passwd);
//數據庫連接池的最小連接數
config.setMinConnectionsPerPartition(5);
//數據庫連接池的最大連接數
config.setMaxConnectionsPerPartition(10);
config.setPartitionCount(1);
//根據連接池配置，創建數據庫連接池
connectionPool = new BoneCP(config);
// dataSourcePool = new BoneCPDataSource(config);
} catch (ClassNotFoundException e) {
LOGGER.error("ClassNotFoundException for driver : {}", driverName);
} catch (SQLException e) {
LOGGER.error("error to new BoneCp(), exception:{}", e);
}
}
/**
* 單例設計模式
*
* [@param](https://my.oschina.net/u/2303379) driverName
* [@param](https://my.oschina.net/u/2303379) jdbcUrl
* [@param](https://my.oschina.net/u/2303379) userName
* [@param](https://my.oschina.net/u/2303379) passwd
* @return
*/
public static BonecpJdbcManager getInstance(String driverName, String jdbcUrl, String userName, String passwd) {
if (instance == null) {
synchronized ("buildInstance") {
if (instance == null) {
instance = new BonecpJdbcManager(driverName, jdbcUrl, userName, passwd);
}
}
}
return instance;
}
/**
* 獲取一個連接
*
* @return
*/
public synchronized Connection getConnection() {
try {
return connectionPool.getConnection();
// return dataSourcePool.getConnection();
} catch (SQLException e) {
LOGGER.error("從連接池中獲取連接失敗，ERROR：{}", e);
}
return null;
}
/**
* 關閉連接
*
* @param connection
* @return
*/
public synchronized boolean returnConnection(Connection connection) {
try {
connection.close();
return true;
} catch (SQLException e) {
LOGGER.error("回收連接到連接池失敗，ERROR：{}", e);
}
return false;
}
/**
* 關閉statement和resultset
*
* @return
*/
public boolean closeStatment(Statement statement, ResultSet resultSet) {
try {
resultSet.close();
statement.close();
return true;
} catch (SQLException e) {
LOGGER.error("關閉statement和resultset失敗，ERROR：{}", e);
}
return false;
}
/**
* 測試
* @param args
*/
public static void main(String[] args) {
String driverName = "com.mysql.jdbc.Driver";
String jdbcUrl = "jdbc:mysql://localhost:3306/caiwutong";
String userName = "root";
String passwd = "123456";
BonecpJdbcManager instance = BonecpJdbcManager.getInstance(driverName, jdbcUrl, userName, passwd);
Connection connection = instance.getConnection();
PreparedStatement statement = null;
ResultSet resultSet = null;
String sql = "select * from user_info";
try {
statement = connection.prepareStatement(sql);
resultSet = statement.executeQuery();
while (resultSet.next()) {
System.out.println(resultSet.getString("id"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
instance.closeStatment(statement, resultSet);
instance.returnConnection(connection);
}
}
}
