citydetails.jsp

来自「gps 源码.GPS工作原理,对开发GPS软件有帮助」· JSP 代码 · 共 41 行

<%-- This is a JSP File to retrieve Names based on Category and 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 Name from TourDetails where City='"+cityname+"' and Category='"+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) +"#";
                	      }	
			out.println(str1);
			System.out.println(str1);
				rs.close();
				stmt.close();
				conn.close();			       
		    }catch(Exception e) {
		    
		    System.out.print(e); 
		    }
%>