<%@ page import="java.util.*" %> <%@page contentType="text/html"%> <%@page pageEncoding="UTF-8"%> <%@ include file="connectionDB.jsp" %> <%@ include file="header.jsp" %> <% ResultSet rs = null; Statement st = null; String sql = ""; String country_name = "", city_name = ""; try { %>

<% if(session.getAttribute("uid")!=null){ String twitterId = ""; st = con.createStatement(); sql = "select user_name from login where user_id = '"+Integer.parseInt(session.getAttribute("uid").toString())+"'"; rs = st.executeQuery(sql); if(rs.next()) twitterId = rs.getString("user_name"); %> "> <% } else { session.setAttribute("page","submit"); %> <% } %>

Home

Submit Your Hotel

Hotel Directory »

Select Country * : <% st = con.createStatement(); sql = "select countryname,countryid from country where rating != '0' order by rating"; rs = st.executeQuery(sql); out.println("-- Select Country --"); while(rs.next()){ out.println(""+rs.getString("countryname")+""); } st = con.createStatement(); sql = "SELECT distinct(a.countryname), a.countryid, a.SynId, b.Rating FROM v4 a LEFT JOIN country b ON a.countryname = b.countryname" + " where Rating = 0 OR Rating IS NULL GROUP BY a.countryname"; rs = st.executeQuery(sql); out.println("-----------------------------------"); while(rs.next()){ if(rs.getInt("SynId")==0) out.println(""+rs.getString("countryname")+""); else out.println(""+rs.getString("countryname")+""); } %> Select City * : -- Select City -- Hotel Name * : Address * : Description : Star Rating * : 5 Star 4 Star 3 Star Discount Budget Tariff * : onwards  (in USD) Logo : Site URL : eg: www.twihotels.com Contact Person * : Email Id * : Twitter Id * : Skype Id : Phone * : Fax : Image * : More Images I own/work at this hotel. ( Fields marked with * are mandatory! )

You are not logged in Click here to Login using Twitter

<% } catch(Exception ex){ System.out.println("Exception in submit "+ex.getMessage()); } finally { if(rs!=null) rs.close(); if(con!=null) con.close(); } %> <%@ include file="footer.jsp" %> \