title: jdbc odbc for update an existing data?
body: <p>What would be the problem with jdbc odbc for update an existing data?</p>
  
  <p>in database i declear "ID" and "FirstName" are text type and "Mobile" is number type(integer).</p>
  
  <blockquote>
    <p>Error code : java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.</p>
  </blockquote>
  
  <pre><code>private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {                                         
  
      try{
               int number;
               String id,fName;
                     id=jTextField1.getText();
                       fName=jTextField2.getText();
                       number=Integer.parseInt(jTextField3.getText());
  
          s.executeUpdate("UPDATE Student set ID='"+id+"','FirstName'"+fName+"',Mobile"+number+" where ID='"+id+"'");
              JOptionPane.showMessageDialog(null,"Record has been updated");
                  System.out.println("Updated");
          DBclose();
          DBopen();
      }
  
      catch(HeadlessException | SQLException ae){
              System.out.println(ae);}}
  </code></pre>