Adding new values to mysql database no longer possible?

Hi guys please consider the code below. I was using it to add new values to my table(booking) in mysql database(seat_booking).

Variables include String(id,cname,ctype,event_name) and int(seatsno).I also call a function EventName() in this code and, trust me guys it works perfectly and I am able to derive the event name from the another table(events) but the only problem arises in this method.

Guys my project is to make a seat booking GUI app so this code does work when I used it to add new events for the "Admin" mode but doesn't work here ,i.e., when I need it to store the booking values for a particular customer. Please help guys. I would really appreciate it.

private void newbookbtnActionPerformed(java.awt.event.ActionEvent evt) {                                           
    // TODO add your handling code here:
    try {
        Class.forName("java.sql.Driver");
        Connection con = DriverManager.getConnection("jdbc:mysql://localhost/seat_booking","root","<mypassword>");
        Statement stmt = con.createStatement();
        String query = "SELECT * FROM booking";
        ResultSet rs = stmt.executeQuery(query);
        String cname = tfcname.getText();
        int seatsno = Integer.parseInt(tfseatsno.getText());
        String evtname = EventName();
        String ctype = "Normal Customer"; long bookid = getID();
        String id = Long.toString(bookid); 
        String query1="insert into booking values('"+ id +"','"+ cname +"','"+ ctype +"','"+evtname+"',"+ seatsno+");";
        stmt.executeUpdate(query1);
        JOptionPane.showMessageDialog(null, "Booking successfull!");
        stmt.close();
        con.close();
    }
    catch (Exception e)
    {
        JOptionPane.showMessageDialog(null,"Error encountered while booking new event!");
    }
}