/*
* ViewDatabaseKey.java
*
* Created on July 24, 2002, 3:38 PM
*/
package subjectData;
/**
*
* @author Joset A. Etzel
*/
import subjectData.*; import java.sql.*; import java.awt.event.*; import javax.swing.*; import javax.swing.table.*;
public class ViewDatabaseKey extends javax.swing.JInternalFrame {
Connection conData; Statement stmSQL; //variables for sql database access
/** Creates new form ViewDatabaseKey */
public ViewDatabaseKey() {
initComponents();
//connect to the database
try {
Class.forName("org.gjt.mm.mysql.Driver");
conData = SubjectData.getDatabaseConnection();
} catch (Exception e) { e.printStackTrace(); }
ExcelAdapter myAd = new ExcelAdapter(tblKey); //call code to let the table copy and paste into Excel
CreateKey(); //call sub to put the info into tblKey
}
/** 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;
cmdClose = new javax.swing.JButton();
jLabel1 = new javax.swing.JLabel();
jScrollPane1 = new javax.swing.JScrollPane();
tblKey = new javax.swing.JTable();
getContentPane().setLayout(new java.awt.GridBagLayout());
setClosable(true);
setIconifiable(true);
setMaximizable(true);
setResizable(true);
setTitle("Database Key");
cmdClose.setText("Close");
cmdClose.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
cmdCloseActionPerformed(evt);
}
});
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 2;
gridBagConstraints.anchor = java.awt.GridBagConstraints.EAST;
getContentPane().add(cmdClose, gridBagConstraints);
jLabel1.setFont(new java.awt.Font("Dialog", 2, 12));
jLabel1.setText("Copy (ctrl+c) and paste (ctrl+v) this text into Excel or Notepad to print it.");
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.anchor = java.awt.GridBagConstraints.WEST;
getContentPane().add(jLabel1, gridBagConstraints);
jScrollPane1.setMinimumSize(new java.awt.Dimension(600, 303));
jScrollPane1.setPreferredSize(new java.awt.Dimension(603, 303));
tblKey.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
},
new String [] {
"subID", "name or PPG", "sessionID", "experiment type", "date"
}
) {
Class[] types = new Class [] {
java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
};
boolean[] canEdit = new boolean [] {
false, false, false, false, false
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
tblKey.setPreferredScrollableViewportSize(new java.awt.Dimension(500, 400));
tblKey.setPreferredSize(new java.awt.Dimension(600, 350));
jScrollPane1.setViewportView(tblKey);
gridBagConstraints = new java.awt.GridBagConstraints();
gridBagConstraints.gridx = 0;
gridBagConstraints.gridy = 1;
gridBagConstraints.insets = new java.awt.Insets(5, 0, 5, 0);
getContentPane().add(jScrollPane1, gridBagConstraints);
pack();
}//GEN-END:initComponents
private void cmdCloseActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_cmdCloseActionPerformed
//close the frame
try { this.setClosed(true); }
catch (java.beans.PropertyVetoException e) { e.printStackTrace(); }
}//GEN-LAST:event_cmdCloseActionPerformed
private void CreateKey() {
//creates the database key and displays it in tblKey as:
//count subID PPG/Name sessionID expType expDate
int intC = -1; String strVec[] = {"", "", "", "", "", ""}; String strTemp = ""; String strNames = "";
DefaultTableModel tblModel = (DefaultTableModel)tblKey.getModel(); //get the table model for the table so can alter it
try { //get all of the subjects' IDs and names/PPGs out and into strNames
stmSQL = conData.createStatement(); //stmSQL is global - have to get it ready
ResultSet rssSubjects = stmSQL.executeQuery("SELECT subject.*, sessionData.* FROM subject LEFT JOIN sessionData ON (subject.subID = sessionData.subID) ORDER BY PPG, lastName");
while (rssSubjects.next()) { //fill up the table
intC = intC + 1;
tblModel.addRow(strVec); //add a new empty row so can put in the info
tblModel.setValueAt("" + rssSubjects.getInt("subID"), intC, 0); //first column is subject ID
strTemp = rssSubjects.getString("PPG");
if ( strTemp.equals("") == false ) { strNames = strTemp; }
else { strNames = rssSubjects.getString("lastName") + ", " + rssSubjects.getString("firstName") + " " + rssSubjects.getString("middleInitial") + "."; }
tblModel.setValueAt(strNames, intC, 1); //then subject name or PPG
tblModel.setValueAt("" + rssSubjects.getInt("sessionID"), intC, 2); //third column is sessionID
tblModel.setValueAt(rssSubjects.getString("expType"), intC, 3); //fourth is experiment type
tblModel.setValueAt(rssSubjects.getString("expDate"), intC, 4); //last is experiment date
}
} catch(java.sql.SQLException e) { e.printStackTrace(); }
}
// Variables declaration - do not modify//GEN-BEGIN:variables
private javax.swing.JButton cmdClose;
private javax.swing.JLabel jLabel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable tblKey;
// End of variables declaration//GEN-END:variables
}