/*
* BrainLesion.java
*
* Created on June 24, 2002, 9:41 AM
*/
package subjectData;
/**
*
* @author Joset A. Etzel
*/
import subjectData.*; import java.sql.*; import java.awt.event.*; import javax.swing.*;
public class BrainLesion extends javax.swing.JInternalFrame {
Connection conData; Statement stmSQL; //variables for sql database access
private String strID = "";
/** Creates new form BrainLesion */
public BrainLesion(String strPassed, String strName) { //this is a constructor!
initComponents();
try { Class.forName("org.gjt.mm.mysql.Driver");
conData = SubjectData.getDatabaseConnection(); //gets connection to the correct database
} catch (Exception e) { e.printStackTrace(); }
strID = strPassed; //set passed subjectID to strID for use by BrainLesion
setTitle("Brain Lesion Details for subject " + strID + ": " + strName);
try { //put choices in cboType & cboSubType
stmSQL = conData.createStatement(); //stmSQL is global - have to get it ready
ResultSet rssSubjects = stmSQL.executeQuery("SELECT boxChoice FROM comboBoxes WHERE boxID = 'SubjectType'");
while(rssSubjects.next()) { cboType.addItem(rssSubjects.getString("boxChoice")); }
rssSubjects = stmSQL.executeQuery("SELECT boxChoice FROM comboBoxes WHERE boxID = 'SubjectSubType'");
while(rssSubjects.next()) { cboSubType.addItem(rssSubjects.getString("boxChoice")); }
} catch(java.sql.SQLException e) { e.printStackTrace(); }
FillScreen(); //call sub to get subject's info out of the database
}
private void FillScreen() {
//get the subject's info from brainLesion, if there. strID accessable to whole form
try {
stmSQL = conData.createStatement(); //stmSQL is global - have to get it ready
ResultSet rssSubjects = stmSQL.executeQuery("SELECT * FROM brainLesion WHERE subID = " + strID);
if (rssSubjects.next() == true) { cmdOK.setText("Update");
cboType.setSelectedItem(rssSubjects.getString("subjectType"));
cboSubType.setSelectedItem(rssSubjects.getString("subjectSubType"));
cboAmyLeft.setSelectedItem(rssSubjects.getString("lAmyDamage")); cboAmyRight.setSelectedItem(rssSubjects.getString("rAmyDamage"));
cboOrbLeft.setSelectedItem(rssSubjects.getString("lOrbDamage")); cboOrbRight.setSelectedItem(rssSubjects.getString("rOrbDamage"));
cboDorLeft.setSelectedItem(rssSubjects.getString("lDorDamage")); cboDorRight.setSelectedItem(rssSubjects.getString("rDorDamage"));
cboHemLeft.setSelectedItem(rssSubjects.getString("lHemDamage")); cboHemRight.setSelectedItem(rssSubjects.getString("rHemDamage"));
cboBasLeft.setSelectedItem(rssSubjects.getString("lBasDamage")); cboBasRight.setSelectedItem(rssSubjects.getString("rBasDamage"));
txtAmy.setText(rssSubjects.getString("amyComment")); txtOrb.setText(rssSubjects.getString("orbComment"));
txtDor.setText(rssSubjects.getString("dorComment")); txtHem.setText(rssSubjects.getString("hemComment"));
txtBas.setText(rssSubjects.getString("basComment")); txtComment.setText(rssSubjects.getString("comment"));
}
else { cmdOK.setText("Add"); return; } //exit sub - not in database
} 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;
lblAmygdala = new javax.swing.JLabel();
lblOrbitofrontal = new javax.swing.JLabel();
lblDorsalFrontal = new javax.swing.JLabel();
lblHemisphere = new javax.swing.JLabel();
lblBasalGanglia = new javax.swing.JLabel();
lblComment = new javax.swing.JLabel();
lblLeft = new javax.swing.JLabel();
lblRight = new javax.swing.JLabel();
cboAmyLeft = new javax.swing.JComboBox();
cboAmyLeft.addItem("intact");
cboAmyLeft.addItem("damaged");
cboAmyRight = new javax.swing.JComboBox();
cboAmyRight.addItem("intact");
cboAmyRight.addItem("damaged");
cboOrbLeft = new javax.swing.JComboBox();
cboOrbLeft.addItem("intact");
cboOrbLeft.addItem("damaged");
cboOrbRight = new javax.swing.JComboBox();
cboOrbRight.addItem("intact");
cboOrbRight.addItem("damaged");
cmdOK = new javax.swing.JButton();
cboDorLeft = new javax.swing.JComboBox();
cboDorLeft.addItem("intact");
cboDorLeft.addItem("damaged");
cboDorRight = new javax.swing.JComboBox();
cboDorRight.addItem("intact");
cboDorRight.addItem("damaged");
cboHemLeft = new javax.swing.JComboBox();
cboHemLeft.addItem("intact");
cboHemLeft.addItem("damaged");
cboHemRight = new javax.swing.JComboBox();
cboHemRight.addItem("intact");
cboHemRight.addItem("damaged");
cboBasLeft = new javax.swing.JComboBox();
cboBasLeft.addItem("intact");
cboBasLeft.addItem("damaged");
cboBasRight = new javax.swing.JComboBox();
cboType = new javax.swing.JComboBox();
txtAmy = new javax.swing.JTextField();
txtOrb = new javax.swing.JTextField();
txtHem = new javax.swing.JTextField();
txtBas = new javax.swing.JTextField();
txtDor = new javax.swing.JTextField();
txtComment = new javax.swing.JTextField();
lblRegion = new javax.swing.JLabel();
cmdCancel = new javax.swing.JButton();
lblGeneral = new javax.swing.JLabel();
lblType = new javax.swing.JLabel();
sepOne = new javax.swing.JSeparator();
jSeparator1 = new javax.swing.JSeparator();
lblSubType = new javax.swing.JLabel();
cboSubType = new javax.swing.JComboBox();
getContentPane().setLayout(new java.awt.GridBagLayout());
setIconifiable(true);
setMaximizable(true);
setResizable(true);
lblAmygdala.setText("amygdala: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 3;
getContentPane().add(lblAmygdala, gridBagConstraints);
lblOrbitofrontal.setText("orbitofrontal: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 7;
getContentPane().add(lblOrbitofrontal, gridBagConstraints);
lblDorsalFrontal.setText("dorsal frontal: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 4;
getContentPane().add(lblDorsalFrontal, gridBagConstraints);
lblHemisphere.setText("hemisphere: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 5;
getContentPane().add(lblHemisphere, gridBagConstraints);
lblBasalGanglia.setText("basal ganglia: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 6;
getContentPane().add(lblBasalGanglia, gridBagConstraints);
lblComment.setText("comment");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 2;
getContentPane().add(lblComment, gridBagConstraints);
lblLeft.setText("left");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 2;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
getContentPane().add(lblLeft, gridBagConstraints);
lblRight.setText("right");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 2;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
getContentPane().add(lblRight, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 3;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboAmyLeft, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 3;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboAmyRight, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 7;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboOrbLeft, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 7;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboOrbRight, 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 = 3;
gridBagConstraints.gridy = 10;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(0, 2, 0, 0);
getContentPane().add(cmdOK, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 4;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboDorLeft, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 4;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboDorRight, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 5;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboHemLeft, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 5;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboHemRight, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 6;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboBasLeft, gridBagConstraints);
cboBasRight.addItem("intact");
cboBasRight.addItem("damaged");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 6;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cboBasRight, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 0;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(0, 3, 0, 0);
getContentPane().add(cboType, gridBagConstraints);
txtAmy.setMaximumSize(new java.awt.Dimension(300, 26));
txtAmy.setMinimumSize(new java.awt.Dimension(300, 21));
txtAmy.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 3;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAmy, gridBagConstraints);
txtOrb.setMaximumSize(new java.awt.Dimension(300, 26));
txtOrb.setMinimumSize(new java.awt.Dimension(300, 21));
txtOrb.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 7;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtOrb, gridBagConstraints);
txtHem.setMaximumSize(new java.awt.Dimension(300, 26));
txtHem.setMinimumSize(new java.awt.Dimension(300, 21));
txtHem.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 5;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtHem, gridBagConstraints);
txtBas.setMaximumSize(new java.awt.Dimension(300, 26));
txtBas.setMinimumSize(new java.awt.Dimension(300, 21));
txtBas.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 6;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtBas, gridBagConstraints);
txtDor.setMaximumSize(new java.awt.Dimension(300, 26));
txtDor.setMinimumSize(new java.awt.Dimension(300, 21));
txtDor.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 4;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtDor, gridBagConstraints);
txtComment.setMaximumSize(new java.awt.Dimension(550, 26));
txtComment.setMinimumSize(new java.awt.Dimension(450, 21));
txtComment.setPreferredSize(new java.awt.Dimension(550, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 8;
gridBagConstraints.gridwidth = 3;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtComment, gridBagConstraints);
lblRegion.setText("region");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 2;
getContentPane().add(lblRegion, gridBagConstraints);
cmdCancel.setText("Cancel");
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 = 10;
gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
gridBagConstraints.insets = new java.awt.Insets(0, 0, 0, 2);
getContentPane().add(cmdCancel, gridBagConstraints);
lblGeneral.setText("general comment: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 8;
getContentPane().add(lblGeneral, gridBagConstraints);
lblType.setText("Subject Type: ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 0;
getContentPane().add(lblType, gridBagConstraints);
sepOne.setMaximumSize(new java.awt.Dimension(600, 3));
sepOne.setMinimumSize(new java.awt.Dimension(600, 3));
sepOne.setPreferredSize(new java.awt.Dimension(600, 3));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 9;
gridBagConstraints.gridwidth = 4;
gridBagConstraints.insets = new java.awt.Insets(10, 0, 10, 0);
getContentPane().add(sepOne, gridBagConstraints);
jSeparator1.setMaximumSize(new java.awt.Dimension(600, 3));
jSeparator1.setMinimumSize(new java.awt.Dimension(600, 3));
jSeparator1.setPreferredSize(new java.awt.Dimension(600, 3));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 1;
gridBagConstraints.gridwidth = 4;
gridBagConstraints.insets = new java.awt.Insets(10, 0, 10, 0);
getContentPane().add(jSeparator1, gridBagConstraints);
lblSubType.setText("Subject subtype:");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 0;
gridBagConstraints.insets = new java.awt.Insets(0, 10, 0, 0);
getContentPane().add(lblSubType, gridBagConstraints);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 0;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(0, 3, 0, 0);
getContentPane().add(cboSubType, gridBagConstraints);
pack();
}//GEN-END:initComponents
private void cmdOKActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdOKActionPerformed
//get the data entered on the screen and put it into the database
String strSQL = "";
if (cmdOK.getText() == "Add") { //putting a new row in the database
strSQL = "INSERT INTO brainLesion VALUES ('" + strID + "', '" + (String)cboType.getSelectedItem() + "', '" + (String)cboAmyLeft.getSelectedItem() + "', '" + (String)cboAmyRight.getSelectedItem()
+ "', '" + (String)cboOrbLeft.getSelectedItem() + "', '" + (String)cboOrbRight.getSelectedItem() + "', '" + (String)cboDorLeft.getSelectedItem() + "', '" + (String)cboDorRight.getSelectedItem()
+ "', '" + (String)cboHemLeft.getSelectedItem() + "', '" + (String)cboHemRight.getSelectedItem() + "', '" + (String)cboBasLeft.getSelectedItem() + "', '" + (String)cboBasRight.getSelectedItem()
+ "', '" + txtAmy.getText() + "', '" + txtOrb.getText() + "', '" + txtDor.getText() + "', '" + txtHem.getText() + "', '" + txtBas.getText()
+ "', '" + txtComment.getText() + "', '" + (String)cboSubType.getSelectedItem() + "')"; }
else { //updating an existing row in the database
strSQL = "UPDATE brainLesion SET subjectType = '" + (String)cboType.getSelectedItem() + "', lAmyDamage = '" + (String)cboAmyLeft.getSelectedItem()
+ "', rAmyDamage = '" + (String)cboAmyRight.getSelectedItem() + "', lOrbDamage = '" + (String)cboOrbLeft.getSelectedItem()
+ "', rOrbDamage = '" + (String)cboOrbRight.getSelectedItem() + "', lDorDamage = '" + (String)cboDorLeft.getSelectedItem()
+ "', rDorDamage = '" + (String)cboDorRight.getSelectedItem() + "', lHemDamage = '" + (String)cboHemLeft.getSelectedItem()
+ "', rHemDamage = '" + (String)cboHemRight.getSelectedItem() + "', lBasDamage = '" + (String)cboBasLeft.getSelectedItem()
+ "', rBasDamage = '" + (String)cboBasRight.getSelectedItem() + "', amyComment = '" + txtAmy.getText()
+ "', orbComment = '" + txtOrb.getText() + "', dorComment = '" + txtDor.getText() + "', hemComment = '" + txtHem.getText()
+ "', basComment = '" + txtBas.getText() + "', comment = '" + txtComment.getText()
+ "', subjectSubType = '" + (String)cboSubType.getSelectedItem() + "' WHERE subID = '" + strID + "'"; }
try { stmSQL = conData.createStatement(); stmSQL.executeUpdate(strSQL); }
catch(java.sql.SQLException e) { e.printStackTrace(); }
CloseClass(); //call sub to close the window
}//GEN-LAST:event_cmdOKActionPerformed
private void cmdCancelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdCancelActionPerformed
CloseClass(); //call sub to close the window
}//GEN-LAST:event_cmdCancelActionPerformed
private void CloseClass() {
//close the frame
try { this.setClosed(true); }
catch (java.beans.PropertyVetoException e) { e.printStackTrace(); }
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JComboBox cboAmyLeft;
private javax.swing.JComboBox cboAmyRight;
private javax.swing.JComboBox cboBasLeft;
private javax.swing.JComboBox cboBasRight;
private javax.swing.JComboBox cboDorLeft;
private javax.swing.JComboBox cboDorRight;
private javax.swing.JComboBox cboHemLeft;
private javax.swing.JComboBox cboHemRight;
private javax.swing.JComboBox cboOrbLeft;
private javax.swing.JComboBox cboOrbRight;
private javax.swing.JComboBox cboSubType;
private javax.swing.JComboBox cboType;
private javax.swing.JButton cmdCancel;
private javax.swing.JButton cmdOK;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JLabel lblAmygdala;
private javax.swing.JLabel lblBasalGanglia;
private javax.swing.JLabel lblComment;
private javax.swing.JLabel lblDorsalFrontal;
private javax.swing.JLabel lblGeneral;
private javax.swing.JLabel lblHemisphere;
private javax.swing.JLabel lblLeft;
private javax.swing.JLabel lblOrbitofrontal;
private javax.swing.JLabel lblRegion;
private javax.swing.JLabel lblRight;
private javax.swing.JLabel lblSubType;
private javax.swing.JLabel lblType;
private javax.swing.JSeparator sepOne;
private javax.swing.JTextField txtAmy;
private javax.swing.JTextField txtBas;
private javax.swing.JTextField txtComment;
private javax.swing.JTextField txtDor;
private javax.swing.JTextField txtHem;
private javax.swing.JTextField txtOrb;
// End of variables declaration//GEN-END:variables
}