DBCP 使用

package com.sk.pool;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.ResourceBundle;

import org.apache.commons.dbcp.BasicDataSource;

/**
* @author LuckyStar
* 2008-2-22
* 下午05:59:21
* test
* LuckyStar
*/
public class PoolTest {
private Connection conn;
public static BasicDataSource ds;
//驱动
private String driver="oracle.jdbc.driver.OracleDriver";
//连接字符串
private String url="jdbc:oracle:thin:@localhost:1521:ml";
//用户名
private String username="mms";
//密码
private String password="mms";
//初始化连接数
private int initSize=5;
/**
 * 初始化 数据库配置文件
 * 读取数据
 * @throws Exception 
 */
private void initSource() throws Exception{
if(ds==null){//初始化时 如果ds为空,则初始化
ResourceBundle rb=ResourceBundle.getBundle("conf/DB");//读取资源
if(rb==null){
throw new Exception("数据库配置文件读取失败,程序终止,请查实conf下是否有DB.properties文件");
}else{
if(!rb.getString("driver").equals(""))
driver= rb.getString("driver");
if(!rb.getString("url").endsWith(""))
url=rb.getString("url");
if(!rb.getString("username").equals(""))
username=rb.getString("username");
if(!rb.getString("password").equals(""))
password=rb.getString("password");
}
//设置dbcp
ds=new BasicDataSource();
ds.setDriverClassName(driver);
ds.setUrl(url);
ds.setUsername(username);
ds.setPassword(password);
ds.setInitialSize(initSize);
}
}
public PoolTest() throws Exception{
System.out.println("连接池初始化...........................................");
this.initSource();
show();
}
/**
 * 获取数据库连接
 * @return Connection
 * @throws Exception 
 */
public Connection getConnection() throws Exception{
System.out.println("getConection.......................................");
show();
if(ds!=null){
return conn=ds.getConnection();
}
throw new Exception("dbcp init error! DBOper line 64");

}
/**
 * 关闭数据库连接
 * @throws SQLException
 */
public void closeConnection() throws SQLException{
if(conn!=null){
this.conn.close();
}
System.out.println("...........................................关闭一个连接");
show();
}
private void show(){
System.out.println("InitialSize"+ds.getInitialSize());
System.out.println("NumberActive"+ds.getNumActive());
System.out.println("NumberIdle"+ds.getNumIdle());

}

public static void main(String[] args) {
// TODO Auto-generated method stub
try {
PoolTest db= new PoolTest();
for(int i=0;i<10;i++){
try {
db.getConnection();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println(Thread.currentThread().getName()+"获取第"+(i+1)+"个链接");
if(ds.getNumActive()>4){
try {
//ds.close();
//System.out.println("......................................DS 关闭");
db.closeConnection();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
//db.closeConnection();
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}

}
########################################################################################################
调用
#####################################
/**
 * 释放资源
 * @throws SQLException
 */
private void releaseResource() throws SQLException{
if(rs!=null){
rs.close();
rs=null;
}
if(cs!=null){
cs.close();
cs=null;
}
if(conn!=null&&!conn.isClosed()){
db.closeConnection();
}
}
/**
 * 初始化 资源 到 cs,cs须 设置参数
 * @param callSql
 * @throws Exception
 */
private void initResource(String callSql) throws Exception{
if(db==null){
db=new DBOperator();
}
if(conn==null||conn.isClosed()){
conn=db.getConnection();
}
if(cs==null){
cs=conn.prepareCall(callSql);
}
}