public BookingRegister getBookingSearch(int Phone, Connection con) 
  {
      BookingRegister br = null;

      
      String SQLString1 =       // get order
          "select *" +
          "from BOOKING"; 
 
      PreparedStatement statement=null;
      
      try
      {
          //=== get order
          
          statement = con.prepareStatement(SQLString1);
          
          statement.setInt(1, Phone);     // 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 OrderMapper - removeBooking");
          System.out.println(e.getMessage());
      }
      finally														// must close statement
      {
    	  try {
			statement.close();
		} catch (SQLException e) {
			System.out.println("Fail in OrderMapper - removeBooking");
			System.out.println(e.getMessage());
		}  
      }
      return br;                         
  }