0

When i am coding in netbeans, java and mysql, in some point i couldn't insert values where db table having auto increment primary key (user_id). 

         String sql = "INSERT INTO `user`(`fname`, `lname`, `uemail`, 
        `upass`, `role_id`) VALUES (?, ?, ?, ?, ?)";
        //ps.setInt(1,2);
        ps.setString(1, fname);
        ps.setString(2, lname);
        ps.setString(3, uemail);
        ps.setString(4, upass);
        ps.setInt(5, Integer.parseInt(urole));

I get below error:

Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException at mxm.MainFrame.btnURegisterActionPerformed(MainFrame.java:1365)

Regolith
  • 2,944
  • 9
  • 33
  • 50
sasa0110
  • 13
  • 3
  • 1
    What's happening at line 1365 ? – Adeel Aug 14 '17 at 06:49
  • maybe `ps` is null or `urole` is null - also leave a space before `(` and also I don't think the ugly backticks are needed – Scary Wombat Aug 14 '17 at 06:51
  • String fname = txtUFName.getText(); String lname = txtULName.getText(); String uemail = txtUEmail.getText(); String upass = String.valueOf(pwdUSet.getPassword()); String setpass = String.valueOf(pwdUConfirm.getPassword()); String urole = cmbURole.getSelectedItem().toString(); Connection con; PreparedStatement ps = null; Statement st; – sasa0110 Aug 14 '17 at 06:57
  • 1
    *PreparedStatement ps = null;* – Scary Wombat Aug 14 '17 at 06:58
  • try { con = DriverManager.getConnection("jdbc:mysql://localhost:3306/ji_computer?zeroDateTimeBehavior=convertToNull", "root", ""); String sql = "INSERT INTO `user`(`fname`, `lname`, `uemail`, `upass`, `role_id`) VALUES (?, ?, ?, ?, ?)"; //ps.setInt(1,2); ps.setString(1, fname); ps.setString(2, lname); ps.setString(3, uemail); ps.setString(4, upass); ps.setInt(5, Integer.parseInt(urole)); – sasa0110 Aug 14 '17 at 06:58
  • You never initialise `ps`. – bcsb1001 Aug 14 '17 at 06:59
  • PreparedStatement ps = null; – Scary Wombat it is auto initialized. down in the code i use ps = con.prepareStatement(sql,PreparedStatement.RETURN_GENERATED_KEYS); boolean execute = ps.execute(); ps.close(); – sasa0110 Aug 14 '17 at 07:00
  • You should edit your **question**, don't use comments for additional information (especially not for code, as it becomes unreadable in comments). – Mark Rotteveel Aug 14 '17 at 08:54

0 Answers0