/*
* BackgroundNeuro.java
*
* Created on June 25, 2002, 4:46 PM
*/
package subjectData;
/**
*
* @author Joset A. Etzel
*/
import subjectData.*; import java.sql.*; import java.awt.event.*; import javax.swing.*;// import javax.swing.plaf.multi.MultiLookAndFeel;
public class BackgroundNeuro extends javax.swing.JInternalFrame {
private String strID = ""; private String strSubName = ""; Connection conData; Statement stmSQL;
/** Creates new form BackgroundNeuro */
public BackgroundNeuro(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 BackgroundNeuro
strSubName = strName;
setTitle("Background Neuropsychological Details for subject " + strID + ": " + strName);
FillScreen(); //call sub to fill the screen boxes with existing info in the database, if any
}
/** 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;
lblVIQ = new javax.swing.JLabel();
lblPIQ = new javax.swing.JLabel();
lblFIQ = new javax.swing.JLabel();
txtVIQ = new javax.swing.JTextField();
txtPIQ = new javax.swing.JTextField();
txtFIQ = new javax.swing.JTextField();
txtVdate = new javax.swing.JTextField();
txtPdate = new javax.swing.JTextField();
txtFdate = new javax.swing.JTextField();
txtVcomment = new javax.swing.JTextField();
txtPcomment = new javax.swing.JTextField();
txtFcomment = new javax.swing.JTextField();
lblScore = new javax.swing.JLabel();
lblDate = new javax.swing.JLabel();
lblComment = new javax.swing.JLabel();
lblType = new javax.swing.JLabel();
lblBDI = new javax.swing.JLabel();
lblWickslow1 = new javax.swing.JLabel();
lblAVLT1 = new javax.swing.JLabel();
lblBenton = new javax.swing.JLabel();
txtBDIscore = new javax.swing.JTextField();
txtBDIdate = new javax.swing.JTextField();
txtBDIcomment = new javax.swing.JTextField();
txtBentonScore = new javax.swing.JTextField();
txtBentonDate = new javax.swing.JTextField();
txtBentonComment = new javax.swing.JTextField();
lblWickslow2 = new javax.swing.JLabel();
lblAVLT2 = new javax.swing.JLabel();
lblAVLT3 = new javax.swing.JLabel();
txtWick1 = new javax.swing.JTextField();
txtWick2 = new javax.swing.JTextField();
txtAVLT1 = new javax.swing.JTextField();
txtAVLT2 = new javax.swing.JTextField();
txtAVLT3 = new javax.swing.JTextField();
txtWickDate1 = new javax.swing.JTextField();
txtWickDate2 = new javax.swing.JTextField();
txtAVLTdate1 = new javax.swing.JTextField();
txtAVLTdate2 = new javax.swing.JTextField();
txtAVLTdate3 = new javax.swing.JTextField();
txtWickComm1 = new javax.swing.JTextField();
txtWickComm2 = new javax.swing.JTextField();
txtAVLTcomm1 = new javax.swing.JTextField();
txtAVLTcomm2 = new javax.swing.JTextField();
txtAVLTcomm3 = new javax.swing.JTextField();
lblGenComment = new javax.swing.JLabel();
txtComment = new javax.swing.JTextField();
cmdCancel = new javax.swing.JButton();
cmdOK = new javax.swing.JButton();
lblDateHelp = new javax.swing.JLabel();
jSeparator1 = new javax.swing.JSeparator();
getContentPane().setLayout(new java.awt.GridBagLayout());
setIconifiable(true);
setMaximizable(true);
setResizable(true);
setFrameIcon(null);
lblVIQ.setText("verbal IQ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 3;
getContentPane().add(lblVIQ, gridBagConstraints);
lblPIQ.setText("performance IQ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 4;
getContentPane().add(lblPIQ, gridBagConstraints);
lblFIQ.setText("full scale IQ");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 5;
getContentPane().add(lblFIQ, gridBagConstraints);
txtVIQ.setMinimumSize(new java.awt.Dimension(40, 26));
txtVIQ.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 3;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtVIQ, gridBagConstraints);
txtPIQ.setMinimumSize(new java.awt.Dimension(40, 26));
txtPIQ.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 4;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtPIQ, gridBagConstraints);
txtFIQ.setMinimumSize(new java.awt.Dimension(40, 26));
txtFIQ.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 5;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtFIQ, gridBagConstraints);
txtVdate.setMinimumSize(new java.awt.Dimension(60, 26));
txtVdate.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 3;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtVdate, gridBagConstraints);
txtPdate.setMinimumSize(new java.awt.Dimension(60, 26));
txtPdate.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 4;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtPdate, gridBagConstraints);
txtFdate.setMinimumSize(new java.awt.Dimension(60, 26));
txtFdate.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 5;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtFdate, gridBagConstraints);
txtVcomment.setMinimumSize(new java.awt.Dimension(200, 26));
txtVcomment.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(txtVcomment, gridBagConstraints);
txtPcomment.setMinimumSize(new java.awt.Dimension(200, 26));
txtPcomment.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(txtPcomment, gridBagConstraints);
txtFcomment.setMinimumSize(new java.awt.Dimension(200, 26));
txtFcomment.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(txtFcomment, gridBagConstraints);
lblScore.setFont(new java.awt.Font("Dialog", 3, 12));
lblScore.setText("score");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 2;
getContentPane().add(lblScore, gridBagConstraints);
lblDate.setFont(new java.awt.Font("Dialog", 3, 12));
lblDate.setText("date");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 2;
getContentPane().add(lblDate, gridBagConstraints);
lblComment.setFont(new java.awt.Font("Dialog", 3, 12));
lblComment.setText("comment");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 2;
getContentPane().add(lblComment, gridBagConstraints);
lblType.setFont(new java.awt.Font("Dialog", 3, 12));
lblType.setText("type");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 2;
getContentPane().add(lblType, gridBagConstraints);
lblBDI.setText("BDI");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 6;
getContentPane().add(lblBDI, gridBagConstraints);
lblWickslow1.setText("Wickslow1");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 8;
getContentPane().add(lblWickslow1, gridBagConstraints);
lblAVLT1.setText("AVLT3");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 12;
getContentPane().add(lblAVLT1, gridBagConstraints);
lblBenton.setText("Benton Faces");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 7;
getContentPane().add(lblBenton, gridBagConstraints);
txtBDIscore.setMinimumSize(new java.awt.Dimension(40, 26));
txtBDIscore.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 6;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtBDIscore, gridBagConstraints);
txtBDIdate.setMinimumSize(new java.awt.Dimension(60, 26));
txtBDIdate.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 6;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtBDIdate, gridBagConstraints);
txtBDIcomment.setMinimumSize(new java.awt.Dimension(200, 26));
txtBDIcomment.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(txtBDIcomment, gridBagConstraints);
txtBentonScore.setMinimumSize(new java.awt.Dimension(40, 26));
txtBentonScore.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 7;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtBentonScore, gridBagConstraints);
txtBentonDate.setMinimumSize(new java.awt.Dimension(60, 26));
txtBentonDate.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 7;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtBentonDate, gridBagConstraints);
txtBentonComment.setMinimumSize(new java.awt.Dimension(200, 26));
txtBentonComment.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(txtBentonComment, gridBagConstraints);
lblWickslow2.setText("Wickslow2");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 9;
getContentPane().add(lblWickslow2, gridBagConstraints);
lblAVLT2.setText("AVLT2");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 11;
getContentPane().add(lblAVLT2, gridBagConstraints);
lblAVLT3.setText("AVLT1");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 10;
getContentPane().add(lblAVLT3, gridBagConstraints);
txtWick1.setMinimumSize(new java.awt.Dimension(40, 26));
txtWick1.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 8;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtWick1, gridBagConstraints);
txtWick2.setMinimumSize(new java.awt.Dimension(40, 26));
txtWick2.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 9;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtWick2, gridBagConstraints);
txtAVLT1.setMinimumSize(new java.awt.Dimension(40, 26));
txtAVLT1.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 10;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLT1, gridBagConstraints);
txtAVLT2.setMinimumSize(new java.awt.Dimension(40, 26));
txtAVLT2.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 11;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLT2, gridBagConstraints);
txtAVLT3.setMinimumSize(new java.awt.Dimension(40, 26));
txtAVLT3.setPreferredSize(new java.awt.Dimension(80, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 12;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLT3, gridBagConstraints);
txtWickDate1.setMinimumSize(new java.awt.Dimension(60, 26));
txtWickDate1.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 8;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtWickDate1, gridBagConstraints);
txtWickDate2.setMinimumSize(new java.awt.Dimension(60, 26));
txtWickDate2.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 9;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtWickDate2, gridBagConstraints);
txtAVLTdate1.setMinimumSize(new java.awt.Dimension(60, 26));
txtAVLTdate1.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 10;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLTdate1, gridBagConstraints);
txtAVLTdate2.setMinimumSize(new java.awt.Dimension(60, 26));
txtAVLTdate2.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 11;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLTdate2, gridBagConstraints);
txtAVLTdate3.setMinimumSize(new java.awt.Dimension(60, 26));
txtAVLTdate3.setPreferredSize(new java.awt.Dimension(120, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 2;
gridBagConstraints.gridy = 12;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLTdate3, gridBagConstraints);
txtWickComm1.setMinimumSize(new java.awt.Dimension(200, 26));
txtWickComm1.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 8;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtWickComm1, gridBagConstraints);
txtWickComm2.setMinimumSize(new java.awt.Dimension(200, 26));
txtWickComm2.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 9;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtWickComm2, gridBagConstraints);
txtAVLTcomm1.setMinimumSize(new java.awt.Dimension(200, 26));
txtAVLTcomm1.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 10;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLTcomm1, gridBagConstraints);
txtAVLTcomm2.setMinimumSize(new java.awt.Dimension(200, 26));
txtAVLTcomm2.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 11;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLTcomm2, gridBagConstraints);
txtAVLTcomm3.setMinimumSize(new java.awt.Dimension(200, 26));
txtAVLTcomm3.setPreferredSize(new java.awt.Dimension(300, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 3;
gridBagConstraints.gridy = 12;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtAVLTcomm3, gridBagConstraints);
lblGenComment.setText("comments");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 13;
getContentPane().add(lblGenComment, gridBagConstraints);
txtComment.setMinimumSize(new java.awt.Dimension(300, 26));
txtComment.setPreferredSize(new java.awt.Dimension(510, 26));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 1;
gridBagConstraints.gridy = 13;
gridBagConstraints.gridwidth = 3;
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(txtComment, 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 = 3;
gridBagConstraints.gridy = 14;
gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
gridBagConstraints.insets = new java.awt.Insets(4, 0, 0, 4);
getContentPane().add(cmdCancel, 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 = 4;
gridBagConstraints.gridy = 14;
gridBagConstraints.insets = new java.awt.Insets(4, 4, 0, 0);
getContentPane().add(cmdOK, gridBagConstraints);
lblDateHelp.setText("Dates must be entered in the format yyyy-mm-dd. If the date is unknown enter 0000-00-00.");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 0;
gridBagConstraints.gridwidth = 5;
getContentPane().add(lblDateHelp, gridBagConstraints);
jSeparator1.setMinimumSize(new java.awt.Dimension(700, 2));
jSeparator1.setPreferredSize(new java.awt.Dimension(700, 2));
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 1;
gridBagConstraints.gridwidth = 5;
gridBagConstraints.insets = new java.awt.Insets(5, 0, 10, 0);
getContentPane().add(jSeparator1, gridBagConstraints);
pack();
}//GEN-END:initComponents
private void cmdOKActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdOKActionPerformed
//enter the new data into the neuropsych table
String strSQL = ""; String strTemp = "";
String strvIQscore = ""; String strvIQdate = ""; String strpIQscore = ""; String strpIQdate = "";
String strfIQscore = ""; String strfIQdate = ""; String strvIQcomment = ""; String strpIQcomment = "";
String strfIQcomment = ""; String strBDIscore = ""; String strBDIdate = ""; String strBDIcomment = "";
String str1Wickscore = ""; String str2Wickscore = ""; String str1Wickdate = ""; String str2Wickdate = "";
String str1Wickcomment = ""; String str2Wickcomment = ""; String str1AVLTscore = ""; String str2AVLTscore = "";
String str3AVLTscore = ""; String str1AVLTdate = ""; String str2AVLTdate = ""; String str3AVLTdate = "";
String str1AVLTcomment = ""; String str2AVLTcomment = ""; String str3AVLTcomment = ""; String strbentonScore = "";
String strbentonDate = ""; String strbentonComment = ""; String strcomment = "";
//get the info from all of the text boxes ...
strvIQscore = txtVIQ.getText(); strpIQscore = txtPIQ.getText(); strfIQscore = txtFIQ.getText();
strvIQdate = txtVdate.getText(); strpIQdate = txtPdate.getText(); strfIQdate = txtFdate.getText();
strvIQcomment = txtVcomment.getText(); strpIQcomment = txtPcomment.getText(); strfIQcomment = txtFcomment.getText();
strBDIscore = txtBDIscore.getText(); strBDIdate = txtBDIdate.getText(); strBDIcomment = txtBDIcomment.getText();
str1Wickscore = txtWick1.getText(); str2Wickscore = txtWick2.getText(); str1Wickdate = txtWickDate1.getText();
str2Wickdate = txtWickDate2.getText(); str1Wickcomment = txtWickComm1.getText(); str2Wickcomment = txtWickComm2.getText();
str1AVLTscore = txtAVLT1.getText(); str2AVLTscore = txtAVLT2.getText(); str3AVLTscore = txtAVLT3.getText();
str1AVLTdate = txtAVLTdate1.getText(); str2AVLTdate = txtAVLTdate2.getText(); str3AVLTdate = txtAVLTdate3.getText();
strbentonScore = txtBentonScore.getText(); strbentonDate = txtBentonDate.getText(); strbentonComment = txtBentonComment.getText();
strcomment = txtComment.getText(); str1AVLTcomment = txtAVLTcomm1.getText(); str2AVLTcomment = txtAVLTcomm2.getText();
str3AVLTcomment = txtAVLTcomm3.getText();
//add escape chars to the comment strings
strvIQcomment = SubjectData.AddEscapeChars(strvIQcomment); strpIQcomment = SubjectData.AddEscapeChars(strpIQcomment);
strfIQcomment = SubjectData.AddEscapeChars(strfIQcomment); strBDIcomment = SubjectData.AddEscapeChars(strBDIcomment);
str1Wickcomment = SubjectData.AddEscapeChars(str1Wickcomment); str2Wickcomment = SubjectData.AddEscapeChars(str2Wickcomment);
strbentonComment = SubjectData.AddEscapeChars(strbentonComment); str1AVLTcomment = SubjectData.AddEscapeChars(str1AVLTcomment);
str2AVLTcomment = SubjectData.AddEscapeChars(str2AVLTcomment); str3AVLTcomment = SubjectData.AddEscapeChars(str3AVLTcomment);
strcomment = SubjectData.AddEscapeChars(strcomment);
//check if the dates are valid, prompt & exit if not. don't call CheckDate if date is "", 0000-00-00, or ?
if (strvIQdate.equals("?") == true) { strvIQdate = "0000-00-00"; }
else if (CheckDate(strvIQdate, "the Verbal IQ field") == false) { return; }
if (strpIQdate.equals("?") == true) { strpIQdate = "0000-00-00"; }
else if (CheckDate(strpIQdate, "the Performance IQ field") == false) { return; }
if (strfIQdate.equals("?") == true) { strfIQdate = "0000-00-00"; }
else if (CheckDate(strfIQdate, "the Full IQ field") == false) { return; }
if (strBDIdate.equals("?") == true) { strBDIdate = "0000-00-00"; }
else if (CheckDate(strBDIdate, "the BDI field") == false) { return; }
if (str1Wickdate.equals("?") == true) { str1Wickdate = "0000-00-00"; }
else if (CheckDate(str1Wickdate, "the first Wickslow field") == false) { return; }
if (str2Wickdate.equals("?") == true) { str2Wickdate = "0000-00-00"; }
else if (CheckDate(str2Wickdate, "the second Wickslow field") == false) { return; }
if (str1AVLTdate.equals("?") == true) { str1AVLTdate = "0000-00-00"; }
else if (CheckDate(str1AVLTdate, "the first AVLT field") == false) { return; }
if (str2AVLTdate.equals("?") == true) { str2AVLTdate = "0000-00-00"; }
else if (CheckDate(str2AVLTdate, "the second AVLT field") == false) { return; }
if (str3AVLTdate.equals("?") == true) { str3AVLTdate = "0000-00-00"; }
else if (CheckDate(str3AVLTdate, "the third AVLT field") == false) { return; }
if (strbentonDate.equals("?") == true) { strbentonDate = "0000-00-00"; }
else if (CheckDate(strbentonDate, "the Benton Faces field") == false) { return; }
//make SQL string to enter or update the data in the database
if (cmdOK.getLabel().equals("Add") == true) { //make sql string to ADD a new row
strSQL = "INSERT INTO neuropsych VALUES ('" + strID + "', '" + strvIQscore + "', '" + strvIQdate + "', '" +
strvIQcomment + "', '" + strpIQscore + "', '" + strpIQdate + "', '" + strpIQcomment + "', '" + strfIQscore + "', '" + strfIQdate + "', '" +
strfIQcomment + "', '" + strBDIscore + "', '" + strBDIdate + "', '" + strBDIcomment + "', '" + str1Wickscore + "', '" + str1Wickdate + "', '" +
str1Wickcomment + "', '" + str2Wickscore + "', '" + str2Wickdate + "', '" + str2Wickcomment + "', '" + str1AVLTscore + "', '" +
str1AVLTdate + "', '" + str1AVLTcomment + "', '" + str2AVLTscore + "', '" + str2AVLTdate + "', '" + str2AVLTcomment + "', '" +
str3AVLTscore + "', '" + str3AVLTdate + "', '" + str3AVLTcomment + "', '" + strbentonScore + "', '" + strbentonDate + "', '" +
strbentonComment + "', '" + strcomment + "')"; }
else if (cmdOK.getLabel().equals("Update") == true) { //make sql string to UPDATE an existing row
strSQL = "UPDATE neuropsych SET vIQscore = '" + strvIQscore + "', vIQdate = '" + strvIQdate
+ "', vIQcomment = '" + strvIQcomment + "', pIQscore = '" + strpIQscore + "', pIQdate = '" + strpIQdate
+ "', pIQcomment = '" + strpIQcomment + "', fIQscore = '" + strfIQscore + "', fIQdate = '" + strfIQdate
+ "', fIQcomment = '" + strfIQcomment + "', BDIscore = '" + strBDIscore + "', BDIdate = '" + strBDIdate
+ "', BDIcomment = '" + strBDIcomment + "', 1Wickscore = '" + str1Wickscore + "', 1Wickdate = '" + str1Wickdate
+ "', 1Wickcomment = '" + str1Wickcomment + "', 2Wickscore = '" + str2Wickscore + "', 2Wickdate = '" + str2Wickdate
+ "', 2Wickcomment = '" + str2Wickcomment + "', 1AVLTscore = '" + str1AVLTscore + "', 1AVLTdate = '" + str1AVLTdate
+ "', 1AVLTcomment = '" + str1AVLTcomment + "', 2AVLTscore = '" + str2AVLTscore + "', 2AVLTdate = '" + str2AVLTdate
+ "', 2AVLTcomment = '" + str2AVLTcomment + "', 3AVLTscore = '" + str3AVLTscore + "', 3AVLTdate = '" + str3AVLTdate
+ "', 3AVLTcomment = '" + str3AVLTcomment + "', bentonScore = '" + strbentonScore + "', bentonDate = '" + strbentonDate
+ "', bentonComment = '" + strbentonComment + "', comment = '" + strcomment + "' WHERE subID = '" + strID + "'"; }
try { stmSQL = conData.createStatement(); stmSQL.executeUpdate(strSQL); }
catch(java.sql.SQLException e) { e.printStackTrace(); }
try { this.setClosed(true); } //close the frame
catch (java.beans.PropertyVetoException e) { e.printStackTrace(); }
}//GEN-LAST:event_cmdOKActionPerformed
private void cmdCancelActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdCancelActionPerformed
//close the frame
try { this.setClosed(true); }
catch (java.beans.PropertyVetoException e) { e.printStackTrace(); }
}//GEN-LAST:event_cmdCancelActionPerformed
public static boolean CheckDate(String strTemp, String strBox) {
//function checks if the date passed (strDate) is in a valid format returns true if so, false if not
String strMonth = ""; String strDay = ""; String strYear = ""; boolean bolReturn = true;
int intYear = 0; int intMonth = 0; int intDay = 0;
if (strTemp.equals("0000-00-00") == true | strTemp.equals("") == true) { return true; } //zero string is ok
if (strTemp.indexOf("-") == -1) { JOptionPane.showMessageDialog(null, "The date in in " + strBox + " must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
strYear = strTemp.substring(0, strTemp.indexOf("-"));
intYear = strTemp.indexOf("-") + 1;
strTemp = strTemp.substring(intYear);
if (strTemp.indexOf("-") == -1) { JOptionPane.showMessageDialog(null, "The date in in " + strBox + " must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
strMonth = strTemp.substring(0, strTemp.indexOf("-")); //now can parse out the next part - the month
intYear = strTemp.indexOf("-") + 1;
strDay = strTemp.substring(intYear); //take out the month, leaves day
intYear = Integer.parseInt(strYear); intMonth = Integer.parseInt(strMonth); intDay = Integer.parseInt(strDay);
if (strYear.length() != 4) { JOptionPane.showMessageDialog(null, "Please use four digits for the year in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
if (strMonth.length() != 2) { JOptionPane.showMessageDialog(null, "Please use two digits for the month (01 to 12) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
if (strDay.length() != 2) { JOptionPane.showMessageDialog(null, "Please use two digits for the day (01 to 31) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
if (intYear < 1800 | intYear > 2200) { JOptionPane.showMessageDialog(null, "Please use four digits for the year in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
if (intMonth < 1 | intMonth > 12) { JOptionPane.showMessageDialog(null, "Please use two digits for the month (01 to 12) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
if (intDay < 1 | intDay > 31) { JOptionPane.showMessageDialog(null, "Please use two digits for the day (01 to 31) in " + strBox + ". \nThe date must be in the exact format yyyy-mm-dd.", "Missing Data Error", JOptionPane.ERROR_MESSAGE); return false; }
return true; //if haven't exited yet, date is ok so return true
}
private void FillScreen() {
//puts info from the database into the boxes on the screen for this subject
try {
stmSQL = conData.createStatement(); //stmSQL is global - have to get it ready
ResultSet rssSubjects = stmSQL.executeQuery("SELECT * FROM neuropsych WHERE subID = " + strID);
if (rssSubjects.next() == true) { cmdOK.setText("Update");
txtVIQ.setText(rssSubjects.getString("vIQscore")); txtVdate.setText(rssSubjects.getString("vIQdate"));
txtPIQ.setText(rssSubjects.getString("pIQscore")); txtPdate.setText(rssSubjects.getString("pIQdate"));
txtFIQ.setText(rssSubjects.getString("fIQscore")); txtFdate.setText(rssSubjects.getString("fIQdate"));
txtVcomment.setText(rssSubjects.getString("vIQcomment")); txtPcomment.setText(rssSubjects.getString("pIQcomment"));
txtFcomment.setText(rssSubjects.getString("fIQcomment")); txtBDIscore.setText(rssSubjects.getString("BDIscore"));
txtBDIdate.setText(rssSubjects.getString("BDIdate")); txtBDIcomment.setText(rssSubjects.getString("BDIcomment"));
txtWick1.setText(rssSubjects.getString("1Wickscore")); txtWick2.setText(rssSubjects.getString("2Wickscore"));
txtWickDate1.setText(rssSubjects.getString("1Wickdate")); txtWickDate2.setText(rssSubjects.getString("2Wickdate"));
txtWickComm1.setText(rssSubjects.getString("1Wickcomment")); txtWickComm2.setText(rssSubjects.getString("2Wickcomment"));
txtAVLT1.setText(rssSubjects.getString("1AVLTscore")); txtAVLT2.setText(rssSubjects.getString("2AVLTscore"));
txtAVLT3.setText(rssSubjects.getString("3AVLTscore")); txtAVLTdate1.setText(rssSubjects.getString("1AVLTdate"));
txtAVLTdate2.setText(rssSubjects.getString("2AVLTdate")); txtAVLTdate3.setText(rssSubjects.getString("3AVLTdate"));
txtAVLTcomm1.setText(rssSubjects.getString("1AVLTcomment")); txtAVLTcomm2.setText(rssSubjects.getString("2AVLTcomment"));
txtAVLTcomm3.setText(rssSubjects.getString("3AVLTcomment")); txtBentonScore.setText(rssSubjects.getString("bentonScore"));
txtBentonDate.setText(rssSubjects.getString("bentonDate")); txtBentonComment.setText(rssSubjects.getString("bentonComment"));
txtComment.setText(rssSubjects.getString("comment"));
}
else { cmdOK.setText("Add"); return; } //exit sub - not in database
} catch(java.sql.SQLException e) { e.printStackTrace(); }
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JButton cmdCancel;
private javax.swing.JButton cmdOK;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JLabel lblAVLT1;
private javax.swing.JLabel lblAVLT2;
private javax.swing.JLabel lblAVLT3;
private javax.swing.JLabel lblBDI;
private javax.swing.JLabel lblBenton;
private javax.swing.JLabel lblComment;
private javax.swing.JLabel lblDate;
private javax.swing.JLabel lblDateHelp;
private javax.swing.JLabel lblFIQ;
private javax.swing.JLabel lblGenComment;
private javax.swing.JLabel lblPIQ;
private javax.swing.JLabel lblScore;
private javax.swing.JLabel lblType;
private javax.swing.JLabel lblVIQ;
private javax.swing.JLabel lblWickslow1;
private javax.swing.JLabel lblWickslow2;
private javax.swing.JTextField txtAVLT1;
private javax.swing.JTextField txtAVLT2;
private javax.swing.JTextField txtAVLT3;
private javax.swing.JTextField txtAVLTcomm1;
private javax.swing.JTextField txtAVLTcomm2;
private javax.swing.JTextField txtAVLTcomm3;
private javax.swing.JTextField txtAVLTdate1;
private javax.swing.JTextField txtAVLTdate2;
private javax.swing.JTextField txtAVLTdate3;
private javax.swing.JTextField txtBDIcomment;
private javax.swing.JTextField txtBDIdate;
private javax.swing.JTextField txtBDIscore;
private javax.swing.JTextField txtBentonComment;
private javax.swing.JTextField txtBentonDate;
private javax.swing.JTextField txtBentonScore;
private javax.swing.JTextField txtComment;
private javax.swing.JTextField txtFIQ;
private javax.swing.JTextField txtFcomment;
private javax.swing.JTextField txtFdate;
private javax.swing.JTextField txtPIQ;
private javax.swing.JTextField txtPcomment;
private javax.swing.JTextField txtPdate;
private javax.swing.JTextField txtVIQ;
private javax.swing.JTextField txtVcomment;
private javax.swing.JTextField txtVdate;
private javax.swing.JTextField txtWick1;
private javax.swing.JTextField txtWick2;
private javax.swing.JTextField txtWickComm1;
private javax.swing.JTextField txtWickComm2;
private javax.swing.JTextField txtWickDate1;
private javax.swing.JTextField txtWickDate2;
// End of variables declaration//GEN-END:variables
}