title: Alter or modify values of particular record in table using servlet jsp
body: <p>I have created a JSP page which shows the existing values and the new values that need to be updated on submit. The servlet <em>Accountdetails.java</em> is used to process the data.</p>
  
  <h2>Example</h2>
  
  <p>First Name: aaa
  Enter the new first name in a text box to enter the new value.</p>
  
  <p>Middle Name: bbb
  Enter the new middle name and a textbox to enter the new value.</p>
  
  <p>Last Name: ccc
  Enter the new last name and a textbox to enter the new value.</p>
  
  <p>Submit button to alter or modify a record.</p>
  
  <ol>
  <li>Which is the best way to do it?</li>
  <li>Which query should I used to update a particular record? </li>
  </ol>
  
  <p>I'm stuck. because, I don't know which SQL query to use to update a particular record.
  i.e removing existing value and update with the new one.</p>