/*
 * frmConnectToDatabase.java
 *
 * Created on June 24, 2004, 11:01 AM
 */

package subjectData;

import java.util.ArrayList;
import javax.swing.JOptionPane;

/**
 *
 * @author  jaetzel
 */
public class frmConnectToDatabase extends javax.swing.JInternalFrame {
  
  /** Creates new form frmConnectToDatabase */
  public frmConnectToDatabase() {
	initComponents();
	
	ArrayList jcNameList = SubjectData.getDBNames();
	java.util.Iterator jcIterator = jcNameList.iterator();
	while (jcIterator.hasNext()) { cboDBName.addItem((String)jcIterator.next()); }
	
  }
  
  
  /** This method is called from within the constructor to
   * initialize the form.
   * WARNING: Do NOT modify this code. The content of this method is
   * always regenerated by the Form Editor.
   */
  private void initComponents() {//GEN-BEGIN:initComponents
    java.awt.GridBagConstraints gridBagConstraints;

    lblDBName = new javax.swing.JLabel();
    cmdOK = new javax.swing.JButton();
    cboDBName = new javax.swing.JComboBox();
    lblUserName = new javax.swing.JLabel();
    txtUserName = new javax.swing.JTextField();
    lblPassword = new javax.swing.JLabel();
    txtPassword = new javax.swing.JTextField();
    lblTop1 = new javax.swing.JLabel();
    lblTop2 = new javax.swing.JLabel();
    cmdClose = new javax.swing.JButton();

    getContentPane().setLayout(new java.awt.GridBagLayout());

    setIconifiable(true);
    setMaximizable(true);
    setResizable(true);
    setTitle("Connect to the Database");
    lblDBName.setText("connect to this database");
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 0;
    gridBagConstraints.gridy = 2;
    getContentPane().add(lblDBName, gridBagConstraints);

    cmdOK.setText("OK");
    cmdOK.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        cmdOKActionPerformed(evt);
      }
    });

    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 2;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.insets = new java.awt.Insets(20, 0, 0, 0);
    gridBagConstraints.anchor = java.awt.GridBagConstraints.SOUTHEAST;
    getContentPane().add(cmdOK, gridBagConstraints);

    cboDBName.setPreferredSize(new java.awt.Dimension(100, 19));
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 2;
    gridBagConstraints.gridwidth = 2;
    gridBagConstraints.insets = new java.awt.Insets(0, 3, 0, 0);
    gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
    getContentPane().add(cboDBName, gridBagConstraints);

    lblUserName.setText("username");
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 0;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
    gridBagConstraints.insets = new java.awt.Insets(5, 0, 0, 0);
    getContentPane().add(lblUserName, gridBagConstraints);

    txtUserName.setText("root");
    txtUserName.setPreferredSize(new java.awt.Dimension(100, 20));
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 3;
    gridBagConstraints.gridwidth = 2;
    gridBagConstraints.insets = new java.awt.Insets(5, 3, 0, 0);
    gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
    getContentPane().add(txtUserName, gridBagConstraints);

    lblPassword.setText("password");
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 0;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
    gridBagConstraints.insets = new java.awt.Insets(5, 0, 0, 0);
    getContentPane().add(lblPassword, gridBagConstraints);

    txtPassword.setPreferredSize(new java.awt.Dimension(100, 20));
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 4;
    gridBagConstraints.gridwidth = 2;
    gridBagConstraints.insets = new java.awt.Insets(5, 3, 0, 0);
    gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
    getContentPane().add(txtPassword, gridBagConstraints);

    lblTop1.setText("To change the database names on this screen edit subjectDataConfig.txt.");
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 0;
    gridBagConstraints.gridy = 0;
    gridBagConstraints.gridwidth = 3;
    getContentPane().add(lblTop1, gridBagConstraints);

    lblTop2.setText("Enter the username and password for the database, not this program.");
    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 0;
    gridBagConstraints.gridy = 1;
    gridBagConstraints.gridwidth = 3;
    gridBagConstraints.insets = new java.awt.Insets(0, 0, 10, 0);
    gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
    getContentPane().add(lblTop2, gridBagConstraints);

    cmdClose.setLabel("Close");
    cmdClose.addActionListener(new java.awt.event.ActionListener() {
      public void actionPerformed(java.awt.event.ActionEvent evt) {
        cmdCloseActionPerformed(evt);
      }
    });

    gridBagConstraints = new java.awt.GridBagConstraints();
    gridBagConstraints.gridx = 1;
    gridBagConstraints.gridy = 5;
    gridBagConstraints.insets = new java.awt.Insets(20, 30, 0, 0);
    gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
    getContentPane().add(cmdClose, gridBagConstraints);

    pack();
  }//GEN-END:initComponents

  private void cmdCloseActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdCloseActionPerformed
	//close the window IF there is a database connection
	try {
      Class.forName("org.gjt.mm.mysql.Driver");
      java.sql.Connection conData = SubjectData.getDatabaseConnection();
      if (conData == null) { JOptionPane.showMessageDialog(null, "You must connect to a database before leaving this screen.", "Startup Error", JOptionPane.ERROR_MESSAGE); }
      else {  this.setClosed(true); }
    }  catch(Exception e) { e.printStackTrace(); }
  }//GEN-LAST:event_cmdCloseActionPerformed

  private void cmdOKActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdOKActionPerformed
	// TODO add your handling code here:
	SubjectData.setDBName((String)cboDBName.getSelectedItem());
	SubjectData.setDBUserID(txtUserName.getText());
	SubjectData.setDBPassword(txtPassword.getText());
	
	//close the frame
    try {  this.setClosed(true); }
    catch(java.beans.PropertyVetoException e) { e.printStackTrace(); }
  }//GEN-LAST:event_cmdOKActionPerformed
  
  
  // Variables declaration - do not modify//GEN-BEGIN:variables
  private javax.swing.JComboBox cboDBName;
  private javax.swing.JButton cmdClose;
  private javax.swing.JButton cmdOK;
  private javax.swing.JLabel lblDBName;
  private javax.swing.JLabel lblPassword;
  private javax.swing.JLabel lblTop1;
  private javax.swing.JLabel lblTop2;
  private javax.swing.JLabel lblUserName;
  private javax.swing.JTextField txtPassword;
  private javax.swing.JTextField txtUserName;
  // End of variables declaration//GEN-END:variables
  
}