连接C3P0方式1 手动连接
@Test
//方式1 手动连接
public void C3P0_01() throws PropertyVetoException, SQLException {
ComboPooledDataSource cps = new ComboPooledDataSource();
cps.setJdbcUrl(JDBCUtils.getUrl());
cps.setUser(JDBCUtils.getUser());
cps.setPassword(JDBCUtils.getPassword());
cps.setDriverClass(JDBCUtils.getDriver());
//初始连接数
cps.setInitialPoolSize(10);
//最大连接数
cps.setMaxPoolSize(50);
//建立连接
Connection connection = cps.getConnection();
connection.close();
}
方式2 通过配置文件模板
public void C3P0_02() throws SQLException {
ComboPooledDataSource wzg_db02 = new ComboPooledDataSource("wzg_db02");
Connection connection = wzg_db02.getConnection();
connection.close();
}
德鲁伊连接方法
@Test
public void Druid_01() throws Exception {
Properties properties = new Properties();
properties.load(new FileInputStream("src\\druid.properties"));
DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
Connection connection = dataSource.getConnection();
connection.close();
}
使用上述连接池
1.需要将对应的jar包导入到java,可以新建一个文件夹存放进去并右击添加到库
2.将对应的配置文件拖入src包下
德鲁伊工具类
package JDBC.Tool;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.FileInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
/**
* @author whlie(true){learn}
*/
public class DruTool {
private static DataSource ds;
private static String user;
private static String password;
private static String url;
private static String driver;
static {
Properties properties = new Properties();
try {
properties.load(new FileInputStream("src\\druid.properties"));
user = properties.getProperty("user");
password = properties.getProperty("password");
url = properties.getProperty("url");
driver = properties.getProperty("driver");
ds = (DataSource) DruidDataSourceFactory.createDataSource(properties);
} catch (Exception e) {
e.printStackTrace();
}
}
public static Connection getConnection() throws SQLException {
return ds.getConnection();
}
public static void close(ResultSet resultSet, Statement statement, Connection connection) throws SQLException {
try {
if (resultSet != null) {
resultSet.close();
}
if (statement != null) {
statement.close();
}
if (connection != null) {
connection.close();
}
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
public static String getUser() {
return user;
}
public static String getPassword() {
return password;
}
public static String getUrl() {
return url;
}
public static String getDriver() {
return driver;
}
}