private void jButton1ActionPerformed(
java.awt.event.ActionEvent evt) { // GEN-FIRST:event_jButton1ActionPerformed
try {
String status = null;
if (jRadioButton1.isSelected()) status = "Student";
else if (jRadioButton2.isSelected()) status = "Teacher";
User u = new User();
u.setUsername(jTextField8.getText());
u.setPassword(jPasswordField1.getText());
u.setFirstname(jTextField1.getText());
u.setLastname(jTextField2.getText());
u.setStudentID(jTextField3.getText());
u.setBirthDay(jTextField4.getText());
u.setTelephone(jTextField5.getText());
u.setEmail(jTextField6.getText());
u.setFacebook(jTextField7.getText());
u.setStatus(status);
SQLConnection MyCon = new SQLConnection();
Connection c = MyCon.getConnection("journal");
Statement stmt = c.createStatement();
// String name = MyCon.getUsername();
String checkname, checkid;
int foundname = 0, foundid = 0;
String SQL = "select * from profile ;";
ResultSet rs = stmt.executeQuery(SQL);
while (rs.next()) {
checkname = rs.getString("username");
if (checkname.toUpperCase().equals(jTextField8.getText().toUpperCase())) {
foundname = 1;
break;
}
checkid = rs.getString("studentID");
if (checkid.toUpperCase().equals(jTextField3.getText().toUpperCase())) {
foundid = 1;
break;
}
}
if (u.getUsername().equalsIgnoreCase("")) {
jLabel12.setVisible(true);
jLabel15.setVisible(false);
jLabel16.setVisible(false);
jLabel17.setVisible(false);
jLabel18.setVisible(false);
} else if (foundname == 1) {
JOptionPane.showMessageDialog(null, "Username " + jTextField8.getText() + " is already");
jLabel12.setVisible(true);
jLabel15.setVisible(false);
jLabel16.setVisible(false);
jLabel17.setVisible(false);
jLabel18.setVisible(false);
} else if (u.getPassword().equalsIgnoreCase("")) {
jLabel12.setVisible(false);
jLabel15.setVisible(false);
jLabel16.setVisible(false);
jLabel17.setVisible(false);
jLabel18.setVisible(true);
} else if (u.getFirstname().equalsIgnoreCase("")) {
jLabel12.setVisible(false);
jLabel15.setVisible(true);
jLabel16.setVisible(false);
jLabel17.setVisible(false);
jLabel18.setVisible(false);
} else if (u.getLastname().equalsIgnoreCase("")) {
jLabel12.setVisible(false);
jLabel15.setVisible(false);
jLabel16.setVisible(true);
jLabel17.setVisible(false);
jLabel18.setVisible(false);
} else if (u.getStudentID().equalsIgnoreCase("")) {
jLabel12.setVisible(false);
jLabel15.setVisible(false);
jLabel16.setVisible(false);
jLabel17.setVisible(true);
jLabel18.setVisible(false);
} else if (foundid == 1) {
JOptionPane.showMessageDialog(null, "StudentID " + jTextField3.getText() + " is already");
} else {
SQLConnection mycon = new SQLConnection();
mycon.SQLInsertProfile(u);
mycon.SQLcreateTableForUser(jTextField8.getText());
mycon.useUsername(jTextField8.getText());
new ShowProfile().show();
this.dispose();
}
} catch (SQLException ex) {
Logger.getLogger(CreateProfile.class.getName()).log(Level.SEVERE, null, ex);
}
} // GEN-LAST:event_jButton1ActionPerformed
