Druid连接池获取
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
public class DBUtil {
private static DataSource ds;
private static Connection conn;
static {
try {
Properties properties = new Properties();
InputStream inStream = DBUtil.class.getClassLoader().getResourceAsStream("jdbc.properties");
properties.load(inStream);
ds = DruidDataSourceFactory.createDataSource(properties);
} catch (Exception e) {
e.printStackTrace();
}
}
// 获取连接
public static Connection getConn() throws SQLException {
if (conn == null || conn.isClosed()) {
conn = ds.getConnection();
}
return conn;
}
// 回收连接
public static void closeConn() {
try {
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
conn = null;
}
}
}
jdbc.properties
url=jdbc:oracle:thin:@xxx.xxx.xxx.xxx:1521:ORCL
username=xxx
password=xxx
其他jdbc.properties配置:传送门
DBCP连接池获取
DBCP形式:传送门