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