View source for Yurttas/PL/DBL/mssql/F/04/02/01/RunScriptUI.java

<syntaxhighlight lang="java" line start="1" enclose="div">/**
 *  Copyright(C) 1998
 *  All Rights Reserved. Salih Yurttas, ZCubes, BitsOfCode Software Systems, Inc..
 *
 *  Permission to use, copy, modify, and distribute this
 *  software and its documentation for EDUCATIONAL purposes
 *  and without fee is hereby granted provided that this
 *  copyright notice appears in all copies.
 *
 *  Adapted by David Nolden, April 19, 2003
 *
 *  @date   : January 1, 1998.
 *  @author : Salih Yurttas.
 */

import ui.*;
import inout.*;
import sqls.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.Connection;

public class RunScriptUI extends Frame
                         implements ActionListener {

  private String[] menuLabel = {"Create",
                                "Delete",
                                "Query"};
  private int mLabelLength= menuLabel.length;
  private Connection mycon;
  private MenuBar mB;
  private Menu[] m;
  private DBLogin dbLogin;

  private UIRunScript[] uIRunScript = {new UIRunScript(new SQLScript("Create Tables")),
                                       new UIRunScript(new SQLScript("Insert Tuples")),
                                       new UIRunScript(new SQLScript("Drop Tables")),
                                       new UIRunScript(new SQLScript("Delete Tuples")),
                                       new UIRunScript(new SQLScript("Query Database"))};

  public RunScriptUI() {
    super("RunScriptUI");
    dbLogin = new DBLogin(this);
    dbLogin.pack();
    dbLogin.setLocationRelativeTo(this);
    dbLogin.setVisible(true);
    if (dbLogin.fail)
      System.exit(0);
    mycon = dbLogin.getCon();
    try {
      mB = new MenuBar();

      m = new Menu[mLabelLength];

      for(int i=0; i<mLabelLength; i++) {
        m[i] = new Menu(menuLabel[i]);

        switch(i) {
          case 0 : for(int j=0; j<2; j++)
                     uIRunScript[j].addSelfToMenu(m[i]);
                   break;
          case 1 : for(int j=2; j<4; j++)
                     uIRunScript[j].addSelfToMenu(m[i]);
                   break;
          case 2 : for(int j=4; j<5; j++)
                     uIRunScript[j].addSelfToMenu(m[i]);
                   break;
        }

        m[i].addActionListener(this);
        mB.add(m[i]);
      }

      setMenuBar(mB);

      addWindowListener(
        new WindowAdapter() {
          public void windowClosing(WindowEvent wE) {
            System.exit(0);
          }
        }
      );
    }
    catch(Exception e) {
      System.out.println(e);
    }
  }

  public void actionPerformed(ActionEvent aE) {
    String arg = aE.getActionCommand();
    for(int i=0; i<2; i++)
      if(uIRunScript[i].nameEquals(arg))
        uIRunScript[i].runScript(this, mycon);

    for(int i=2; i<4; i++)
      if(uIRunScript[i].nameEquals(arg))
         uIRunScript[i].runScript(this, mycon);

    for(int i=4; i<5; i++)
      if(uIRunScript[i].nameEquals(arg))
         uIRunScript[i].runScript(this, mycon);

    repaint();
  }
  
  static public void main(String[] args) {
    RunScriptUI rSUI = new RunScriptUI();
    rSUI.setLocationRelativeTo(null);
    rSUI.setSize(320, 160);
    rSUI.show();
  }

}
</syntaxhighlight>