Unable to get data from GUI to the database

Hi Folks, hoping you can help me as I am very confused at the moment as I have read a number of different articles and tried quite a few diiferent methods, but have not got anywhere!

I'm building a simple GUI that sits on a MySQL database to track my wedding guest list...i.e whether they've replied, dietary requirements, whether they are coming all day or to just the evening etc...
Anyway, I've built the majority of the GUI and the database, and got them connected. What I can't do however, is get records inserted into the table (and presumably update and delete records too as I haven't tried doing them yet!) . This is not because of a lack of SQL knowledge, I just don't know how to get the data from the GUI to the database. I've tried a number of different ways (as can be seen in the code)but I don't seems to be getting any nearer.

Below is my code and then the errors I've been getting.

Thanks in advance.

package guestList;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import net.miginfocom.swing.*;
import java.sql.*;

class gList
{
  // Define the GUI components-------------------------------------------------
  
  //Create variables, getters and setters--------------------------------
  private String name;
  public String getName()
  {
    return name;
  }
  public String setName(String inputName)
  {
    name = inputName;
  }

private String address;
  public String getAddress()
  {
    return address;
  }
  public String setAddress(String inputAddress)
  {
    address = inputAddress;
  }

private int number;
  public Integer getNumber()
  {
    return number;
  }
  public Integer setNumber(int inputNumber)
  {
    number = inputNumber;
  }  
  
  private int guestNo;
  public integer getGuestNo()
  {
    return guestNo;
  }
  public Integer setGuest(int inputGuestNo)
  {
    guestNo = inputGuestNo;
  }  
  
  private String kids;
  public String getKids()
  {
    return kids;
  }
  public String setKids(String inputKids)
  {
    kids = inputKids;
  }  
  
  private int kidsNo;
  public Integer getKidsNo()
  {
    return kidsNo;
  }
  public Integer setKidsNo(int inputKidsNo)
  {
    kidsNo = inputKidsNo;
  }
  
  private String replied;
  public String getReply()
  {
    return replied;
  }
  public String setReply(String inputReply)
  {
    replied = inputReply;
  }  
  
  private String attend;
  public String getAttend()
  {
    return attend;
  }
  public String setAttend(String inputAttend)
  {
    attend = inputAttend;
  }  
  
  private String invite;
  public String getInvite()
  {
    return invite;
  }
  public String setInvite(String inputInvite)
  {
    invite = inputInvite;
  }
    
  private String dietRes;
  public String getDiet()
  {
    return dietRes;
  }
  public String setDiet(String inputDiet)
  {
    dietRes = inputDiet;
  }
    
  private String dietInfo;
  public String getDietInfo()
  {
    return dietInfo;
  }
  public String setDietInfo(String inputDietInfo)
  {
    dietInfo = inputDietInfo;
  }  
  
  public static void main(String[] args) throws Exception
  {
    gList g = new gList();
    g.buildingGUI();
    g.dbConnect();
  }
  public void dbConnect()
  {
    try
    {
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      Connection con = DriverManager.getConnection("jdbc:mysql://localhost/guests?"+"user=root&password=xxxxxxxxxx");
      con.setAutoCommit(false);
      if(!con.isClosed())
      {
        lblInfo.setText("Database Connected...");
      }
    }
    catch(Exception e)
    {
      System.err.println("Exception: "+ e.getMessage());
      e.printStackTrace();
    }
  }
  void buildingGUI()
  {
      //GUI build
  }
  public class kidBoxListener implements ItemListener
  {
    public void itemStateChanged(ItemEvent ev)
    {
      String kids = "N";
      if(kidBox.isSelected())
      {
        lblKidNo.setVisible(true);
        kidNoCombo.setVisible(true);
        kids = "Y";
      }
      else
      {
        lblKidNo.setVisible(false);
        kidNoCombo.setVisible(false);
        kidNoCombo.setSelectedIndex(-1);
        kids = "N";
      }
    } //Close itemStateChanged
  } // Close kidNoListener
  public class replyBoxListener implements ItemListener
  {
    public void itemStateChanged(ItemEvent ev)
    {
      String replyRes = "N";
      if(replyBox.isSelected())
      {
        lblAttend.setVisible(true);
        attendCombo.setVisible(true);
        replyRes = "Y";
      }
      else
      {
        lblAttend.setVisible(false);
        attendCombo.setVisible(false);
        attendCombo.setSelectedIndex(-1);
        replyRes = "N";
      }
    } //Close itemStateChanged
  } // Close replyBoxListener
  public class inviteComboListener implements ItemListener
  {
    public void itemStateChanged(ItemEvent ev)
    {
      if(ev.getSource() instanceof JComboBox)
      {
        String inviteSelect = (String) ev.getItem();
        if (inviteSelect.equals("All Day"))
        {
          lblDiet.setVisible(true);
          dietBox.setVisible(true);
        }
        else
        {
          lblDiet.setVisible(false);
          dietBox.setVisible(false);
          dietBox.setSelected(false);
        }
      }// Close if
    }// Close ItemStateChanged  
  } // Close listener
  public class dietBoxListener implements ItemListener
  {
    String diet = "N";
    public void itemStateChanged(ItemEvent ev)
    {
      if(dietBox.isSelected())
      {
        lblDietReq.setVisible(true);
        tfDiet.setVisible(true);
        diet = "Y";
      }
      else
      {
        lblDietReq.setVisible(false);
        tfDiet.setVisible(false);
        tfDiet.setText("");
        diet = "N";
      }
    } //Close itemStateChanged
  } // Close dietBoxListener
  public class btnSaveListener implements ActionListener
  {
    public void actionPerformed(ActionEvent event)// insertData()
    {
      String inputName = tfName.getText();
      this.getName(inputName);
      String inputAddress = taAddress.getText();
      this.getAddress(inputAddress);
      String num = tfNumber.getText();
      int number = Integer.parseInt( num );
      String guest = (String)guestNoCombo.getSelectedItem();
      int guestNo = Integer.parseInt( guest );
      String kid = kids;
      String kids = (String)kidNoCombo.getSelectedItem();
      int kidsNo = Integer.parseInt( kids );
      String replied = replyRes;
      String attend = (String)attendCombo.getSelectedItem();
      String invite = inviteSelect;
      String dietRes = diet;
      String dietInfo = tfDiet.getText();
      
      try
      {
        //stmt = con.createStatement();
        resultSet = Statement.executeQuery("INSERT INTO guestList VALUES(name, address, number, guestNo, kid, kidsNo, replied, attend, invite, dietRes, dietInfo)");
        //String insert("INSERT INTO guestList VALUES("+ name +", " + address +", "+ number +", "+ guestNo +", "+ kid +", "+ kidsNo +", " + replied +", " + attend +", " + invite +", " + dietRes +", " + dietInfo +");";
        //stmt.executeUpdate(insert);
      }
      catch (SQLException e)
     {
        lblInfo.setText(e);
      }
    }
  } // Close btnSaveListener
} // Close gList

Now the errors:

Please do not cross-post the same question in multiple forums. It wastes people's time when multiple redundant conversations take place. Please read this for more information.