cities.jsp

来自「< 嵌入式系统编程源代码解析>>这本书所附的代码,有了几个典型」· 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); 
		}
%>