/** * schedule result * * @param seq * @param isResult * @param msg */ public static void saveScheduleResult(int seq, boolean isResult, String msg) throws Exception { ScheduleResultDAO dao = new ScheduleResultDAO(); dao.setSchedule_main_seq(seq); dao.setResult( isResult ? PublicTadpoleDefine.YES_NO.YES.name() : PublicTadpoleDefine.YES_NO.NO.name()); dao.setDescription(msg); SqlMapClient sqlClient = TadpoleSQLManager.getInstance(TadpoleSystemInitializer.getUserDB()); sqlClient.insert("scheduleResultInsert", dao); }
@Override protected Control createContents(Composite parent) { Composite container = new Composite(parent, SWT.NULL); container.setLayout(new GridLayout(2, false)); Label lblResultType = new Label(container, SWT.NONE); lblResultType.setText(Messages.get().RDBPreferencePage_resultType); comboRDBResultType = new Combo(container, SWT.READ_ONLY); comboRDBResultType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); comboRDBResultType.add("Table"); // comboRDBResultType.add("Text"); // comboRDBResultType.add("JSON"); comboRDBResultType.select(0); Label lblNumberColumnAdd = new Label(container, SWT.NONE); lblNumberColumnAdd.setText(Messages.get().RDBPreferencePage_lblNumberColumnAdd_text); comboRDBNumberComma = new Combo(container, SWT.READ_ONLY); comboRDBNumberComma.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); comboRDBNumberComma.add(PublicTadpoleDefine.YES_NO.YES.name()); comboRDBNumberComma.add(PublicTadpoleDefine.YES_NO.NO.name()); comboRDBNumberComma.select(0); Label lblNewLabel = new Label(container, SWT.NONE); lblNewLabel.setText(Messages.get().DefaultPreferencePage_0); textSelectLimit = new Text(container, SWT.BORDER); textSelectLimit.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); Label lblNewLabel_1 = new Label(container, SWT.NONE); lblNewLabel_1.setText(Messages.get().DefaultPreferencePage_other_labelText_1); textResultPage = new Text(container, SWT.BORDER); textResultPage.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); Label lblResultViewFont = new Label(container, SWT.NONE); lblResultViewFont.setText(Messages.get().RDBPreferencePage_lblResultViewFont_text); lblUserFont = new Label(container, SWT.NONE); lblUserFont.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); lblUserFont.setText(""); new Label(container, SWT.NONE); Button btnNewButton = new Button(container, SWT.NONE); btnNewButton.addSelectionListener( new SelectionAdapter() { @Override public void widgetSelected(SelectionEvent e) { setFontData(); } }); btnNewButton.setText(Messages.get().RDBPreferencePage_btnNewButton_text); Label lblQueryTimeout = new Label(container, SWT.NONE); lblQueryTimeout.setText(Messages.get().RDBPreferencePage_lblQueryTimeout_text); textQueryTimeout = new Text(container, SWT.BORDER); textQueryTimeout.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); Label lblCommitCount = new Label(container, SWT.NONE); lblCommitCount.setText(Messages.get().RDBPreferencePage_lblCommitCount_text); textCommitCount = new Text(container, SWT.BORDER); textCommitCount.setText(Messages.get().RDBPreferencePage_text_text); textCommitCount.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); Label lblCharacterShownIn = new Label(container, SWT.NONE); lblCharacterShownIn.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1)); lblCharacterShownIn.setText(Messages.get().RDBPreferencePage_lblCharacterShownIn_text); textShowInTheColumn = new Text(container, SWT.BORDER); textShowInTheColumn.setText(Messages.get().RDBPreferencePage_text_text_1); textShowInTheColumn.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); Label label = new Label(container, SWT.SEPARATOR | SWT.HORIZONTAL); label.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 2, 1)); label.setText(""); // $NON-NLS-1$ Label lblNewLabel_2 = new Label(container, SWT.NONE); lblNewLabel_2.setText(Messages.get().DefaultPreferencePage_other_labelText); textOraclePlan = new Text(container, SWT.BORDER); textOraclePlan.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1)); new Label(container, SWT.NONE); Button btnCreatePlanTable = new Button(container, SWT.NONE); btnCreatePlanTable.addSelectionListener( new SelectionAdapter() { @Override public void widgetSelected(SelectionEvent e) { TadpoleSimpleMessageDialog planDialog = new TadpoleSimpleMessageDialog( getShell(), textOraclePlan.getText(), ORACLE_PLAN_TABLE); planDialog.open(); } }); btnCreatePlanTable.setText(Messages.get().RDBPreferencePage_btnCreatePlanTable_text); initDefaultValue(); // google analytic AnalyticCaller.track(this.getClass().getName()); return container; }
@Override protected void okPressed() { String strEmail = StringUtils.trimToEmpty(textEMail.getText()); String strPass = StringUtils.trimToEmpty(textPasswd.getText()); if (!validation(strEmail, strPass)) return; try { UserDAO userDao = TadpoleSystem_UserQuery.login(strEmail, strPass); // firsttime email confirm if (PublicTadpoleDefine.YES_NO.NO.name().equals(userDao.getIs_email_certification())) { InputDialog inputDialog = new InputDialog( getShell(), Messages.get().LoginDialog_10, Messages.get().LoginDialog_17, "", null); //$NON-NLS-3$ //$NON-NLS-1$ if (inputDialog.open() == Window.OK) { if (!userDao.getEmail_key().equals(inputDialog.getValue())) { throw new Exception(Messages.get().LoginDialog_19); } else { TadpoleSystem_UserQuery.updateEmailConfirm(strEmail); } } else { throw new Exception(Messages.get().LoginDialog_20); } } if (PublicTadpoleDefine.YES_NO.NO.name().equals(userDao.getApproval_yn())) { MessageDialog.openError( getParentShell(), Messages.get().LoginDialog_7, Messages.get().LoginDialog_27); return; } // Check the allow ip String strAllowIP = userDao.getAllow_ip(); boolean isAllow = IPFilterUtil.ifFilterString(strAllowIP, RequestInfoUtils.getRequestIP()); if (logger.isDebugEnabled()) logger.debug( Messages.get().LoginDialog_21 + userDao.getEmail() + Messages.get().LoginDialog_22 + strAllowIP + Messages.get().LoginDialog_23 + RequestInfoUtils.getRequestIP()); if (!isAllow) { logger.error( Messages.get().LoginDialog_21 + userDao.getEmail() + Messages.get().LoginDialog_22 + strAllowIP + Messages.get().LoginDialog_26 + RequestInfoUtils.getRequestIP()); MessageDialog.openError( getParentShell(), Messages.get().LoginDialog_7, Messages.get().LoginDialog_28); return; } if (PublicTadpoleDefine.YES_NO.YES.name().equals(userDao.getUse_otp())) { OTPLoginDialog otpDialog = new OTPLoginDialog(getShell()); otpDialog.open(); if (!GoogleAuthManager.getInstance() .isValidate(userDao.getOtp_secret(), otpDialog.getIntOTPCode())) { throw new Exception(Messages.get().LoginDialog_2); } } // 로그인 유지. registLoginID(userDao.getEmail()); SessionManager.addSession(userDao); // save login_history TadpoleSystem_UserQuery.saveLoginHistory(userDao.getSeq()); } catch (Exception e) { logger.error( String.format( "Login exception. request email is %s, reason %s", strEmail, e.getMessage())); // $NON-NLS-1$ MessageDialog.openError(getParentShell(), Messages.get().LoginDialog_29, e.getMessage()); textPasswd.setFocus(); return; } super.okPressed(); }
@Override public boolean makeUserDBDao(boolean isTest) { if (!isValidateInput(isTest)) return false; DBDefine selectDB = (DBDefine) comboDriverType.getData(comboDriverType.getText()); String dbUrl = String.format( selectDB.getDB_URL_INFO(), StringUtils.trimToEmpty(textHost.getText()), StringUtils.trimToEmpty(textPort.getText()), StringUtils.trimToEmpty(textDatabase.getText())); if (!"".equals(textJDBCOptions.getText())) { dbUrl += "?" + textJDBCOptions.getText(); } userDB = new UserDBDAO(); userDB.setDbms_type(selectDB.getDBToString()); userDB.setUrl(dbUrl); userDB.setUrl_user_parameter(textJDBCOptions.getText()); userDB.setDb(StringUtils.trimToEmpty(textDatabase.getText())); userDB.setGroup_name(StringUtils.trimToEmpty(preDBInfo.getComboGroup().getText())); userDB.setDisplay_name(StringUtils.trimToEmpty(preDBInfo.getTextDisplayName().getText())); userDB.setOperation_type( PublicTadpoleDefine.DBOperationType.getNameToType( preDBInfo.getComboOperationType().getText()) .toString()); userDB.setHost(StringUtils.trimToEmpty(textHost.getText())); userDB.setPort(StringUtils.trimToEmpty(textPort.getText())); userDB.setUsers(StringUtils.trimToEmpty(textUser.getText())); userDB.setPasswd(StringUtils.trimToEmpty(textPassword.getText())); // others connection 정보를 입력합니다. // setOtherConnectionInfo(); OthersConnectionInfoDAO otherConnectionDAO = othersConnectionInfo.getOthersConnectionInfo(); userDB.setIs_readOnlyConnect( otherConnectionDAO.isReadOnlyConnection() ? PublicTadpoleDefine.YES_NO.YES.name() : PublicTadpoleDefine.YES_NO.NO.name()); userDB.setIs_autocommit( otherConnectionDAO.isAutoCommit() ? PublicTadpoleDefine.YES_NO.YES.name() : PublicTadpoleDefine.YES_NO.NO.name()); userDB.setIs_showtables( otherConnectionDAO.isShowTables() ? PublicTadpoleDefine.YES_NO.YES.name() : PublicTadpoleDefine.YES_NO.NO.name()); // // userDB.setIs_table_filter(otherConnectionDAO.isTableFilter()?PublicTadpoleDefine.YES_NO.YES.name():PublicTadpoleDefine.YES_NO.NO.name()); // userDB.setTable_filter_include(otherConnectionDAO.getStrTableFilterInclude()); // userDB.setTable_filter_exclude(otherConnectionDAO.getStrTableFilterExclude()); userDB.setIs_profile( otherConnectionDAO.isProfiling() ? PublicTadpoleDefine.YES_NO.YES.name() : PublicTadpoleDefine.YES_NO.NO.name()); userDB.setQuestion_dml( otherConnectionDAO.isDMLStatement() ? PublicTadpoleDefine.YES_NO.YES.name() : PublicTadpoleDefine.YES_NO.NO.name()); userDB.setIs_external_browser( otherConnectionDAO.isExterBrowser() ? PublicTadpoleDefine.YES_NO.YES.name() : PublicTadpoleDefine.YES_NO.NO.name()); // 처음 등록자는 권한이 어드민입니다. userDB.setRole_id(PublicTadpoleDefine.USER_ROLE_TYPE.ADMIN.toString()); return true; }