if(verifyFields()) { try { if(!checkUsername(usrname)) { Connection conn = null; try { conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/amazingrestaurant", "root", ""); } catch (SQLException ex) { Logger.getLogger(RegistrationForm.class.getName()).log(Level.SEVERE, null, ex); } PreparedStatement stmt; ResultSet rs; String registerUserQuery = "INSERT INTO 'loginregister'('firstname', 'lastname', 'username', 'gender', 'dateofbirth', 'phone', 'address', 'suburb', 'postcode', 'state', 'password') VALUES (?,?,?,?,?,?,?,?,?,?,?)"; try { stmt = conn.prepareStatement(registerUserQuery); stmt.setString(1, fname); stmt.setString(2, lname); stmt.setString(3, gender); stmt.setString(4, dob); stmt.setString(5, phone); stmt.setString(6, address); stmt.setString(7, suburb); stmt.setString(8, postcode); stmt.setString(9, state); stmt.setString(10, psw); if(stmt.executeUpdate()!= 0){ JOptionPane.showMessageDialog(null,"Your account has been created successfully"); } else { JOptionPane.showMessageDialog(null, "Error: Check your information"); } } catch (SQLException ex) { Logger.getLogger(RegistrationForm.class.getName()).log(Level.SEVERE, null, ex); } } } catch (SQLException ex) { Logger.getLogger(RegistrationForm.class.getName()).log(Level.SEVERE, null, ex); } } }
Can someone help me get rid of nullpointerexception here
xception in thread "AWT-EventQueue-0" java.lang.NullPointerException at EmployeeAccess.RegistrationForm.verifyFields(RegistrationForm.java:487) at EmployeeAccess.RegistrationForm.jButton_signupActionPerformed(RegistrationForm.java:413) at EmployeeAccess.RegistrationForm$4.actionPerformed(RegistrationForm.java:250)
Dhiran
source share