/*
* 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
}