<%-- This is a JSP File to retrieve Infromation of Particular Category of a particular City from the Database  --%> 


<%@ page import="java.sql.*,java.util.*" %>
<%! Connection conn; %>
<%! Statement stmt; %>
<%! ResultSet rs; %>
<%! String str1,category,city,cityname;
    String param; %>

<%
   
		try{

			
			city = request.getQueryString();
			city = city.replace('_',' ');
			cityname = city.substring(city.indexOf("=")+1,city.indexOf("&"));
			category=city.substring(city.lastIndexOf("=")+1);
			param="select Description,Timings,EntryFee,RecomDuration,PublicMobility,PrivateMobility,City from TourDetails where City='"+cityname+"' and Name='"+category+"'";
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		        conn = DriverManager.getConnection("jdbc:odbc:ETour");    
		       	stmt = conn.createStatement();
		        System.out.println(param);
		        rs = stmt.executeQuery(param);
		       	str1 = "";
		       		while(rs.next())
		       		{
				str1 = rs.getString(1) +"#";
				str1 += rs.getString(2) +"#";
				str1 += rs.getString(3) +"#";
				str1 += rs.getString(4) +"#";
				str1 += rs.getString(5) +"#";
				str1 += rs.getString(6) +"#";
				str1 += rs.getString(7) +"#";
				}	
			out.println(str1);
			System.out.println(str1);
				rs.close();
				stmt.close();
				conn.close();			       
			}catch(Exception e) {
			
			System.out.print(e); 
			}
%>