categories.jsp

gps 源码.GPS工作原理,对开发GPS软件有帮助

<!-- This is a JSP File to retrieve Categories of a particular City from the Database   -->

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

<%
   
		try{

			
		 	cityname=request.getQueryString();
			cityname = cityname.substring(cityname.indexOf("=")+1);
			cityname = cityname.replace('_',' ');
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		        conn = DriverManager.getConnection("jdbc:odbc:ETour");    
		        stmt = conn.createStatement();
		        rs = stmt.executeQuery("select Distinct(Category) from TourDetails where City='"+cityname+"'");
		        str1 = "";
		 	       while(rs.next())
		      	       {
				str1 += rs.getString(1) +"#";
			       }	
			out.println(str1);
			System.out.println(str1);
				rs.close();
				stmt.close();
				conn.close();			       
		  }catch(Exception e) { 
		  
		  System.out.print(e+"Error in Jsp"); 
		  }
%>