private JTextField4j jTextFieldURL;

  private static final long serialVersionUID = 1;

  private JDesktopPane desktopPane = new JDesktopPane();

  private JButton4j jButtonApply;

  private JButton4j jButtonDelete;

  private JButton4j jButtonUp;

  private JButton4j jButtonClose;

  private JTextField4j jTextFieldSchema;

  private JLabel4j_std jLabelSchema;

  private JLabel4j_std jLabelSelectTime;

  private JTextField4j jTextFieldSelectLimit;

  private JButton4j jButtonUpdate;

  private JButton4j jButtonTest;

  private JLabel4j_std jLabelServer;

  private JTextField4j jTextFieldDatabase;

  private JTextField4j jTextFieldSID;

  private JCheckBox jCheckBoxEnabled;

  private JCheckBox jCheckBoxSplash;

  private JTextField4j jTextFieldDriver;

  private JTextField4j jTextFieldSiteNo;

  private JTextField4j jTextFieldPort;

  private JPasswordField jTextFieldPassword;

  private JTextField4j jTextFieldUsername;

  private JTextField4j jTextFieldDateTime;

  private JLabel4j_std jLabelPort;

  private JLabel4j_std jLabelUsername;

  private JLabel4j_std jLabelSiteNo;

  private JLabel4j_std jLabelDescription;

  private JLabel4j_std jLabelPassword;

  private JLabel4j_std jLabelDBDateTime;

  private JLabel4j_std jLabelConnectionString;

  private JTextField4j jTextFieldServer;

  private JButton4j jButtonCancel;

  private JLabel4j_std jLabelSID;

  private JLabel4j_std jLabelDatabase;

  private JLabel4j_std jLabelDriver;

  private JTextField4j jTextFieldConnect;

  private JComboBox4j jComboBoxjdbcDriver;

  private JLabel4j_std jLabelDatabaseType;

  private JTextField4j jTextFieldDescription;

  private JButton4j jButtonSave;

  private JButton4j jButtonUndo;

  private JButton4j jButtonDown;

  private JButton4j jButtonAdd;

  private JButton4j btnSchema;

  private JList4j jListHosts;

  private JScrollPane jScrollPane1;

  private LinkedList<JHost> hostList = new LinkedList<JHost>();

  final Logger logger = Logger.getLogger(JFrameHostAdmin.class);

  private JFrameHostAdmin me;

  private JPanel contentPane;

  private JLabel4j_std jLabelUniqueID;

  private JTextField4j jTextFieldUniqueID;

  private JLabel4j_std jLabelMenuURL;

  private JProgressBar progressBar = new JProgressBar();

  private JLabel4j_std labelCommand = new JLabel4j_std("");

  private JTextField4j JTextFieldUpdateURL;

  private final ButtonGroup buttonGroup = new ButtonGroup();

  private JRadioButton4j rdbtnManual = new JRadioButton4j("MANUAL");

  private JRadioButton4j rdbtnAutomatic = new JRadioButton4j("AUTOMATIC");

  private JTextField4j jTextField4jInstallDir = new JTextField4j();

  private JPasswordField setupPasswordField;

  private JPasswordField verifyPasswordField;

  /**

   * Launch the application.

   */

  public static void main(String[] args)

  {

    EventQueue.invokeLater(new Runnable()

    {

      public void run()

      {

        try

        {

          JFrameHostAdmin frame = new JFrameHostAdmin();

          frame.setVisible(true);

        } catch (Exception e)

        {

          e.printStackTrace();

        }

      }

    });

  }

  private void setUpdateMode(String mode)

  {

    if (mode.equals("MANUAL"))

    {

      rdbtnManual.setSelected(true);

    }

    if (mode.equals("AUTOMATIC"))

    {

      rdbtnAutomatic.setSelected(true);

    }

  }

  private String getUpdateMode()

  {

    String result = "";

    if (rdbtnManual.isSelected())

    {

      result = "MANUAL";

    }

    if (rdbtnAutomatic.isSelected())

    {

      result = "AUTOMATIC";

    }

    return result;

  }

  public JFrameHostAdmin()

  {

    setResizable(false);

    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

    setBounds(100, 100, 937, 604);

    contentPane = new JPanel();

    contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));

    setContentPane(contentPane);

    contentPane.setLayout(null);

    desktopPane.setBounds(0, 0, 937, 581);

    desktopPane.setBackground(Color.WHITE);

    contentPane.add(desktopPane);

    Common.sessionID = JUnique.getUniqueID();

    Common.sd.setData(Common.sessionID, "silentExceptions", "No", true);

    JUtility.initLogging("");

    logger.debug("JFrameHostAdmin starting...");

    initGUI();

    setIconImage(Common.imageIconloader.getImageIcon(Common.image_osx_setup4j).getImage());

    Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();

    setLocation((screenSize.width - getSize().width) / 2, (screenSize.height - getSize().height) / 2);

    getHosts();

   

    if (Common.setupPassword.equals("")==false)

    {

      JDialogSetupPassword u = new JDialogSetupPassword(null,Common.setupPassword);

      u.setModal(true);

    }

   

    populateList("");

  }

  private void jTextFieldKeyTyped()

  {

    jButtonApply.setEnabled(true);

    jButtonCancel.setEnabled(true);

    jButtonTest.setEnabled(false);

    jButtonUpdate.setEnabled(false);

  }

  private void setSaveButtonState(boolean enabled)

  {

    jButtonSave.setEnabled(enabled);

    jButtonUndo.setEnabled(enabled);

  }

  private void getHosts()

  {

    setEditable(false);

    hostList.clear();

    Common.hostList.loadHosts();

    hostList = Common.hostList.getHosts();

    jCheckBoxSplash.setSelected(Common.displaySplashScreen);

    JTextFieldUpdateURL.setText(Common.updateURL);

    jTextField4jInstallDir.setText(Common.updateInstallDir);

    if (Common.updateInstallDir.equals(""))

    {

      jTextField4jInstallDir.setText(Common.base_dir);

    }

    setupPasswordField.setText(Common.setupPassword);

    verifyPasswordField.setText(Common.setupPassword);

    setUpdateMode(Common.updateMODE);

    setButtonState();

  }

  private void renumberHosts()

  {

    for (int j = 0; j < hostList.size(); j++)

    {

      hostList.get(j).setSiteNumber(String.valueOf(j + 1));

    }

  }

  private void populateList(String defaultitem)

  {

    setButtonState();

    int sel = 0;

    DefaultComboBoxModel DefComboBoxMod = new DefaultComboBoxModel();

    for (int j = 0; j < hostList.size(); j++)

    {

      DefComboBoxMod.addElement(hostList.get(j));

      if (hostList.get(j).getSiteDescription().equals(defaultitem))

      {

        sel = j;

      }

    }

    ListModel jList1Model = DefComboBoxMod;

    jListHosts.setModel(jList1Model);

    jListHosts.setCellRenderer(Common.renderer_list);

    jListHosts.setSelectedIndex(sel);

  }

  private void writeBackHosts(LinkedList<JHost> hsts)

  {

    Common.hostList.disconnectAll();

    Common.hostList.clear();

    Common.hostList.addHosts(hsts);

  }

  private void setButtonState()

  {

    if (hostList.size() > 0)

    {

      jButtonUp.setEnabled(true);

      jButtonDown.setEnabled(true);

    } else

    {

      jButtonUp.setEnabled(false);

      jButtonDown.setEnabled(false);

    }

  }

  private void getHostData()

  {

    int j = jListHosts.getSelectedIndex();

    if (j >= 0)

    {

      JHost hst = new JHost();

      hst = (JHost) jListHosts.getModel().getElementAt(j);

      jTextFieldDescription.setText(hst.getSiteDescription());

      jTextFieldUniqueID.setText(hst.getUniqueID());

      jTextFieldURL.setText(hst.getSiteURL());

      jTextFieldSiteNo.setText(hst.getSiteNumber());

      jTextFieldDriver.setText(hst.getDatabaseParameters().getjdbcDriver());

      if (hst.getDatabaseParameters().getjdbcDriver().equals(""))

      {

        jComboBoxjdbcDriver.setSelectedIndex(0);

      }

      if (hst.getDatabaseParameters().getjdbcDriver().equals("com.mysql.jdbc.Driver"))

      {

        jComboBoxjdbcDriver.setSelectedIndex(1);

      }

      if (hst.getDatabaseParameters().getjdbcDriver().equals("oracle.jdbc.driver.OracleDriver"))

      {

        jComboBoxjdbcDriver.setSelectedIndex(2);

      }

      if (hst.getDatabaseParameters().getjdbcDriver().equals("com.microsoft.sqlserver.jdbc.SQLServerDriver"))

      {

        jComboBoxjdbcDriver.setSelectedIndex(3);

      }

      if (hst.getDatabaseParameters().getjdbcDriver().equals("http"))

      {

        jComboBoxjdbcDriver.setSelectedIndex(4);

      }

      jTextFieldConnect.setText(hst.getDatabaseParameters().getjdbcConnectString());

      jTextFieldDateTime.setText(hst.getDatabaseParameters().getjdbcDatabaseDateTimeToken());

      jTextFieldSelectLimit.setText(hst.getDatabaseParameters().getjdbcDatabaseSelectLimit());

      jTextFieldSchema.setText(hst.getDatabaseParameters().getjdbcDatabaseSchema());

      jTextFieldUsername.setText(hst.getDatabaseParameters().getjdbcUsername());

      jTextFieldPassword.setText(hst.getDatabaseParameters().getjdbcPassword());

      jTextFieldPort.setText(hst.getDatabaseParameters().getjdbcPort());

      jTextFieldSID.setText(hst.getDatabaseParameters().getjdbcSID());

      jTextFieldServer.setText(hst.getDatabaseParameters().getjdbcServer());

      jTextFieldDatabase.setText(hst.getDatabaseParameters().getjdbcDatabase());

      if (hst.getEnabled().equals("Y"))

        jCheckBoxEnabled.setSelected(true);

      else

        jCheckBoxEnabled.setSelected(false);

      setEditable(true);

      jButtonApply.setEnabled(false);

      jButtonCancel.setEnabled(false);

      jButtonTest.setEnabled(true);

      jButtonUpdate.setEnabled(false);

      btnSchema.setEnabled(false);

    } else

    {

      jTextFieldDescription.setText("");

      jTextFieldURL.setText("");

      jTextFieldSiteNo.setText("");

      jTextFieldDriver.setText("");

      jTextFieldConnect.setText("");

      jTextFieldDateTime.setText("");

      jTextFieldSelectLimit.setText("");

      jTextFieldUsername.setText("");

      jTextFieldPassword.setText("");

      jTextFieldPort.setText("");

      jTextFieldSID.setText("");

      jTextFieldServer.setText("");

      jTextFieldDatabase.setText("");

      jCheckBoxEnabled.setSelected(false);

      setEditable(false);

      // jButtonTest.setEnabled(false);

    }

  }

  private JHost setHostData()

  {

    int j = jListHosts.getSelectedIndex();

    JHost hst = new JHost();

    if (j > -1)

    {

      hst.setSiteDescription(jTextFieldDescription.getText());

      hst.setSiteURL(jTextFieldURL.getText());

      hst.setSiteNumber(jTextFieldSiteNo.getText());

      hst.getDatabaseParameters().setjdbcDriver(jTextFieldDriver.getText());

      hst.getDatabaseParameters().setjdbcDatabaseDateTimeToken(jTextFieldDateTime.getText());

      hst.getDatabaseParameters().setjdbcDatabaseSelectLimit(jTextFieldSelectLimit.getText());

      hst.getDatabaseParameters().setjdbcDatabaseSchema(jTextFieldSchema.getText());

      hst.getDatabaseParameters().setjdbcUsername(jTextFieldUsername.getText());

      hst.getDatabaseParameters().setjdbcPassword(String.valueOf(jTextFieldPassword.getPassword()));

      hst.getDatabaseParameters().setjdbcPort(jTextFieldPort.getText());

      hst.getDatabaseParameters().setjdbcSID(jTextFieldSID.getText());

      hst.getDatabaseParameters().setjdbcServer(jTextFieldServer.getText());

      hst.getDatabaseParameters().setjdbcDatabase(jTextFieldDatabase.getText());

      hst.setUniqueID(jTextFieldUniqueID.getText());

      hst.getSqlstatements().setjdbcDriver(hst.getDatabaseParameters().getjdbcDriver());

      hst.getSqlstatements().setjdbcDriver(hst.getDatabaseParameters().getjdbcDriver());

      if (jCheckBoxEnabled.isSelected())

        hst.setEnabled("Y");

      else

        hst.setEnabled("N");

      hostList.set(j, hst);

      setEditable(false);

      populateList("");

      jButtonApply.setEnabled(false);

      jButtonCancel.setEnabled(false);

    }

    return hst;

  }

  public static LinkedList<JHost> moveElementDown(LinkedList<JHost> list, JHost element)

  {

    int position;

    int size;

    size = list.size();

    if (size > 0)

    {

      position = list.indexOf(element);

      if (position < (size - 1))

      {

        list.remove(position);

        list.add(position + 1, element);

      }

    }

    return list;

  }

  public static LinkedList<JHost> moveElementUp(LinkedList<JHost> list, JHost element)

  {

    int position;

    int size;

    size = list.size();

    if (size > 0)

    {

      position = list.indexOf(element);

      if (position > 0)

      {

        list.remove(position);

        list.add(position - 1, element);

      }

    }

    return list;

  }

  private void setEditable(boolean edit)

  {

    jTextFieldDescription.setEnabled(edit);

    jTextFieldURL.setEnabled(edit);

    jTextFieldSiteNo.setEnabled(edit);

    // jTextFieldDriver.setEnabled(edit);

    // jTextFieldConnect.setEnabled(edit);

    jTextFieldDateTime.setEnabled(edit);

    jTextFieldSelectLimit.setEnabled(edit);

    jTextFieldSchema.setEnabled(edit);

    jTextFieldUsername.setEnabled(edit);

    jTextFieldPassword.setEnabled(edit);

    jTextFieldPort.setEnabled(edit);

    jTextFieldSID.setEnabled(edit);

    jTextFieldServer.setEnabled(edit);

    jTextFieldDatabase.setEnabled(edit);

    jCheckBoxEnabled.setEnabled(edit);

    jComboBoxjdbcDriver.setEnabled(edit);

  }

  private void initGUI()

  {

    try

    {

      setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);

      this.setTitle("Host Administration " + JVersion.getProgramVersion());

      desktopPane.setLayout(null);

      // this.setResizable(false);

      {

        {

          jScrollPane1 = new JScrollPane();

          desktopPane.add(jScrollPane1);

          jScrollPane1.setBounds(14, 37, 258, 395);

          {

            ListModel jListHostsModel = new DefaultComboBoxModel(new String[]

            { "Item One", "Item Two" });

            jListHosts = new JList4j();

            jScrollPane1.setViewportView(jListHosts);

            jListHosts.setModel(jListHostsModel);

            jListHosts.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);

            jListHosts.addListSelectionListener(new ListSelectionListener()

            {

              public void valueChanged(ListSelectionEvent evt)

              {

                getHostData();

              }

            });

          }

        }

        {

          jButtonAdd = new JButton4j(Common.icon_add);

          desktopPane.add(jButtonAdd);

          jButtonAdd.setText("Add DB Connection");

          jButtonAdd.setBounds(762, 12, 160, 36);

          jButtonAdd.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              // Generate Next Site No //

              String siteNo = "";

              int siteNoVal = 0;

              for (int j = 0; j < hostList.size(); j++)

              {

                siteNo = hostList.get(j).getSiteNumber();

                int x = Integer.valueOf(siteNo);

                if (x > siteNoVal)

                {

                  siteNoVal = x;

                }

              }

              siteNoVal++;

              siteNo = String.valueOf(siteNoVal);

              // Generate unique description //

              int i = 0;

              // int j = 0;

              boolean found = false;

              String newdesc = "";

              do

              {

                i++;

                newdesc = "New[" + String.valueOf(i) + "]";

                found = false;

                for (int y = 0; y < hostList.size(); y++)

                {

                  if (hostList.get(y).getSiteDescription().equals(newdesc))

                  {

                    found = true;

                  }

                }

              } while (found);

              JHost hst = new JHost();

              hst.setSiteNumber(siteNo);

              hst.setSiteDescription(newdesc);

              hostList.add(hst);

              setSaveButtonState(true);

              populateList(newdesc);

              getHostData();

            }

          });

        }

        {

          jButtonApply = new JButton4j(Common.icon_ok);

          desktopPane.add(jButtonApply);

          jButtonApply.setText("Confirm Changes");

          jButtonApply.setBounds(762, 160, 160, 36);

          jButtonApply.setEnabled(false);

          jButtonApply.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              int j = jListHosts.getSelectedIndex();

              JHost hst = setHostData();

              hostList.set(j, hst);

              setEditable(false);

              populateList("");

              jButtonApply.setEnabled(false);

              jButtonCancel.setEnabled(false);

              setSaveButtonState(true);

              jButtonTest.setEnabled(true);

              jListHosts.setSelectedIndex(j);

            }

          });

        }

        {

          jButtonDelete = new JButton4j(Common.icon_delete);

          desktopPane.add(jButtonDelete);

          jButtonDelete.setText("Delete DB Connection");

          jButtonDelete.setBounds(762, 49, 160, 36);

          jButtonDelete.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              if (jListHosts.getSelectedIndex() > -1)

              {

                int j = jListHosts.getSelectedIndex();

                hostList.remove(j);

                renumberHosts();

                populateList("");

                if (hostList.size() > 0)

                {

                  if (j > (hostList.size() - 1))

                  {

                    j--;

                  }

                  if (j >= 0)

                  {

                    populateList(hostList.get(j).getSiteDescription());

                  }

                }

                getHostData();

                setSaveButtonState(true);

              }

            }

          });

        }

        {

          jButtonUp = new JButton4j(Common.icon_arrow_up);

          desktopPane.add(jButtonUp);

          jButtonUp.setEnabled(false);

          jButtonUp.setBounds(284, 221, 28, 28);

          jButtonUp.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              if (jListHosts.getSelectedIndex() > -1)

              {

                int j = jListHosts.getSelectedIndex();

                JHost element = ((JHost) jListHosts.getModel().getElementAt(j));

                hostList = moveElementUp(hostList, element);

                renumberHosts();

                populateList(element.getSiteDescription());

                setSaveButtonState(true);

              }

            }

          });

        }

        {

          jButtonDown = new JButton4j(Common.icon_arrow_down);

          desktopPane.add(jButtonDown);

          jButtonDown.setEnabled(false);

          jButtonDown.setBounds(284, 256, 28, 28);

          jButtonDown.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              if (jListHosts.getSelectedIndex() > -1)

              {

                int j = jListHosts.getSelectedIndex();

                JHost element = ((JHost) jListHosts.getModel().getElementAt(j));

                hostList = moveElementDown(hostList, element);

                renumberHosts();

                populateList(element.getSiteDescription());

                setSaveButtonState(true);

              }

            }

          });

        }

        {

          jButtonClose = new JButton4j(Common.icon_close);

          desktopPane.add(jButtonClose);

          jButtonClose.setText("Close");

          jButtonClose.setBounds(762, 382, 160, 36);

          jButtonClose.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              logger.debug("JFrameHostAdmin closed");

              dispose();

            }

          });

        }

        {

          jButtonUndo = new JButton4j(Common.icon_undo);

          desktopPane.add(jButtonUndo);

          jButtonUndo.setText("Undo Changes");

          jButtonUndo.setBounds(762, 271, 160, 36);

          jButtonUndo.setEnabled(false);

          jButtonUndo.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              // Common.hosts = JXMLHost.loadHosts(false);

              int j = jListHosts.getSelectedIndex();

              String Current = hostList.get(j).getSiteDescription();

              getHosts();

              populateList(Current);

              getHostData();

              setSaveButtonState(false);

              setSaveButtonState(false);

            }

          });

        }

        {

          jButtonSave = new JButton4j(Common.icon_update);

          desktopPane.add(jButtonSave);

          jButtonSave.setText("Save DB Connections");

          jButtonSave.setBounds(762, 197, 160, 36);

          jButtonSave.setEnabled(false);

          jButtonSave.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              String pass1 = "";

              String pass2 = "";

              pass1 = String.valueOf(setupPasswordField.getPassword());

              pass2 = String.valueOf(verifyPasswordField.getPassword());

              if (pass1.equals(pass2))

              {

                String splash;

                if (jCheckBoxSplash.isSelected())

                {

                  splash = "Y";

                } else

                {

                  splash = "N";

                }

                JXMLHost.writeHosts(hostList, splash, JTextFieldUpdateURL.getText(), getUpdateMode(), jTextField4jInstallDir.getText(), pass1);

                jButtonSave.setEnabled(false);

                jButtonUndo.setEnabled(false);

              } else

              {

                JOptionPane.showMessageDialog(null,

                      "Setup password has been changed but failed verification - please check.",

                      "Error",

                      JOptionPane.ERROR_MESSAGE);

              }

            }

          });

        }

        {

          jTextFieldDescription = new JTextField4j();

          desktopPane.add(jTextFieldDescription);

          jTextFieldDescription.setFocusCycleRoot(true);

          jTextFieldDescription.setBounds(425, 40, 325, 21);

          jTextFieldDescription.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldURL = new JTextField4j();

          desktopPane.add(jTextFieldURL);

          jTextFieldURL.setFocusCycleRoot(true);

          jTextFieldURL.setBounds(425, 65, 325, 21);

          jTextFieldURL.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jLabelDatabaseType = new JLabel4j_std();

          desktopPane.add(jLabelDatabaseType);

          jLabelDatabaseType.setText("Database Type");

          jLabelDatabaseType.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelDatabaseType.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelDatabaseType.setBounds(291, 91, 127, 21);

        }

        {

          ComboBoxModel jComboBoxjdbcDriverModel = new DefaultComboBoxModel(new String[]

          { "", "mySQL", "Oracle", "SQL Server", "Web URL" });

          jComboBoxjdbcDriver = new JComboBox4j();

          desktopPane.add(jComboBoxjdbcDriver);

          jComboBoxjdbcDriver.setModel(jComboBoxjdbcDriverModel);

          jComboBoxjdbcDriver.setBounds(425, 90, 164, 21);

          jComboBoxjdbcDriver.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              if (jComboBoxjdbcDriver.getSelectedItem().toString().equals("Oracle"))

              {

                jTextFieldDriver.setText("oracle.jdbc.driver.OracleDriver");

                jTextFieldConnect.setText("jdbc:oracle:thin:@jdbcServer:jdbcPort:jdbcSID");

                jTextFieldDateTime.setText("sysdate");

                jTextFieldSelectLimit.setText("rownum");

                jTextFieldServer.setText("localhost");

                jTextFieldPort.setText("1521");

              }

              if (jComboBoxjdbcDriver.getSelectedItem().toString().equals("mySQL"))

              {

                jTextFieldDriver.setText("com.mysql.jdbc.Driver");

                jTextFieldConnect.setText("jdbc:mysql://jdbcServer/jdbcDatabase");

                jTextFieldDateTime.setText("sysdate");

                jTextFieldSelectLimit.setText("limit");

                jTextFieldServer.setText("localhost");

                jTextFieldPort.setText("3306");

              }

              if (jComboBoxjdbcDriver.getSelectedItem().toString().equals("SQL Server"))

              {

                jTextFieldDriver.setText("com.microsoft.sqlserver.jdbc.SQLServerDriver");

                jTextFieldConnect.setText("jdbc:sqlserver://jdbcServer\\jdbcSID");

                jTextFieldDateTime.setText("sysdate");

                jTextFieldSelectLimit.setText("top");

                jTextFieldServer.setText("localhost");

                jTextFieldPort.setText("1433");

              }

              if (jComboBoxjdbcDriver.getSelectedItem().toString().equals("Web URL"))

              {

                jTextFieldDriver.setText("http");

                jTextFieldConnect.setText("");

                jTextFieldDateTime.setText("");

                jTextFieldSelectLimit.setText("");

                jTextFieldServer.setText("");

                jTextFieldPort.setText("");

              }

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldConnect = new JTextField4j();

          desktopPane.add(jTextFieldConnect);

          jTextFieldConnect.setFocusCycleRoot(true);

          jTextFieldConnect.setBounds(425, 145, 325, 21);

          jTextFieldConnect.setEditable(false);

          jTextFieldConnect.setEnabled(false);

          jTextFieldConnect.setDisabledTextColor(Common.color_textdisabled);

          jTextFieldConnect.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jLabelDriver = new JLabel4j_std();

          desktopPane.add(jLabelDriver);

          jLabelDriver.setText("Driver");

          jLabelDriver.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelDriver.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelDriver.setBounds(291, 116, 127, 21);

        }

        {

          jLabelDatabase = new JLabel4j_std();

          desktopPane.add(jLabelDatabase);

          jLabelDatabase.setText("Database");

          jLabelDatabase.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelDatabase.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelDatabase.setBounds(320, 196, 98, 21);

        }

        {

          jLabelDBDateTime = new JLabel4j_std();

          desktopPane.add(jLabelDBDateTime);

          jLabelDBDateTime.setText("DB Date Time");

          jLabelDBDateTime.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelDBDateTime.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelDBDateTime.setBounds(291, 321, 127, 21);

        }

        {

          jLabelPassword = new JLabel4j_std();

          desktopPane.add(jLabelPassword);

          jLabelPassword.setText("Password");

          jLabelPassword.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelPassword.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelPassword.setBounds(291, 296, 127, 21);

        }

        {

          jLabelDescription = new JLabel4j_std();

          desktopPane.add(jLabelDescription);

          jLabelDescription.setText("Description");

          jLabelDescription.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelDescription.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelDescription.setBounds(291, 41, 127, 21);

        }

        {

          jLabelSiteNo = new JLabel4j_std();

          desktopPane.add(jLabelSiteNo);

          jLabelSiteNo.setText("Site No");

          jLabelSiteNo.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelSiteNo.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelSiteNo.setBounds(291, 15, 127, 21);

        }

        {

          jLabelUsername = new JLabel4j_std();

          desktopPane.add(jLabelUsername);

          jLabelUsername.setText("Username");

          jLabelUsername.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelUsername.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelUsername.setBounds(291, 271, 127, 21);

        }

        {

          jLabelPort = new JLabel4j_std();

          desktopPane.add(jLabelPort);

          jLabelPort.setText("Port");

          jLabelPort.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelPort.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelPort.setBounds(320, 221, 98, 21);

        }

        {

          jTextFieldDateTime = new JTextField4j();

          desktopPane.add(jTextFieldDateTime);

          jTextFieldDateTime.setFocusCycleRoot(true);

          jTextFieldDateTime.setBounds(425, 320, 325, 21);

          jTextFieldDateTime.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldUsername = new JTextField4j();

          desktopPane.add(jTextFieldUsername);

          jTextFieldUsername.setFocusCycleRoot(true);

          jTextFieldUsername.setBounds(425, 270, 325, 21);

          jTextFieldUsername.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldPassword = new JPasswordField(10);

          desktopPane.add(jTextFieldPassword);

          jTextFieldPassword.setFocusCycleRoot(true);

          jTextFieldPassword.setBounds(425, 295, 325, 21);

          jTextFieldPassword.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldPort = new JTextField4j();

          desktopPane.add(jTextFieldPort);

          jTextFieldPort.setFocusCycleRoot(true);

          jTextFieldPort.setBounds(425, 220, 325, 21);

          jTextFieldPort.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldSID = new JTextField4j();

          desktopPane.add(jTextFieldSID);

          jTextFieldSID.setFocusCycleRoot(true);

          jTextFieldSID.setBounds(425, 245, 325, 21);

          jTextFieldSID.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldSiteNo = new JTextField4j();

          desktopPane.add(jTextFieldSiteNo);

          jTextFieldSiteNo.setFocusCycleRoot(true);

          jTextFieldSiteNo.setBounds(425, 14, 28, 21);

          jTextFieldSiteNo.setHorizontalAlignment(SwingConstants.CENTER);

          jTextFieldSiteNo.setEnabled(false);

          jTextFieldSiteNo.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jTextFieldDriver = new JTextField4j();

          desktopPane.add(jTextFieldDriver);

          jTextFieldDriver.setFocusCycleRoot(true);

          jTextFieldDriver.setBounds(425, 117, 325, 21);

          jTextFieldDriver.setEditable(false);

          jTextFieldDriver.setEnabled(false);

          jTextFieldDriver.setDisabledTextColor(Common.color_textdisabled);

          jTextFieldDriver.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jCheckBoxEnabled = new JCheckBox();

          jCheckBoxEnabled.setFont(Common.font_std);

          desktopPane.add(jCheckBoxEnabled);

          jCheckBoxEnabled.setText("Enabled");

          jCheckBoxEnabled.setBounds(467, 14, 91, 21);

          jCheckBoxEnabled.setBackground(new java.awt.Color(255, 255, 255));

          jCheckBoxEnabled.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jCheckBoxSplash = new JCheckBox();

          jCheckBoxSplash.setSelected(true);

          jCheckBoxSplash.setFont(Common.font_std);

          desktopPane.add(jCheckBoxSplash);

          jCheckBoxSplash.setText("Enable Splash Screen");

          jCheckBoxSplash.setBounds(687, 445, 150, 21);

          jCheckBoxSplash.setBackground(new java.awt.Color(255, 255, 255));

          jCheckBoxSplash.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jLabelSID = new JLabel4j_std();

          desktopPane.add(jLabelSID);

          jLabelSID.setText("SID");

          jLabelSID.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelSID.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelSID.setBounds(320, 246, 98, 21);

        }

        {

          jButtonCancel = new JButton4j(Common.icon_cancel);

          desktopPane.add(jButtonCancel);

          jButtonCancel.setText("Cancel");

          jButtonCancel.setBounds(762, 345, 160, 36);

          jButtonCancel.setEnabled(false);

          jButtonCancel.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              getHostData();

            }

          });

        }

        {

          jTextFieldServer = new JTextField4j();

          desktopPane.add(jTextFieldServer);

          jTextFieldServer.setFocusCycleRoot(true);

          jTextFieldServer.setBounds(425, 170, 325, 21);

          jTextFieldServer.setEnabled(false);

          jTextFieldServer.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jLabelConnectionString = new JLabel4j_std();

          desktopPane.add(jLabelConnectionString);

          jLabelConnectionString.setText("Connect String");

          jLabelConnectionString.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelConnectionString.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelConnectionString.setBounds(291, 141, 127, 21);

        }

        {

          jTextFieldDatabase = new JTextField4j();

          desktopPane.add(jTextFieldDatabase);

          jTextFieldDatabase.setEnabled(false);

          jTextFieldDatabase.setFocusCycleRoot(true);

          jTextFieldDatabase.setBounds(425, 195, 325, 21);

          jTextFieldDatabase.addKeyListener(new KeyAdapter()

          {

            public void keyTyped(KeyEvent evt)

            {

              jTextFieldKeyTyped();

            }

          });

        }

        {

          jLabelServer = new JLabel4j_std();

          desktopPane.add(jLabelServer);

          jLabelServer.setText("Server");

          jLabelServer.setHorizontalAlignment(SwingConstants.RIGHT);

          jLabelServer.setHorizontalTextPosition(SwingConstants.RIGHT);

          jLabelServer.setBounds(320, 171, 98, 21);

        }

        {

          jButtonTest = new JButton4j(Common.icon_connect);

          desktopPane.add(jButtonTest);

          jButtonTest.setText("Connect to DB");

          jButtonTest.setBounds(762, 86, 160, 36);

          jButtonTest.setToolTipText("Connect to selected Host Database");

          jButtonTest.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              writeBackHosts(hostList);

              int j = jListHosts.getSelectedIndex();

              JHost hst = (JHost) jListHosts.getModel().getElementAt(j);

              Common.selectedHostID = hst.getSiteNumber();

              if (Common.hostList.getHost(Common.selectedHostID).connect(Common.sessionID, Common.selectedHostID))

              {

                btnSchema.setEnabled(true);

                jButtonUpdate.setEnabled(true);

                Common.hostList.getHost(Common.selectedHostID).disconnect(Common.sessionID);

              } else

              {

                jButtonUpdate.setEnabled(false);

                btnSchema.setEnabled(false);

              }

            }

          });

        }

        {

          jButtonUpdate = new JButton4j(Common.icon_update);

          desktopPane.add(jButtonUpdate);

          jButtonUpdate.setText("Create/Update Tables");

          jButtonUpdate.setBounds(762, 123, 160, 36);

          jButtonUpdate.setEnabled(false);

          jButtonUpdate.setToolTipText("Create or Upgrade Application Database Schema");

          jButtonUpdate.addActionListener(new ActionListener()

          {

            public void actionPerformed(ActionEvent evt)

            {

              writeBackHosts(hostList);

              int j = jListHosts.getSelectedIndex();

              JHost hst = (JHost) jListHosts.getModel().getElementAt(j);

              Common.selectedHostID = hst.getSiteNumber();

              if (Common.hostList.getHost(Common.selectedHostID).connect(Common.sessionID, Common.selectedHostID))

              {

                JDBSchema schema = new JDBSchema(Common.sessionID, Common.hostList.getHost(Common.selectedHostID));

                JDBUpdateRequest updrst = new JDBUpdateRequest();

                updrst = schema.validate(false);

                if (updrst.schema_updateRequired)

                {

                  int continueUpdate = JOptionPane.showConfirmDialog(me, "Current Schema Version is " + String.valueOf(updrst.schema_currentVersion) + ", required version is " + String.valueOf(updrst.schema_requiredVersion)

                      + ". Upgrade ?", "Connection to (" + hst.getSiteDescription() + ")", JOptionPane.YES_NO_OPTION);

                  if (continueUpdate == 0)

                  {

                    LinkedList<JDBDDL> cmds = new LinkedList<JDBDDL>();

                    cmds.clear();

                    cmds = JXMLSchema.loadDDLStatements(jTextFieldDriver.getText(), "xml/schema/" + Common.hostList.getHost(Common.selectedHostID).getDatabaseParameters().getjdbcDriver() + "/");

                    boolean updateCtrl = false;

                    if (cmds.size() > 0)

                    {

                      if (schema.executeDDL(cmds, progressBar, labelCommand) == true)

                      {

                        updateCtrl = true;

                      } else

                      {

                        JUtility.errorBeep();

                        JDialogDMLErrors dmlerrs = new JDialogDMLErrors(me, cmds);

                        dmlerrs.setModal(true);

                        int ignoreDDLErrors = JOptionPane.showConfirmDialog(me, "Ignore Errors and set SCHEMA version to " + String.valueOf(updrst.schema_requiredVersion) + " ?", "Connection to (" + hst.getSiteDescription()

                            + ")", JOptionPane.YES_NO_OPTION);