<%@ page language="java" import="java.util.*,java.sql.*,javax.servlet.http.*" %> <%@ include file="application.jsp"%> <%@ include file="header.jsp"%> <% String search=""; String state=""; String sector=""; if (request.getParameter("search") != null){ search=request.getParameter("search"); } if(request.getParameter("state") != null){ state=request.getParameter("state"); } if(request.getParameter("sector") != null){ sector=request.getParameter("sector"); } %> <% Connection conn = dbConnection.getConnection(); Statement state1 = conn.createStatement(); java.util.Date date = new java.util.Date(); %> <% boolean norecord=true; String ss ="(TO_DAYS(NOW())-TO_DAYS(createDate))"; String topQuery = "select * from project where recNo > 0"; if (request.getParameter("search") == null){ topQuery=topQuery + " order by createDate desc"; } if (request.getParameter("search") != null){ if((request.getParameter("state") != null) && (!request.getParameter("state").equals("--Select--")) && (request.getParameter("state") != "--Select--")){ topQuery= topQuery + " and state='"+ state +"'"; } if((request.getParameter("sector") != null) && (!request.getParameter("sector").equals("--Select--")) && (request.getParameter("sector") != "--Select--")){ topQuery= topQuery + " and sector='"+ sector +"'"; } topQuery=topQuery + " order by createDate desc"; } ResultSet rst =state1.executeQuery(topQuery); /****Code to print the pagination*****/ navi.setchunk(15); navi.setRS(rst); int i=0; if(request.getParameter("off")==null){ i=1;}else{ i=Integer.parseInt(request.getParameter("off")); } navi.setcursor(i); ResultSet rs1=navi.getRS(); int h1=1; if(request.getParameter("off")!=null) h1=Integer.parseInt(request.getParameter("off")); int h2= navi.getchunk(); int h3= navi.getcount(); int offset=(h3-h1)

<%if(c3>c2 && c3<=c1){ out.print(""); }%>

<%if(c1>c2 && (c1-c3)>=c2){ out.print(""); }%>

<%} int topStory=0; boolean topStr=true;%> <%if(c1!=0){%> <%//while(rst.next()){ for(int l=0;l <%norecord=true; navi.setcursor(); }%> <%} else{%> <%}%>

Project Name & Location	State	Sector	Status	PCN Link
<%=rst.getString("project")%>	<%=rst.getString("state")%>	<%=rst.getString("sector")%>	Approved	">View
<%if(c3>c2 && c3<=c1){ out.print(""); }%>				<%if(c1>c2 && (c1-c3)>=c2){ out.print(""); }%>
No Record Found !!

<%rst.close(); state1.close(); %> <%@ include file="footer.jsp"%>