update prepared statement to update user input information in java

Question

The error i receive is : Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException

String sourceURL = "jdbc:odbc:studentdb"; String driverName = "sun.jdbc.odbc.JdbcOdbcDriver";

        String BName = txtDate.getText();
        String AName = txtadd.getText();
        String CName = txtCon.getText();
        String Search = txtSeaNam.getText();
       try{ 
      Class.forName(driverName);
      Connection conn = DriverManager.getConnection(sourceURL,"","");

      Statement ins = conn.createStatement();
      String Insert = "UPDATE student SET Address = '%"+AName+"%', ContactDetails = '%"+CName+"%', DateOfBirth = '%"+BName+"%'"
              + " WHERE Name = '%"+Search+"%' and ContactDetails = '%"+Search+"%' and DateOfBirth = '%"+Search+"%'";
      PreparedStatement st = conn.prepareStatement(Insert);


      st.setString(1, BName);
      st.setString(2, AName);
      st.setString(3,CName);
      st.executeUpdate();

  }catch (SQLException | ClassNotFoundException e){
      System.out.println(e.toString());
  }

Please help with error. thanks

also: do yourself a favour and look into naming conventions – Stultuske Oct 24 '17 at 11:58 — Stultuske, Oct 24 '17 at 11:58
That query is not going to work... – f1sh Oct 24 '17 at 12:00 — f1sh, Oct 24 '17 at 12:00

update prepared statement to update user input information in java

0 Answers0