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