/**
* Method declaration
*
* @param ev
*/
public void actionPerformed(ActionEvent ev) {
String s = ev.getActionCommand();
if (s == null) {
if (ev.getSource() instanceof MenuItem) {
MenuItem i;
s = ((MenuItem) ev.getSource()).getLabel();
}
}
if (s.equals("Execute")) {
execute();
} else if (s.equals("Exit")) {
windowClosing(null);
} else if (s.equals("Transfer")) {
Transfer.work(null);
} else if (s.equals("Dump")) {
Transfer.work(new String[] {"-d"});
/* NB - 26052002 Restore is not implemented yet in the transfer tool */
/*
} else if (s.equals("Restore")) {
Transfer.work(new String[]{"-r"});
*/
} else if (s.equals("Logging on")) {
jdbcSystem.setLogToSystem(true);
} else if (s.equals("Logging off")) {
jdbcSystem.setLogToSystem(false);
} else if (s.equals("Refresh Tree")) {
refreshTree();
} else if (s.startsWith("#")) {
int i = Integer.parseInt(s.substring(1));
txtCommand.setText(sRecent[i]);
} else if (s.equals("Connect...")) {
connect(ConnectionDialog.createConnection(fMain, "Connect"));
refreshTree();
} else if (s.equals("Results in Grid")) {
iResult = 0;
pResult.removeAll();
pResult.add("Center", gResult);
pResult.doLayout();
} else if (s.equals("Open Script...")) {
FileDialog f = new FileDialog(fMain, "Open Script", FileDialog.LOAD);
// (ulrivo): set default directory if set from command line
if (defDirectory != null) {
f.setDirectory(defDirectory);
}
f.show();
String file = f.getFile();
if (file != null) {
txtCommand.setText(DatabaseManagerCommon.readFile(f.getDirectory() + file));
}
} else if (s.equals("Save Script...")) {
FileDialog f = new FileDialog(fMain, "Save Script", FileDialog.SAVE);
// (ulrivo): set default directory if set from command line
if (defDirectory != null) {
f.setDirectory(defDirectory);
}
f.show();
String file = f.getFile();
if (file != null) {
DatabaseManagerCommon.writeFile(f.getDirectory() + file, txtCommand.getText());
}
} else if (s.equals("Save Result...")) {
FileDialog f = new FileDialog(fMain, "Save Result", FileDialog.SAVE);
// (ulrivo): set default directory if set from command line
if (defDirectory != null) {
f.setDirectory(defDirectory);
}
f.show();
String file = f.getFile();
if (file != null) {
showResultInText();
DatabaseManagerCommon.writeFile(f.getDirectory() + file, txtResult.getText());
}
} else if (s.equals("Results in Text")) {
iResult = 1;
pResult.removeAll();
pResult.add("Center", txtResult);
pResult.doLayout();
showResultInText();
} else if (s.equals("AutoCommit on")) {
try {
cConn.setAutoCommit(true);
} catch (SQLException e) {
}
} else if (s.equals("AutoCommit off")) {
try {
cConn.setAutoCommit(false);
} catch (SQLException e) {
}
} else if (s.equals("Enlarge Tree")) {
Dimension d = tTree.getMinimumSize();
d.width += 20;
tTree.setMinimumSize(d);
fMain.pack();
} else if (s.equals("Shrink Tree")) {
Dimension d = tTree.getMinimumSize();
d.width -= 20;
if (d.width >= 0) {
tTree.setMinimumSize(d);
}
fMain.pack();
} else if (s.equals("Enlarge Command")) {
txtCommand.setRows(txtCommand.getRows() + 1);
fMain.pack();
} else if (s.equals("Shrink Command")) {
int i = txtCommand.getRows() - 1;
txtCommand.setRows(i < 1 ? 1 : i);
fMain.pack();
} else if (s.equals("Commit")) {
try {
cConn.commit();
} catch (SQLException e) {
}
} else if (s.equals("Insert test data")) {
insertTestData();
} else if (s.equals("Rollback")) {
try {
cConn.rollback();
} catch (SQLException e) {
}
} else if (s.equals("Disable MaxRows")) {
try {
sStatement.setMaxRows(0);
} catch (SQLException e) {
}
} else if (s.equals("Set MaxRows to 100")) {
try {
sStatement.setMaxRows(100);
} catch (SQLException e) {
}
} else if (s.equals("SELECT")) {
showHelp(DatabaseManagerCommon.selectHelp);
} else if (s.equals("INSERT")) {
showHelp(DatabaseManagerCommon.insertHelp);
} else if (s.equals("UPDATE")) {
showHelp(DatabaseManagerCommon.updateHelp);
} else if (s.equals("DELETE")) {
showHelp(DatabaseManagerCommon.deleteHelp);
} else if (s.equals("CREATE TABLE")) {
showHelp(DatabaseManagerCommon.createTableHelp);
} else if (s.equals("DROP TABLE")) {
showHelp(DatabaseManagerCommon.dropTableHelp);
} else if (s.equals("CREATE INDEX")) {
showHelp(DatabaseManagerCommon.createIndexHelp);
} else if (s.equals("DROP INDEX")) {
showHelp(DatabaseManagerCommon.dropIndexHelp);
} else if (s.equals("CHECKPOINT")) {
showHelp(DatabaseManagerCommon.checkpointHelp);
} else if (s.equals("SCRIPT")) {
showHelp(DatabaseManagerCommon.scriptHelp);
} else if (s.equals("SHUTDOWN")) {
showHelp(DatabaseManagerCommon.shutdownHelp);
} else if (s.equals("SET")) {
showHelp(DatabaseManagerCommon.setHelp);
} else if (s.equals("Test Script")) {
showHelp(DatabaseManagerCommon.testHelp);
}
}
void setupGUI() {
taDictionary = new TextArea();
taDictionary.setLocation(0, 0);
taDictionary.setSize(106, 567);
taDictionary.setBackground(new Color(-1));
taDictionary.setText("");
taDictionary.setRows(5);
taDictionary.setColumns(1);
getContentPane().add(taDictionary);
tfSourc = new TextField();
tfSourc.setLocation(224, 90);
tfSourc.setSize(266, 25);
tfSourc.setBackground(new Color(-1));
tfSourc.setText("");
tfSourc.setColumns(10);
getContentPane().add(tfSourc);
lblSourc = new Label();
lblSourc.setLocation(106, 90);
lblSourc.setSize(119, 25);
lblSourc.setText("Source Word:");
getContentPane().add(lblSourc);
/*
lblDestinatio = new Label();
lblDestinatio.setLocation(106,97);
lblDestinatio.setSize(119,25);
lblDestinatio.setText("Destination Wor");
getContentPane().add(lblDestinatio);
*/
lblDestinatio = new Label();
lblDestinatio.setLocation(106, 120);
lblDestinatio.setSize(119, 25);
lblDestinatio.setText("Destination Word:");
getContentPane().add(lblDestinatio);
lblWordSize = new Label();
lblWordSize.setLocation(106, 27); // 106,120
lblWordSize.setSize(119, 25);
lblWordSize.setText("Word Size:");
getContentPane().add(lblWordSize);
tfWordSize = new TextField();
tfWordSize.setLocation(224, 27); // 224,120
tfWordSize.setSize(263, 25);
tfWordSize.setBackground(new Color(-1));
tfWordSize.setText("5");
tfWordSize.setColumns(10);
getContentPane().add(tfWordSize);
tfSourc_6 = new TextField();
tfSourc_6.setLocation(226, 120);
tfSourc_6.setSize(263, 25);
tfSourc_6.setBackground(new Color(-1));
tfSourc_6.setText("");
tfSourc_6.setColumns(10);
getContentPane().add(tfSourc_6);
lblFileNam = new Label();
lblFileNam.setLocation(104, 0);
lblFileNam.setSize(119, 25);
lblFileNam.setText("FilePath:");
getContentPane().add(lblFileNam);
tfFilePat = new TextField();
tfFilePat.setLocation(224, 0);
tfFilePat.setSize(266, 25);
tfFilePat.setBackground(new Color(-1));
// OS Detection
if (System.getProperty("os.name").startsWith("Windows")) {
// includes: Windows 2000, Windows 95, Windows 98, Windows NT, Windows Vista, Windows XP
tfFilePat.setText("c:\\ics340\\words.txt");
System.out.println("Detected Windows: " + System.getProperty("os.name"));
} else {
tfFilePat.setText("/Users/jasonedstrom/ics340/d1.txt");
System.out.println("Detected Mac OS X: " + System.getProperty("os.name"));
}
tfFilePat.setColumns(10);
getContentPane().add(tfFilePat);
btLoadTextFiel = new JButton();
btLoadTextFiel.setLocation(108, 50); // 108,27
btLoadTextFiel.setSize(198, 32);
btLoadTextFiel.setText("Load Words from Text Field");
getContentPane().add(btLoadTextFiel);
btLoadFil = new JButton();
btLoadFil.setLocation(306, 50); // 306,27
btLoadFil.setSize(183, 32);
btLoadFil.setText("Load Words from File");
getContentPane().add(btLoadFil);
btFindPat = new JButton();
btFindPat.setLocation(106, 160);
btFindPat.setSize(384, 38);
btFindPat.setText("Find Path");
getContentPane().add(btFindPat);
lblDictCoun = new JLabel();
lblDictCoun.setLocation(108, 513);
lblDictCoun.setSize(300, 27);
lblDictCoun.setForeground(new Color(-65536));
lblDictCoun.setText("Words in Dictionary = 0 words");
getContentPane().add(lblDictCoun);
lblIndexing1 = new JLabel();
lblIndexing1.setLocation(107, 454);
lblIndexing1.setSize(130, 27);
lblIndexing1.setForeground(new Color(-16777216));
lblIndexing1.setText("");
getContentPane().add(lblIndexing1);
lblFindPat = new JLabel();
lblFindPat.setLocation(108, 540);
lblFindPat.setSize(250, 27);
lblFindPat.setForeground(new Color(-14646771));
lblFindPat.setText("Time to find Path: 0 milliseconds");
getContentPane().add(lblFindPat);
lblCos = new JLabel();
lblCos.setLocation(360, 540);
lblCos.setSize(175, 27);
lblCos.setForeground(new Color(-16777216));
lblCos.setText("Cost of Path: 0.0");
getContentPane().add(lblCos);
lblProgres = new JLabel();
lblProgres.setLocation(108, 484);
lblProgres.setSize(371, 26);
lblProgres.setForeground(new Color(-14646771));
lblProgres.setText("Time to Build Graph: 0 milliseconds");
getContentPane().add(lblProgres);
testpanel = new JPanel();
testpanel.setLocation(106, 200);
testpanel.setSize(350, 200);
testpanel.setForeground(new Color(-14646771));
// testpanel.setText("Test Location");
getContentPane().add(testpanel);
btClear = new JButton();
btClear.setLocation(355, 513);
btClear.setSize(125, 25);
btClear.setText("Clear Results");
getContentPane().add(btClear);
// add actionlisteners to buttons
btFindPat.addActionListener(this);
btLoadTextFiel.addActionListener(this);
btLoadFil.addActionListener(this);
btClear.addActionListener(this);
setTitle("WordLadderGUI");
setSize(500, 600);
setVisible(true);
setResizable(false);
}