package untitled4;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import com.borland.dx.sql.dataset.*;
import org.postgresql.*;
import com.borland.dbswing.*;
import com.borland.dx.dataset.*;

/**
 * Title:        aa
 * Description:
 * Copyright:    Copyright (c) 2001
 * Company:      cc
 * @author bb
 * @version 1.0
 */

public class Frame1 extends JFrame {
  JPanel contentPane;
  JMenuBar jMenuBar1 = new JMenuBar();
  JMenu jMenuFile = new JMenu();
  JMenuItem jMenuFileExit = new JMenuItem();
  JMenu jMenuHelp = new JMenu();
  JMenuItem jMenuHelpAbout = new JMenuItem();
  JToolBar jToolBar = new JToolBar();
  JButton jButton1 = new JButton();
  JButton jButton2 = new JButton();
  JButton jButton3 = new JButton();
  ImageIcon image1;
  ImageIcon image2;
  ImageIcon image3;
  JLabel statusBar = new JLabel();
  BorderLayout borderLayout1 = new BorderLayout();
  Database database1 = new Database();
  QueryResolver queryResolver1 = new QueryResolver();
  QueryDataSet queryDataSet1 = new QueryDataSet();
  TableScrollPane tableScrollPane1 = new TableScrollPane();
  JdbTable jdbTable1 = new JdbTable();
  DBDisposeMonitor dBDisposeMonitor1 = new DBDisposeMonitor();
  JdbNavToolBar jdbNavToolBar1 = new JdbNavToolBar();
  Column articleid = new Column();

  /**Construct the frame*/
  public Frame1() {
    enableEvents(AWTEvent.WINDOW_EVENT_MASK);
    try {
      jbInit();
    }
    catch(Exception e) {
      e.printStackTrace();
    }
  }
  /**Component initialization*/
  private void jbInit() throws Exception  {
    image1 = new ImageIcon(untitled4.Frame1.class.getResource("openFile.gif"));
    image2 = new ImageIcon(untitled4.Frame1.class.getResource("closeFile.gif"));
    image3 = new ImageIcon(untitled4.Frame1.class.getResource("help.gif"));
    //setIconImage(Toolkit.getDefaultToolkit().createImage(Frame1.class.getResource("[Your Icon]")));
    contentPane = (JPanel) this.getContentPane();
    contentPane.setLayout(borderLayout1);
    this.setSize(new Dimension(705, 341));
    this.setTitle("Frame Title");
    statusBar.setText(" ");
    jMenuFile.setText("File");
    jMenuFileExit.setText("Exit");
    jMenuFileExit.addActionListener(new ActionListener()  {
      public void actionPerformed(ActionEvent e) {
        jMenuFileExit_actionPerformed(e);
      }
    });
    jMenuHelp.setText("Help");
    jMenuHelpAbout.setText("About");
    jMenuHelpAbout.addActionListener(new ActionListener()  {
      public void actionPerformed(ActionEvent e) {
        jMenuHelpAbout_actionPerformed(e);
      }
    });
    jButton1.setIcon(image1);
    jButton1.setToolTipText("Open File");
    jButton2.setIcon(image2);
    jButton2.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButton2_actionPerformed(e);
      }
    });
    jButton2.setToolTipText("Save Database");
    jButton3.setIcon(image3);
    jButton3.setToolTipText("Help");
    database1.setConnection(new com.borland.dx.sql.dataset.ConnectionDescriptor("jdbc:postgresql://chunky.scenario.co.uk/sol2", "mmilner", "", false, "org.postgresql.Driver"));
    queryResolver1.setDatabase(database1);
    queryDataSet1.setMetaDataUpdate(MetaDataUpdate.TABLENAME+MetaDataUpdate.PRECISION+MetaDataUpdate.SCALE+MetaDataUpdate.SEARCHABLE);
    queryDataSet1.setResolver(queryResolver1);
    queryDataSet1.setSchemaName("");
    queryDataSet1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1, "select * from article", null, true, Load.ALL));
    jdbTable1.setCellSelectionEnabled(true);
    jdbTable1.setDataSet(queryDataSet1);
    jdbTable1.setSmartColumnWidths(false);
    dBDisposeMonitor1.setDataAwareComponentContainer(this);
    jdbNavToolBar1.setDataSet(queryDataSet1);
    articleid.setColumnName("articleid");
    articleid.setDataType(com.borland.dx.dataset.Variant.INT);
    articleid.setRowId(true);
    articleid.setTableName("article");
    articleid.setServerColumnName("articleid");
    articleid.setSqlType(4);
    jToolBar.add(jButton1);
    jToolBar.add(jButton2);
    jToolBar.add(jButton3);
    jToolBar.add(jdbNavToolBar1, null);
    jMenuFile.add(jMenuFileExit);
    jMenuHelp.add(jMenuHelpAbout);
    jMenuBar1.add(jMenuFile);
    jMenuBar1.add(jMenuHelp);
    this.setJMenuBar(jMenuBar1);
    queryDataSet1.setColumns(new Column[] {articleid});
    contentPane.add(jToolBar, BorderLayout.NORTH);
    contentPane.add(statusBar, BorderLayout.SOUTH);
    contentPane.add(tableScrollPane1, BorderLayout.CENTER);
    tableScrollPane1.getViewport().add(jdbTable1, null);
  }
  /**File | Exit action performed*/
  public void jMenuFileExit_actionPerformed(ActionEvent e) {
    System.exit(0);
  }
  /**Help | About action performed*/
  public void jMenuHelpAbout_actionPerformed(ActionEvent e) {
    Frame1_AboutBox dlg = new Frame1_AboutBox(this);
    Dimension dlgSize = dlg.getPreferredSize();
    Dimension frmSize = getSize();
    Point loc = getLocation();
    dlg.setLocation((frmSize.width - dlgSize.width) / 2 + loc.x, (frmSize.height - dlgSize.height) / 2 + loc.y);
    dlg.setModal(true);
    dlg.show();
  }
  /**Overridden so we can exit when window is closed*/
  protected void processWindowEvent(WindowEvent e) {
    super.processWindowEvent(e);
    if (e.getID() == WindowEvent.WINDOW_CLOSING) {
      jMenuFileExit_actionPerformed(null);
    }
  }

  void jButton2_actionPerformed(ActionEvent e) {
      try {
          database1.saveChanges(queryDataSet1);
          }
      catch (Exception ex) {
          DBExceptionHandler.handleException(ex);
          }
  }
}