<p><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html></p>
<p><head>
<TITLE>view particular applicants application details</TITLE>
<link rel="stylesheet" type="text/css" href="style.css" /></p>
<script type="text/javascript" src="valid.js">
</script>
<p></head></p>
<p><body></p>
<div id="page">
<div id="header">
<a href="#"><h1>PASSPORT SERVICE</h1></a>
<div class="description">REPUBLIC OF INDIA</div>
</div>
<div id="menulinks">
<a href="useracc.html">HOME</a>
<div class="menulines"></div>
<a href="modifypro.html">MODIFY PROFILE</a>
<div class="menulines"></div>
<a href="feedback.jsp">FEEDBACK</a>
<div class="menulines"></div>
<a href="cont.html">CONTACT</a>
<div class="menulines"></div>
<a href="help.html">HELP</a>
<div class="menulines"></div>
<a href="index.html">LOGOUT</a>
<div class="menulines"></div>
</div>
<div id="mainarea">
<div id="sidebar">
<div class="sidebarheader1">SERVICES</div><br>
<a href="fpptstep1.jsp">APPLY FOR FRESH/REISSUE OF PASSPORT</a><br><br>
<a href="">TAKE APPOINTMENT</a><br><br>
<a href="">VIEW PASSPORT STATUS</a><br><br><br>
<a href="locatepsk.html">LOCATE PASSPORT OFFICE</a><br><br>
<a href="">DOCUMENTS REQUIRED</a><br><br>
<a href="feecalcu.html">FEE CALCULATOR</a><br><br>
<a href="process.html">PASSPORT PROCESS</a><br><br>
</div>
<div id="contentarea">
<form name="viewpart" action="viewparticularappli.jsp">
<pre><font face="Georgia, Times New Roman, Times, serif">
<h2><b><u>VIEW PARTICULAR APPLICANTS APPLICATION DETAILS</u></b></h2>
<table cellspacing="15">
<tr><td><b>ENTER REFERENCE NUMBER :</b></td><td><input type="text" name="refno" /></td><td><input type="submit" name="b1" value="Go"></td></tr></table>
</font>
</pre>
<%@ include file="connect.jsp"%>
<%
String refno=request.getParameter("refno");
re=stmt.executeQuery("select * from passapp where refno='"+refno+"' ");
for(;re.next();)
{
String applyingfor=re.getString(1);
String appltype=re.getString(2);
String booklet=re.getString(3);
String name=re.getString(4);
String surname=re.getString(5);
String dob=re.getString(6);
String birthplace=re.getString(7);
String state=re.getString(8);
String district=re.getString(9);
String gender=re.getString(10);
String maritalstat=re.getString(11);
String citizenship=re.getString(12);
String pan=re.getString(13);
String voterid=re.getString(14);
String emptype=re.getString(15);
String education=re.getString(16);
String identitymk=re.getString(17);
String fathername=re.getString(18);
String fsurname=re.getString(19);
String mothername=re.getString(20);
String msurname=re.getString(21);
String guardname=re.getString(22);
String gsurname=re.getString(23);
String peaddress=re.getString(24);
String pedistrict=re.getString(25);
String pepolicestat=re.getString(26);
String pepin=re.getString(27);
String pephone=re.getString(28);
String praddress=re.getString(29);
String prdistrict=re.getString(30);
String prpolicestat=re.getString(31);
String prpin=re.getString(32);
String prphone=re.getString(33);
String enameadd=re.getString(34);
String ephone=re.getString(35);
String refnameadd1=re.getString(36);
String refphone1=re.getString(37);
String refnameadd2=re.getString(38);
String refphone2=re.getString(39);
String passportno=re.getString(40);
String passissuedate=re.getString(41);
String passexpdate=re.getString(42);
String passissueplace=re.getString(43);
String notissued=re.getString(44);
String crime=re.getString(45);
String crimeoff=re.getString(46);
String refused=re.getString(47);
String revoked=re.getString(48);
String politicalaslyum=re.getString(49);
String ec=re.getString(50);
String applace=re.getString(51);
String apdate=re.getString(52);
String username=re.getString(53);
String status=re.getString(55);
%>
<table border="1" cellspacing="5">
<tr><td>APPLYING FOR</td><td><%=applyingfor%></td></tr>
<tr><td>APPLICATION TYPE</td><td><%=appltype%></td></tr>
<tr><td>PASSPORT BOOKLET</td><td><%=booklet%></td></tr>
<tr><td>NAME</td><td><%=name%></td></tr>
<tr><td>SURNAME</td><td><%=surname%></td></tr>
<tr><td>DOB</td><td><%=dob%></td></tr>
<tr><td>BIRTHPLACE</td> <td><%=birthplace%></td></tr>
<tr><td>STATE</td><td><%=state%></td></tr>
<tr><td>DISTRICT</td><td><%=district%></td></tr>
<tr><td>GENDER</td><td><%=gender%></td></tr>
<tr><td>MARITAL STATUS</td><td><%=maritalstat%></td></tr>
<tr><td>CITIZENSHIPOF INDIA BY</td><td><%=citizenship%></td></tr>
<tr><td>PANCARD NO</td><td><%=pan%></td></tr>
<tr><td>VOTER ID</td><td><%=voterid%></td></tr>
<tr><td>EMPLOYMENT TYPE</td><td><%=emptype%></td></tr>
<tr><td>EDUCATION QUALIFICATION</td><td><%=education%></td></tr>
<tr><td>IDENTIFICATION MARK</td><td><%=identitymk%></td></tr>
<tr><td>FATHER'S NAME</td><td><%=fathername%></td></tr>
<tr><td>FATHER'S SURNAME</td><td><%=fsurname%></td></tr>
<tr><td>MOTHER'S NAME</td><td><%=mothername%></td></tr>
<tr><td>MOTHER'S SURNAME</td><td><%=msurname%></td></tr>
<tr><td>GAURDIAN'S NAME</td><td><%=guardname%></td></tr>
<tr><td>GAURDIAN'S SURNAME</td><td><%=gsurname%></td></tr>
<tr><td>PERMANENT_ADDRESS</td><td><%=peaddress%></td></tr>
<tr><td>PERMANENT ADDRESS DIST</td><td><%=pedistrict%></td></tr>
<tr><td>POLICE STATION</td><td><%=pepolicestat%></td></tr>
<tr><td>PIN CODE</td><td><%=pepin%></td></tr>
<tr><td>PRESENT PHNO</td><td><%=pephone%></td></tr>
<tr><td>PRESENT_ADDRESS</td><td><%=praddress%></td></tr>
<tr><td>PRESENT ADDRESS DIST</td><td><%=prdistrict%></td></tr>
<tr><td>POLICE STATION</td><td><%=prpolicestat%></td></tr>
<tr><td>PIN CODE</td><td><%=prpin%></td></tr>
<tr><td>PRESENT PHNO</td><td><%=prphone%></td></tr>
<tr><td>EMERGENCY_NAME_AND ADDRESS</td><td><%=enameadd%></td></tr>
<tr><td>EMERGENCY PHONE NO</td><td><%=ephone%></td></tr>
<tr><td>REF_PERSON1_NAME_AND ADD</td><td><%=refnameadd1%></td></tr>
<tr><td>REF PERSON1 PHNO</td><td><%=refphone1%></td></tr>
<tr><td>REF_PERSON2_NAME_AND ADD</td><td><%=refnameadd2%></td></tr>
<tr><td>REF PERSON2 PHNO</td><td><%=refphone2%></td></tr>
<tr><td>PREV PASSPORT NO</td><td><%=passportno%></td></tr>
<tr><td>PREV PASSPORT DATE OF ISSUE</td><td><%=passissuedate%></td></tr>
<tr><td>PREV PASSPORT EXPIRY DATE</td><td><%=passexpdate%></td></tr>
<tr><td>PREV PASSPORT PLACE OF ISSUE</td><td><%=passissueplace%></td></tr>
<tr><td>IS APPLICANT EVER APPLIED FOR PASSPORT BUT NOT ISSUED??</td><td><%=notissued%></td></tr>
<tr><td>IS APPLICANT EVER BEEN CHARGED WITH CRIMINAL PROCEEDINGS??</td><td><%=crime%></td></tr>
<tr><td>IS APPLICANT CONVICTED BY COURT IN INDIA FOR ANY CRIMINAL<br>OFFENCE AND SENTENCED TO IMPRISONMENT</td><td><%=crimeoff%></td></tr>
<tr><td>IS APPLICANT EVER BEEN REFUSED OR DENIED PASSPORT??</td><td><%=refused%></td></tr>
<tr><td>IS APPLICANTS PASSPORT EVER BEEN IMPOUNDED OR REVOCKED??</td><td><%=revoked%></td></tr>
<tr><td>IS APPLICANT EVER APPLIED FOR/BEEN GRANTED POLITICAL ASYLUM<br>BY FOREIGN COUNTRY</td><td><%=politicalaslyum%></td></tr>
<tr><td>IS APPLI EVER RETURNED TO INDIA ON EMERGENCY CERTIFICATE(EC)<br>OR WERE EVER DEPORTED OR REPATRIATED??</td><td><%=ec%></td></tr>
<tr><td>PLACE</td><td><%=applace%></td></tr>
<tr><td>DATE</td><td><%=apdate%></td></tr>
<tr><td>USERNAME</td><td><%=username%></td></tr>
<tr><td>STATUS</td><td><%=status%></td></tr>
<%}%>
</table>
</form>
<pre>
<FONT face="Georgia, Times New Roman, Times, serif" size="4"><B><u>SELECT STATUS</u></B></FONT>
<input type="radio" name="rad" value="Document's Being Verified"><FONT face="Georgia, Times New Roman, Times, serif">Document's Being Verified</FONT>
<input type="radio" name="rad" value="Under Progress"><FONT face="Georgia, Times New Roman, Times, serif">Under Progress</FONT>
<input type="radio" name="rad" value="Document's Being Verified"><FONT face="Georgia, Times New Roman, Times, serif">Document's Being Verified</FONT>
<input type="radio" name="rad" value="Under Police Verification"><FONT face="Georgia, Times New Roman, Times, serif">Under Police Verification</FONT>
<input type="radio" name="rad" value="Dispatched"><FONT face="Georgia, Times New Roman, Times, serif">Dispatched</FONT>
<input type="radio" name="rad" value="Rejected"><FONT face="Georgia, Times New Roman, Times, serif">Rejected</FONT>
<input type="submit" name="submit" value="update" class="cmdbutton" />
</font>
</pre>
</div>
<p></div></p>
<div id="footer">
<center> © Copyright and Design by: Chandan and Indrajeet </center>
</div>
<p></BODY></p>
<p></HTML></p>