/**
* mongodb update
*
* @param txtLimitCount
* @param txtMacCount
* @param txtFindPage
* @param txtResultPage
* @throws Exception
*/
public static void updateMongoDBUserInfoData(
String txtLimitCount, String txtMacCount, String txtFindPage, String txtResultPage)
throws Exception {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
UserInfoDataDAO userInfoData = new UserInfoDataDAO();
userInfoData.setUser_seq(SessionManager.getSeq());
// MONGO_DEFAULT_LIMIT
userInfoData.setName(PreferenceDefine.MONGO_DEFAULT_LIMIT);
userInfoData.setValue0(txtLimitCount);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
// MONGO_DEFAULT_MAX_COUNT
userInfoData.setName(PreferenceDefine.MONGO_DEFAULT_MAX_COUNT);
userInfoData.setValue0(txtMacCount);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
// MONGO_DEFAULT_FIND
userInfoData.setName(PreferenceDefine.MONGO_DEFAULT_FIND);
userInfoData.setValue0(txtFindPage);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
// MONGO_DEFAULT_RESULT
userInfoData.setName(PreferenceDefine.MONGO_DEFAULT_RESULT);
userInfoData.setValue0(txtResultPage);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
}
/**
* general 정보의 export delimit을 저장합니다.
*
* @param sessionTimeOut
* @throws Exception
*/
public static void updateGeneralExportDelimitData(String delimit) throws Exception {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
UserInfoDataDAO userInfoData = new UserInfoDataDAO();
userInfoData.setUser_seq(SessionManager.getSeq());
// select 제한 갯수
userInfoData.setName(PreferenceDefine.EXPORT_DILIMITER);
userInfoData.setValue0(delimit);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
}
/**
* general 정보의 session time을 저장합니다.
*
* @param sessionTimeOut
* @throws Exception
*/
public static void updateGeneralUserInfoData(String sessionTimeOut) throws Exception {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
UserInfoDataDAO userInfoData = new UserInfoDataDAO();
userInfoData.setUser_seq(SessionManager.getSeq());
// select 제한 갯수
userInfoData.setName(PreferenceDefine.SESSION_DFEAULT_PREFERENCE);
userInfoData.setValue0(sessionTimeOut);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
}
/**
* default home page
*
* @param use
* @throws Exception
*/
public static void updateDefaultHomePageUse(String use) throws Exception {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
UserInfoDataDAO userInfoData = new UserInfoDataDAO();
userInfoData.setUser_seq(SessionManager.getSeq());
// select 제한 갯수
userInfoData.setName(PreferenceDefine.DEFAULT_HOME_PAGE_USE);
userInfoData.setValue0(use);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
}
/**
* update SQLFormatter
*
* @param userdb
* @param tabSize
* @param resultSelect
* @param sqlFormatIn
*/
public static void updateSQLFormatterInfoData(
String tabSize, String sqlFormatDecode, String sqlFormatIn) throws Exception {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
UserInfoDataDAO userInfoData = new UserInfoDataDAO();
userInfoData.setUser_seq(SessionManager.getSeq());
userInfoData.setName(PreferenceDefine.DEFAULT_TAB_SIZE_PREFERENCE);
userInfoData.setValue0(tabSize);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
userInfoData.setName(PreferenceDefine.SQL_FORMATTER_DECODE_PREFERENCE);
userInfoData.setValue0(sqlFormatDecode);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
userInfoData.setName(PreferenceDefine.SQL_FORMATTER_IN_PREFERENCE);
userInfoData.setValue0(sqlFormatIn);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
}
/**
* 신규 사용자의 기본 유저 데이터 정보를 저장합니다.
*
* @param userdb
* @param limitSelect
* @param resultSelect
* @param oraclePlan
*/
public static void updateRDBUserInfoData(
String limitSelect, String resultSelect, String oraclePlan) throws Exception {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
UserInfoDataDAO userInfoData = new UserInfoDataDAO();
userInfoData.setUser_seq(SessionManager.getSeq());
// select 제한 갯수
userInfoData.setName(PreferenceDefine.SELECT_LIMIT_COUNT);
userInfoData.setValue0(limitSelect);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
// 검색 결과 페이지 당 보여주는 갯수
userInfoData.setName(PreferenceDefine.SELECT_RESULT_PAGE_PREFERENCE);
userInfoData.setValue0(resultSelect);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
// ORACLE PLAN TABLE
userInfoData.setName(PreferenceDefine.ORACLE_PLAN_TABLE);
userInfoData.setValue0(oraclePlan);
sqlClient.update("userInfoDataUpdate", userInfoData); // $NON-NLS-1$
}
/**
* 사용자 정보 데이터.
*
* @param key
* @return
* @throws Exception
*/
public static Object getUserInfoData(String key) throws Exception {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB());
return sqlClient.queryForObject("getUserInfoData", SessionManager.getSeq()); // $NON-NLS-1$
}
@Override
public boolean connection() {
if (!isValidate()) return false;
String dbUrl = "";
if (comboConnType.getText().equals("SID")) {
dbUrl =
String.format(
DBDefine.ORACLE_DEFAULT.getDB_URL_INFO(),
textHost.getText(),
textPort.getText(),
textDatabase.getText());
} else if (comboConnType.getText().equals("Service Name")) {
dbUrl =
String.format(
"jdbc:oracle:thin:@%s:%s/%s",
textHost.getText(), textPort.getText(), textDatabase.getText());
}
userDB = new UserDBDAO();
userDB.setTypes(DBDefine.ORACLE_DEFAULT.getDBToString());
userDB.setUrl(dbUrl);
userDB.setDb(textDatabase.getText());
userDB.setGroup_name(comboGroup.getText().trim());
userDB.setDisplay_name(textDisplayName.getText());
userDB.setOperation_type(
DBOperationType.getNameToType(comboOperationType.getText()).toString());
userDB.setHost(textHost.getText());
userDB.setPasswd(textPassword.getText());
userDB.setPort(textPort.getText());
// userDB.setLocale(comboLocale.getText().trim());
userDB.setUsers(textUser.getText());
// 기존 데이터 업데이트
if (oldUserDB != null) {
if (!MessageDialog.openConfirm(null, "Confirm", Messages.SQLiteLoginComposite_13))
return false; //$NON-NLS-1$
if (!checkDatabase(userDB)) return false;
try {
TadpoleSystem_UserDBQuery.updateUserDB(userDB, oldUserDB, SessionManager.getSeq());
} catch (Exception e) {
logger.error(Messages.SQLiteLoginComposite_8, e);
Status errStatus =
new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); // $NON-NLS-1$
ExceptionDetailsErrorDialog.openError(
getShell(), "Error", Messages.SQLiteLoginComposite_5, errStatus); // $NON-NLS-1$
return false;
}
// 신규 데이터 저장.
} else {
// db가 정상적인지 채크해본다
try {
SqlMapClient sqlClient = TadpoleSQLManager.getInstance(userDB);
List showTables = sqlClient.queryForList("tableList", textDatabase.getText());
} catch (Exception e) {
logger.error(Messages.OracleLoginComposite_7, e);
Status errStatus =
new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); // $NON-NLS-1$
ExceptionDetailsErrorDialog.openError(
getShell(), "Error", Messages.OracleLoginComposite_10, errStatus); // $NON-NLS-1$
return false;
}
try {
TadpoleSystem_UserDBQuery.newUserDB(userDB, SessionManager.getSeq());
} catch (Exception e) {
logger.error("Oracle db info save", e);
Status errStatus =
new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); // $NON-NLS-1$
ExceptionDetailsErrorDialog.openError(
getShell(), "Error", Messages.OracleLoginComposite_11, errStatus); // $NON-NLS-1$
}
}
return true;
}
