dbconnectiondialog.java

报表设计软件,很好的

                    editURL.getText(),
                    editUsername.getText(),
                    editPassword.getText(),
                    editDatabase.getText(),
                    editName.getText(),
                    checkBoxSavePwd.isSelected());
    setVisible(false);
  }

  private void onBtCancel ()
  {
    result = null;
    setVisible(false);
  }

  public final void initFromConnectionEntry (final ConnectionEntry ce)
  {
    editDatabase.setText(ce.getDatabase());
    editUsername.setText(ce.getUsername());
    editPassword.setText(ce.getPassword());
    checkBoxSavePwd.setSelected(ce.isSavepwd());
    comboDriverList.setSelectedItem(ce.getDriverClass());
    editName.setText(ce.getName());
    editURL.setText(ce.getUrl());
  }

  /**
   * Expects list of driver class names ... ugly and not very usefull. There must be
   * better an more flexible ways of doing this.
   *
   * @param enum
   */
  public final void fillComboDrivers (final Enumeration enum)
  {
    comboDriverList.setModel(new DefaultComboBoxModel());
    while (enum.hasMoreElements())
    {
      final String drv = (String) enum.nextElement();
      comboDriverList.addItem(drv);
    }
    if (comboDriverList.getItemCount() > 0)
    {
      this.comboDriverList.setSelectedIndex(0);
    }
    pack();
  }

  private String getDriver ()
  {
    return (String) comboDriverList.getSelectedItem();
  }

  private void onBtWizard ()
  {
    final String driver = getDriver();
    if (driver.equals("org.gjt.mm.mysql.Driver"))
    {
      String url = "jdbc:mysql://localhost/";
      if ((editDatabase.getText()).trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.internetcds.jdbc.tds.Driver"))
    {
      String url = "jdbc:freetds:sqlserver://localhost/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.microsoft.jdbc.sqlserver.SQLServerDriver"))
    {
      String url =
              "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("sun.jdbc.odbc.JdbcOdbcDriver"))
    {
      String url = "jdbc:odbc:";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "DSNAME";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.ms.jdbc.odbc.JdbcOdbcDriver"))
    {
      String url = "jdbc:odbc:";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "DSNAME";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("oracle.jdbc.driver.OracleDriver"))
    {
      String url = "jdbc:oracle:thin:@localhost:1521:";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("COM.ibm.db2.jdbc.app.DB2Driver"))
    {
      String url = "jdbc:db2:";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.informix.jdbc.IfxDriver"))
    {
      String url = "jdbc:informix-sqli://localhost:port/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }

      url += ":informixserver=SERVERNAME";
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.sybase.jdbc2.jdbc.SybDriver"))
    {
      final String url = "jdbc:sybase:Tds:localhost:2638";
      //if (editDatabase.getText().trim().length()>0)
      //  url += editDatabase.getText();
      //else
      //  url += "MYDATABASE";
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.mysql.jdbc.Driver"))
    {
      String url = "jdbc:mysql://localhost/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.merant.datadirect.jdbc.sqlserver.SQLServerDriver"))
    {
      String url = "jdbc:sqlserver://localhost:1433/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("com.inet.tds.TdsDriver"))
    {
      String url = "jdbc:inetdae7:localhost:1433/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("org.postgresql.Driver"))
    {
      String url = "jdbc:postgresql://localhost:5432/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("org.hsqldb.jdbcDriver"))
    {
      String url = "jdbc:hsqldb:[PATH_TO_DB_FILES]/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }
    else if (
            ((String) comboDriverList.getSelectedItem()).equalsIgnoreCase("COM.cloudscape.JDBCDriver "))
    {
      String url = "jdbc:cloudscape:/cloudscape/";
      if (editDatabase.getText().trim().length() > 0)
      {
        url += editDatabase.getText();
      }
      else
      {
        url += "MYDATABASE";
      }
      editURL.setText(url);
    }

  }

  public final ConnectionEntry getResult ()
  {
    return result;
  }

  public static Enumeration getDefaultDriverList ()
  {
    final Vector v = new Vector();
    v.addElement("org.gjt.mm.mysql.Driver");
    v.addElement("com.internetcds.jdbc.tds.Driver");
    v.addElement("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    v.addElement("sun.jdbc.odbc.JdbcOdbcDriver");
    v.addElement("com.ms.jdbc.odbc.JdbcOdbcDriver");
    v.addElement("oracle.jdbc.driver.OracleDriver");
    v.addElement("COM.ibm.db2.jdbc.app.DB2Driver");
    v.addElement("com.informix.jdbc.IfxDriver");
    v.addElement("com.sybase.jdbc2.jdbc.SybDriver");
    v.addElement("com.mysql.jdbc.Driver");
    v.addElement("com.merant.datadirect.jdbc.sqlserver.SQLServerDriver");
    v.addElement("com.inet.tds.TdsDriver");
    v.addElement("org.postgresql.Driver");
    v.addElement("org.hsqldb.jdbcDriver");
    v.addElement("COM.cloudscape.JDBCDriver");
    return v.elements();
  }
}