public BookingRegister getCreateNewBooking(int ph, Connection con) {
        BookingRegister br = null;
        String SQLString1 = // get booking
                "select * "
                + "from BOOKING ";
        PreparedStatement statement = null;

        try {
            //get booking

            statement = con.prepareStatement(SQLString1);

            statement.setInt(1, ph);     // primary key value
            ResultSet rs = statement.executeQuery();
            if (rs.next()) {                            
                br = new BookingRegister(
                    
                        rs.getString(1),
                        rs.getString(2),
                        rs.getString(3),
                        rs.getString(4),
                        rs.getString(5),
                        rs.getInt(6),
                        rs.getInt(7),
                        rs.getInt(8),
                        rs.getString(9),
                        rs.getString(10),
                        rs.getInt(11),
                        rs.getInt(12),
                        rs.getInt(13));
            }            
            

        } catch (Exception e) {
            System.out.println("Fail in bookingMapper - CreateNewBooking");
            System.out.println(e.getMessage());
        } finally // must close statement
        {
            try {
                statement.close();
            } catch (SQLException e) {
                System.out.println("Fail in bookingMapper - CreateNewBooking");
                System.out.println(e.getMessage());
            }
        }
        return br;
    }