<% if(session.getAttribute("EmailId")!=null){ %> <%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> Allproject.in - A Place for Innovative Technical Projects

Requested Project


<% if(session.getAttribute("EmailId").equals("Admin")) { db.connect(); try { ResultSet rs=db.execSQL("select * from userdetails,userprojects where userdetails.UserId=userprojects.UserId"); while(rs.next()){ String FileName=rs.getString("Image"); File savedFile = new File(config.getServletContext().getContextPath() +"/Uploaded/"+FileName ); %>
" value="<%=rs.getString("ProjectId") %>" name="ProjectId" src="<%=savedFile %>" width="200" height="150"/>

<%=rs.getString("ProjectName") %>

Price : Rs.<%=rs.getString("Price") %>

<%} } catch(Exception e){ out.println(""+e); }%> <%} else{ %>
<% String EmailId=session.getAttribute("EmailId").toString(); db.connect(); try{ ResultSet i=db.execSQL("select * from userdetails where EmailId='"+EmailId+"'"); if(i.next()){ String UserId=i.getString("UserId"); ResultSet rs=db.execSQL("select * from userprojects where UserId='"+UserId+"'"); while(rs.next()){ String FileName=rs.getString("Image"); File savedFile = new File(config.getServletContext().getContextPath() +"/Uploaded/"+FileName ); %>
" value="<%=rs.getString("ProjectId") %>" name="ProjectId" src="<%=savedFile %>" width="200" height="150"/>

<%=rs.getString("ProjectName") %>

Price : Rs.<%=rs.getString("Price") %>

<%} } else{ out.println("You Have no requested Project"); } } catch(Exception e){ out.println(""+e); } } %>

<%} else{ response.sendRedirect("Login.html"); } %>