oracle使用连接池,【JDBC】使用连接池技术访问oracle

packagecom.xdl.util;importjava.io.IOException;importjava.io.InputStream;importjava.sql.Connection;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.sql.Statement;importjava.util.Properties;importjavax.sql.DataSource;importorg.apache.commons.dbcp.BasicDataSourceFactory;public classDBCPUtilProperties {private staticDataSource datasource;static{

InputStream inputStream= DBCPUtilProperties.class.getClassLoader().getResourceAsStream("db.properties");

Properties pro= newProperties();try{

pro.load(inputStream);

datasource=BasicDataSourceFactory.

createDataSource(pro);/*** 也可以设置驱动，用户名，账号，密码，如果db.properties里的属性名称改变了，可以通过下面的方式手动设置

* datasource.setDriverClassName(pro.getProperty("driverClassName"));

* datasource.setUrl(pro.getProperty("url"));

* datasource.setUsername(pro.getProperty("username"));

* datasource.setPassword(pro.getProperty("password"));*/}catch(IOException e) {//TODO Auto-generated catch block

e.printStackTrace();

}catch(Exception e) {//TODO Auto-generated catch block

e.printStackTrace();

}

}public staticConnection getConnection(){try{returndatasource.getConnection();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}return null;

}public static voidreleaseResource(Connection conn,Statement st,ResultSet rs){if(rs != null) {try{

rs.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{

rs= null;

}

}if(st != null) {try{

st.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{

st= null;

}

}if(conn != null) {try{

conn.close();

}catch(SQLException e) {//TODO Auto-generated catch block

e.printStackTrace();

}finally{

conn= null;

}

}

}

}