public boolean createNewBooking(Gaest g)
    {
        int rowsInserted = 0;
        String SQLStringGæst = "insert into GAEST_TBL "
                + " values (?,?,?,?,?,?,?,?,?,?,?)";
//        String oldgid = "select GAEST_ID from GAEST_TBL";
//        String nygid = oldgid.substring(1);
//        int nynr = Integer.parseInt(nygid);
//        nygid = "G"+(nynr+1);
//        String SQLStringLejlighed = "insert into LEJLIGHED_TBL "
//                + " values (?,?,?)";
        PreparedStatement statement = null;
        try
        {
            String selectgid = "select MAX(GAEST_ID) from GAEST_TBL";
            
            statement = con.prepareStatement(selectgid);
            ResultSet rs = statement.executeQuery();
            String oldgid = null;
            if (rs.next()){
                oldgid = rs.getString(1);
                System.out.println(oldgid);
            }
            // Husk fejl besked hvis gæstID ikke fundet.
            try {
            String nygid = oldgid.substring(1);
            System.out.println(nygid); // Print
            int nynr = Integer.parseInt(nygid);
            System.out.println(nynr); // Print
            String nyrgid = "G" + (nynr + 1);
            System.out.println(nyrgid); // Print
            
            statement = con.prepareStatement(SQLStringGæst);
            statement.setString(1, nyrgid);
            statement.setString(2, g.getFornavn());
            statement.setString(3, g.getEfternavn());
            statement.setInt(4, g.getTelefonnummer());
            statement.setString(5, g.getEmail());
            statement.setString(6, g.getVejnavn());
            statement.setInt(7, g.getVejnummer());
            statement.setInt(8, g.getPostnummer());
            statement.setString(9, g.getBynavn());
            statement.setString(10, g.getLand());
            statement.setString(11, g.getRejsebureau());
            rowsInserted = statement.executeUpdate();
            }
            catch (SQLException e)
            {
                System.out.println("Fejler i mapper - Create New Booking før close");
            }
//            statement = con.prepareStatement(SQLStringLejlighed);
//            statement.set

        } catch (SQLException e)
        {
            System.out.println("Fejler i mapper - Create New Booking før close");
            System.out.println(e.getMessage());
        } finally
        {
            try
            {
                statement.close();
            } catch (SQLException e)
            {
                System.out.println("Fejler i mapper - Create New booking");
            }
        }
        return rowsInserted == 1;
    }