Java MySQL Update Record Statement
<p>Hi I have writtten a code to update a record in a database, as soon as a button is clicked. below is the code. As soon as i run it and click the button, it says that the syntax is wrong. Could someone please advise?</p>

<pre><code>    JButton button = new JButton("Save");
    button.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent arg0) {         

        try {
            con.stmt.executeUpdate(  "UPDATE student set StudentID='" + txtAUniqueStudent.getText() + 
                      "', FirstName='" + textField_1.getText() + 
                      "', Surname='" + textField_2.getText() + 
                      "', DOB='" + textField_3.getText() + 
                      "', Gender='" + textField.getText() + 
                      "', AddressLine1='" + textField_4.getText() + 
                      "', AddressLine2='" + textField_5.getText() + 
                      "', PostCode='" + textField_6.getText() + 
                      "', FatherFullName='" + textField_7.getText() + 
                      "', Phone='" + textField_8.getText() + 
                      "', Mobile='" + textField_9.getText() +
                      "', Fax='" + textField_10.getText() + 
                      "', Email='" + textField_11.getText() + 
                      "', EmergencyContactName='" + textField_12.getText() + 
                      "', EmergencyTel='" + textField_13.getText() + 
                      "', AcademicYear='" + textField_14.getText() + 
                      "', Subjects='" + textField_15.getText() + 
                      "' WHERE studentID ='" + textField_16.getText());

            con.stmt.executeUpdate();
            JOptionPane.showMessageDialog(frmFindStudent, "Record has been updated successfully.");
        } 
</code></pre>
