import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;

public class ImportFiles_form
{
  //Create a JPanel to put combo boxes and labels in
  JPanel cboPanel = new JPanel(new GridLayout(0,2,10,10));

  // Create components to put in the JPanel
  JLabel dataset_lbl = new JLabel("Dataset:");
  String[] datasetNames = runQuery("SELECT DISTINCT dataset FROM data_files");
  JComboBox dataset_cbo = new JComboBox(datasetNames);

  JLabel region_lbl = new JLabel("Region:");
  String[] regionNames = runQuery("SELECT DISTINCT region FROM data_files ORDER BY region");
  JComboBox region_cbo = new JComboBox(regionNames);

  JButton import_btn = new JButton("Import files");

  //Constructor
  public void ImportFiles_form()
  {
    //set default values for combo boxes
    dataset_cbo.setSelectedIndex(0);
    region_cbo.setSelectedIndex(0);

    //Create a button listener
    import_btn.addActionListener(new ActionListener()
    {
      public void actionPerformed(ActionEvent e)
      {
        //Call the actual operation to import files
        //...nothing here yet...
      }
    });

    cboPanel.add(dataset_lbl);
    cboPanel.add(dataset_cbo);
    cboPanel.add(region_lbl);
    cboPanel.add(region_cbo);
    cboPanel.add(import_btn);

  }

  public String[] runQuery(String query)
  //execute a database query and return a single string array of results
  {
    try
    {
      Connection cnxn = DriverManager.getConnection("jdbc:default:connection:");
      Statement stmt = cnxn.createStatement();
      ResultSet rset = stmt.executeQuery(query);

      //create an ArrayList to hold the results
      ArrayList queryResults = new ArrayList();
      while(rset.next())
      {
        queryResults.add(rset.getString(1));
      }

      //convert the ArrayList to a String[] array
      String[] rval = new String[ queryResults.size() ];
      queryResults.toArray( rval );

      stmt.close();
      cnxn.close();

      //return the String[] array
      return rval;
    }
    catch (SQLException se)
    {
      String[] errMsg = { "ERROR: SQL Exception:" + se.getErrorCode() + "; Message: " + se.getMessage() };
      return errMsg;
    }
  }

  public static void showForm()
  {
    //Construct the class object
    ImportFiles_form importTheFiles = new ImportFiles_form();

    //Create JFrame
    JFrame frame = new JFrame("Import Files");
    frame.getContentPane().add(importTheFiles.cboPanel);
    frame.pack();
    frame.setVisible(true);
  }

}

CREATE OR REPLACE PROCEDURE JavaImportFiles
AS
LANGUAGE JAVA
NAME 'ImportFiles_form.showForm()';

BEGIN
  JavaImportFiles;
END;