title: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Error JAVA
body: <p>I am getting a error that I do not fully understand, why is it showing up ?<br>
  I have a form where I enter details into relevant JTextBoxes and data from those textboxes should be sent to a database I have set up on my local.</p>
  
  <p>Full error message</p>
  
  <pre><code>com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException. You have an error in your 
  SQL syntax; check the manual that corresponds to your MySQL server version for the 
  right   syntax to use near ')VALUES'asd','asd',",",",",",",'Home','Female','White  
  British' at line 1
  </code></pre>
  
  <p>Code </p>
  
  <pre><code>conn = (Connection) SQLConnect.ConnectDb();
      //inserting all values to database
      String sql = "INSERT INTO w1283057.criminalrecords "
              + "(FName, MName, Sname, DOB, Address, HPhone, BPhone, MPhone "
              + "ResidentStatus, Sex, Race, IncidentLocation, Zone, PremiseType "
              + "DateRecorded, TimeRecorded, Weapons, CrimeOffences) "
              + "VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
      try{
          //Declaring all variable that wiil be collected from JTextField
          pst = conn.prepareStatement(sql);
          //coverting JText to String
          String fname = FName.getText();
          String mname = MName.getText();
          String surname = Surname.getText();
          String dob = DOB.getText();
          String fullAddress = FullAddress.getText();
          String hPhone = HPhone.getText();
          String bPhone = BPhone.getText();
          String mPhone = MPhone.getText();
          String incidentLocation = IncidentLocation.getText();
          String incidentZone = IncidentZone.getText();
          String incidentPrType = IncidentPrType.getText();
          String incidentDate = IncidentDate.getText();
          String incidentTime = IncidentTime.getText();
          String incidentWeapons = IncidentWeapons.getText();
          String crimeOffences = CrimeOffences.getText();
          String radioText = "";
  
          //collecting input data and assign them to variables            
              pst.setString(1, fname);
              pst.setString(2, mname);
              pst.setString(3, surname);
              pst.setString(4, dob);
              pst.setString(5, fullAddress);
              pst.setString(6, hPhone);
              pst.setString(7, bPhone);
              pst.setString(8, mPhone);
              //radio buttons Resident Status
              if(RHome.isSelected())
              {
                  radioText = RHome.getText();
                  pst.setString(9, radioText);
              }
              else if(RForeign.isSelected())
              {
                  radioText = RForeign.getText();
                  pst.setString(9, radioText);
              }
              //radio buttons Sex
              if(Male.isSelected())
              {
                  radioText = Male.getText();
                  pst.setString(10, radioText);
  
              }
              else if(Female.isSelected())
              {
                  radioText = Female.getText();
                  pst.setString(10, radioText);
              }
              //radio button Race
              if(WhiteBritish.isSelected())
              {
                  radioText = WhiteBritish.getText();
                  pst.setString(11, radioText);
  
              }
              else if(WhiteOther.isSelected())
              {
                  radioText = WhiteOther.getText();
                  pst.setString(11, radioText);
              }
              else if(Black.isSelected())
              {
                  radioText = Black.getText();
                  pst.setString(11, radioText);
              }
              else if(Asian.isSelected())
              {
                  radioText = Asian.getText();
                  pst.setString(11, radioText);
              }
              else if(Indian.isSelected())
              {
                  radioText = Indian.getText();
                  pst.setString(11, radioText);
              }
              /////////////////////////////////////
              pst.setString(12, incidentLocation);
              pst.setString(13, incidentZone);
              pst.setString(14, incidentPrType);
              pst.setString(15, incidentDate);
              pst.setString(16, incidentTime);
              pst.setString(17, incidentWeapons);
              pst.setString(18, crimeOffences);
              pst.executeUpdate();
              System.out.println("records added sucessfully");
  
      }
      catch (SQLException a)
          {
              JOptionPane.showMessageDialog(null, a);
          }
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/G7qDC.jpg" alt="enter image description here"></p>