java数据库连接池代码,Java代码库,德仔网

代码语言

代码分类

【Java】 java数据库连接池

作者:阮天波 / 发布于2012/6/25/ 586

java数据库连接池

import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
import java.sql.SQLException;
import java.sql.Connection;
import java.util.Properties;
public class ConnectionSource {
 private static BasicDataSource dataSource = null;
 public ConnectionSource() {
 }
 public static void init() {
 if (dataSource != null) {
 try {
 dataSource.close();
 } catch (Exception e) {
 //
 }
 dataSource = null;
 }
 try {
 Properties p = new Properties();
 p.setProperty("driverClassName", "oracle.jdbc.driver.OracleDriver");
 p.setProperty("url", "jdbc:oracle:thin:@192.168.0.1:1521:testDB");
 p.setProperty("password", "scott");
 p.setProperty("username", "tiger");
 p.setProperty("maxActive", "30");
 p.setProperty("maxIdle", "10");
 p.setProperty("maxWait", "1000");
 p.setProperty("removeAbandoned", "false");
 p.setProperty("removeAbandonedTimeout", "120");
 p.setProperty("testOnBorrow", "true");
 p.setProperty("logAbandoned", "true");
 dataSource = (BasicDataSource) BasicDataSourceFactory.createDataSource(p);
 } catch (Exception e) {
 //
 }
 }
<div> public static synchronized Connection getConnection() throws SQLException {
 if (dataSource == null) {
 init();
 }
 Connection conn = null;
 if (dataSource != null) {
 conn = dataSource.getConnection();
 }
 return conn;
 }
}

试试其它关键字

　数据库连接池　

同语言下

可能有用的

阮天波贡献的其它代码(1)

.java数据库连接池