Home
Answers
Viewqa
JSP-Servlet
i want to retriev and update in same form but its not working pls help....
QuestionAsk Questions?
indrajeet kamble
i want to retriev and update in same form but its not working pls help....
0 Answer(s) 2 years and 2 months ago
Posted in : JSP-Servlet
0 Answer(s) 2 years and 2 months ago
Posted in : JSP-Servlet
<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>
View Answers
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
