<%@ page language="java" %> <%@ page import="java.util.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page import="tripindya.constants.*" %> <%@ page import="tripindya.util.*" %> <% Connection con=null; Statement stmt=null; PreparedStatement pstmt=null; ResultSet rs1=null; //////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////// //////////////////////////////////////////////////////////////// %> A Trip To India Cities, India Hotels, Hotel In Delhi, Hotel In India, Delhi Hotels, Goa Hotels, Kerala Hotels, Royal Hotels, Booking Online Hotels.
cheap airfare agents india
Hotels In India, Travel Agent In India, Hotel Reservation In India, Hotel Booking In India, Tour Packages of India, Vacation In India.
Honeymoon destinations agent
Agra Travel Agent, Delhi Travel Agent, Goa Travel Agent, Jaipur Travel Agent, Kerala Travel Agent, Nanital Travel Agent, Mumbai Travel Agent, Ladakh Travel Agent, Srinagar Travel Agent
A Trip To Indya Packages
Rajasthan Tour
Kerala Tour
Golden Triangle
Adventure Tour
Ayurveda & Spa
Spiritual Tour

Incentive &


Beach Tour
India Train Tour
Wildlife Tour
Culture Tour
Goa Tour
Leh Ladakh Tour
Eastern Himalayas
Book a Tour
Hotel Booking
Contact Us
Email Us
Yoga Holiday Travel Packages vacation packages agent guide cheap Flight tickets agency
honeymoon vacation packages india
air india travel tickets agents Ayurveda day trips tour packages romantic holidays getaways destinations breaks



North India : South India :
Delhi Pondicherry
Haryana Andhra Pradesh
Jammu and Kashmir Tamil Nadu
Punjab Karnataka
Uttar Pradesh Kerala
Himachal Pradesh
Madhya Pradesh
West India : East India :
Maharashtra Bihar
Goa Orissa
Gujarat Jharkand
Rajasthan Chattisgarh
West Bengal
North-East India : Indian Union Territories :
Arunachal Pradesh Andaman and Nicobar Islands
Assam Chandigarh
Meghalaya Dadra and Nagar Haveli
Nagaland Daman and Diu
Tripura Lakshadweep


<%@ include file="../jsp/clientSearch.jsp" %>
<% int city_id=0; String city_name=null; //String city=null; try { con = DBConnection.getConnect(); //String SqlHotelSearch = "select city.city_name from city,hotel_information where city.city_name=hotel_information.city_name order by city.city_name"; //String SqlHotelSearch = "select city.city_name,city.city_id from city where exists (select hotel_information.city_name,hotel_information.hotel_id from hotel_information where city.city_name=hotel_information.city_name) order by city.city_name"; String SqlHotelSearch = "SELECT DISTINCT hotel_id, city_name FROM hotel_information GROUP BY city_name ORDER BY city_name LIMIT 0,20"; pstmt = con.prepareStatement(SqlHotelSearch); //pstmt.setString(2,city); rs1 = pstmt.executeQuery(); if(!rs1.next()) { out.println("

"); out.println("
"); out.println(""); out.println("

No Hotel found for this search criteria.

"); } else { do { city_name = rs1.getString("city_name"); //city_id = rs1.getInt("city_id"); %> <%=city_name%> | <% // } // end of if valid_type 1,2,3 }while(rs1.next()); // end of while } // end odf else } catch(Exception e) { out.println("Exception Occurred......."); out.println(e.getMessage()); } finally { DBConnection.closeResources(con,rs1,pstmt,null); } %>
Online International
Flights Booking
Incentive & Conferences

India is a great location for a corporate meeting, incentive trip, venue to hold a business conference ..
and More


About Us | Currency Converter | Send Enquiry | India Major Cities | Contact Us | Query | Sitemap | Email

India Hotel Booking, Delhi Hotel Booking, Agra Hotel Booking, Jaipur Hotel Booking, Kerala Hotel Booking, Goa Hotel Booking, Five Star Hotel Directory,  Mumbai Hotels, Mumbai Five Star Hotels
Copyright@ Frank Hospitalities all right reserved. Website Designed & Maintained by Mind Source
  Conference Management, Conference Organizing, Event Management, Parties Organizing, All india tours and travels, Accomodation In India, Conference In India