public static void addConnPool(ZCDatabaseSchema db) { DBConnConfig dcc = new DBConnConfig(); dcc.DBName = db.getDBName(); dcc.DBPassword = db.getPassword(); dcc.DBPort = (int) db.getPort(); dcc.DBServerAddress = db.getAddress(); dcc.DBType = db.getServerType(); dcc.DBUserName = db.getUserName(); dcc.PoolName = ("_OuterDatabase_" + db.getID()); dcc.TestTable = db.getTestTable(); dcc.isLatin1Charset = "Y".equals(db.getLatin1Flag()); if (!DBConnPool.getPoolMap().containsKey(dcc.PoolName + ".")) new DBConnPoolImpl(dcc); }
public void save() { ZCDatabaseSchema db = new ZCDatabaseSchema(); if (StringUtil.isEmpty($V("ID"))) { db.setValue(this.Request); db.setID(NoUtil.getMaxID("DatabaseID")); db.setAddTime(new Date()); db.setAddUser(User.getUserName()); db.setSiteID(Application.getCurrentSiteID()); if (db.insert()) this.Response.setMessage("添加数据库连接成功"); else this.Response.setError("发生错误,添加数据库连接失败"); } else { db.setID(Long.parseLong($V("ID"))); db.fill(); db.setValue(this.Request); db.setModifyTime(new Date()); db.setModifyUser(User.getUserName()); if (db.update()) this.Response.setMessage("修改数据库连接成功"); else { this.Response.setError("发生错误,修改数据库连接失败"); } } removeConnPool(db.getID()); addConnPool(db); }