java连接多个mysql_Java连接到多个数据库

我正在创建一个连接到多个数据库的Java应用程序.用户将能够从下拉框中选择要连接的数据库.

然后,程序通过将名称传递给创建初始上下文的方法来连接到数据库,以便它可以与oracle Web逻辑数据源进行通信.

public class dbMainConnection {

private static dbMainConnection conn = null;

private static java.sql.Connection dbConn = null;

private static javax.sql.DataSource ds = null;

private static Logger log = LoggerUtil.getLogger();

private dbMainConnection(String database) {

try {

Context ctx = new InitialContext();

if (ctx == null) {

log.info("JDNI Problem, cannot get InitialContext");

}

database = "jdbc/" + database;

log.info("This is the database string in DBMainConnection" + database);

ds = (javax.sql.DataSource) ctx.lookup (database);

} catch (Exception ex) {

log.error("eMTSLogin: Error in