Example usage for org.eclipse.jface.dialogs MessageDialog openConfirm

List of usage examples for org.eclipse.jface.dialogs MessageDialog openConfirm

  1. HOME
  2. Java
  3. org.eclipse.jface
  4. org.eclipse.jface.dialogs.*
  5. MessageDialog
  6. openConfirm

Introduction

In this page you can find the example usage for org.eclipse.jface.dialogs MessageDialog openConfirm.

Prototype

public static boolean openConfirm(Shell parent, String title, String message)

Source Link

Document

Convenience method to open a simple confirm (OK/Cancel) dialog.

Usage

From source file:com.hangum.tadpole.commons.admin.core.dialogs.users.ModifyUserDialog.java

License:Open Source License

@Override
protected void okPressed() {
    if (MessageDialog.openConfirm(getShell(), Messages.get().Confirm, Messages.get().ModifyUserDialog_13)) {
        UserDAO user = new UserDAO();
        user.setSeq(userDAO.getSeq());/*w  ww .  j  a  va  2 s  .  c  om*/
        user.setAllow_ip(textAllowIP.getText());
        user.setIs_regist_db(comboIsRegistDB.getText());
        user.setApproval_yn(comboApproval.getText());
        user.setIs_email_certification(comboUserConfirm.getText());
        user.setDelYn(comboDel.getText());

        // ?? ? no  session?  ?? .
        if ("YES".equals(user.getDelYn()) || "YES".equals(user.getApproval_yn())) { //$NON-NLS-1$ //$NON-NLS-2$
            String sessionId = SessionManagerListener.getSessionIds(user.getEmail());
        }

        try {
            TadpoleSystem_UserQuery.updateUserData(user);
        } catch (Exception e) {
            logger.error("data update", e); //$NON-NLS-1$

            Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
            ExceptionDetailsErrorDialog.openError(getShell(), Messages.get().Error, "User Info update", //$NON-NLS-1$
                    errStatus); //$NON-NLS-2$

            return;
        }

        super.okPressed();
    } else {
        return;
    }
}

From source file:com.hangum.tadpole.commons.admin.core.editors.sqlaudit.AdminSQLAuditEditor.java

License:Open Source License

/**
 * download//  w  ww. j av  a 2 s. c  o  m
 */
private void download() {
    if (gridHistory.getItemCount() == 0)
        return;
    if (!MessageDialog.openConfirm(getSite().getShell(), Messages.get().Confirm,
            Messages.get().AdminSQLAuditEditor_22))
        return;

    List<String[]> listCsvData = new ArrayList<String[]>();

    // add header
    listCsvData.add(strArrHeader);

    String[] strArryData = new String[gridHistory.getColumnCount()];
    for (int i = 0; i < gridHistory.getItemCount(); i++) {
        strArryData = new String[gridHistory.getColumnCount()];

        GridItem gi = gridHistory.getItem(i);
        for (int intColumnCnt = 0; intColumnCnt < gridHistory.getColumnCount(); intColumnCnt++) {
            strArryData[intColumnCnt] = Utils.convHtmlToLine(gi.getText(intColumnCnt));
        }
        listCsvData.add(strArryData);
    }

    try {
        String strCVSContent = CSVFileUtils.makeData(listCsvData);
        downloadExtFile("SQLAudit.csv", strCVSContent); //$NON-NLS-1$

        MessageDialog.openInformation(getSite().getShell(), Messages.get().Confirm,
                Messages.get().AdminSQLAuditEditor_24);
    } catch (Exception e) {
        logger.error("Save CSV Data", e); //$NON-NLS-1$
    }
}

From source file:com.hangum.tadpole.commons.admin.core.editors.system.AdminSystemSettingEditor.java

License:Open Source License

/**
 * save data//from w w w. ja  va 2  s  . co  m
 * 
 */
private void saveData() {
    if (!MessageDialog.openConfirm(null, Messages.get().Confirm, Messages.get().AdminSystemSettingEditor_4))
        return;

    try {
        UserInfoDataDAO userInfoDao = TadpoleSystem_UserInfoData
                .updateAdminValue(PreferenceDefine.ADMIN_NEW_USER_PERMIT, comboNewUserPermit.getText());
        GetAdminPreference.updateAdminData(PreferenceDefine.ADMIN_NEW_USER_PERMIT, userInfoDao);
    } catch (Exception e) {
        logger.error("save exception", e); //$NON-NLS-1$

        Status errStatus = new Status(IStatus.ERROR, Activator.PLUGIN_ID, e.getMessage(), e); //$NON-NLS-1$
        ExceptionDetailsErrorDialog.openError(null, Messages.get().Error, "", errStatus); //$NON-NLS-1$ //$NON-NLS-2$
    }
}

From source file:com.hangum.tadpole.importdb.core.dialog.importdb.csv.CsvToRDBImportDialog.java

License:Open Source License

/**
 * Create contents of the dialog./*from  ww w  .j  a va2s. c om*/
 * @param parent
 */
@Override
protected Control createDialogArea(Composite parent) {
    Composite container = (Composite) super.createDialogArea(parent);
    GridLayout gridLayout = (GridLayout) container.getLayout();
    gridLayout.horizontalSpacing = 5;
    gridLayout.verticalSpacing = 5;
    gridLayout.marginHeight = 5;
    gridLayout.marginWidth = 5;

    Composite compositeHead = new Composite(container, SWT.NONE);
    compositeHead.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
    compositeHead.setLayout(new GridLayout(3, false));

    Label lblTableName = new Label(compositeHead, SWT.NONE);
    lblTableName.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblTableName.setText(Messages.CsvToRDBImportDialog_0);

    textTableName = new Text(compositeHead, SWT.BORDER);
    textTableName.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));

    btnCopyNew = new Button(compositeHead, SWT.CHECK);
    btnCopyNew.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnDeleteAll.setSelection(true);
            btnTruncate.setSelection(false);
            btnNotDelete.setSelection(false);
            compositeExistsData.setEnabled(!btnCopyNew.getSelection());

            btnTrigger.setSelection(false);
            btnFk.setSelection(false);
            btnPk.setSelection(false);
            compositeDisable.setEnabled(!btnCopyNew.getSelection());

            btnInsert.setSelection(true);
            btnUpdate.setSelection(false);
            btnDelete.setSelection(false);
            compositeExecuteType.setEnabled(!btnCopyNew.getSelection());
        }
    });
    btnCopyNew.setText(Messages.CsvToRDBImportDialog_btnCopyNew_text);

    Label lblFileName = new Label(compositeHead, SWT.NONE);
    lblFileName.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblFileName.setText(Messages.CsvToRDBImportDialog_1);

    fileNameLabel = new Text(compositeHead, SWT.BORDER);
    fileNameLabel.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));

    final String url = startUploadReceiver();
    pushSession = new ServerPushSession();

    /* Window builder Design View bug */
    /*
    Label temp = new Label(compositeHead, SWT.NONE);
    temp.setText("Temp");
    temp.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false));
    */
    fileUpload = new FileUpload(compositeHead, SWT.NONE);
    fileUpload.setText(Messages.CsvToRDBImportDialog_2);
    fileUpload.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false));
    fileUpload.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            String fileName = fileUpload.getFileName();
            if ("".equals(fileName) || null == fileName) //$NON-NLS-1$
                return;

            if (!MessageDialog.openConfirm(null, Messages.CsvToRDBImportDialog_4,
                    Messages.CsvToRDBImportDialog_5))
                return;
            fileNameLabel.setText(fileName == null ? "" : fileName); //$NON-NLS-1$

            pushSession.start();
            fileUpload.submit(url);
        }
    });

    Label lblSeprator = new Label(compositeHead, SWT.NONE);
    lblSeprator.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblSeprator.setText(Messages.CsvToRDBImportDialog_6);

    Composite composite_3 = new Composite(compositeHead, SWT.NONE);
    composite_3.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    composite_3.setLayout(new GridLayout(3, false));

    textSeprator = new Text(composite_3, SWT.BORDER);
    GridData gd_textSeprator = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_textSeprator.widthHint = 101;
    textSeprator.setLayoutData(gd_textSeprator);
    textSeprator.setText(",");

    Label lblBatchSize = new Label(composite_3, SWT.NONE);
    lblBatchSize.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblBatchSize.setText(Messages.CsvToRDBImportDialog_lblBatchSize_text);

    textBatchSize = new Text(composite_3, SWT.BORDER | SWT.RIGHT);
    if (DBDefine.getDBDefine(userDB) == DBDefine.SQLite_DEFAULT) {
        //SQLite  BatchExecute? ? 200 ??  database logic? ?  1 executeBatch ? commit? ?? .
        textBatchSize.setEditable(false);
        textBatchSize.setText("1");
    } else {
        textBatchSize.setEditable(true);
        textBatchSize.setText(Messages.CsvToRDBImportDialog_text_1_text_1);
    }
    textBatchSize.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
    new Label(compositeHead, SWT.NONE);

    Label lblException = new Label(compositeHead, SWT.NONE);
    lblException.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblException.setText(Messages.CsvToRDBImportDialog_lblException_text);

    Composite composite_4 = new Composite(compositeHead, SWT.NONE);
    composite_4.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    composite_4.setLayout(new GridLayout(2, false));

    btnIgnore = new Button(composite_4, SWT.RADIO);
    GridData gd_btnIgnore = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnIgnore.widthHint = 98;
    btnIgnore.setLayoutData(gd_btnIgnore);
    btnIgnore.setToolTipText(Messages.CsvToRDBImportDialog_btnIgnore_toolTipText);
    btnIgnore.setText(Messages.CsvToRDBImportDialog_btnIgnore_text);

    btnStop = new Button(composite_4, SWT.RADIO);
    btnStop.setSelection(true);
    btnStop.setToolTipText(Messages.CsvToRDBImportDialog_btnStop_toolTipText);
    GridData gd_btnStop = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnStop.widthHint = 95;
    btnStop.setLayoutData(gd_btnStop);
    btnStop.setText(Messages.CsvToRDBImportDialog_btnStop_text);
    new Label(compositeHead, SWT.NONE);

    Label lblExecuteType = new Label(compositeHead, SWT.NONE);
    lblExecuteType.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblExecuteType.setText(Messages.CsvToRDBImportDialog_lblExecuteType_text);

    compositeExecuteType = new Composite(compositeHead, SWT.NONE);
    compositeExecuteType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    compositeExecuteType.setLayout(new GridLayout(3, false));

    btnInsert = new Button(compositeExecuteType, SWT.RADIO);
    GridData gd_btnInsert = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnInsert.widthHint = 97;
    btnInsert.setLayoutData(gd_btnInsert);
    btnInsert.setSelection(true);
    btnInsert.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnDeleteAll.setSelection(true);
            btnTruncate.setSelection(false);
            btnNotDelete.setSelection(false);
            compositeExistsData.setEnabled(true);
        }
    });
    btnInsert.setText(Messages.CsvToRDBImportDialog_btnInsert_text);

    btnUpdate = new Button(compositeExecuteType, SWT.RADIO);
    btnUpdate.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnTruncate.setSelection(false);
            btnDeleteAll.setSelection(false);
            btnNotDelete.setSelection(true);
            compositeExistsData.setEnabled(false);
        }
    });
    GridData gd_btnUpdate = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnUpdate.widthHint = 89;
    btnUpdate.setLayoutData(gd_btnUpdate);
    btnUpdate.setText(Messages.CsvToRDBImportDialog_btnUpdate_text);

    btnDelete = new Button(compositeExecuteType, SWT.RADIO);
    btnDelete.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnTruncate.setSelection(false);
            btnDeleteAll.setSelection(false);
            btnNotDelete.setSelection(true);
            compositeExistsData.setEnabled(false);
        }
    });
    GridData gd_btnDelete = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnDelete.widthHint = 88;
    btnDelete.setLayoutData(gd_btnDelete);
    btnDelete.setText(Messages.CsvToRDBImportDialog_btnDelete_text);

    Button btnSaveLog = new Button(compositeHead, SWT.NONE);
    btnSaveLog.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    btnSaveLog.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            if (!validate())
                return;
            saveResultLog();
        }
    });
    btnSaveLog.setText(Messages.CsvToRDBImportDialog_btnSaveLog_text);

    Label lblExistsData = new Label(compositeHead, SWT.NONE);
    lblExistsData.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblExistsData.setText(Messages.CsvToRDBImportDialog_lblExistsData_text);

    compositeExistsData = new Composite(compositeHead, SWT.NONE);
    compositeExistsData.setLayout(new GridLayout(3, false));
    compositeExistsData.setLayoutData(new GridData(SWT.FILL, SWT.TOP, false, false, 1, 1));

    btnTruncate = new Button(compositeExistsData, SWT.RADIO);
    GridData gd_btnTruncate = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnTruncate.widthHint = 97;
    btnTruncate.setLayoutData(gd_btnTruncate);
    btnTruncate.setText(Messages.CsvToRDBImportDialog_btnTruncate_text);

    btnDeleteAll = new Button(compositeExistsData, SWT.RADIO);
    GridData gd_btnDeleteAll = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnDeleteAll.widthHint = 91;
    btnDeleteAll.setLayoutData(gd_btnDeleteAll);
    btnDeleteAll.setSelection(true);
    btnDeleteAll.setText(Messages.CsvToRDBImportDialog_btnDeleteAll_text);

    btnNotDelete = new Button(compositeExistsData, SWT.RADIO);
    btnNotDelete.setText(Messages.CsvToRDBImportDialog_btnRadioButton_text);

    Button btnDownloadSql = new Button(compositeHead, SWT.NONE);
    btnDownloadSql.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    btnDownloadSql.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            if (!validate())
                return;
            downloadSQL();
        }
    });
    btnDownloadSql.setText(Messages.CsvToRDBImportDialog_btnDownloadSql_text);
    btnDownloadSql.setVisible(false);

    Label lblDisable = new Label(compositeHead, SWT.NONE);
    lblDisable.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblDisable.setText(Messages.CsvToRDBImportDialog_lblDisable_text);

    compositeDisable = new Composite(compositeHead, SWT.NONE);
    compositeDisable.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    compositeDisable.setLayout(new GridLayout(3, false));

    btnTrigger = new Button(compositeDisable, SWT.CHECK);
    GridData gd_btnTrigger = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnTrigger.widthHint = 81;
    btnTrigger.setLayoutData(gd_btnTrigger);
    btnTrigger.setText(Messages.CsvToRDBImportDialog_btnTrigger_text);

    btnPk = new Button(compositeDisable, SWT.CHECK);
    btnPk.setEnabled(false);
    GridData gd_btnPk = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnPk.widthHint = 67;
    btnPk.setLayoutData(gd_btnPk);
    btnPk.setText(Messages.CsvToRDBImportDialog_btnPk_text);

    btnFk = new Button(compositeDisable, SWT.CHECK);
    btnFk.setEnabled(false);
    GridData gd_btnFk = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnFk.widthHint = 72;
    btnFk.setLayoutData(gd_btnFk);
    btnFk.setText(Messages.CsvToRDBImportDialog_btnFk_text);

    Button btnGenrateSql = new Button(compositeHead, SWT.NONE);
    btnGenrateSql.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    btnGenrateSql.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            if (!validate())
                return;
            generatePreviewSQL();
        }
    });
    btnGenrateSql.setText(Messages.CsvToRDBImportDialog_11);

    Group grpSqlTemplate = new Group(container, SWT.NONE);
    grpSqlTemplate.setLayout(new GridLayout(1, false));
    grpSqlTemplate.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1));
    grpSqlTemplate.setText(Messages.CsvToRDBImportDialog_16);

    textSQL = new Text(grpSqlTemplate,
            SWT.BORDER | SWT.READ_ONLY | SWT.H_SCROLL | SWT.V_SCROLL | SWT.CANCEL | SWT.MULTI);
    textSQL.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1));

    registerServiceHandler();

    textTableName.setFocus();

    return container;
}

From source file:com.hangum.tadpole.importdb.core.dialog.importdb.csv.CsvToRDBImportDialog.java

License:Open Source License

@Override
protected void buttonPressed(int buttonId) {
    super.buttonPressed(buttonId);

    if (buttonId == ID_BTN_INSERT) {
        if (MessageDialog.openConfirm(null, Messages.CsvToRDBImportDialog_4,
                Messages.CsvToRDBImportDialog_14)) {
            insertData();//from   w  w  w.  j a va2  s  .c  o  m
        }
    }
}

From source file:com.hangum.tadpole.importdb.core.dialog.importdb.editor.MongoDBImportEditor.java

License:Open Source License

/**
 * data import/*from  ww  w. j  a v a 2 s  .co  m*/
 */
private void importData() {
    // ? .
    if (tabFolderQuery.getSelectionIndex() == 0) {
        if (tableColumnListComposite.getSelectListTables().isEmpty())
            return;
    } else if (tabFolderQuery.getSelectionIndex() == 1) {
        if ("".equals(textCollectionName.getText().trim())) { //$NON-NLS-1$
            MessageDialog.openError(null, Messages.MongoDBImportEditor_14, Messages.QueryToMongoDBImport_5);
            return;
        }

        if ("".equals(textQuery.getText().trim())) { //$NON-NLS-1$
            MessageDialog.openInformation(null, Messages.QueryToMongoDBImport_1,
                    Messages.QueryToMongoDBImport_2);
            return;
        }
    }

    // job make
    final UserDBDAO sourceDBDAO = (UserDBDAO) comboDBList.getData(comboDBList.getText());
    Job job = null;
    if (MessageDialog.openConfirm(null, "Confirm", Messages.MongoDBImportEditor_1)) { //$NON-NLS-1$
        if (tabFolderQuery.getSelectionIndex() == 0) {

            DBImport dbImport = null;
            if (targetDBDAO != null
                    && DBDefine.MONGODB_DEFAULT == DBDefine.getDBDefine(sourceDBDAO.getDbms_types())) {
                dbImport = new MongoDBCollectionToMongodBImport(sourceDBDAO, targetDBDAO,
                        tableColumnListComposite.getSelectListTables());
            } else {
                dbImport = new RDBTableToMongoDBImport(sourceDBDAO, targetDBDAO,
                        tableColumnListComposite.getSelectListTables());
            }
            job = dbImport.workTableImport();
            if (job == null)
                return;

        } else if (tabFolderQuery.getSelectionIndex() == 1) {
            if (targetDBDAO != null
                    && DBDefine.MONGODB_DEFAULT == DBDefine.getDBDefine(sourceDBDAO.getDbms_types())) {
                MessageDialog.openInformation(null, "Confirm", "Not support MongoDB.");
                return;
            } else {
                QueryToMongoDBImport importData = new QueryToMongoDBImport(sourceDBDAO, targetDBDAO,
                        textCollectionName.getText(), textQuery.getText(), btnExistOnDelete.getSelection());
                job = importData.workTableImport();
                if (job == null)
                    return;
            }
        }
    } else
        return;

    // job listener
    job.addJobChangeListener(new JobChangeAdapter() {
        public void done(IJobChangeEvent event) {
            final IJobChangeEvent jobEvent = event;
            getSite().getShell().getDisplay().asyncExec(new Runnable() {
                public void run() {
                    if (jobEvent.getResult().isOK()) {
                        MessageDialog.openInformation(null, "Confirm", Messages.MongoDBImportEditor_11); //$NON-NLS-1$
                    } else {
                        ExceptionDetailsErrorDialog.openError(null, "Error", Messages.MongoDBImportEditor_12, //$NON-NLS-1$
                                jobEvent.getResult());
                    }
                }
            }); // end display.asyncExec
        } // end done         
    }); // end job

    job.setName(targetDBDAO.getDisplay_name());
    job.setUser(true);
    job.schedule();
}

From source file:com.hangum.tadpole.importdb.core.dialog.importdb.sql.SQLToDBImportDialog.java

License:Open Source License

/**
 * Create contents of the dialog./*  w  w  w  .j  ava2  s. c  om*/
 * @param parent
 */
@Override
protected Control createDialogArea(Composite parent) {
    Composite container = (Composite) super.createDialogArea(parent);
    GridLayout gridLayout = (GridLayout) container.getLayout();
    gridLayout.verticalSpacing = 5;
    gridLayout.horizontalSpacing = 5;
    gridLayout.marginHeight = 5;
    gridLayout.marginWidth = 5;

    Composite compositeHead = new Composite(container, SWT.NONE);
    compositeHead.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
    compositeHead.setLayout(new GridLayout(3, false));

    Label lblFileName = new Label(compositeHead, SWT.NONE);
    lblFileName.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblFileName.setText(Messages.CsvToRDBImportDialog_1);

    fileNameLabel = new Text(compositeHead, SWT.BORDER);
    fileNameLabel.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));

    final String url = startUploadReceiver();
    pushSession = new ServerPushSession();

    /* fileUpload ?  ???    */
    /*
    Label lblDumy = new Label(compositeHead, SWT.NONE);
    lblDumy.setText(Messages.CsvToRDBImportDialog_2);
    lblDumy.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false));
    */
    fileUpload = new FileUpload(compositeHead, SWT.NONE);
    fileUpload.setText(Messages.CsvToRDBImportDialog_2);
    fileUpload.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false));
    fileUpload.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            String fileName = fileUpload.getFileName();
            if ("".equals(fileName) || null == fileName) //$NON-NLS-1$
                return;

            if (!MessageDialog.openConfirm(null, Messages.CsvToRDBImportDialog_4,
                    Messages.CsvToRDBImportDialog_5))
                return;
            fileNameLabel.setText(fileName == null ? "" : fileName); //$NON-NLS-1$

            pushSession.start();
            fileUpload.submit(url);
        }
    });

    Label lblSeprator = new Label(compositeHead, SWT.NONE);
    lblSeprator.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblSeprator.setText(Messages.SQLToDBImportDialog_lblSeprator_text);

    textSeprator = new Text(compositeHead, SWT.BORDER);
    textSeprator.setText(Messages.SQLToDBImportDialog_text_1_text);
    textSeprator.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
    new Label(compositeHead, SWT.NONE);

    Label lblBatchSize = new Label(compositeHead, SWT.NONE);
    lblBatchSize.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblBatchSize.setText(Messages.SQLToDBImportDialog_0);

    textBatchSize = new Text(compositeHead, SWT.BORDER | SWT.RIGHT);
    if (DBDefine.getDBDefine(userDB) == DBDefine.SQLite_DEFAULT) {
        //SQLite  BatchExecute? ? 200 ??  database logic? ?  1 executeBatch ? commit? ?? .
        textBatchSize.setEditable(false);
        textBatchSize.setText("1");
    } else {
        textBatchSize.setEditable(true);
        textBatchSize.setText(Messages.SQLToDBImportDialog_BatchSize);
    }
    textBatchSize.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
    new Label(compositeHead, SWT.NONE);

    Label lblException = new Label(compositeHead, SWT.NONE);
    lblException.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblException.setText(Messages.SQLToDBImportDialog_Exception);

    Composite composite = new Composite(compositeHead, SWT.NONE);
    composite.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    composite.setLayout(new GridLayout(2, false));

    btnIgnore = new Button(composite, SWT.RADIO);
    GridData gd_btnIgnore = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnIgnore.widthHint = 98;
    btnIgnore.setLayoutData(gd_btnIgnore);
    btnIgnore.setText(Messages.SQLToDBImportDialog_Ignore);

    btnStop = new Button(composite, SWT.RADIO);
    btnStop.setSelection(true);
    GridData gd_btnStop = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnStop.widthHint = 92;
    btnStop.setLayoutData(gd_btnStop);
    btnStop.setText(Messages.SQLToDBImportDialog_Stop);
    new Label(compositeHead, SWT.NONE);
    new Label(compositeHead, SWT.NONE);

    compositeDumy = new Composite(compositeHead, SWT.NONE);
    GridData gd_composite_1 = new GridData(SWT.FILL, SWT.TOP, false, false, 1, 1);
    gd_composite_1.heightHint = 16;
    compositeDumy.setLayoutData(gd_composite_1);
    new Label(compositeHead, SWT.NONE);

    registerServiceHandler();

    return container;
}

From source file:com.hangum.tadpole.importdb.core.dialog.importdb.sql.SQLToDBImportDialog.java

License:Open Source License

private void insert() throws IOException {
    int ret;/* w ww.ja  va 2s . c  o m*/
    BOMInputStream bomInputStream = null;

    File[] arryFiles = receiver.getTargetFiles();
    if (arryFiles.length == 0) {
        MessageDialog.openError(null, Messages.CsvToRDBImportDialog_4, Messages.CsvToRDBImportDialog_21);
        return;
    }

    if (!MessageDialog.openConfirm(null, Messages.CsvToRDBImportDialog_4,
            Messages.SQLToDBImportDialog_UploadQuestion))
        return;
    bufferBatchResult = new StringBuffer();

    try {
        batchSize = Integer.valueOf(textBatchSize.getText());
    } catch (Exception e) {
        batchSize = 1000;
    }

    File userUploadFile = arryFiles[arryFiles.length - 1];
    try {
        // bom?  charset? ? ?.
        bomInputStream = new BOMInputStream(FileUtils.openInputStream(FileUtils.getFile(userUploadFile)));//`, false, ByteOrderMark.UTF_8, ByteOrderMark.UTF_16LE, ByteOrderMark.UTF_16BE, ByteOrderMark.UTF_32LE, ByteOrderMark.UTF_32BE);

        String charsetName = "utf-8";
        String strSQLData = "";
        if (bomInputStream.getBOM() == null) {
            strSQLData = FileUtils.readFileToString(userUploadFile, charsetName);
        } else {
            charsetName = bomInputStream.getBOMCharsetName();
            strSQLData = FileUtils.readFileToString(userUploadFile, charsetName).substring(1);
        }

        String[] strArrySQL = StringUtils.split(strSQLData, textSeprator.getText());
        ret = runSQLExecuteBatch(Arrays.asList(strArrySQL));

        if (ret == 0)
            MessageDialog.openInformation(null, "Confirm", Messages.SQLToDBImportDialog_StoreData); //$NON-NLS-1$
    } catch (IOException e) {
        logger.error(Messages.SQLToDBImportDialog_ReadError, e);
        MessageDialog.openError(null, Messages.CsvToRDBImportDialog_4,
                Messages.SQLToDBImportDialog_LoadException + e.getMessage());

    } catch (Exception e) {
        logger.error(Messages.SQLToDBImportDialog_ImportException, e);
        MessageDialog.openError(null, Messages.CsvToRDBImportDialog_4,
                Messages.SQLToDBImportDialog_LoadException + e.getMessage());
    } finally {
        if (bomInputStream != null)
            bomInputStream.close();
    }
}

From source file:com.hangum.tadpole.importexport.core.dialogs.CsvToRDBImportDialog.java

License:Open Source License

/**
 * Create contents of the dialog.//from  w w  w. ja  va2  s  .  com
 * @param parent
 */
@Override
protected Control createDialogArea(Composite parent) {
    Composite container = (Composite) super.createDialogArea(parent);
    GridLayout gridLayout = (GridLayout) container.getLayout();
    gridLayout.horizontalSpacing = 5;
    gridLayout.verticalSpacing = 5;
    gridLayout.marginHeight = 5;
    gridLayout.marginWidth = 5;

    Composite compositeHead = new Composite(container, SWT.NONE);
    compositeHead.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
    compositeHead.setLayout(new GridLayout(3, false));

    Label lblTableName = new Label(compositeHead, SWT.NONE);
    lblTableName.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblTableName.setText(Messages.get().CsvToRDBImportDialog_0);

    textTableName = new Text(compositeHead, SWT.BORDER);
    textTableName.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));

    btnCopyNew = new Button(compositeHead, SWT.CHECK);
    btnCopyNew.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnDeleteAll.setSelection(true);
            btnTruncate.setSelection(false);
            btnNotDelete.setSelection(false);
            compositeExistsData.setEnabled(!btnCopyNew.getSelection());

            btnTrigger.setSelection(false);
            btnFk.setSelection(false);
            btnPk.setSelection(false);
            compositeDisable.setEnabled(!btnCopyNew.getSelection());

            btnInsert.setSelection(true);
            btnUpdate.setSelection(false);
            btnDelete.setSelection(false);
            compositeExecuteType.setEnabled(!btnCopyNew.getSelection());
        }
    });
    btnCopyNew.setText(Messages.get().CsvToRDBImportDialog_btnCopyNew_text);

    Label lblFileName = new Label(compositeHead, SWT.NONE);
    lblFileName.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblFileName.setText(Messages.get().CsvToRDBImportDialog_1);

    fileNameLabel = new Text(compositeHead, SWT.BORDER);
    fileNameLabel.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));

    final String url = startUploadReceiver();
    pushSession = new ServerPushSession();

    /* Window builder Design View bug */
    /*
    Label temp = new Label(compositeHead, SWT.NONE);
    temp.setText("Temp");
    temp.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false));
    */
    fileUpload = new FileUpload(compositeHead, SWT.NONE);
    fileUpload.setText(Messages.get().CsvToRDBImportDialog_2);
    fileUpload.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false));
    fileUpload.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            String fileName = fileUpload.getFileName();
            if ("".equals(fileName) || null == fileName) //$NON-NLS-1$
                return;

            if (!MessageDialog.openConfirm(null, Messages.get().Confirm, Messages.get().CsvToRDBImportDialog_5))
                return;
            fileNameLabel.setText(fileName == null ? "" : fileName); //$NON-NLS-1$

            pushSession.start();
            fileUpload.submit(url);
        }
    });

    Label lblSeprator = new Label(compositeHead, SWT.NONE);
    lblSeprator.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblSeprator.setText(Messages.get().CsvToRDBImportDialog_6);

    Composite composite_3 = new Composite(compositeHead, SWT.NONE);
    composite_3.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    composite_3.setLayout(new GridLayout(3, false));

    textSeprator = new Text(composite_3, SWT.BORDER);
    GridData gd_textSeprator = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_textSeprator.widthHint = 101;
    textSeprator.setLayoutData(gd_textSeprator);
    textSeprator.setText(","); //$NON-NLS-1$

    Label lblBatchSize = new Label(composite_3, SWT.NONE);
    lblBatchSize.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblBatchSize.setText(Messages.get().CsvToRDBImportDialog_lblBatchSize_text);

    textBatchSize = new Text(composite_3, SWT.BORDER | SWT.RIGHT);
    if (userDB.getDBDefine() == DBDefine.SQLite_DEFAULT) {
        //SQLite  BatchExecute? ? 200 ??  database logic? ?  1 executeBatch ? commit? ?? .
        textBatchSize.setEditable(false);
        textBatchSize.setText("1"); //$NON-NLS-1$
    } else {
        textBatchSize.setEditable(true);
        textBatchSize.setText(Messages.get().CsvToRDBImportDialog_text_1_text_1);
    }
    textBatchSize.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
    new Label(compositeHead, SWT.NONE);

    Label lblException = new Label(compositeHead, SWT.NONE);
    lblException.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblException.setText(Messages.get().CsvToRDBImportDialog_lblException_text);

    Composite composite_4 = new Composite(compositeHead, SWT.NONE);
    composite_4.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    composite_4.setLayout(new GridLayout(2, false));

    btnIgnore = new Button(composite_4, SWT.RADIO);
    GridData gd_btnIgnore = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnIgnore.widthHint = 98;
    btnIgnore.setLayoutData(gd_btnIgnore);
    btnIgnore.setToolTipText(Messages.get().CsvToRDBImportDialog_btnIgnore_toolTipText);
    btnIgnore.setText(Messages.get().CsvToRDBImportDialog_btnIgnore_text);

    btnStop = new Button(composite_4, SWT.RADIO);
    btnStop.setSelection(true);
    btnStop.setToolTipText(Messages.get().CsvToRDBImportDialog_btnStop_toolTipText);
    GridData gd_btnStop = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnStop.widthHint = 95;
    btnStop.setLayoutData(gd_btnStop);
    btnStop.setText(Messages.get().CsvToRDBImportDialog_btnStop_text);
    new Label(compositeHead, SWT.NONE);

    Label lblExecuteType = new Label(compositeHead, SWT.NONE);
    lblExecuteType.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblExecuteType.setText(Messages.get().CsvToRDBImportDialog_lblExecuteType_text);

    compositeExecuteType = new Composite(compositeHead, SWT.NONE);
    compositeExecuteType.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    compositeExecuteType.setLayout(new GridLayout(3, false));

    btnInsert = new Button(compositeExecuteType, SWT.RADIO);
    GridData gd_btnInsert = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnInsert.widthHint = 97;
    btnInsert.setLayoutData(gd_btnInsert);
    btnInsert.setSelection(true);
    btnInsert.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnDeleteAll.setSelection(true);
            btnTruncate.setSelection(false);
            btnNotDelete.setSelection(false);
            compositeExistsData.setEnabled(true);
        }
    });
    btnInsert.setText(Messages.get().CsvToRDBImportDialog_btnInsert_text);

    btnUpdate = new Button(compositeExecuteType, SWT.RADIO);
    btnUpdate.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnTruncate.setSelection(false);
            btnDeleteAll.setSelection(false);
            btnNotDelete.setSelection(true);
            compositeExistsData.setEnabled(false);
        }
    });
    GridData gd_btnUpdate = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnUpdate.widthHint = 89;
    btnUpdate.setLayoutData(gd_btnUpdate);
    btnUpdate.setText(Messages.get().CsvToRDBImportDialog_btnUpdate_text);

    btnDelete = new Button(compositeExecuteType, SWT.RADIO);
    btnDelete.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            // update delete ? ?  ???  ?  ? ?  ?.
            btnTruncate.setSelection(false);
            btnDeleteAll.setSelection(false);
            btnNotDelete.setSelection(true);
            compositeExistsData.setEnabled(false);
        }
    });
    GridData gd_btnDelete = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnDelete.widthHint = 88;
    btnDelete.setLayoutData(gd_btnDelete);
    btnDelete.setText(Messages.get().CsvToRDBImportDialog_btnDelete_text);

    Button btnSaveLog = new Button(compositeHead, SWT.NONE);
    btnSaveLog.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    btnSaveLog.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            if (!validate())
                return;
            saveResultLog();
        }
    });
    btnSaveLog.setText(Messages.get().CsvToRDBImportDialog_btnSaveLog_text);

    Label lblExistsData = new Label(compositeHead, SWT.NONE);
    lblExistsData.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblExistsData.setText(Messages.get().CsvToRDBImportDialog_lblExistsData_text);

    compositeExistsData = new Composite(compositeHead, SWT.NONE);
    compositeExistsData.setLayout(new GridLayout(3, false));
    compositeExistsData.setLayoutData(new GridData(SWT.FILL, SWT.TOP, false, false, 1, 1));

    btnTruncate = new Button(compositeExistsData, SWT.RADIO);
    GridData gd_btnTruncate = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnTruncate.widthHint = 97;
    btnTruncate.setLayoutData(gd_btnTruncate);
    btnTruncate.setText(Messages.get().CsvToRDBImportDialog_btnTruncate_text);

    btnDeleteAll = new Button(compositeExistsData, SWT.RADIO);
    GridData gd_btnDeleteAll = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnDeleteAll.widthHint = 91;
    btnDeleteAll.setLayoutData(gd_btnDeleteAll);
    btnDeleteAll.setSelection(true);
    btnDeleteAll.setText(Messages.get().CsvToRDBImportDialog_btnDeleteAll_text);

    btnNotDelete = new Button(compositeExistsData, SWT.RADIO);
    btnNotDelete.setText(Messages.get().CsvToRDBImportDialog_btnRadioButton_text);

    Button btnDownloadSql = new Button(compositeHead, SWT.NONE);
    btnDownloadSql.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    btnDownloadSql.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            if (!validate())
                return;
            downloadSQL();
        }
    });
    btnDownloadSql.setText(Messages.get().CsvToRDBImportDialog_btnDownloadSql_text);
    btnDownloadSql.setVisible(false);

    Label lblDisable = new Label(compositeHead, SWT.NONE);
    lblDisable.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
    lblDisable.setText(Messages.get().CsvToRDBImportDialog_lblDisable_text);

    compositeDisable = new Composite(compositeHead, SWT.NONE);
    compositeDisable.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    compositeDisable.setLayout(new GridLayout(3, false));

    btnTrigger = new Button(compositeDisable, SWT.CHECK);
    GridData gd_btnTrigger = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnTrigger.widthHint = 81;
    btnTrigger.setLayoutData(gd_btnTrigger);
    btnTrigger.setText(Messages.get().CsvToRDBImportDialog_btnTrigger_text);

    btnPk = new Button(compositeDisable, SWT.CHECK);
    btnPk.setEnabled(false);
    GridData gd_btnPk = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnPk.widthHint = 67;
    btnPk.setLayoutData(gd_btnPk);
    btnPk.setText(Messages.get().CsvToRDBImportDialog_btnPk_text);

    btnFk = new Button(compositeDisable, SWT.CHECK);
    btnFk.setEnabled(false);
    GridData gd_btnFk = new GridData(SWT.LEFT, SWT.CENTER, false, false, 1, 1);
    gd_btnFk.widthHint = 72;
    btnFk.setLayoutData(gd_btnFk);
    btnFk.setText(Messages.get().CsvToRDBImportDialog_btnFk_text);

    Button btnGenrateSql = new Button(compositeHead, SWT.NONE);
    btnGenrateSql.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, false, false, 1, 1));
    btnGenrateSql.addSelectionListener(new SelectionAdapter() {
        @Override
        public void widgetSelected(SelectionEvent e) {
            if (!validate())
                return;
            generatePreviewSQL();
        }
    });
    btnGenrateSql.setText(Messages.get().CsvToRDBImportDialog_11);

    Group grpSqlTemplate = new Group(container, SWT.NONE);
    grpSqlTemplate.setLayout(new GridLayout(1, false));
    grpSqlTemplate.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1));
    grpSqlTemplate.setText(Messages.get().CsvToRDBImportDialog_16);

    textSQL = new Text(grpSqlTemplate,
            SWT.BORDER | SWT.READ_ONLY | SWT.H_SCROLL | SWT.V_SCROLL | SWT.CANCEL | SWT.MULTI);
    textSQL.setLayoutData(new GridData(SWT.FILL, SWT.FILL, true, true, 1, 1));

    registerServiceHandler();

    textTableName.setFocus();

    return container;
}

From source file:com.hangum.tadpole.importexport.core.dialogs.CsvToRDBImportDialog.java

License:Open Source License

@Override
protected void buttonPressed(int buttonId) {
    super.buttonPressed(buttonId);

    if (buttonId == ID_BTN_INSERT) {
        if (MessageDialog.openConfirm(null, Messages.get().Confirm, Messages.get().CsvToRDBImportDialog_14)) {
            insertData();//from   w ww.  jav  a 2 s . co  m
        }
    }
}