archive/net.sourceforge.phpeclipse.quantum.sql/src/com/quantum/properties/BookmarkPropertyPage.java

   1 package com.quantum.properties;
   2
   3 import com.quantum.IQuantumConstants;
   4 import com.quantum.adapters.AdapterFactory;
   5 import com.quantum.adapters.DriverInfo;
   6 import com.quantum.model.Bookmark;
   7 import com.quantum.model.BookmarkCollection;
   8 import com.quantum.model.JDBCDriver;
   9 import com.quantum.view.bookmark.TreeNode;
  10
  11 import org.eclipse.swt.SWT;
  12 import org.eclipse.swt.events.SelectionAdapter;
  13 import org.eclipse.swt.events.SelectionEvent;
  14 import org.eclipse.swt.layout.GridData;
  15 import org.eclipse.swt.layout.GridLayout;
  16 import org.eclipse.swt.widgets.Button;
  17 import org.eclipse.swt.widgets.Combo;
  18 import org.eclipse.swt.widgets.Composite;
  19 import org.eclipse.swt.widgets.Control;
  20 import org.eclipse.swt.widgets.Label;
  21 import org.eclipse.swt.widgets.TabFolder;
  22 import org.eclipse.swt.widgets.TabItem;
  23 import org.eclipse.swt.widgets.Text;
  24 import org.eclipse.ui.dialogs.PropertyPage;
  25
  26 public class BookmarkPropertyPage extends PropertyPage {
  27
  28     private Text password;
  29     private Text userid;
  30     private Button prompt;
  31
  32     private Text jdbcURL;
  33     private Text driverName;
  34     private Text driverPath;
  35
  36     private Combo type;
  37         private Combo autoCommit;
  38     private DriverInfo[] adapters = AdapterFactory.getInstance().getDriverList();
  39
  40     protected Control createContents(Composite parent) {
  41
  42         Composite composite = new Composite(parent, SWT.NONE);
  43         GridLayout layout = new GridLayout();
  44         layout.numColumns = 2;
  45         composite.setLayout(layout);
  46         GridData data = new GridData(GridData.FILL);
  47         data.grabExcessHorizontalSpace = true;
  48         composite.setLayoutData(data);
  49
  50                 Label nameLabel = new Label(composite, SWT.NONE);
  51         nameLabel.setText("Name:");
  52
  53         Label name = new Label(composite, SWT.NONE);
  54
  55         Bookmark bookmark = getBookmark();
  56         String description = bookmark.getName();
  57         name.setText(description);
  58
  59         TabFolder tabFolder = new TabFolder(parent, SWT.NONE);
  60         layout = new GridLayout();
  61         tabFolder.setLayout(layout);
  62         data = new GridData(GridData.FILL_BOTH);
  63         data.grabExcessHorizontalSpace = true;
  64         data.grabExcessVerticalSpace = true;
  65         data.verticalAlignment = GridData.FILL;
  66         data.horizontalSpan = 2;
  67         data.verticalAlignment = GridData.VERTICAL_ALIGN_BEGINNING;
  68         tabFolder.setLayoutData(data);
  69
  70         createUserTab(tabFolder);
  71         createDriverTab(tabFolder);
  72         createOptionsTab(tabFolder);
  73
  74         performDefaults();
  75         return composite;
  76         }
  77
  78         private Bookmark getBookmark() {
  79         Bookmark bookmark =
  80             ((TreeNode) getElement()).getBookmark();
  81         return bookmark;
  82     }
  83
  84     private void createDriverTab(TabFolder tabFolder) {
  85         TabItem driverTab = new TabItem(tabFolder, SWT.NONE);
  86         driverTab.setText("JDBC Driver");
  87
  88         Composite composite = new Composite(tabFolder, SWT.NONE);
  89         GridLayout layout = new GridLayout();
  90         layout.numColumns = 2;
  91         composite.setLayout(layout);
  92         GridData data = new GridData(GridData.FILL);
  93         data.verticalAlignment = GridData.VERTICAL_ALIGN_BEGINNING;
  94         data.grabExcessHorizontalSpace = true;
  95         composite.setLayoutData(data);
  96
  97         Label label = new Label(composite, SWT.NONE);
  98         label.setText("Connection URL:");
  99
 100         this.jdbcURL = new Text(composite, SWT.BORDER);
 101         data = new GridData(GridData.FILL);
 102         data.horizontalAlignment = GridData.FILL;
 103         data.grabExcessHorizontalSpace = true;
 104         data.grabExcessHorizontalSpace = true;
 105         this.jdbcURL.setLayoutData(data);
 106
 107         label = new Label(composite, SWT.NONE);
 108         label.setText("Driver Name:");
 109
 110         this.driverName = new Text(composite, SWT.BORDER);
 111         data = new GridData(GridData.FILL);
 112         data.horizontalAlignment = GridData.FILL;
 113         data.grabExcessHorizontalSpace = true;
 114         this.driverName.setLayoutData(data);
 115
 116         label = new Label(composite, SWT.NONE);
 117         label.setText("Driver Location:");
 118
 119         this.driverPath = new Text(composite, SWT.BORDER);
 120         data = new GridData(GridData.FILL);
 121         data.horizontalAlignment = GridData.FILL;
 122         data.grabExcessHorizontalSpace = true;
 123         this.driverPath.setLayoutData(data);
 124
 125         label = new Label(composite, SWT.NULL);
 126         label.setText("Type:");
 127         this.type = new Combo(composite, SWT.SIMPLE | SWT.DROP_DOWN | SWT.READ_ONLY);
 128         String adapterNames[] = new String[adapters.length];
 129         for (int i = 0; i < adapters.length; i++) {
 130             adapterNames[i] = adapters[i].getDisplayName();
 131         }
 132         this.type.setItems(adapterNames);
 133
 134         data = new GridData();
 135         data.horizontalAlignment = GridData.FILL;
 136         this.type.setLayoutData(data);
 137
 138         driverTab.setControl(composite);
 139     }
 140
 141     private void createUserTab(TabFolder tabFolder) {
 142         TabItem userTab = new TabItem(tabFolder, SWT.NONE);
 143         userTab.setText("User");
 144
 145         Composite composite = new Composite(tabFolder, SWT.NONE);
 146         GridLayout layout = new GridLayout();
 147         layout.numColumns = 2;
 148         composite.setLayout(layout);
 149         GridData data = new GridData(GridData.FILL);
 150         data.verticalAlignment = GridData.VERTICAL_ALIGN_BEGINNING;
 151         data.grabExcessHorizontalSpace = true;
 152         composite.setLayoutData(data);
 153
 154         Label useridLabel = new Label(composite, SWT.NONE);
 155         useridLabel.setText("Userid:");
 156
 157         this.userid = new Text(composite, SWT.BORDER);
 158         data = new GridData(GridData.FILL);
 159         data.horizontalAlignment = GridData.FILL;
 160         data.grabExcessHorizontalSpace = true;
 161         data.grabExcessHorizontalSpace = true;
 162         this.userid.setLayoutData(data);
 163
 164         Label passworLabel = new Label(composite, SWT.NONE);
 165         passworLabel.setText("Password:");
 166
 167         this.password = new Text(composite, SWT.BORDER);
 168         this.password.setEchoChar('*');
 169         data = new GridData(GridData.FILL);
 170         data.horizontalAlignment = GridData.FILL;
 171         data.grabExcessHorizontalSpace = true;
 172         this.password.setLayoutData(data);
 173
 174         this.prompt = new Button(composite, SWT.CHECK);
 175         this.prompt.setText("Prompt for password");
 176         data = new GridData(GridData.FILL);
 177         data.horizontalSpan = 2;
 178         data.horizontalAlignment = GridData.FILL;
 179         data.grabExcessHorizontalSpace = true;
 180         this.prompt.setLayoutData(data);
 181
 182         this.prompt.addSelectionListener(new SelectionAdapter() {
 183             public void widgetSelected(SelectionEvent event) {
 184                 password.setEditable(!((Button) event.getSource()).getSelection());
 185             }
 186         });
 187
 188         userTab.setControl(composite);
 189     }
 190
 191         /**
 192           * @param tabFolder
 193           */
 194          private void createOptionsTab(TabFolder tabFolder) {
 195                 TabItem optionsTab = new TabItem(tabFolder, SWT.NONE);
 196                 optionsTab.setText("Options");
 197
 198                 Composite composite = new Composite(tabFolder, SWT.NONE);
 199                 GridLayout layout = new GridLayout();
 200                 layout.numColumns = 2;
 201                 composite.setLayout(layout);
 202                 GridData data = new GridData(GridData.FILL);
 203                 data.verticalAlignment = GridData.VERTICAL_ALIGN_BEGINNING;
 204                 data.grabExcessHorizontalSpace = true;
 205                 composite.setLayoutData(data);
 206
 207                 Label label;
 208
 209                 label = new Label(composite, SWT.NULL);
 210                 label.setText("On connection, Auto-Commit should be:");
 211                 this.autoCommit = new Combo(composite, SWT.SIMPLE | SWT.DROP_DOWN | SWT.READ_ONLY);
 212                 String autoCommitTypes[] = new String[] {
 213                         IQuantumConstants.autoCommitTrue,
 214                         IQuantumConstants.autoCommitFalse,
 215                         IQuantumConstants.autoCommitSaved
 216                 };
 217                 this.autoCommit.setItems(autoCommitTypes);
 218
 219                 data = new GridData();
 220                 data.horizontalAlignment = GridData.FILL;
 221                 this.autoCommit.setLayoutData(data);
 222
 223                 optionsTab.setControl(composite);
 224
 225          }
 226
 227
 228
 229     /**
 230      * @see org.eclipse.jface.preference.PreferencePage#performApply()
 231      */
 232     public boolean performOk() {
 233         Bookmark bookmark = getBookmark();
 234         bookmark.setUsername(this.userid.getText());
 235         bookmark.setPromptForPassword(this.prompt.getSelection());
 236         if (this.prompt.getSelection()) {
 237             bookmark.setPassword("");
 238         } else {
 239             bookmark.setPassword(this.password.getText());
 240         }
 241
 242         int index = this.type.getSelectionIndex();
 243         bookmark.setType(this.adapters[index].getDriverType());
 244         bookmark.setConnect(this.jdbcURL.getText());
 245                 JDBCDriver jdbcDriver = BookmarkCollection.getInstance().findDriver(
 246                                 this.driverName.getText(), this.driverPath.getText());
 247                 bookmark.setJDBCDriver(jdbcDriver);
 248         if (this.autoCommit.getSelectionIndex() >= 0)
 249                 bookmark.setAutoCommitPreference(this.autoCommit.getItem(this.autoCommit.getSelectionIndex()));
 250         return super.performOk();
 251     }
 252     /* (non-Javadoc)
 253      * @see org.eclipse.jface.preference.PreferencePage#performDefaults()
 254      */
 255     protected void performDefaults() {
 256         super.performDefaults();
 257         Bookmark bookmark = getBookmark();
 258
 259         this.prompt.setSelection(bookmark.getPromptForPassword());
 260         this.password.setEditable(!bookmark.getPromptForPassword());
 261         this.password.setText(bookmark.getPassword());
 262         this.userid.setText(bookmark.getUsername());
 263
 264         this.type.select(0);
 265         boolean done = false;
 266         for (int i = 0,
 267             length = (adapters == null) ? 0 : adapters.length;
 268             !done && i < length;
 269             i++) {
 270             if (bookmark.getType() != null &&
 271                 bookmark.getType().equals(adapters[i].getDriverType())) {
 272                 this.type.select(i);
 273                 done = true;
 274             }
 275         }
 276         if (bookmark.getAutoCommitPreference().equals(IQuantumConstants.autoCommitTrue))
 277                 this.autoCommit.select(0);
 278         else if (bookmark.getAutoCommitPreference().equals(IQuantumConstants.autoCommitFalse))
 279                         this.autoCommit.select(1);
 280                 else if (bookmark.getAutoCommitPreference().equals(IQuantumConstants.autoCommitSaved))
 281                         this.autoCommit.select(2);
 282
 283         this.driverName.setText(bookmark.getJDBCDriver().getClassName());
 284         this.jdbcURL.setText(bookmark.getConnect());
 285         this.driverPath.setText(bookmark.getJDBCDriver().getJarFileName());
 286     }
 287 }