java - Netbeans Java - 您的 sql 语法有错误

Question

当我去更新数据库时遇到此错误。 Error I'm getting

这就是我的数据库的样子 Database

这是我的代码:

私有(private)无效 updatebtnActionPerformed(java.awt.event.ActionEvent evt) {

    try{
    String mid = midtxt.getText();
    String fname = firstnametxt.getText();
    String lname = lastname.getText();
    String nic = nictxt.getText();
    String Address = addresstxt.getText();
    String Telephone = telephonetxt.getText();   


    DateFormat dateFormat = new SimpleDateFormat("dd/MM/yyyy");
    jXDatePicker1.setFormats(dateFormat);
    DateFormat sysDate = new SimpleDateFormat("yyyy/MM/dd");
    String Dob  = sysDate.format(jXDatePicker1.getDate());



   String sql = "UPDATE `addmember` SET `FirstName`='"+fname+"',LastName`='"+lname+"',`NIC`='"+nic+"',`DOB`='"+Dob+"', `ADDRESS`='"+Address+"', `Telephone`='"+Telephone+"' WHERE MID='"+mid+"' ";
      try{
            Updater(sql);
            JOptionPane.showMessageDialog(null, "Values Updated");
        }
        catch( Exception ex){
            JOptionPane.showMessageDialog(null, ex);
        }
    }

    catch(Exception ex){
        JOptionPane.showMessageDialog(null, ex);
    }
}                                         

Answer 1

LastName 之前缺少反引号。