cities.jsp

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

<%-- This is a JSP File to retrieve Cities from the Database   --%>

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

<%
   
		try{

				
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                conn = DriverManager.getConnection("jdbc:odbc:ETour");    
                stmt = conn.createStatement();
                rs = stmt.executeQuery("select Distinct(City) from TourDetails ");
   	        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); 
		}
%>