<%@ include file="coockie.jsp" %>
<%@ include file="view.jsp" %>
<%@ page import="java.sql.*" %>

<% String state=request.getParameter("state"); String city=request.getParameter("city"); int stateid=Integer.parseInt(state); int cityid=Integer.parseInt(city); try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","classified","classified"); PreparedStatement ps=con.prepareStatement("select id,type,name,description from classified where state=? and city=?"); ps.setInt(1,stateid); ps.setInt(2,cityid); ResultSet rs=ps.executeQuery(); while(rs.next()){ %> <%} %>
<% }catch(Exception e){e.printStackTrace();}%>




<%@ include file="footer.html"%>
www.000webhost.com