无框架德鲁伊了连接池（自己下包）

package PlatUtils;

import java.io.File;

import java.io.FileInputStream;

import java.io.InputStream;

import java.sql.SQLException;

import java.util.Properties;

import org.apache.log4j.Logger;

import com.alibaba.druid.pool.DruidDataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import com.alibaba.druid.pool.DruidPooledConnection;

/**

* 要实现单例模式，保证全局只有一个数据库连接池

*/

public class DBPoolConnection {

static Logger log = Logger.getLogger(DBPoolConnection.class);

private static DBPoolConnection dbPoolConnection = null;

private static DruidDataSource druidDataSource = null;

static {

Properties properties = loadPropertiesFile("classes/db_server.properties");

try {

druidDataSource = (DruidDataSource)DruidDataSourceFactory.createDataSource(properties); //DruidDataSrouce工厂模式

} catch (Exception e) {

log.error("获取配置失败");

}

}

/**

* 数据库连接池单例

* @return

*/

public static synchronized DBPoolConnection getInstance(){

if (null == dbPoolConnection){

dbPoolConnection = new DBPoolConnection();

}

return dbPoolConnection;

}

/**

* 返回druid数据库连接

* @return

* @throws SQLException

*/

public DruidPooledConnection getConnection() throws SQLException{

return druidDataSource.getConnection();

}

/**

* @param string 配置文件名

* @return Properties对象

*/

private static Properties loadPropertiesFile(String fullFile) {

String webRootPath = null;

if (null == fullFile || fullFile.equals("")){

throw new IllegalArgumentException("Properties file path can not be null" + fullFile);

}

webRootPath = DBPoolConnection.class.getClassLoader().getResource("").getPath();

webRootPath = new File(webRootPath).getParent();

InputStream inputStream = null;

Properties p =null;

try {

inputStream = new FileInputStream(new File(webRootPath + File.separator + fullFile));

p = new Properties();

p.load(inputStream);

} catch (Exception e) {

e.printStackTrace();

} finally {

try {

if (null != inputStream){

inputStream.close();

}

} catch (Exception e) {

e.printStackTrace();

}

}

return p;

}

}

package TestAll;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Types;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.Iterator;

import java.util.LinkedList;

import java.util.List;

import java.util.Map;

import com.alibaba.druid.pool.DruidPooledConnection;

import PlatUtils.BaseDaoUtils;

import PlatUtils.DBPoolConnection;

import entity.platUser;

public class IterableTest {

public static void main(String[] args) throws SQLException {

DBPoolConnection dbp = DBPoolConnection.getInstance();

DruidPooledConnection conn = null;

PreparedStatement ptmt = null;

ResultSet rs;

try {

conn = dbp.getConnection();

ptmt = conn.prepareStatement("SELECT * FROM t_user");

rs = ptmt.executeQuery();

System.out.println(rs);

while (rs.next()) {

System.out.println(rs.getString("USER_NAME"));

}

} catch (Exception e) {

e.printStackTrace();

}finally{

if(ptmt!=null){

try {

ptmt.close();

System.out.println("ptmt关闭成功");

} catch (SQLException e2) {

System.out.println("ptmt关闭失败");

}

}

if(conn!=null){

try {

conn.close();

System.out.println("conn关闭成功");

} catch (SQLException e2) {

System.out.println("conn关闭失败");

}

}

}

}

}

   <!--druid连接池包 -->

    <dependency>

      <groupId>com.alibaba</groupId>

      <artifactId>druid</artifactId>

      <version>1.1.10</version>

    </dependency>

<--配置文件-->

driverClassName=oracle.jdbc.OracleDriver

url=***

username=***

password=***

filters=stat

initialSize=2

maxActive=300

maxWait=60000

timeBetweenEvictionRunsMillis=60000

minEvictableIdleTimeMillis=300000

validationQuery=select 1 from dual

testWhileIdle=true

testOnBorrow=false

testOnReturn=false

poolPreparedStatements=false

maxPoolPreparedStatementPerConnectionSize=200