<%@ page import="sun.net.smtp.SmtpClient, java.io.*" %> <%@ page import="java.util.*, javax.mail.*, javax.mail.internet.*, javax.activation.*" %> <%@ page import="java.sql.*" %> <%@ page import="java.util.Iterator" %> <%@ page import="java.io.File" %> <%@ page import="org.apache.commons.fileupload.servlet.ServletFileUpload"%> <%@ page import="org.apache.commons.fileupload.disk.DiskFileItemFactory"%> <%@ page import="org.apache.commons.fileupload.*"%> <%@ page import="javax.servlet.http.*" %> <%@ page import="org.apache.commons.fileupload.*" %> <%@ page import="org.apache.commons.fileupload.disk.*" %> <%@ page import="org.apache.commons.fileupload.servlet.*" %> <%@ page import="org.apache.commons.io.output.*" %> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <%@ page import="java.io.File" %> <%@ page import="java.io.FileInputStream" %> <%@ page import="java.io.FileOutputStream" %> <%@ page import="java.io.IOException" %> <%@ page import="java.io.InputStream" %> <%@ page import="java.io.OutputStream" %> <% //if (session.getValue("sUserIDflag")==null) //{ // response.sendRedirect("http://www.iucaa.in:8080/iucaa/jsp/PER_JOB_APP/per_job_app_S&TO-C-RES-MAR2014.jsp"); // return; //} %> Registration Form
<%! String fileBasePath = "/webdsk/installations/softwares/apache-tomcat-7.0.69/webapps/iucaa/jsp/PER_JOB_APP/gw/uploads/"; String filePath = ""; String ss_APP_NO = ""; String ss_APP_DT = ""; String s_APP_NO = ""; String s_APP_DT = ""; String s_ADV_NO = ""; String s_NM_POST = ""; String s_FULLNM = ""; String s_SEX = ""; String s_NATION = ""; String s_BD_D= ""; String s_BD_M= ""; String s_BD_Y= ""; String s_RES_CAT = ""; String s_C_ADD= ""; String s_C_CITY = ""; String s_C_PIN= ""; String s_C_STATE = ""; String s_C_COUNTRY =""; String s_C_PHONE=""; String s_SAME_CORR_ADD=""; String s_P_ADD=""; String s_P_CITY =""; String s_P_PIN=""; String s_P_STATE=""; String s_P_COUNTRY=""; String s_P_PHONE =""; String s_EMAIL=""; String s_REF1NAME =""; String s_REF1ADD=""; String s_REF1PH =""; String s_REF1EMAIL=""; String s_REF2NAME=""; String s_REF2ADD=""; String s_REF2PH =""; String s_REF2EMAIL=""; String s_EVA_MARK=""; String s_REMARK =""; String bdsf =""; //###################### String s_Q1SR= ""; String s_Q1NM=""; String s_Q1YR=""; String s_Q1NIB=""; String s_Q1MSUB=""; String s_Q1PERC=""; String s_Q1GR=""; String s_Q2SR=""; String s_Q2NM=""; String s_Q2YR=""; String s_Q2NIB=""; String s_Q2MSUB=""; String s_Q2PERC=""; String s_Q2GR=""; String s_Q3SR=""; String s_Q3NM=""; String s_Q3YR=""; String s_Q3NIB=""; String s_Q3MSUB=""; String s_Q3PERC=""; String s_Q3GR=""; String s_Q4SR=""; String s_Q4NM=""; String s_Q4YR=""; String s_Q4NIB=""; String s_Q4MSUB=""; String s_Q4PERC=""; String s_Q4GR=""; String s_Q5SR=""; String s_Q5NM=""; String s_Q5YR=""; String s_Q5NIB=""; String s_Q5MSUB=""; String s_Q5PERC=""; String s_Q5GR=""; String s_Q6SR=""; String s_Q6NM=""; String s_Q6YR=""; String s_Q6NIB=""; String s_Q6MSUB=""; String s_Q6PERC=""; String s_Q6GR=""; //###################### String s_E1SR =""; String s_E1NORG =""; String s_E1FR =""; String s_E1TO =""; String s_E1POST =""; String s_E1PAY =""; String s_E1PT =""; String s_E1REAFL=""; String s_E1ROLE =""; String s_E2SR =""; String s_E2NORG =""; String s_E2FR =""; String s_E2TO =""; String s_E2POST =""; String s_E2PAY =""; String s_E2PT =""; String s_E2REAFL=""; String s_E2ROLE =""; String s_E3SR =""; String s_E3NORG =""; String s_E3FR =""; String s_E3TO =""; String s_E3POST =""; String s_E3PAY =""; String s_E3PT =""; String s_E3REAFL=""; String s_E3ROLE =""; String s_E4SR =""; String s_E4NORG =""; String s_E4FR =""; String s_E4TO =""; String s_E4POST =""; String s_E4PAY =""; String s_E4PT =""; String s_E4REAFL=""; String s_E4ROLE =""; String s_E5SR =""; String s_E5NORG =""; String s_E5FR =""; String s_E5TO =""; String s_E5POST =""; String s_E5PAY =""; String s_E5PT =""; String s_E5REAFL=""; String s_E5ROLE =""; String s_E6SR =""; String s_E6NORG =""; String s_E6FR =""; String s_E6TO =""; String s_E6POST =""; String s_E6PAY =""; String s_E6PT =""; String s_E6REAFL=""; String s_E6ROLE =""; String uploadedFile =""; //##Change## String s_LANGUAGES_FLUENT_AT =""; String s_COMPUTER_SKILLS =""; String s_PREVIOUS_EXPERIENCE_DETAILS =""; String s_I_AGREE =""; String s_ANY_RELATIVE_INFO = ""; Statement stmtvalidator=null; // added,cnt148,cnt149,cnt150=0,cnt151=0; //##Change## int cntvalidator =0; int appflag =0; int cnt1=0,cnt2=0,cnt3=0,cnt4=0,cnt5=0,cnt6=0,cnt7=0,cnt8=0,cnt9=0,cnt10=0,cnt11=0,cnt12=0,cnt13=0,cnt14=0,cnt15=0,cnt16=0,cnt17=0,cnt18=0,cnt19=0,cnt20=0,cnt21=0,cnt22=0,cnt23=0,cnt24=0,cnt25=0, cnt26=0,cnt27=0,cnt28=0,nt29=0,cnt30=0,cnt31=0,cnt32=0,cnt33=0,cnt34=0,cnt35=0,cnt36=0,cnt37=0,cnt38=0,cnt39=0,cnt40=0,cnt41=0,cnt42=0,cnt43=0,cnt44=0,cnt45=0,cnt46=0,cnt47=0,cnt48=0,cnt49=0,cnt50=0,cnt51=0,cnt52=0,cnt53=0,cnt54=0,cnt55=0,cnt56=0,cnt57=0,cnt58=0,cnt59=0,cnt60=0,cnt61=0,cnt62=0,cnt63=0,cnt64=0,cnt65=0,cnt66=0,cnt67=0,cnt68=0,cnt69=0,cnt70=0,cnt71=0,cnt72=0,cnt73=0,cnt74=0,cnt75=0,cnt76=0,cnt77=0,cnt78=0,cnt79=0,cnt80=0,cnt81=0,cnt82=0,cnt83=0,cnt84=0,cnt85=0,cnt86=0,cnt87=0,cnt88=0,cnt89=0,cnt90=0,cnt91=0,cnt92=0,cnt93=0,cnt94=0,cnt95=0,cnt96=0,cnt97=0,cnt98=0,cnt99=0,cnt100=0,cnt101=0,cnt102=0,cnt103=0,cnt104=0,cnt105=0,cnt106=0,cnt107=0,cnt108=0,cnt109=0,cnt110=0,cnt111=0,cnt112=0,cnt113=0,cnt114=0,cnt115=0,cnt116=0,cnt117=0,cnt118=0,cnt119=0,cnt120=0,cnt121=0,cnt122=0,cnt123=0,cnt124=0,cnt125=0,cnt126=0,cnt127=0,cnt128=0,cnt129=0,cnt130=0,cnt131=0,cnt132=0,cnt133=0,cnt134=0,cnt135=0,cnt136=0,cnt137=0,cnt138=0,cnt139=0,cnt140=0,cnt141=0,cnt142=0,cnt143=0,cnt144=0,cnt145=0,cnt146=0,cnt147=0,cnt148,cnt149,cnt150=0,cnt151=0; Connection con1=null; Statement stmtmax1=null; String fileName; String img_path; %> <% boolean isMultipart = ServletFileUpload.isMultipartContent(request); DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); Connection con=DBConn.getConnection(); Statement stmtmax = DBConn.getConnection().createStatement(); ResultSet rset = stmtmax.executeQuery ("SELECT PER_JOB_APP_MST_APP_NO.Nextval, to_char(SYSDATE,'DD-MON-RRRR') from dual"); while (rset.next()) { //s_APP_NO =Integer.parseInt(rset.getString(1)); s_APP_NO =rset.getString(1); s_APP_DT =rset.getString(2); //out.println(s_DOB); }//while (rset.next()) if (!isMultipart) { appflag =0; response.sendRedirect("http://www.iucaa.in/Opportunities.html"); } else {appflag =1; FileItemFactory factory = new DiskFileItemFactory(); ServletFileUpload upload = new ServletFileUpload(factory); List items = null; try { items = upload.parseRequest(request); } catch (FileUploadException e) { e.printStackTrace(); } Iterator itr = items.iterator(); //out.println(" :=======: " + items.size() + "
"); while (itr.hasNext()) { FileItem item = (FileItem) itr.next(); //out.println(item.getFieldName() + " :: ITEM.isFormField():: " + item.isFormField() + "
"); if (item.isFormField()) { String name = item.getFieldName(); String value = item.getString(); //if(name.equals("APP_NO")){ s_APP_NO =value; cnt1=1; } //if(name.equals("APP_DT")){ s_APP_DT =value; cnt2=2; } if(name.equals("ADV_NO")){ s_ADV_NO =value; cnt3=3; } if(name.equals("NM_POST")){ s_NM_POST =value; cnt4=4; } if(name.equals("FULLNM")){ s_FULLNM =value.toUpperCase(); cnt5=5; } if(name.equals("SEX")){ s_SEX =value; cnt6=6; } if(name.equals("NATION")){ s_NATION =value.toUpperCase(); cnt7=7; } if(name.equals("BD_D")){ s_BD_D= value; cnt8=8; } if(name.equals("BD_M")){ s_BD_M= value; cnt9=9; } if(name.equals("BD_Y")){ s_BD_Y= value; cnt10=10; } if(name.equals("RES_CAT")){ s_RES_CAT =value; cnt11=11; } if(name.equals("C_ADD")){ s_C_ADD=value.toUpperCase(); cnt12=12; } if(name.equals("C_CITY")){ s_C_CITY =value.toUpperCase(); cnt13=13; } if(name.equals("C_PIN")){ s_C_PIN= value.toUpperCase(); cnt14=14; } if(name.equals("C_STATE")){ s_C_STATE =value.toUpperCase(); cnt15=15; } if(name.equals("C_COUNTRY")){ s_C_COUNTRY =value.toUpperCase(); cnt16=16; } if(name.equals("C_PHONE")){ s_C_PHONE=value; cnt17=17; } if(name.equals("SAME_CORR_ADD")){ s_SAME_CORR_ADD=value.toUpperCase(); cnt18=18; //out.println(" :=======: " + request.getParameter( "SAME_CORR_ADD" ) + "
"); //out.println("*****" + name + " --> " + value + "
" ); } if(name.equals("P_ADD")){ s_P_ADD=value.toUpperCase(); cnt19=19; } if(name.equals("P_CITY")){ s_P_CITY =value.toUpperCase(); cnt20=20; } if(name.equals("P_PIN")){ s_P_PIN=value.toUpperCase(); cnt21=21; } if(name.equals("P_STATE")){ s_P_STATE=value.toUpperCase(); cnt22=22; } if(name.equals("P_COUNTRY")){ s_P_COUNTRY=value.toUpperCase(); cnt23=23; } if(name.equals("P_PHONE")){ s_P_PHONE =value; cnt24=24; } if(name.equals("EMAIL")){ s_EMAIL=value; cnt25=25; } //if(name.equals("REF1NAME")){ s_REF1NAME =value; cnt26=26; } //if(name.equals("REF1ADD")){ s_REF1ADD=value; cnt27=27; } //if(name.equals("REF1PH")){ s_REF1PH =value; cnt28=28; } //if(name.equals("REF1EMAIL")){ s_REF1EMAIL=value; cnt29=29; } //if(name.equals("REF2NAME")){ s_REF2NAME=value; cnt30=30; } //if(name.equals("REF2ADD")){ s_REF2ADD=value; cnt31=31; } //if(name.equals("REF2PH")){ s_REF2PH =value; cnt32=32; } //if(name.equals("REF2EMAIL")){ s_REF2EMAIL=value; cnt33=33; } //if(name.equals("EVA_MARK")){ s_EVA_MARK=value; cnt34=34; } //if(name.equals("REMARK")){ s_REMARK =value; cnt35=35; } if(name.equals("Q1SR")){ s_Q1SR=value; cnt39=39; } if(name.equals("Q1NM")){ s_Q1NM=value; cnt40=40; } if(name.equals("Q1YR")){ s_Q1YR=value; cnt41=41; } if(name.equals("Q1NIB")){ s_Q1NIB=value; cnt42=42; } if(name.equals("Q1MSUB")){ s_Q1MSUB=value; cnt43=43; } if(name.equals("Q1PERC")){ s_Q1PERC=value; cnt44=44; } if(name.equals("Q1GR")){ s_Q1GR=value; cnt45=45; } if(name.equals("Q2SR")){ s_Q2SR=value; cnt47=47; } if(name.equals("Q2NM")){ s_Q2NM=value; cnt48=48; } if(name.equals("Q2YR")){ s_Q2YR=value; cnt49=49; } if(name.equals("Q2NIB")){ s_Q2NIB=value; cnt50=50; } if(name.equals("Q2MSUB")){ s_Q2MSUB=value; cnt51=51; } if(name.equals("Q2PERC")){ s_Q2PERC=value; cnt52=52; } if(name.equals("Q2GR")){ s_Q2GR=value; cnt53=53; } if(name.equals("Q3SR")){ s_Q3SR=value; cnt55=55; } if(name.equals("Q3NM")){ s_Q3NM=value; cnt56=56; } if(name.equals("Q3YR")){ s_Q3YR=value; cnt57=57; } if(name.equals("Q3NIB")){ s_Q3NIB=value; cnt58=58; } if(name.equals("Q3MSUB")){ s_Q3MSUB=value; cnt59=59; } if(name.equals("Q3PERC")){ s_Q3PERC=value; cnt60=60; } if(name.equals("Q3GR")){ s_Q3GR=value; cnt61=61; } if(name.equals("Q4SR")){ s_Q4SR=value; cnt63=63; } if(name.equals("Q4NM")){ s_Q4NM=value; cnt64=64; } if(name.equals("Q4YR")){ s_Q4YR=value; cnt65=65; } if(name.equals("Q4NIB")){ s_Q4NIB=value; cnt66=66; } if(name.equals("Q4MSUB")){ s_Q4MSUB=value; cnt67=67; } if(name.equals("Q4PERC")){ s_Q4PERC=value; cnt68=68; } if(name.equals("Q4GR")){ s_Q4GR=value; cnt69=69; } if(name.equals("Q5SR")){ s_Q5SR=value; cnt71=71; } if(name.equals("Q5NM")){ s_Q5NM=value; cnt72=72; } if (s_Q5NM.equals("Other Qualification (Type here)")){ s_Q5NM="";} if(name.equals("Q5YR")){ s_Q5YR=value; cnt73=73; } if(name.equals("Q5NIB")){ s_Q5NIB=value; cnt74=74; } if(name.equals("Q5MSUB")){ s_Q5MSUB=value; cnt75=75; } if(name.equals("Q5PERC")){ s_Q5PERC=value; cnt76=76; } if(name.equals("Q5GR")){ s_Q5GR=value; cnt77=77; } if(name.equals("Q6SR")){ s_Q6SR=value; cnt79=79; } if(name.equals("Q6NM")){ s_Q6NM=value; cnt80=80; } if (s_Q6NM.equals("Other Qualification (Type here)")){ s_Q6NM="";} if(name.equals("Q6YR")){ s_Q6YR=value; cnt81=81; } if(name.equals("Q6NIB")){ s_Q6NIB=value; cnt82=82; } if(name.equals("Q6MSUB")){ s_Q6MSUB=value; cnt83=83; } if(name.equals("Q6PERC")){ s_Q6PERC=value; cnt84=84; } if(name.equals("Q6GR")){ s_Q6GR=value; cnt85=85; } if(name.equals("E1SR" )){ s_E1SR =value; cnt89=89; } if(name.equals("E1NORG")){ s_E1NORG =value; cnt90=90; } if(name.equals("E1FR")){ s_E1FR =value; cnt91=91; } if(name.equals("E1TO")){ s_E1TO =value; cnt92=92; } if(name.equals("E1POST")){ s_E1POST =value; cnt93=93; } if(name.equals("E1PAY")){ s_E1PAY =value; cnt94=94; } if(name.equals("E1PT")){ s_E1PT =value; cnt95=95; } if(name.equals("E1REAFL")){ s_E1REAFL=value; cnt96=96; } if(name.equals("E1ROLE")){ s_E1ROLE =value; cnt97=97; } if(name.equals("E2SR")){ s_E2SR =value; cnt99=99; } if(name.equals("E2NORG")){ s_E2NORG =value; cnt100=100; } if(name.equals("E2FR")){ s_E2FR =value; cnt101=101; } if(name.equals("E2TO")){ s_E2TO =value; cnt102=102; } if(name.equals("E2POST")){ s_E2POST =value; cnt103=103; } if(name.equals("E2PAY")){ s_E2PAY =value; cnt104=104; } if(name.equals("E2PT")){ s_E2PT =value; cnt105=105; } if(name.equals("E2REAFL")){ s_E2REAFL=value; cnt106=106; } if(name.equals("E2ROLE")){ s_E2ROLE =value; cnt107=107; } if(name.equals("E3SR")){ s_E3SR =value; cnt109=109; } if(name.equals("E3NORG")){ s_E3NORG =value; cnt110=110; } if(name.equals("E3FR")){ s_E3FR =value; cnt111=111; } if(name.equals("E3TO")){ s_E3TO =value; cnt112=112; } if(name.equals("E3POST")){ s_E3POST =value; cnt113=113; } if(name.equals("E3PAY")){ s_E3PAY =value; cnt114=114; } if(name.equals("E3PT")){ s_E3PT =value; cnt115=115; } if(name.equals("E3REAFL")){ s_E3REAFL=value; cnt116=116; } if(name.equals("E3ROLE")){ s_E3ROLE =value; cnt117=117; } if(name.equals("E4SR")){ s_E4SR =value; cnt119=119; } if(name.equals("E4NORG")){ s_E4NORG =value; cnt120=120; } if(name.equals("E4FR")){ s_E4FR =value; cnt121=121; } if(name.equals("E4TO")){ s_E4TO =value; cnt122=122; } if(name.equals("E4POST")){ s_E4POST =value; cnt123=123; } if(name.equals("E4PAY")){ s_E4PAY =value; cnt124=124; } if(name.equals("E4PT")){ s_E4PT =value; cnt125=125; } if(name.equals("E4REAFL")){ s_E4REAFL=value; cnt126=126; } if(name.equals("E4ROLE")){ s_E4ROLE =value; cnt127=127; } if(name.equals("E5SR")){ s_E5SR =value; cnt129=129; } if(name.equals("E5NORG")){ s_E5NORG =value; cnt130=130; } if(name.equals("E5FR")){ s_E5FR =value; cnt131=131; } if(name.equals("E5TO")){ s_E5TO =value; cnt132=132; } if(name.equals("E5POST")){ s_E5POST =value; cnt133=133; } if(name.equals("E5PAY")){ s_E5PAY =value; cnt134=134; } if(name.equals("E5PT")){ s_E5PT =value; cnt135=135; } if(name.equals("E5REAFL")){ s_E5REAFL=value; cnt136=136; } if(name.equals("E5ROLE")){ s_E5ROLE =value; cnt137=137; } if(name.equals("E6SR")){ s_E6SR =value; cnt139=139; } if(name.equals("E6NORG")){ s_E6NORG =value; cnt140=140; } if(name.equals("E6FR")){ s_E6FR =value; cnt141=141; } if(name.equals("E6TO")){ s_E6TO =value; cnt142=142; } if(name.equals("E6POST")){ s_E6POST =value; cnt143=143; } if(name.equals("E6PAY")){ s_E6PAY =value; cnt144=144; } if(name.equals("E6PT")){ s_E6PT =value; cnt145=145; } if(name.equals("E6REAFL")){ s_E6REAFL=value; cnt146=146; } if(name.equals("E6ROLE")){ s_E6ROLE =value; cnt147=147; } //##Change## //if(name.equals("LANGUAGES_FLUENT_AT")){ s_LANGUAGES_FLUENT_AT =value; cnt148=148; } //if(name.equals("COMPUTER_SKILLS")){ s_COMPUTER_SKILLS =value; cnt149=149; } //if(name.equals("PREVIOUS_EXPERIENCE_DETAILS")){ s_PREVIOUS_EXPERIENCE_DETAILS =value; cnt150=150; } if(name.equals("I_AGREE")){ s_I_AGREE =value; cnt151=151; } if(name.equals("ANY_RELATIVE_INFO")){ s_ANY_RELATIVE_INFO = value; cnt151=151; } //##Change## //out.println("s_FULLNM"+ s_FULLNM+ " - "); //Insert into db values(to_date('" + ReportDate.Text + "','dd/mm/yyyy')); bdsf = s_BD_D + "-" + s_BD_M+ "-" + s_BD_Y; //out.println("bdsf"+ bdsf+ " - "); } else // if (item.isFormField()) { //out.println("else // if (item.isFormField()) s_ADV_NO"+ s_ADV_NO); try { // Statement stmtmax = DBConn.getConnection().createStatement(); // ResultSet rset = stmtmax.executeQuery ("SELECT max(nvl(APP_NO,0))+1, to_char(SYSDATE,'DD-MON-RRRR') from PER_JOB_APP_MST"); // while (rset.next()) // { // ss_APP_NO = rset.getString(1); // } //ResultSet rsetvalidator = stmtvalidator.executeQuery ("SELECT count(1) from INAT_APP_MST where APPFULLNAME ='"+s_AppFullName+"' and to_date(APP_DT,'DD-MON-RRRR') =to_date(sysdate,'DD-MON-RRRR')"); stmtvalidator= con .createStatement(); ResultSet rsetvalidator = stmtvalidator.executeQuery ("SELECT count(EMAIL) from PER_JOB_APP_MST where ADV_NO ='"+s_ADV_NO+"' and FULLNM ='"+s_FULLNM+"' and EMAIL='"+s_EMAIL+"'"); while (rsetvalidator.next()) { cntvalidator =Integer.parseInt(rsetvalidator.getString(1)); //out.println( "cntvalidator"+cntvalidator ); }//while (rsetvalidator.next()) //out.println( "cntvalidator"+cntvalidator ); if(cntvalidator == 0) { ss_APP_NO = s_APP_NO; ServletContext context = pageContext.getServletContext(); String itemName = item.getName(); //out.println("itemName: " + itemName); filePath = fileBasePath + s_ADV_NO; File f = new File(filePath); if(!f.exists()) f.mkdir(); fileName = new File(itemName).getName(); uploadedFile = ss_APP_NO+"_"+itemName; File savedFile = new File(filePath+"/"+uploadedFile); item.write(savedFile); } } catch (Exception e) { out.println("Exception :: error while uploading file...." + e.getMessage()); e.printStackTrace(); } } // if (item.isFormField()) }// while (itr.hasNext()) }//else OF if (!isMultipart) %> <% //############### //declaration //---------------- //Connection con=null; //Statement stmtvalidator=null; //Statement stmtmax=null; Statement stmtmaster =null; Statement stmtd=null; Statement stmtd2=null; Statement stmtd3=null; Statement stmtd4=null; Statement stmtd5=null; Statement stmtd6=null; try { //Class.forName("oracle.jdbc.driver"); DriverManager.registerDriver (new oracle.jdbc.driver.OracleDriver()); //con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.214.251:21521:ORCL","dffd","dfdf"); //con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.2:1521:ORCL","dfdf","dfdf"); con=DBConn.getConnection(); stmtmax= con .createStatement(); stmtmaster = con.createStatement(); stmtd = con .createStatement(); stmtd2 = con .createStatement(); stmtd3 = con .createStatement(); stmtd4 = con .createStatement(); stmtd5 = con .createStatement(); stmtd6 = con .createStatement(); //ResultSet rsetvalidator = stmtvalidator.executeQuery ("SELECT count(1) from INAT_APP_MST where APPFULLNAME ='"+s_AppFullName+"' and to_date(APP_DT,'DD-MON-RRRR') =to_date(sysdate,'DD-MON-RRRR')"); //ResultSet rsetvalidator = stmtvalidator.executeQuery ("SELECT count(1) from PER_JOB_APP_MST where ADV_NO ='"+s_ADV_NO+"' and FULLNM ='"+s_FULLNM+"' and EMAIL='"+s_EMAIL+"'"); //while (rsetvalidator.next()) //{ // cntvalidator =Integer.parseInt(rsetvalidator.getString(1)); //out.println( "cntvalidator"+cntvalidator ); //}//while (rsetvalidator.next()) %>
<% if (cntvalidator == 0 && appflag ==1 ) { //ResultSet rset = stmtmax.executeQuery ("SELECT max(nvl(APP_NO,0))+1, trim(to_char(max(nvl(APP_NO,0))+1,'00000')), to_char(SYSDATE,'DD-MON-RRRR') from PER_JOB_APP_MST"); //out.println( "s_APP_NO"+s_APP_NO );out.println("bdsf"+ bdsf); //int rs=stmt.executeUpdate("INSERT INTO WEBMAIL_UNPW(UNAME,PW) values ('"+unvar+"','"+pwvar+"')"); //Master Entry to_date('" + bdsf + "','dd/mm/yyyy') //int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,APP_DT,ADV_NO,NM_POST,FULLNM,SEX,NATION,DOB,RES_CAT,C_ADD,C_CITY,C_PIN,C_STATE,C_COUNTRY,C_PHONE,SAME_CORR_ADD,P_ADD ,P_CITY,P_PIN ,P_STATE,P_COUNTRY,P_PHONE,EMAIL,REF1NAME,REF1ADD,REF1PH,REF1EMAIL,REF2NAME ,REF2ADD ,REF2PH,REF2EMAIL ,EVA_MARK,REMARK,RESUME_FILE ) values ('"+s_APP_NO+"','"+s_APP_DT+"','"+s_ADV_NO+"','"+s_NM_POST+"','"+s_FULLNM+"','"+s_SEX+"','"+s_NATION+"','"+s_DOB+"','"+s_RES_CAT+"','"+s_C_ADD +"','"+s_C_CITY+"','"+s_C_PIN +"','"+s_C_STATE+"','"+s_C_COUNTRY+"','"+s_C_PHONE+"','"+s_SAME_CORR_ADD+"','"+s_P_ADD +"','"+s_P_CITY+"','"+s_P_PIN +"','"+s_P_STATE+"','"+s_P_COUNTRY+"','"+s_P_PHONE+"','"+s_EMAIL +"','"+s_REF1NAME +"','"+s_REF1ADD+"','"+s_REF1PH+"','"+s_REF1EMAIL+"','"+s_REF2NAME +"','"+s_REF2ADD+"','"+s_REF2PH+"','"+s_REF2EMAIL+"','"+s_EVA_MARK +"','"+s_REMARK+"','"+uploadedFile+"')"); //int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,APP_DT,NM_POST,FULLNM,SEX,NATION,DOB,RES_CAT,C_ADD,C_CITY,C_PIN,C_STATE,C_COUNTRY,C_PHONE,SAME_CORR_ADD,P_ADD ,P_CITY,P_PIN ,P_STATE,P_COUNTRY,P_PHONE,EMAIL,EVA_MARK,REMARK ) values ('"+s_APP_NO+"','"+s_APP_DT+"','"+s_NM_POST+"','"+s_FULLNM+"','"+s_SEX+"','"+s_NATION+"','"+s_DOB+"','"+s_RES_CAT+"','"+s_C_ADD +"','"+s_C_CITY+"','"+s_C_PIN +"','"+s_C_STATE+"','"+s_C_COUNTRY+"','"+s_C_PHONE+"','"+s_SAME_CORR_ADD+"','"+s_P_ADD +"','"+s_P_CITY+"','"+s_P_PIN +"','"+s_P_STATE+"','"+s_P_COUNTRY+"','"+s_P_PHONE+"','"+s_EMAIL +"','"+s_EVA_MARK +"','"+s_REMARK+"')"); //int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,APP_DT) values ('"+s_APP_NO+"','"+s_APP_DT+"')"); //int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,APP_DT,NM_POST,FULLNM,SEX,NATION ) values ('"+s_APP_NO+"','"+s_APP_DT+"','"+s_NM_POST+"','"+s_FULLNM+"','"+s_SEX+"','"+s_NATION+"')"); //int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,APP_DT,NM_POST,FULLNM,SEX,NATION,DOB,RES_CAT,C_ADD,C_CITY,C_PIN,C_STATE,C_COUNTRY,C_PHONE,SAME_CORR_ADD,P_ADD ,P_CITY,P_PIN ,P_STATE,P_COUNTRY,P_PHONE,EMAIL ) values ('"+s_APP_NO+"','"+s_APP_DT+"','"+s_NM_POST+"','"+s_FULLNM+"','"+s_SEX+"','"+s_NATION+"','"+s_DOB+"','"+s_RES_CAT+"','"+s_C_ADD +"','"+s_C_CITY+"','"+s_C_PIN +"','"+s_C_STATE+"','"+s_C_COUNTRY+"','"+s_C_PHONE+"','"+s_SAME_CORR_ADD+"','"+s_P_ADD +"','"+s_P_CITY+"','"+s_P_PIN +"','"+s_P_STATE+"','"+s_P_COUNTRY+"','"+s_P_PHONE+"','"+s_EMAIL +"')"); //int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,APP_DT,ADV_NO,NM_POST,FULLNM,SEX,NATION,RES_CAT,C_ADD,C_CITY,C_PIN,C_STATE,C_COUNTRY,C_PHONE,P_ADD ,P_CITY,P_PIN ,P_STATE,P_COUNTRY,P_PHONE,EMAIL ) values ('"+s_APP_NO+"','"+s_APP_DT+"','"+s_ADV_NO+"','"+s_NM_POST+"','"+s_FULLNM+"','"+s_SEX+"','"+s_NATION+"','"+s_RES_CAT+"','"+s_C_ADD +"','"+s_C_CITY+"','"+s_C_PIN +"','"+s_C_STATE+"','"+s_C_COUNTRY+"','"+s_C_PHONE+"','"+s_P_ADD +"','"+s_P_CITY+"','"+s_P_PIN +"','"+s_P_STATE+"','"+s_P_COUNTRY+"','"+s_P_PHONE+"','"+s_EMAIL +"')"); //##Change## //int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,APP_DT,ADV_NO,NM_POST,FULLNM,SEX,NATION,DOB,RES_CAT,C_ADD,C_CITY,C_PIN,C_STATE,C_COUNTRY,C_PHONE,SAME_CORR_ADD,P_ADD ,P_CITY,P_PIN ,P_STATE,P_COUNTRY,P_PHONE,EMAIL,LANGUAGES_FLUENT_AT,COMPUTER_SKILLS, PREVIOUS_EXPERIENCE_DETAILS,I_AGREE ) values ('"+s_APP_NO+"','"+s_APP_DT+"','"+s_ADV_NO+"','"+s_NM_POST+"','"+s_FULLNM +"','"+s_SEX+"','"+s_NATION+"', to_date('" + bdsf + "','dd/mm/yyyy'),'"+s_RES_CAT+"','"+s_C_ADD +"','"+s_C_CITY+"','"+s_C_PIN +"','"+s_C_STATE+"','"+s_C_COUNTRY+"','"+s_C_PHONE+"','"+s_SAME_CORR_ADD+"','"+s_P_ADD +"','"+s_P_CITY+"','"+s_P_PIN +"','"+s_P_STATE+"','"+s_P_COUNTRY+"','"+s_P_PHONE+"','"+s_EMAIL +"','"+s_LANGUAGES_FLUENT_AT +"','"+s_COMPUTER_SKILLS +"','"+s_PREVIOUS_EXPERIENCE_DETAILS +"','"+s_I_AGREE+"')"); //##Change## String sqlQuery = "insert into PER_JOB_APP_MST(APP_NO,APP_DT,ADV_NO,NM_POST,FULLNM,SEX,NATION,DOB,RES_CAT,C_ADD,C_CITY,C_PIN,C_STATE,C_COUNTRY,C_PHONE,SAME_CORR_ADD,P_ADD ,P_CITY,P_PIN ,P_STATE,P_COUNTRY,P_PHONE,EMAIL,I_AGREE,ANY_RELATIVE_INFO,RESUME_FILE ) values ('"+s_APP_NO+"','"+s_APP_DT+"','"+s_ADV_NO+"','"+s_NM_POST+"','"+s_FULLNM +"','"+s_SEX+"','"+s_NATION+"', to_date('" + bdsf + "','dd/mm/yyyy'),'"+s_RES_CAT+"','"+s_C_ADD +"','"+s_C_CITY+"','"+s_C_PIN +"','"+s_C_STATE+"','"+s_C_COUNTRY+"','"+s_C_PHONE+"','"+s_SAME_CORR_ADD+"','"+s_P_ADD +"','"+s_P_CITY+"','"+s_P_PIN +"','"+s_P_STATE+"','"+s_P_COUNTRY+"','"+s_P_PHONE+"','"+s_EMAIL +"','"+s_I_AGREE+"','" + s_ANY_RELATIVE_INFO +"','"+uploadedFile+"')"; //out.print("SQL Query :: " + sqlQuery + "
"); int rs=stmtmaster.executeUpdate(sqlQuery); // int rs=stmtmaster.executeUpdate("insert into PER_JOB_APP_MST(APP_NO,DOB) values ('"+s_APP_NO+"', to_date('" + bdsf + "','dd/mm/yyyy'))"); //Child Quali Entry int rsd1=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_QUALI_DET(APP_NO,Q_SR,Q_NM,Q_YR,Q_NIB,Q_MSUB,Q_PERC,Q_GR) values ('"+s_APP_NO+"','"+s_Q1SR+"','"+s_Q1NM+"','"+s_Q1YR+"','"+s_Q1NIB+"','"+s_Q1MSUB+"','"+s_Q1PERC+"','"+s_Q1GR+"')"); int rsd2=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_QUALI_DET(APP_NO,Q_SR,Q_NM,Q_YR,Q_NIB,Q_MSUB,Q_PERC,Q_GR) values ('"+s_APP_NO+"','"+s_Q2SR+"','"+s_Q2NM+"','"+s_Q2YR+"','"+s_Q2NIB+"','"+s_Q2MSUB+"','"+s_Q2PERC+"','"+s_Q2GR+"')"); int rsd3=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_QUALI_DET(APP_NO,Q_SR,Q_NM,Q_YR,Q_NIB,Q_MSUB,Q_PERC,Q_GR) values ('"+s_APP_NO+"','"+s_Q3SR+"','"+s_Q3NM+"','"+s_Q3YR+"','"+s_Q3NIB+"','"+s_Q3MSUB+"','"+s_Q3PERC+"','"+s_Q3GR+"')"); int rsd4=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_QUALI_DET(APP_NO,Q_SR,Q_NM,Q_YR,Q_NIB,Q_MSUB,Q_PERC,Q_GR) values ('"+s_APP_NO+"','"+s_Q4SR+"','"+s_Q4NM+"','"+s_Q4YR+"','"+s_Q4NIB+"','"+s_Q4MSUB+"','"+s_Q4PERC+"','"+s_Q4GR+"')"); int rsd5=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_QUALI_DET(APP_NO,Q_SR,Q_NM,Q_YR,Q_NIB,Q_MSUB,Q_PERC,Q_GR) values ('"+s_APP_NO+"','"+s_Q5SR+"','"+s_Q5NM+"','"+s_Q5YR+"','"+s_Q5NIB+"','"+s_Q5MSUB+"','"+s_Q5PERC+"','"+s_Q5GR+"')"); int rsd6=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_QUALI_DET(APP_NO,Q_SR,Q_NM,Q_YR,Q_NIB,Q_MSUB,Q_PERC,Q_GR) values ('"+s_APP_NO+"','"+s_Q6SR+"','"+s_Q6NM+"','"+s_Q6YR+"','"+s_Q6NIB+"','"+s_Q6MSUB+"','"+s_Q6PERC+"','"+s_Q6GR+"')"); //Child Experience Entry int rsd7=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_EXPER_DET (APP_NO,E_SR,E_NORG,E_FR,E_TO,E_POST,E_PAY,E_PT,E_REAFL) values ('"+s_APP_NO+"','"+s_E1SR+"','"+s_E1NORG+"','"+s_E1FR+"','"+s_E1TO+"','"+s_E1POST+"','"+s_E1PAY+"','"+s_E1PT+"','"+s_E1REAFL+"')"); int rsd8=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_EXPER_DET (APP_NO,E_SR,E_NORG,E_FR,E_TO,E_POST,E_PAY,E_PT,E_REAFL) values ('"+s_APP_NO+"','"+s_E2SR+"','"+s_E2NORG+"','"+s_E2FR+"','"+s_E2TO+"','"+s_E2POST+"','"+s_E2PAY+"','"+s_E2PT+"','"+s_E2REAFL+"')"); int rsd9=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_EXPER_DET (APP_NO,E_SR,E_NORG,E_FR,E_TO,E_POST,E_PAY,E_PT,E_REAFL) values ('"+s_APP_NO+"','"+s_E3SR+"','"+s_E3NORG+"','"+s_E3FR+"','"+s_E3TO+"','"+s_E3POST+"','"+s_E3PAY+"','"+s_E3PT+"','"+s_E3REAFL+"')"); int rsd10=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_EXPER_DET (APP_NO,E_SR,E_NORG,E_FR,E_TO,E_POST,E_PAY,E_PT,E_REAFL) values ('"+s_APP_NO+"','"+s_E4SR+"','"+s_E4NORG+"','"+s_E4FR+"','"+s_E4TO+"','"+s_E4POST+"','"+s_E4PAY+"','"+s_E4PT+"','"+s_E4REAFL+"')"); int rsd11=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_EXPER_DET (APP_NO,E_SR,E_NORG,E_FR,E_TO,E_POST,E_PAY,E_PT,E_REAFL) values ('"+s_APP_NO+"','"+s_E5SR+"','"+s_E5NORG+"','"+s_E5FR+"','"+s_E5TO+"','"+s_E5POST+"','"+s_E5PAY+"','"+s_E5PT+"','"+s_E5REAFL+"')"); int rsd12=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_EXPER_DET (APP_NO,E_SR,E_NORG,E_FR,E_TO,E_POST,E_PAY,E_PT,E_REAFL) values ('"+s_APP_NO+"','"+s_E6SR+"','"+s_E6NORG+"','"+s_E6FR+"','"+s_E6TO+"','"+s_E6POST+"','"+s_E6PAY+"','"+s_E6PT+"','"+s_E6REAFL+"')"); //int rsd13=stmtd.executeUpdate("INSERT INTO PER_JOB_APP_EXPER_DET (APP_NO,E_SR,E_NORG,E_FR,E_TO,E_POST,E_PAY,E_PT,E_REAFL,E_ROLE) values ('"+s_APP_NO+"','"+s_E1SR+"','"+s_E7NORG+"','"+s_E7FR+"','"+s_E7TO+"','"+s_E7POST+"','"+s_E7PAY+"','"+s_E7REAFL+"','"+s_E7ROLE+"')"); %> <% }//if cntvalidator == 0 then else { %> <% } %>
You have successfully submitted your application. A copy of your application has been sent to <%out.println(s_EMAIL); %>
(the email id provided by you in your application).
<< Go back to Home Page              
<% out.println("\n"+" You have already applied.."+" \n");%>
<% out.println("\n"+" In case in issue, please write mail to Mr. Yogesh Thakare (thakare@iucaa.in)"+" \n");%>
 << Go back to Home Page        Close  

<% if (cntvalidator == 0 && appflag==1 ) { %>
Application No.: <% //out.println("cntvalidator -"+cntvalidator +"-"); //if (session.getValue("S_APP_NO")==null){ session.setAttribute("S_APP_NO",s_APP_NO); } else { s_APP_NO =(String)session.getValue("S_APP_NO");} %> <%out.println(s_APP_NO); %>
1. Name of the Post:* <%out.println(s_NM_POST); %>  
2. Full Name:* <%out.println(s_FULLNM); %>     Gender : <%out.println(s_SEX); %>
 
3. Address for Correspondence:   4. Permanent Address :
Address Lines:* <%out.println(s_C_ADD); %>   Address Lines: <%out.println(s_P_ADD); %>
City:* <%out.println(s_C_CITY); %>   City: <%out.println(s_P_CITY); %>
Pin code:* <%out.println(s_C_PIN); %>   Pin code: <%out.println(s_P_PIN); %>
State:* <%out.println(s_C_STATE); %>   State: <%out.println(s_P_STATE); %>
Country:* <%out.println(s_C_COUNTRY); %>   Country: <%out.println(s_P_COUNTRY); %>
Phone/Mobile No.: <%out.println(s_C_PHONE); %>   Phone/Mobile No.: <%out.println(s_P_PHONE); %>
5.Email: * <%out.println(s_EMAIL); %>      
 
6.Nationality: <%out.println(s_NATION); %>
7. Date of Birth: *
Day
<%out.println(s_BD_D); %>
  Month
<%out.println(s_BD_M); %>
  Year
<%out.println(s_BD_Y); %>
8. Category: <%out.println(s_RES_CAT); %>
 
9. Educational Qualifications:
<% if ((!s_Q4NIB.equals(""))|| (!s_Q4NM.equals(""))||(!s_Q4MSUB.equals(""))) { %> <% } //if ((!s_Q4NIB.equals(""))|| (!s_Q4NM.equals(""))||(!s_Q4MSUB.equals(""))) { %> <% if ((!s_Q5NIB.equals(""))|| (!s_Q5NM.equals(""))||(!s_Q5MSUB.equals(""))) { %> <% } //if ((!s_Q4NIB.equals(""))|| (!s_Q4NM.equals(""))||(!s_Q4MSUB.equals(""))) { %> <% if ((!s_Q6NIB.equals(""))|| (!s_Q6NM.equals(""))||(!s_Q6MSUB.equals(""))) { %> <% }//if ((!s_Q5NIB.equals(""))|| (!s_Q5NM.equals(""))||(!s_Q5MSUB.equals(""))) %>
Name of the
Institution/ Bord 		Exam/ Degree
& Year of Passing 		Main Subjects Agreegate Marks
& Division
 <%out.println(s_Q1NIB); %> <%out.println(s_Q1NM); %>
 Year : <%out.println(s_Q1YR); %> 		<%out.println(s_Q1MSUB); %>  <%out.println(s_Q1PERC); %> %
Division <%out.println(s_Q1GR); %>
 <%out.println(s_Q2NIB); %> *  <%out.println(s_Q2NM); %>
 Year : <%out.println(s_Q2YR); %> 		<%out.println(s_Q2MSUB); %>   <%out.println(s_Q2PERC); %> %
Division <%out.println(s_Q2GR); %>
 <%out.println(s_Q3NIB); %> Degree*  <%out.println(s_Q3NM); %>
 Year : <%out.println(s_Q3YR); %> 		<%out.println(s_Q3MSUB); %>   <%out.println(s_Q3PERC); %> %
Division  <%out.println(s_Q3GR); %>
 <%out.println(s_Q4NIB); %> Post Graduation   <%out.println(s_Q4NM); %>
Year : <%out.println(s_Q4YR); %> 		 <%out.println(s_Q4MSUB); %>    <%out.println(s_Q4PERC); %> %
Division <%out.println(s_Q4GR); %>
 <%out.println(s_Q5NIB); %>  <%out.println(s_Q5NM); %>
 Year : <%out.println(s_Q5YR); %> 		 <%out.println(s_Q5MSUB); %>   <%out.println(s_Q5PERC); %> %
Division <%out.println(s_Q5GR); %>
 <%out.println(s_Q6NIB); %>  <%out.println(s_Q6NM); %>
Year : <%out.println(s_Q6YR); %> 		 <%out.println(s_Q6MSUB); %>

  <%out.println(s_Q6PERC); %> %
Division <%out.println(s_Q6GR); %>

 
10. Any other relevant information: <%out.println(s_ANY_RELATIVE_INFO);%>
11. Experience with complete details in chronological order :
<% if ((!s_E2NORG.equals(""))|| (!s_E2FR.equals(""))) { %> <%} // if ((!s_E2NORG.equals(""))|| (!s_E2FR.equals(""))) { %> <% if ((!s_E3NORG.equals(""))|| (!s_E3FR.equals(""))) { %> <% }// if ((!s_E2NORG.equals(""))|| (!s_E2FR.equals(""))) { %> <% if ((!s_E4NORG.equals(""))|| (!s_E4FR.equals(""))) { %>   <% }//if ((!s_E3NORG.equals(""))|| (!s_E3FR.equals(""))) { %> <% if ((!s_E5NORG.equals(""))|| (!s_E5FR.equals(""))) { %> <% }//if ((!s_E3NORG.equals(""))|| (!s_E3FR.equals(""))) { %> <% if ((!s_E6NORG.equals(""))|| (!s_E6FR.equals(""))) { %> <% } //if ((!s_E3NORG.equals(""))|| (!s_E3FR.equals(""))) { %>
Name & Address of
Employer/ Institition 		Period of service
From - To

Post held &
Pay

Whether
Permanent or
Temporary 		Reason for
Leaving
 <%out.println(s_E1NORG ); %>  <%out.println(s_E1FR); %> - <%out.println(s_E1TO); %>  <%out.println(s_E1POST); %>  <%out.println(s_E1PAY); %>  <%out.println(s_E1PT); %>  <%out.println(s_E1REAFL); %>
 <%out.println(s_E2NORG ); %>  <%out.println(s_E2FR); %> - <%out.println(s_E2TO); %>  <%out.println(s_E2POST); %>  <%out.println(s_E2PAY); %>  <%out.println(s_E2PT); %>  <%out.println(s_E2REAFL); %>
 <%out.println(s_E3NORG ); %>  <%out.println(s_E3FR); %> - <%out.println(s_E3TO); %>  <%out.println(s_E3POST); %>  <%out.println(s_E3PAY); %>  <%out.println(s_E3PT); %>  <%out.println(s_E3REAFL); %>
 <%out.println(s_E4NORG ); %>  <%out.println(s_E4FR); %> - <%out.println(s_E4TO); %>  <%out.println(s_E4POST); %>  <%out.println(s_E4PAY); %>  <%out.println(s_E4PT); %>  <%out.println(s_E4REAFL); %>
 <%out.println(s_E5NORG ); %>  <%out.println(s_E5FR); %> - <%out.println(s_E5TO); %>  <%out.println(s_E5POST); %>  <%out.println(s_E5PAY); %>  <%out.println(s_E5PT); %>  <%out.println(s_E5REAFL); %>
 <%out.println(s_E6NORG ); %>  <%out.println(s_E6FR); %> - <%out.println(s_E6TO); %>  <%out.println(s_E6POST); %>  <%out.println(s_E6PAY); %>  <%out.println(s_E6PT); %>  <%out.println(s_E6REAFL); %>
12. Uploaded Curriculum vitae (Resume): " target="_blank"> <%=uploadedFile %>
 

I hereby certify that the fore-going information is correct to the best of my knowledge and belief. I have not suppressed any material fact or factual information in the above statement. In case I have given wrong information, or suppressed any material fact or factual information, then my selection is liable to be terminated, without giving any notice or reason therefore. I am not aware of any circumstances which might impair my fitness for employment. I also undertake that, I am possessing all the relevant certificates/documents issued by relevant competent Authority on the date of submitting this ONLINE application.
<%//out.println(s_I_AGREE ); %>
<% } // if cntvalidator == 0 then %> <% if (cntvalidator == 0 && appflag ==1) { //----Email Source Code--------- //String from="ioas@iucaa.in"; //String cc=s_AppEmail; //String to= s_AppEmail; //"+","+cc; // String Subject = "INAT-2010"+" ("+ s_APP_FORM_NO+")"; String estr =""; estr += "***********************NOTE********************************\n"; estr += "Your application has been successfully submitted.\n"; estr += "***********************************************************\n"; estr += "Application No.: "+ s_APP_NO+"\n"; //estr += "Advertisement No.: "+ s_ADV_NO+"\n"; estr += "\n"; estr += "1. Name of the Post: "+ s_NM_POST+"\n"; estr += "2. Full Name: "+ s_FULLNM+"\n"; estr += " Gender: "+s_SEX+"\n"; estr += "3. Address for Correspondence: "+"\n"; estr += " Address Lines: "+s_C_ADD+"\n"; estr += " City: "+s_C_CITY+"\n"; estr += " Pin code: "+s_C_PIN+"\n"; estr += " State: "+s_C_STATE+"\n"; estr += " Country: "+s_C_COUNTRY+"\n"; estr += " Phone/Mobile No.: "+s_C_PHONE+"\n"; estr += " Email: "+s_EMAIL+"\n"; estr += "4. Permanent Address: "+"\n"; estr += " Address Lines: "+s_P_ADD+"\n"; estr += " City: "+s_P_CITY+"\n"; estr += " Pin code: "+s_P_PIN+"\n"; estr += " State: "+s_P_STATE+"\n"; estr += " Country: "+s_P_COUNTRY+"\n"; estr += " Phone/Mobile No.: "+s_P_PHONE+"\n"; estr += "\n"; estr += "5. e-mail address: "+s_EMAIL+"\n"; estr += "\n"; estr += "6. Nationality: "+s_NATION+"\n"; estr += "7. Date of Birth: "+bdsf+"\n"; estr += "8. Reserve Category: "+s_RES_CAT+"\n"; estr += "\n"; estr += "9. Educational Qualifications: "+"\n"; estr += "====================================================================================="+"\n"; //estr += "Name of the Institution/ Bord: "+s_Q1NIB+"\n"; //estr += "Exam/ Degree: "+s_Q1NM+"\n"; //estr += "Year of Passing: "+s_Q1YR+"\n"; //estr += "Main Subjects: "+s_Q1MSUB+"\n"; //estr += "Agreegate Marks: "+s_Q1PERC+"\n"; //estr += "Division: "+s_Q1GR+"\n"; //estr += "--------------------------------------------------------------"+"\n"; //estr += "Name of the Institution/ Bord: "+s_Q2NIB+"\n"; //estr += "Exam/ Degree: "+s_Q2NM+"\n"; //estr += "Year of Passing: "+s_Q2YR+"\n"; //estr += "Main Subjects: "+s_Q2MSUB+"\n"; //estr += "Agreegate Marks: "+s_Q2PERC+"\n"; //estr += "Division: "+s_Q2GR+"\n"; //estr += "--------------------------------------------------------------"+"\n"; estr += "Name of the Institution/ Bord: "+s_Q3NIB+"\n"; estr += "Exam/ Degree: "+s_Q3NM+"\n"; estr += "Year of Passing: "+s_Q3YR+"\n"; estr += "Main Subjects: "+s_Q3MSUB+"\n"; estr += "Agreegate Marks : "+s_Q3PERC+"\n"; estr += "Division: "+s_Q3GR+"\n"; if ((!s_Q4NIB.equals(""))|| (!s_Q4NM.equals(""))||(!s_Q4MSUB.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name of the Institution/ Bord: "+s_Q4NIB+"\n"; estr += "Exam/ Degree: "+s_Q4NM+"\n"; estr += "Year of Passing: "+s_Q4YR+"\n"; estr += "Main Subjects: "+s_Q4MSUB+"\n"; estr += "Agreegate Marks: "+s_Q4PERC+"\n"; estr += "Division: "+s_Q4GR+"\n"; } if ((!s_Q5NIB.equals(""))|| (!s_Q5NM.equals(""))||(!s_Q5MSUB.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name of the Institution/ Bord: "+s_Q5NIB+"\n"; estr += "Exam/ Degree: "+s_Q5NM+"\n"; estr += "Year of Passing: "+s_Q5YR+"\n"; estr += "Main Subjects: "+s_Q5MSUB+"\n"; estr += "Agreegate Marks: "+s_Q5PERC+"\n"; estr += "Division: "+s_Q5GR+"\n"; } if ((!s_Q6NIB.equals(""))|| (!s_Q6NM.equals(""))||(!s_Q6MSUB.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name of the Institution/ Bord: "+s_Q6NIB+"\n"; estr += "Exam/ Degree: "+s_Q6NM+"\n"; estr += "Year of Passing: "+s_Q6YR+"\n"; estr += "Main Subjects: "+s_Q6MSUB+"\n"; estr += "Agreegate Marks: "+s_Q6PERC+"\n"; estr += "Division: "+s_Q6GR+"\n"; } estr += "\n"; estr += "====================================================================================="+"\n"; estr += "\n"; estr += "10. Any other relevant information: "+"\n"; if(!s_ANY_RELATIVE_INFO.equals("")) estr += s_ANY_RELATIVE_INFO + "\n"; estr += "\n"; estr += "11. Experience with complete details in chronological order : "+"\n"; if ((!s_E1NORG.equals(""))|| (!s_E1FR.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name & Address of Employer/ Institition: "+s_E1NORG +"\n"; estr += "Period of service (From - To) : ( "+s_E1FR+" - "+s_E1TO+")\n"; estr += "Post held & Pay : "+s_E1POST+" , "+s_E1PAY+"\n"; estr += "Status: "+s_E1PT+"\n"; estr += "Reason for Leaving: "+s_E1REAFL+"\n"; } if ((!s_E2NORG.equals(""))|| (!s_E2FR.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name & Address of Employer/ Institition: "+ s_E2NORG +"\n"; estr += "Period of service (From - To) : ( "+ s_E2FR+" - "+ s_E2TO+")\n"; estr += "Post held & Pay : "+ s_E2POST+" , "+ s_E2PAY+"\n"; estr += "Status: "+ s_E2PT+"\n"; estr += "Reason for Leaving: "+ s_E2REAFL+"\n"; } if ((! s_E3NORG.equals(""))|| (!s_E3FR.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name & Address of Employer/ Institition: "+ s_E3NORG +"\n"; estr += "Period of service (From - To) : ( "+ s_E3FR+" - "+ s_E3TO+")\n"; estr += "Post held & Pay : "+ s_E3POST+" , "+ s_E3PAY+"\n"; estr += "Status: "+ s_E3PT+"\n"; estr += "Reason for Leaving: "+ s_E3REAFL+"\n"; } if ((!s_E4NORG.equals(""))|| (!s_E4FR.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name & Address of Employer/ Institition: "+ s_E4NORG +"\n"; estr += "Period of service (From - To) : ( "+ s_E4FR+" - "+ s_E4TO+")\n"; estr += "Post held & Pay: "+ s_E4POST+" , "+ s_E4PAY+"\n"; estr += "Status: "+ s_E4PT+"\n"; estr += "Reason for Leaving: "+ s_E4REAFL+"\n"; } if ((! s_E5NORG.equals(""))|| (!s_E5FR.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name & Address of Employer/ Institition: "+ s_E5NORG +"\n"; estr += "Period of service (From - To) : ( "+ s_E5FR+" - "+ s_E5TO+")\n"; estr += "Post held & Pay: "+ s_E5POST+" , "+ s_E5PAY+"\n"; estr += "Status: "+ s_E5PT+"\n"; estr += "Reason for Leaving: "+ s_E5REAFL+"\n"; } if ((!s_E6NORG.equals(""))|| (!s_E6FR.equals(""))) { estr += "--------------------------------------------------------------"+"\n"; estr += "Name & Address of Employer/ Institition: "+ s_E6NORG +"\n"; estr += "Period of service (From - To) : ( "+ s_E6FR+" - "+ s_E6TO+")\n"; estr += "Post held & Pay: "+ s_E6POST+" , "+ s_E6PAY+"\n"; estr += "Status: "+ s_E6PT+"\n"; estr += "Reason for Leaving: "+ s_E6REAFL+"\n"; } //estr += "10. Languages fluent at: "+ s_LANGUAGES_FLUENT_AT+"\n"; //estr += "11. Computer skills: "+ s_COMPUTER_SKILLS+"\n"; //estr += "12. Relevant information about previous experience in Science Outreach (in not more that 200 words). "+ s_PREVIOUS_EXPERIENCE_DETAILS+"\n"; estr += "\n"; estr += "12. Curriculum vitae (Resume): " + uploadedFile; estr += "\n"; estr += "\n"; //out.println("before email try"); String to = s_EMAIL; String cc = "recruit@iucaa.in"; String from = "recruit@iucaa.in"; String host = "192.168.11.49"; String msgText1 = estr ; String subject = "APPLICATION"+" ("+ s_APP_NO+")"; // create some properties and get the default Session Properties props = System.getProperties(); props.put("mail.smtp.host", host); Session session1 = Session.getInstance(props, null); try { // create a message MimeMessage msg = new MimeMessage(session1); msg.setFrom(new InternetAddress(from)); InternetAddress[] address = {new InternetAddress(to)}; msg.setRecipients(Message.RecipientType.TO, address); InternetAddress[] ccaddress = {new InternetAddress(cc)}; msg.setRecipients(Message.RecipientType.CC, ccaddress); msg.setSubject(subject); // create and fill the first message part MimeBodyPart mbp1 = new MimeBodyPart(); mbp1.setText(msgText1); // create the Multipart and add its parts to it Multipart mp = new MimeMultipart(); mp.addBodyPart(mbp1); ////mp.addBodyPart(mbp2); // attach the file to the message // create the second message part MimeBodyPart mbp2 = new MimeBodyPart(); String filePhyPath = filePath+"/"+uploadedFile; FileDataSource fds = new FileDataSource(filePhyPath); mbp2.setDataHandler(new DataHandler(fds)); mbp2.setFileName(fds.getName()); mp.addBodyPart(mbp2); // add the Multipart to the message msg.setContent(mp); // set the Date: header //msg.setSentDate(new Date()); // send the message Transport.send(msg); } catch (MessagingException mex) { mex.printStackTrace(); Exception ex = null; if ((ex = mex.getNextException()) != null) { ex.printStackTrace(); } } //----Email Source Code--------- } //if (cntvalidator == 0) { stmtmax.close(); stmtmaster.close(); stmtd.close(); stmtd2.close(); stmtd3.close(); stmtd4.close(); stmtd5.close(); stmtd6.close(); con.close(); /* //File delFolder = new File("/usr/local/apache-tomcat/webapps/iucaa/jsp/temp/"+s_APP_NO); File delFolder = new File("/usr/local/apache-tomcat/webapps/iucaa/jsp/temp/"+s_APP_NO); //File delFolder = new File("/usr/local/apache-tomcat/webapps/iucaa/jsp/temp/10"); //make sure source exists if(!delFolder.exists()){ out.println("Directory does not exist."); //just exit System.exit(0); }else { try { out.println("Directory exist " + delFolder.getName()); //copyFolder(srcFolder,destFolder); boolean success = RemoveDirectory.removeDir(delFolder); //boolean success =true; out.print(success); if (!success) { // Deletion failed out.println("Directory delete failed"); } else { out.println("Directory method not found"); } } catch(IOException e) { e.printStackTrace(); System.exit(0); } // end of catch } //end of else */ } catch(Exception e) { System.err.println(e.getMessage()); } finally { try { if (stmtd != null) { stmtd.close(); } if (con != null) { con.close(); } } catch(SQLException sqle) { System.err.println(sqle.getMessage()); } } //------------------ // } // catch (IOException e){ // System.out.println("ERROR SENDING EMAIL: "+e); //out.println("Email-id: "+s_AppEmail +" is wrong. Please Check and enter full email-id"); // } //-------------------------------------------------------- %>