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