【文件属性】:
文件名称:c3p0配置文件
文件大小:342B
文件格式:XML
更新时间:2022-05-26 08:22:48
c3p0
c3p0配置文件
package com.itheima.util;
import com.mchange.v2.c3p0.ComboPooledDataSource;
import javax.sql.DataSource;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcUtils {
/**c3p0连接池被创建时,会自动从src下加载c3p0-config.xml*/
private static DataSource dataSource = new ComboPooledDataSource();
/**
* 获取连接
*/
public static Connection getConnection() throws Exception {
//获取连接
Connection connection = dataSource.getConnection();
return connection;
}
/**
* 释放资源
*/
public static void close(ResultSet resultSet, Statement statement, Connection connection){
if (resultSet != null) {
try {
resultSet.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (statement != null) {
try {
statement.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
if (connection != null) {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public static DataSource getDataSource() {
return dataSource;
}
}