title: Java SQL Incorrect Integer Value
body: <p>Here is my error: SQL Exception: java.sql.SQLException: Incorrect integer value: 'age' for column 'age' at row 1</p>
  
  <p>The field that is giving me the problem is the first Int field in the table.</p>
  
  <p>Here is the code I am using:</p>
  
  <p>The data:</p>
  
  <pre><code>   String username = "test1";
      String id="test1";
      String firstName="Testname";
      String lastName="Testnamer";
      String address="Testadd";
      String phone="Test0851459574";
      String email="Testemailee";
      int age = 24;
      char sex='M';
      double height=1.23;
      int kgs=125;
      double stone=5.75;
      int targetWeightKgs=34;
      double bmi=4.34;
      String medicalHistory="testertester";
      String extraHistory="testertestertest";
      boolean smoker=true;
      boolean usernameCompleted=true;
      String myNotes="testnotes";
           UsersDatabase.insertMember(username,id,firstName,lastName,address,phone,email,age,sex,height,kgs,stone,targetWeightKgs,bmi,medicalHistory,extraHistory,smoker,usernameCompleted,myNotes);
  </code></pre>
  
  <p>in the insertMember method:</p>
  
  <pre><code> String sql = "INSERT INTO Members " + "VALUES      ('username','id','firstName','lastName','address','phone','email','age','sex','height','kgs','stone','targetWeightKgs','bmi','medicalHistory','extraHistory','smoker','usernameCompleted','myNotes')";
          stmt.executeUpdate(sql);
  </code></pre>
  
  <p>Here is the table screenshot: <a href="http://snag.gy/VuMpO.jpg" rel="nofollow">http://snag.gy/VuMpO.jpg</a></p>