/*
* AlterCombos.java
*
* Created on April 16, 2002, 11:17 AM
*/
package subjectData;
/**
*
* @author Joset A. Etzel
*/
import subjectData.*; import java.sql.*; import java.awt.event.*; import javax.swing.*;
public class AlterCombos extends javax.swing.JInternalFrame {
Connection conData; Statement stmSQL; //variables for sql database access
/** Creates new form AlterCombos */
public AlterCombos() {
initComponents();
try {
Class.forName("org.gjt.mm.mysql.Driver");
conData = SubjectData.getDatabaseConnection(); //gets connection to the correct database
} catch (Exception e) { e.printStackTrace(); }
FillComboBox(); //call sub to put the subject's names in the combo box
}
private void FillComboBox() {
//fill cboCombos with the names from the database
String strSQL = ""; String strNames = "";
cboCombos.removeAllItems(); //just in case
cboCombos.addItem(""); //on top
strSQL = "SELECT DISTINCT boxID FROM comboBoxes ORDER BY boxID"; //sql statement to execute
try {
stmSQL = conData.createStatement(); //stmSQL is global - have to get it ready
ResultSet rssSubjects = stmSQL.executeQuery(strSQL); //make the resultset on the sql statement
while(rssSubjects.next()) { cboCombos.addItem(rssSubjects.getString("boxID")); }
} catch(java.sql.SQLException e) { e.printStackTrace(); }
}
/** 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;
cmdOK = new javax.swing.JButton();
cmdCancel = new javax.swing.JButton();
lblCombos = new javax.swing.JLabel();
cboCombos = new javax.swing.JComboBox();
cboCombos.addItem("");
cboCombos.addItem("Condition");
cboCombos.addItem("Education");
cboCombos.addItem("Experimenter");
cboCombos.addItem("Movies");
cmdDelete = new javax.swing.JButton();
txtAdd = new javax.swing.JTextField();
lblAdd = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
lstPresent = new javax.swing.JList();
getContentPane().setLayout(new java.awt.GridBagLayout());
setMaximizable(true);
setTitle("Alter Combobox Choices");
setIconifiable(true);
setResizable(true);
cmdOK.setText("Add New Choice");
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 = 1;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(3, 3, 3, 3);
getContentPane().add(cmdOK, gridBagConstraints);
cmdCancel.setText("Close");
cmdCancel.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cmdCancelActionPerformed(evt);
}
});
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 3;
gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
gridBagConstraints.insets = new java.awt.Insets(10, 0, 0, 0);
getContentPane().add(cmdCancel, gridBagConstraints);
lblCombos.setText("Select the Combobox to Alter: ");
getContentPane().add(lblCombos, new java.awt.GridBagConstraints());
cboCombos.setPreferredSize(new java.awt.Dimension(200, 19));
cboCombos.addItemListener(new java.awt.event.ItemListener() {
public void itemStateChanged(java.awt.event.ItemEvent evt) {
cboCombosItemStateChanged(evt);
}
});
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridwidth = 2;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(0, 3, 5, 0);
getContentPane().add(cboCombos, gridBagConstraints);
cmdDelete.setText("Delete Selected Choice");
cmdDelete.setEnabled(false);
cmdDelete.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cmdDeleteActionPerformed(evt);
}
});
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 1;
gridBagConstraints.insets = new java.awt.Insets(3, 3, 3, 3);
getContentPane().add(cmdDelete, gridBagConstraints);
txtAdd.setPreferredSize(new java.awt.Dimension(200, 21));
txtAdd.setMinimumSize(new java.awt.Dimension(200, 21));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 2;
gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
gridBagConstraints.insets = new java.awt.Insets(10, 0, 0, 0);
getContentPane().add(txtAdd, gridBagConstraints);
lblAdd.setText("New choice to add: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 2;
gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
gridBagConstraints.insets = new java.awt.Insets(10, 3, 3, 3);
getContentPane().add(lblAdd, gridBagConstraints);
jScrollPane1.setPreferredSize(new java.awt.Dimension(200, 80));
jScrollPane1.setMinimumSize(new java.awt.Dimension(200, 80));
lstPresent.setVisibleRowCount(4);
jScrollPane1.setViewportView(lstPresent);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 1;
gridBagConstraints.gridheight = 3;
gridBagConstraints.anchor = java.awt.GridBagConstraints.NORTH;
gridBagConstraints.insets = new java.awt.Insets(3, 3, 3, 3);
getContentPane().add(jScrollPane1, gridBagConstraints);
pack();
}//GEN-END:initComponents
private void cmdOKActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdOKActionPerformed
//add the new choice to the database for the combobox selected
String strBoxID = ""; String strBoxChoice = "";
//get the highlighted box and text; make sure not blank
strBoxChoice = txtAdd.getText(); strBoxID = (String)cboCombos.getSelectedItem();
if (strBoxChoice.equals("") == true) { JOptionPane.showMessageDialog(null, "Please type the text to be shown as a choice in the box in the spot labeled New Choice.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return; }
if (strBoxID.equals("") == true) { JOptionPane.showMessageDialog(null, "Please select the box you want to add this item to from the list.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return; }
try { //put the new choice into comboBoxes
stmSQL = conData.createStatement(); //stmSQL & conData are global
stmSQL.executeUpdate("INSERT INTO comboBoxes VALUES ('" + strBoxID + "', '" + strBoxChoice + "')");
} catch(java.sql.SQLException e) { e.printStackTrace(); }
txtAdd.setText(""); UpdateListBox();
}//GEN-LAST:event_cmdOKActionPerformed
private void cmdDeleteActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdDeleteActionPerformed
//delete the choice highlighted in lstPresent
int intAnswer = 0; String strBoxID = ""; String strBoxChoice = "";
strBoxChoice = (String)lstPresent.getSelectedValue(); //get the highlighted choice
strBoxID = (String)cboCombos.getSelectedItem();
//System.out.println(strBoxChoice);
//if (strBoxChoice.equals("") == true | strBoxChoice.equals("null") == true) { JOptionPane.showMessageDialog(null, "Please select the choice to delete.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return; }
//ask the user if they are sure they want to delete the choice
intAnswer = JOptionPane.showConfirmDialog(null, "The choice " + strBoxChoice + " will be deleted from the database. Are you sure you want to continue?", "Delete Confirmation", JOptionPane.YES_NO_OPTION);
if (intAnswer == JOptionPane.NO_OPTION) { return; } //exit this sub
try { //delete the existing record from the movieData table
stmSQL = conData.createStatement(); //stmSQL & conData are global
stmSQL.executeUpdate("DELETE FROM comboBoxes WHERE boxID = \"" + strBoxID + "\" AND boxChoice = \"" + strBoxChoice + "\"");
} catch(java.sql.SQLException e) { e.printStackTrace(); JOptionPane.showMessageDialog(null, "There has been an error deleting the database entry.", "Database Deletion Error", JOptionPane.ERROR_MESSAGE); return; }
UpdateListBox(); //call sub to fill up the list
}//GEN-LAST:event_cmdDeleteActionPerformed
private void cboCombosItemStateChanged(java.awt.event.ItemEvent evt) {//GEN-FIRST:event_cboCombosItemStateChanged
//after the combo's name was selected, show the items in the list
if ((String)cboCombos.getSelectedItem() != "") {
if (evt.getStateChange() == ItemEvent.SELECTED) {
UpdateListBox(); cmdDelete.setEnabled(true); }
}
}//GEN-LAST:event_cboCombosItemStateChanged
private void UpdateListBox() {
//show the items in the list
String strBoxID = ""; int intSize = 0; String strList[];
strBoxID = (String)cboCombos.getSelectedItem(); //the combo box picked
try {
ResultSet rssSubjects = stmSQL.executeQuery("SELECT boxChoice FROM comboBoxes WHERE boxID = \"" + strBoxID + "\" ORDER BY boxChoice");
while(rssSubjects.next()) { intSize = intSize + 1; } //count the number of rows in the resultset
rssSubjects.beforeFirst(); //move to the start of the resultset again
strList = new String[intSize]; //get the array ready to hold the data
intSize = 0;
while(rssSubjects.next()) { //get the data out of the database
strList[intSize] = rssSubjects.getString("boxChoice"); //store the choice
intSize = intSize + 1; //update count for next time
}
lstPresent.setListData(strList); //done with the result set, so add the data to the list
} catch(java.sql.SQLException e) { e.printStackTrace(); }
}
private void cmdCancelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdCancelActionPerformed
try { this.setClosed(true); }
catch(java.beans.PropertyVetoException e) { e.printStackTrace(); }
}//GEN-LAST:event_cmdCancelActionPerformed
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JComboBox cboCombos;
private javax.swing.JButton cmdCancel;
private javax.swing.JButton cmdDelete;
private javax.swing.JButton cmdOK;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JLabel lblAdd;
private javax.swing.JLabel lblCombos;
private javax.swing.JList lstPresent;
private javax.swing.JTextField txtAdd;
// End of variables declaration//GEN-END:variables
}