oracle访问不同库

package com.idt.util;

 

import java.beans.PropertyVetoException;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Map;

import java.util.Properties;

import java.util.concurrent.ConcurrentHashMap;

 

import net.sf.json.JSONArray;

import net.sf.json.JSONException;

import net.sf.json.JSONObject;

 

import org.apache.log4j.Logger;

 

import com.mchange.v2.c3p0.ComboPooledDataSource;

 

public class DBPool {

private static Logger log = Logger.getLogger(DBPool.class);

private static DBPool dbPool = new DBPool();

private static Map<String, ComboPooledDataSource> dataSources = new ConcurrentHashMap<String, ComboPooledDataSource>();

 

public DBPool() {

}

 

public final static DBPool getInstance() {

return dbPool;

}

 

public final Connection getConnection(String connName) {

try {

Connection conn = getDataSource(connName).getConnection();

return conn;

} catch (SQLException e) {

log.error("连接数据库异常 :" + e);

throw new RuntimeException("连接数据库异常：" + connName, e);

}

}

 

private ComboPooledDataSource getDataSource(String connName) {

ComboPooledDataSource dataSource = dataSources.get(connName);

if (dataSource != null) {

return dataSource;

}

try {

InputStream is = DBPool.class.getResourceAsStream("/spring.properties");

Properties p = new Properties();

p.load(is);

String dbUrl = p.getProperty(connName + ".url");

String dbUser = p.getProperty(connName + ".username");

String dbPwd = p.getProperty(connName + ".password");

String driver = p.getProperty(connName + ".driverClassName");

dataSource = new ComboPooledDataSource();

dataSource.setUser(dbUser);

dataSource.setPassword(dbPwd);

dataSource.setJdbcUrl(dbUrl);

dataSource.setDriverClass(driver);

dataSource.setInitialPoolSize(2);

dataSource.setMinPoolSize(1);

dataSource.setMaxPoolSize(10);

dataSource.setMaxStatements(50);

dataSource.setMaxIdleTime(60);

dataSource.setAcquireIncrement(5);

is.close();

} catch (PropertyVetoException e) {

log.error("jdbc.properties error ", e);

} catch (Exception e) {

log.error("datasource generate error ", e);

}

dataSources.put(connName, dataSource);

return dataSource;

}

 

public final void close(Statement pstmt, ResultSet rs, Connection conn) {

try {

if (pstmt != null)

pstmt.close();

if (rs != null)

rs.close();

if (conn != null)

conn.close();

} catch (SQLException e) {

log.error("close conn error ", e);

}

}

 

// 将rs转换为json格式字符串

public String rsChange(ResultSet rs) throws SQLException,JSONException {

// json数组

JSONArray array = new JSONArray();

// 获取列数

ResultSetMetaData metaData = rs.getMetaData();

int columnCount = metaData.getColumnCount();

// 遍历ResultSet中的每条数据

while (rs.next()) {

JSONObject jsonObj = new JSONObject();

// 遍历每一列

for (int i = 1; i <= columnCount; i++) {

String columnName = metaData.getColumnLabel(i);

String value = rs.getString(columnName);

jsonObj.put(columnName, value);

}

array.put(jsonObj);

}

return array.toString();

}

 

}