密文数据源连接发池 ConnectionTools 01
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Map;
import java.util.Properties;

import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
import org.apache.log4j.Logger;

import com.huawei.ngbss.common.EncryptUtil;
import com.huawei.ngbss.esb.FileManager;

public class ConnectionTools
{
private static BasicDataSource basicDateSource = null;

private static Logger logger = Logger.getLogger(ConnectionTools.class);

private static final String DB_FILE_NAME = "db.properties";

private static Map<String, Properties> dbPropMap = new HashMap<String, Properties>();

private static String username = EncryptUtil.decryptDES(FileManager
.getProperties(DB_FILE_NAME).getProperty("username"));

private static String password = EncryptUtil.decryptDES(FileManager
.getProperties(DB_FILE_NAME).getProperty("password"));

/**
* 初始化数据连接
*/
static
{
init();
}

/*
* 初始化数据库连接
*/
static
{
init();
}

public static void init()
{
try
{

Properties prop = new Properties();
prop = FileManager.getProperties(DB_FILE_NAME);
prop.setProperty("username", username);
prop.setProperty("password", password);
dbPropMap.put(DB_FILE_NAME, prop);
prop = null;
basicDateSource = (BasicDataSource) BasicDataSourceFactory
.createDataSource(dbPropMap.get(DB_FILE_NAME));
logger.info("This DB username was:" + username + "," + password);
}
catch (Exception e)
{
logger.info("Initial db pool is failure", e);
}
logger.info("Initial DB pool is successfully");
}

/**
* Connection 2011-12-30,Xgw123485
*/
public static Connection getConnection()
{
Connection connection = null;
try
{
connection = basicDateSource.getConnection();
logger.info("get db connection successful.");
}
catch (Exception e)
{
logger.error("get db connection failure.");
}
return connection;
}