title: JavaFX Textfield to MySQL INSERT: SQL Syntax Error
body: <p>I have a MySQL Table which looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/d5L2V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/d5L2V.png" alt="MYSQL Table"></a></p>
  
  <p>I made some Textfields in my form and saved the input as Strings:</p>
  
  <pre><code>    String name = shopname.getText();
      String address = streetaddress.getText();
      String city = cityname.getText();
      String state = statename.getText();
      String country = countryname.getText();
      String zip = zipcode.getText();
      String phonept1 = phonecountryid.getText();
      String phonept2 = phoneareaid.getText();
      String phonept3 = phoneothernumber.getText();
      String phonefull = phonept2 + " " + "(" + phonept1 + ")" + " " + phonept3;
  </code></pre>
  
  <p>Then I just made an INSERT method which worked well with the old SQLite Database:</p>
  
  <pre><code>            conn = DBConnect.Connector();
              stmt = conn.createStatement();
              stmt.executeUpdate("INSERT INTO shopList (name,address,city,state,country,zipcode,phonefull) VALUES(" +name+ "," + address + "," + city + "," + state + "," + country + "," + zip + "," + phonefull + ")");
              conn.close();
  </code></pre>
  
  <p>But now it says:</p>
  
  <p>SEVERE: null
  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 '(22) 222222)' at line 1</p>
  
  <p>Anyone see the syntax error?</p>
  
  <p>ps. (22) 222222 is the tested phonefull input.</p>