java数据库连接池，java数据库连接,import org.a

java数据库连接池，java数据库连接,import org.a

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) {            //        }    }    public static synchronized Connection getConnection() throws  SQLException {        if (dataSource == null) {            init();        }        Connection conn = null;        if (dataSource != null) {            conn = dataSource.getConnection();        }        return conn;    }}//该片段来自于http://byrx.net