<%@ include file="popup.html" %>
<%@ include file="coockie.jsp" %>

Advertisement

<%@ page import="java.sql.*" %> <% String id=request.getParameter("id"); int cid=Integer.parseInt(id); try{ Class.forName("oracle.jdbc.driver.OracleDriver"); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","classified","classified"); PreparedStatement ps=con.prepareStatement("select name,state,city,description,userid,to_char(dop,'dd/MONTH/yyyy') from classified where id=?"); ps.setInt(1,cid); ResultSet rs=ps.executeQuery();rs.next(); PreparedStatement ps1=con.prepareStatement("select name,email,contact from registered where id=?"); ps1.setInt(1,rs.getInt(5)); ResultSet rs1=ps1.executeQuery();rs1.next(); PreparedStatement ps2=con.prepareStatement("select statename from state where stateid=?"); ps2.setInt(1,rs.getInt(2)); ResultSet rs2=ps2.executeQuery();rs2.next(); %>

<%out.print(rs.getString(1));%>

<%out.print(rs.getString(6));%>
Date Posted
Contact Details :

Name : Mrs <%out.print(rs1.getString(1));%>
Contact person. :<%out.print(rs1.getInt(3));%>
Complete Information
State :<%out.print(rs2.getString(1));%>
City :<%out.print(rs.getInt(3));%>
Ad Description

<%out.print(rs.getString(4));%>


<% }catch(Exception e){e.printStackTrace();}%> <%@ include file="footer.html"%>
www.000webhost.com