Reply Me

Expert:Ragini Shukla
Hi

I am sending some code please check it and solve this code is only insert into the data base please insert data in the database table and reply me fast...I got two error

1 is catch is without try
2 is try without catch or finally

<%@page contentType="text/html" import="java.sql.Connection,java.util.*,java.io.*, java.text.*, java.lang.String.*, java.lang.*, java.sql.DriverManager, java.sql.SQLException, java.sql.*" %>
<jsp:useBean id="DbBean" scope="session" class="colors.DbBean" />
<jsp:setProperty name="DbBean" property="*" />
<%@ include file="../../Webforms/validateSessioninc.inc" %>
<%@ include file="../../Webforms/GenFormId.inc"%>
<%//try
//{%>
<%
String txtchk="0";
String FORMID="", fid="";
ResultSet rs;
fid="";
FORMID=request.getParameter("FORMID");
int level=0;
boolean k=true;
if(FORMID=="null" |FORMID==null | FORMID =="")
{
fid=request.getParameter("fid");
FORMID="";
}
try
{
if((request.getParameter("msg")).indexOf("0")>=0)
{
out.println("<hr>Records Updated Successfully! <hr>");
}
else
{
if((request.getParameter("msg")).indexOf("1")>=0)
{
out.println("<hr>Error: Records could not be Updated ..! <hr>");
}
}
}
catch(Exception e)
{}

Integer USERCODE=(Integer)session.getValue("ucode");
k=DbBean.connect();
ResultSet rs3=DbBean.execSQL("select userlevel as ul from usermaster where usercode='" + USERCODE + "'");
//ctrUC=rscount.getInt("cntUsercode");
while(rs3.next())
{
level=rs3.getInt("ul");
//USERCODE=(Integer)session.getValue("ucode");
}
DbBean.close();
String LOCATIONID=(String)session.getValue("lid"), POSTEDBY=(String)session.getValue("uname");
boolean chkdata=false,ok=false;
//boolean ok=false;
int act=0,ctrUC=0,ctrUC1=0,inst=0,W=0,g=0,nw=0,totcnt=0,txtcnt=0,txtcnt1=0,a=0,b=0;
java.text.SimpleDateFormat dd = new java.text.SimpleDateFormat("dd");
java.util.Date d1 = new java.util.Date();
String dy;
int dte=0,i=0;
//int i=0;
java.text.SimpleDateFormat mm = new java.text.SimpleDateFormat("MM");
java.util.Date dm = new java.util.Date();
String mon ;
java.text.SimpleDateFormat yr = new java.text.SimpleDateFormat("yyyy");
java.util.Date d = new java.util.Date();
String yer ;
int ii;
int yt;
int yt1;
java.util.Date DATESIGN = new java.util.Date();
String FDT="";
FDT=request.getParameter("selD") + "-" + request.getParameter("selM") + "-" + request.getParameter("selY");

//////////////////////////////////NEW VARIABLE//////////////////////////////////////////
//////New Data Defination/////
String POSTDATE="";
int YRENDING=0;
String REGNO="",LICENUMOFFACT="",SECT2Mi="",SECT2Mii="",SECCHEMI="",SECNONCHEM="",FACTORYNAME="",
OCCUPIERNAME="",MANAGERNAME="",DISTRICT="",POSTALADDRESS="",INDUSTRYNATURE="",NICCODE="",
PUBLICSEC="",JOINTSEC="",COOPERSEC="",PRIVATSEC="";
int YRMANDAYWORKED=0,NUMOFWEEKS=0,NMDWADULTMEN=0,NMDWADULTWOMEN=0,NMDWADOLMALE=0,NMDWADOLFEMALE=0,
NMDWCHILBOYS=0,NMDWCHILGIRLS=0,NMDWTOTAL=0,AVGNEADULTMEN=0,AVGNEADULTWOMEN=0,AVGNEADOLMALE=0,AVGNEADOLFEMALE=0,
AVGNECHILBOYS=0,AVGNECHILGIRLS=0,TOTAVGWORKERS=0,TOTMHWADULMEN=0,TOTMHWADULWOMEN=0,TOTMHWYPMEN=0,
TOTMHWYPWOMEN=0,TOTMHWYPTOT=0,AVGNHWADULMEN=0,AVGNHWADULWOMEN=0,AVGNHWADULMALE=0,AVGNHWADULFEMALE=0,AVGNHWADULTOT=0;
String NAMEOFASPSCHEDUEL="";

int MBHSPITALBED=0;
String QUALIFICATION="",MGRNAME="",MGRADDPHONE="";

///////
String Qry="";
/////New Data Defination/////
////////ReUsableValues////

String COMMITTEE="",COMMITTEE1="",FORMLHELTH1="",FORMLHELTH="",GOTONSITE1="",GOTONSITE="",REVISED1="",REVISED="",
OFFSITEEMR1="",OFFSITEEMR="",AMBUROOM1="",AMBUROOM="",LADYDOCTOR1="",LADYDOCTOR="",MIDWIFE1="",MIDWIFE="",
CRECHEPROVIDE1="",CRECHEPROVIDE="",MANAGEDDEPT1="",MANAGEDDEPT="",MANAGEDCONT1="",MANAGEDCONT="",RESTROOM1="",RESTROOM="",LUNCHROOM1="",LUNCHROOM="",
CRECHE1="",CRECHE="",SUGGSCH1="",SUGGSCH="",REMARKS="",REMARKSNOS="",NMEDICALOFF="",MENWORKED1="",WOMENWORKED1="",EMPDADULTMALE1="",EMPDADULTFEMALE1="",
CHILDRENWORKED1="",GIRLSWORKED1="",AVGDAILYEMPDADULT1="",AVGDAILYEMPDADULTWOMEN1="",AVGDAILYEMPDADULTMALE1="",AVGDAILYEMPDADULTFEMALE1="",
AVGDAILYEMPDCHDMALE1="",AVGDAILYEMPDCHDFEMALE1="",TOTMANHRSWORKEDMEN1="",TOTMANHRSWORKEDWOMEN1="",AVGNOHRSPERDAYWOMEN1="",AVGNOHRSPERDAYCHD1="",TOTMANHRSWORKEDCHD1="",
YOUNGFEM1="",AVGNOHRSPERDAYMEN1="",YOUNGFEMALE1="",TOTEMPDTHISYRMEN1="",TOTEMPDTHISYRWOMEN1="",TOTEMPDTHISYRCHD1="",DTHISYRFEMALE1=""
,TOTWRKENTLEAVESMEN1="",TOTWRKENTLEAVESWOMEN1="",TOTWRKENTLLEAVESCHD1="",WRKWGLFEMALE1="",TOTWRKGRDLEAVESMEN1="",TOTWRKGRDLEAVESWOMEN1="",TOTWRKGRDLEAVESCHD1="",
WRKGLFMALE1="",NODISWORKERS1="",NOWRKPAIDLEAVE1="",SAFETYOFFAPPTD1="",MORETHAN1="",LASTREVISED1="",RETAINSHIP1="",VANSAVAI1="",PARTTIMED1="",
VANAMBUL1="",FULLTIMEF1="",AMBUVANS1="",ROOMPROV1="",AVGNEADULTMALE="",AVGNEADULTFEMALE="",
AFTERDELIVE1="";

int USERCODE1=0;
String POSTDATE1="",FORMID1="",LOCATIONID1="";
int YRENDING1=0;
String REGNO1="",LICENUMOFFACT1="",SECT2Mi1="",SECT2Mii1="",SECCHEMI1="",SECNONCHEM1="",FACTORYNAME1="",
OCCUPIERNAME1="",MANAGERNAME1="",DISTRICT1="",POSTALADDRESS1="",INDUSTRYNATURE1="",NICCODE1="",
PUBLICSEC1="",JOINTSEC1="",COOPERSEC1="",PRIVATSEC1="";
int YRMANDAYWORKED1=0,NUMOFWEEKS1=0,NMDWADULTMEN1=0,NMDWADULTWOMEN1=0,NMDWADOLMALE1=0,NMDWADOLFEMALE1=0,
NMDWCHILBOYS1=0,NMDWCHILGIRLS1=0,NMDWTOTAL1=0,AVGNEADULTMEN1=0,AVGNEADULTWOMEN1=0,AVGNEADOLMALE1=0,AVGNEADOLFEMALE1=0,
AVGNECHILBOYS1=0,AVGNECHILGIRLS1=0,TOTAVGWORKERS1=0,TOTMHWADULMEN1=0,TOTMHWADULWOMEN1=0,TOTMHWYPMEN1=0,
TOTMHWYPWOMEN1=0,TOTMHWYPTOT1=0,AVGNHWADULMEN1=0,AVGNHWADULWOMEN1=0,AVGNHWADULMALE1=0,AVGNHWADULFEMALE1=0,AVGNHWADULTOT1=0;
String NAMEOFASPSCHEDUEL1="";

//////////////////////////////////NEW VARIABLE END//////////////////////////////////////////
//String sttt=request.getParameter("txtACCIOCCOR");
//out.println(sttt);
try
{
act=Integer.parseInt((request.getParameter("MODE")).trim());
}
catch(Exception e)
{
act=0;
}
/*String[] DANGOPENAME;
String[] NAMEDANGOPE;
String[] GOPENAMEDAN;
String[] MEDGOPENA;
String[] PENAMEDGO;
int[] AVGEMPDINOPE;
String[] AVGEMPDINOPE1;*/

/*String[] SFTOPENAME;
String[] SFTDANGOPE;
String[] SFTEAMEDAN;
String[] SFTGOPENA;
String[] SFTNAMEDGO;
int[] SFTDINOPE;
String[] SFTDINOPE1;*/
txtcnt=1;
//txtcnt1=1;
try
{
txtcnt=Integer.parseInt((request.getParameter("totcnt")).trim());
//txtcnt1=Integer.parseInt((request.getParameter("totcnt1")).trim());
}
catch(Exception e)
{}
%>
<%
/////////////////////////////////////////////////////////////////////////////
try
{
FORMID=FORMID.trim();
if(FORMID==""| FORMID==null | FORMID.length() < 2)
{
FORMID=idform(request.getParameter("fid"),"FAFORM24GJMASTER");
try
{
ctrUC=0;
Qry="";
k=DbBean.connect();
ResultSet rscount=DbBean.execSQL("Select FORMCOUNT as countfrmid from locformtrack where LOCATIONID='" + LOCATIONID.trim() + "'");
while(rscount.next())
{
ctrUC=rscount.getInt("countfrmid");
}
DbBean.close();
if (ctrUC==0)
{
ctrUC=ctrUC+1;
Qry="insert into locformtrack (LOCATIONID,FORMCOUNT) values('" + LOCATIONID.trim()+ "'," + ctrUC + ")";
}
else
{
ctrUC=ctrUC+1;
Qry="Update locformtrack set FORMCOUNT=" + ctrUC+ " where LOCATIONID='" + LOCATIONID.trim() + "'";
}
DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();
}
catch(Exception e)
{}
}
else
{
Qry="delete from FAFORM24GJMASTER where FORMID='" + FORMID.trim() + "'";
k=DbBean.connect();
DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();

}

if(FORMID.length()>7)
{
//////////////////////////////////COLUMN NAME///////////////////////////////////////////////////////

Qry="";
Qry ="Insert into FAFORM24GJMASTER(";
Qry ="USERCODE,POSTDATE,FORMID,LOCATIONID,YRENDING,REGNO,LICENUMOFFACT,SECT2Mi,SECT2Mii,SECCHEMI,SECNONCHEM";
Qry = Qry +"FACTORYNAME,OCCUPIERNAME,MANAGERNAME,DISTRICT,POSTALADDRESS,INDUSTRYNATURE,NICCODE,PUBLICSEC";
Qry = Qry +"JOINTSEC,COOPERSEC,PRIVATSEC,YRMANDAYWORKED,NUMOFWEEKS,NMDWADULTMEN,NMDWADULTWOMEN";
Qry = Qry +"NMDWADOLMALE,NMDWADOLFEMALE,NMDWCHILBOYS,NMDWCHILGIRLS,NMDWTOTAL,AVGNEADULTMEN";
Qry = Qry +"AVGNEADULTWOMEN,AVGNEADOLMALE,AVGNEADOLFEMALE,AVGNECHILBOYS,AVGNECHILGIRLS,TOTAVGWORKERS";
Qry = Qry +"TOTMHWADULMEN,TOTMHWADULWOMEN,TOTMHWYPMEN,TOTMHWYPWOMEN,TOTMHWYPTOT,AVGNHWADULMEN,AVGNHWADULWOMEN";
Qry = Qry +"AVGNHWADULMALE,AVGNHWADULFEMALE,AVGNHWADULTOT)" +
/////////////////////////////////VALUES///////////////////////////////////////////////////////////////

" values(" + USERCODE + ",sysdate,'" + FORMID.trim() + "','" + LOCATIONID + "'," +
// Qry= "'" + USERCODE + "', sysdate,'" + FORMID.trim() + "','" + LOCATIONID + "'";
"" + Integer.parseInt(request.getParameter("txtYRENDING")) + "," +
"'" + replacestr(request.getParameter("txtREGNO").trim()) + "'," +
"'" + replacestr(request.getParameter("txtLICENUMOFFACT").trim()) + "'," +
"'" + replacestr(request.getParameter("chkSECT2Mi").trim()) + "'," +
"'" + replacestr(request.getParameter("chkSECT2Mii").trim()) + "'," +

"'" + replacestr(request.getParameter("chkSECCHEMI").trim()) + "'," +
"'" + replacestr(request.getParameter("chkSECNONCHEM").trim()) + "'," +
"'" + replacestr(request.getParameter("txtFACTORYNAME").trim()) + "'," +
"'" + replacestr(request.getParameter("txtOCCUPIERNAME").trim()) + "'," +
"'" + replacestr(request.getParameter("txtMANAGERNAME").trim()) + "'," +
"'" + replacestr(request.getParameter("txtDISTRICT").trim()) + "'," +

"'" + replacestr(request.getParameter("txtPOSTALADDRESS").trim()) + "'," +
"'" + replacestr(request.getParameter("txtINDUSTRYNATURE").trim()) + "'," +
"'" + replacestr(request.getParameter("txtNICCODE").trim()) + "'," +
"'" + replacestr(request.getParameter("chkPUBLICSEC").trim()) + "'," +
"'" + replacestr(request.getParameter("chkJOINTSEC").trim()) + "'," +
"'" + replacestr(request.getParameter("chkCOOPERSEC").trim()) + "'," +

"'" + replacestr(request.getParameter("chkPRIVATSEC").trim()) + "'," +
"to_Number('" + request.getParameter("txtYRMANDAYWORKED" ) + "')," +
"to_Number('" + request.getParameter("txtNUMOFWEEKS" ) + "')," +
"to_Number('" + request.getParameter("txtNMDWADULTMEN" ) + "')," +
"to_Number('" + request.getParameter("txtNMDWADULTWOMEN" ) + "')," +
"to_Number('" + request.getParameter("txtNMDWADOLMALE" ) + "')," +

"to_Number('" + request.getParameter("txtNMDWADOLFEMALE" ) + "')," +
"to_Number('" + request.getParameter("txtNMDWCHILBOYS" ) + "')," +
"to_Number('" + request.getParameter("txtNMDWCHILGIRLS" ) + "')," +
"to_Number('" + request.getParameter("txtNMDWTOTAL" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNEADULTMEN" ) + "')," +

"to_Number('" + request.getParameter("txtAVGNEADULTWOMEN" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNEADOLMALE" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNEADOLFEMALE" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNECHILBOYS" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNECHILGIRLS" ) + "')," +

"to_Number('" + request.getParameter("txtTOTAVGWORKERS" ) + "')," +
"to_Number('" + request.getParameter("txtTOTMHWADULMEN" ) + "')," +
"to_Number('" + request.getParameter("txtTOTMHWADULWOMEN" ) + "')," +
"to_Number('" + request.getParameter("txtTOTMHWYPMEN" ) + "')," +
"to_Number('" + request.getParameter("txtTOTMHWYPWOMEN" ) + "')," +
"to_Number('" + request.getParameter("txtTOTMHWYPTOT" ) + "')," +

"to_Number('" + request.getParameter("txtAVGNHWADULMEN" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNHWADULWOMEN" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNHWADULMALE" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNHWADULFEMALE" ) + "')," +
"to_Number('" + request.getParameter("txtAVGNHWADULTOT" ) + "')";

/////////////////MAIN INSERT INTO QUERY//////////////////////////////////
k=DbBean.connect();
DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();

g=0;
Qry="";
Qry="commit";
k=DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();
Qry="";
g=0;
/*while(g<txtcnt)
{
if((request.getParameter("txtDANGOPENAME" + g)).length()>0)
{
Qry="";
Qry="insert into FAForm24GJDetails (FORMID,DANGOPENAME,NAMEDANGOPE,GOPENAMEDAN,MEDGOPENA,PENAMEDGO,AVGEMPDINOPE) values('" + FORMID.trim() + "','" + replacestr( request.getParameter("txtDANGOPENAME" + g)) + "','" + replacestr( request.getParameter("txtNAMEDANGOPE" + g)) + "','" + replacestr( request.getParameter("txtGOPENAMEDAN" + g)) + "','" + replacestr( request.getParameter("txtMEDGOPENA" + g)) + "','" + replacestr( request.getParameter("txtPENAMEDGO" + g)) + "',to_Number('" + request.getParameter("txtAVGEMPDINOPE" + g) + "'))";
k=DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();
}
g=g+1;
}*/
g=0;
Qry="";
Qry="commit";
k=DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();
ok=true;
/*while(g<txtcnt1)
{
if((request.getParameter("txtSFTOPENAME" + g)).length()>0)
{
Qry="";
Qry="insert into FAForm24GJDetails1 (FORMID,SFTOPENAME,SFTDANGOPE,SFTEAMEDAN,SFTGOPENA,SFTNAMEDGO,SFTDINOPE) values('" + FORMID.trim() + "','" + replacestr( request.getParameter("txtSFTOPENAME" + g)) + "','" + replacestr( request.getParameter("txtSFTDANGOPE" + g)) + "','" + replacestr( request.getParameter("txtSFTEAMEDAN" + g)) + "','" + replacestr( request.getParameter("txtSFTGOPENA" + g)) + "','" + replacestr( request.getParameter("txtSFTNAMEDGO" + g)) + "',to_Number('" + request.getParameter("txtSFTDINOPE" + g) + "'))";
k=DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();
}
g=g+1;
}*/
g=0;
Qry="";
Qry="commit";
k=DbBean.connect();
inst=DbBean.updateSQL(Qry);
DbBean.close();
ok=true;
response.sendRedirect("Form24GJ.jsp?FORMID=" + FORMID + "&msg=0");
//}
} // end of try
catch(Exception e)
{
response.sendRedirect("Form24GJ.jsp?FORMID=" + FORMID + "&msg=1");
}
} // end if condition
//if(act==1)CONDITION CLOSED;
//------------------------------------------Delete all records then Insert with same formid ----------------------------------------
if(FORMID !="")
{
k=DbBean.connect();

ResultSet rscount=DbBean.execSQL("select count(FORMID) FORMID from FAForm24GJDetails where FORMID='" + FORMID + "'");
while(rscount.next())
{
ctrUC=rscount.getInt("FORMID");
}
ResultSet rscount1=DbBean.execSQL("select count(FORMID) FORMID from FAForm24GJDetails1 where FORMID='" + FORMID + "'");
while(rscount1.next())
{
ctrUC1=rscount1.getInt("FORMID");
}
DbBean.close();
chkdata=false;
}
if(act==0 | act==1 | act==2)
{
txtcnt=ctrUC;
//txtcnt1=ctrUC1;
}
if(txtcnt==0)
{
txtcnt=1;
}
/*if(txtcnt1==0)
{
txtcnt1=1;
}*/
/* DANGOPENAME=new String[txtcnt];
NAMEDANGOPE=new String[txtcnt];
GOPENAMEDAN=new String[txtcnt];
MEDGOPENA=new String[txtcnt];
PENAMEDGO=new String[txtcnt];
AVGEMPDINOPE= new int[txtcnt];
AVGEMPDINOPE1= new String[txtcnt];*/

/*SFTOPENAME=new String[txtcnt1];
SFTDANGOPE=new String[txtcnt1];
SFTEAMEDAN=new String[txtcnt1];
SFTGOPENA=new String[txtcnt1];
SFTNAMEDGO=new String[txtcnt1];
SFTDINOPE=new int[txtcnt1];
SFTDINOPE1=new String[txtcnt1];*/
/*W=0;
DANGOPENAME[W]="";
NAMEDANGOPE[W]="";
GOPENAMEDAN[W]="";
MEDGOPENA[W]="";
PENAMEDGO[W]="";
AVGEMPDINOPE[W]=0;
AVGEMPDINOPE1[W]="";*/
/*W=0;
SFTOPENAME[W]="";
SFTDANGOPE[W]="";
SFTEAMEDAN[W]="";
SFTGOPENA[W]="";
SFTNAMEDGO[W]="";
SFTDINOPE[W]=0;
SFTDINOPE1[W]="";*/
POSTDATE="";
YRENDING=0;
REGNO="";
LICENUMOFFACT="";
SECT2Mi="";

SECT2Mii="";
SECCHEMI="";
SECNONCHEM="";
FACTORYNAME="";
OCCUPIERNAME="";

MANAGERNAME="";
DISTRICT="";
POSTALADDRESS="";
INDUSTRYNATURE="";
NICCODE="";

PUBLICSEC="";
JOINTSEC="";
COOPERSEC="";
PRIVATSEC="";
YRMANDAYWORKED=0;

NUMOFWEEKS=0;
NMDWADULTMEN=0;
NMDWADULTWOMEN=0;
NMDWADOLMALE=0;
NMDWADOLFEMALE=0;

NMDWCHILBOYS=0;
NMDWCHILGIRLS=0;
NMDWTOTAL=0;
AVGNEADULTMEN=0;
AVGNEADULTWOMEN=0;

AVGNEADOLMALE=0;
AVGNEADOLFEMALE=0;
AVGNECHILBOYS=0;
AVGNECHILGIRLS=0;
TOTAVGWORKERS=0;

TOTMHWADULMEN=0;
TOTMHWADULWOMEN=0;
TOTMHWYPMEN=0;
TOTMHWYPWOMEN=0;
TOTMHWYPTOT=0;

AVGNHWADULMEN=0;
AVGNHWADULWOMEN=0;
AVGNHWADULMALE=0;
AVGNHWADULFEMALE=0;
AVGNHWADULTOT=0;

chkdata=false;
SimpleDateFormat fmt=new SimpleDateFormat("dd-MM-yyyy");
if(ctrUC>=0)
//if(ctrUC>0 | ctrUC1>0 )
{
k=DbBean.connect();
/*rs=DbBean.execSQL("select * from FAFORM24GJMASTER where FORMID='" + FORMID +"'");
while(rs.next())
{*/
rs=DbBean.execSQL("select * from FAFORM24GJMASTER where FORMID='" + FORMID +"'");
while(rs.next())
{
YRENDING= rs.getInt("YRENDING");
REGNO=rs.getString("REGNO");
LICENUMOFFACT=rs.getString("LICENUMOFFACT");
SECT2Mi=rs.getString("SECT2Mi");
SECT2Mii=rs.getString("SECT2Mii");

SECCHEMI=rs.getString("SECCHEMI");
SECNONCHEM=rs.getString("SECNONCHEM");
FACTORYNAME=rs.getString("FACTORYNAME");
OCCUPIERNAME=rs.getString("OCCUPIERNAME");
MANAGERNAME=rs.getString("MANAGERNAME");
DISTRICT=rs.getString("DISTRICT");

POSTALADDRESS=rs.getString("POSTALADDRESS");
INDUSTRYNATURE=rs.getString("INDUSTRYNATURE");
NICCODE=rs.getString("NICCODE");
PUBLICSEC=rs.getString("PUBLICSEC");
JOINTSEC=rs.getString("JOINTSEC");
COOPERSEC=rs.getString("COOPERSEC");

PRIVATSEC= rs.getString("PRIVATSEC");
YRMANDAYWORKED= rs.getInt("YRMANDAYWORKED");
NMDWADULTMEN= rs.getInt("NMDWADULTMEN");
NMDWADULTWOMEN= rs.getInt("NMDWADULTWOMEN");
NMDWADOLMALE= rs.getInt("NMDWADOLMALE");
NMDWADOLFEMALE= rs.getInt("NMDWADOLFEMALE");
NMDWCHILBOYS= rs.getInt("NMDWCHILBOYS");

NMDWCHILGIRLS= rs.getInt("NMDWCHILGIRLS");
NMDWTOTAL= rs.getInt("NMDWTOTAL");
AVGNEADULTMEN= rs.getInt("AVGNEADULTMEN");
AVGNEADULTWOMEN= rs.getInt("AVGNEADULTWOMEN");
AVGNEADOLMALE= rs.getInt("AVGNEADOLMALE");

AVGNEADOLFEMALE= rs.getInt("AVGNEADOLFEMALE");
AVGNECHILBOYS= rs.getInt("AVGNECHILBOYS");
AVGNECHILGIRLS= rs.getInt("AVGNECHILGIRLS");
TOTAVGWORKERS= rs.getInt("TOTAVGWORKERS");
TOTMHWADULMEN= rs.getInt("TOTMHWADULMEN");
TOTMHWADULWOMEN= rs.getInt("TOTMHWADULWOMEN");
TOTMHWYPMEN= rs.getInt("TOTMHWYPMEN");
TOTMHWYPWOMEN= rs.getInt("TOTMHWYPWOMEN");

TOTMHWYPTOT= rs.getInt("TOTMHWYPTOT");
AVGNHWADULWOMEN= rs.getInt("AVGNHWADULWOMEN");
AVGNHWADULMALE= rs.getInt("AVGNHWADULMALE");
AVGNHWADULFEMALE= rs.getInt("AVGNHWADULFEMALE");

AVGNHWADULTOT= rs.getInt("AVGNHWADULTOT");

}
//}
}
DbBean.close();
//if((chkdata==true) & (act !=3))
//{
java.text.SimpleDateFormat dtfmt = new java.text.SimpleDateFormat("dd-MM-yyyy");
// W=0;
//rs=0;
k=DbBean.connect();
// rs=DbBean.execSQL("select * from FAForm24GJDetails where FORMID='" + FORMID + "'");
/*try
{
while(rs.next())
{
DANGOPENAME[W]=rs.getString("DANGOPENAME");
NAMEDANGOPE[W]=rs.getString("NAMEDANGOPE");
GOPENAMEDAN[W]=rs.getString("GOPENAMEDAN");
MEDGOPENA[W]=rs.getString("MEDGOPENA");
PENAMEDGO[W]=rs.getString("PENAMEDGO");
AVGEMPDINOPE[W]=rs.getInt("AVGEMPDINOPE");
AVGEMPDINOPE1[W]=Integer.toString(AVGEMPDINOPE[W]);
W++;
}
W=0;*/
/*rs=DbBean.execSQL("select * from FAForm24GJDetails1 where FORMID='" + FORMID + "'");
while(rs.next())
{
SFTOPENAME[W]=rs.getString("SFTOPENAME");
SFTDANGOPE[W]=rs.getString("SFTDANGOPE");
SFTEAMEDAN[W]=rs.getString("SFTEAMEDAN");
SFTGOPENA[W]=rs.getString("SFTGOPENA");
SFTNAMEDGO[W]=rs.getString("SFTNAMEDGO");
SFTDINOPE[W]=rs.getInt("SFTDINOPE");
SFTDINOPE1[W]=Integer.toString(SFTDINOPE[W]);
W++;
}*/
//}
/* }
catch(Exception e)
{
out.println("Error :: " + W + ":: "+ e);
} */
//}
if(act==3)
{
YRENDING=Integer.parseInt(request.getParameter("txtYRENDING"));
REGNO=request.getParameter("txtREGNO").trim();
LICENUMOFFACT=request.getParameter("txtLICENUMOFFACT").trim();
FACTORYNAME=request.getParameter("txtFACTORYNAME").trim();

OCCUPIERNAME=request.getParameter("txtOCCUPIERNAME").trim();
MANAGERNAME=request.getParameter("txtMANAGERNAME").trim();
DISTRICT=request.getParameter("txtDISTRICT").trim();
POSTALADDRESS=request.getParameter("txtPOSTALADDRESS").trim();
REMARKS=request.getParameter("txtREMARKS").trim();

REMARKSNOS=request.getParameter("txtREMARKSNOS").trim();
INDUSTRYNATURE=request.getParameter("txtINDUSTRYNATURE").trim();
NICCODE=request.getParameter("txtNICCODE").trim();
NMEDICALOFF=request.getParameter("txtNMEDICALOFF").trim();
QUALIFICATION=request.getParameter("txtQUALIFICATION").trim();

YRMANDAYWORKED1=Integer.parseInt(request.getParameter("txtYRMANDAYWORKED"));
NUMOFWEEKS1=Integer.parseInt(request.getParameter("txtNUMOFWEEKS"));

try
{
i=Integer.parseInt(request.getParameter("rCheck"));
if(i==1)
{
a=txtcnt-1;
//b=txtcnt1;
}
else
{
a=txtcnt;
//b=txtcnt1-1;
}
/*W=0;
while(W< a)
{
DANGOPENAME[W]=request.getParameter("txtDANGOPENAME" + W);
NAMEDANGOPE[W]=request.getParameter("txtNAMEDANGOPE" +W);
GOPENAMEDAN[W]=request.getParameter("txtGOPENAMEDAN" +W);
MEDGOPENA[W]=request.getParameter("txtMEDGOPENA" +W);
PENAMEDGO[W]=request.getParameter("txtPENAMEDGO" +W);
AVGEMPDINOPE1[W]=request.getParameter("txtAVGEMPDINOPE" + W);
W++;
}
DANGOPENAME[W]="";
NAMEDANGOPE[W]="";
GOPENAMEDAN[W]="";
MEDGOPENA[W]="";
PENAMEDGO[W]="";
AVGEMPDINOPE[W]=0;
AVGEMPDINOPE1[W]="";*/
/*W=0;
while(W< b)
{
SFTOPENAME[W]=request.getParameter("txtSFTOPENAME" + W);
SFTDANGOPE[W]=request.getParameter("txtSFTDANGOPE" + W);
SFTEAMEDAN[W]=request.getParameter("txtSFTEAMEDAN" + W);
SFTGOPENA[W]=request.getParameter("txtSFTGOPENA" + W);
SFTNAMEDGO[W]=request.getParameter("txtSFTNAMEDGO" + W);
SFTDINOPE1[W]=request.getParameter("txtSFTDINOPE" + W);
W++;
}
SFTOPENAME[W]="";
SFTDANGOPE[W]="";
SFTEAMEDAN[W]="";
SFTGOPENA[W]="";
PENAMEDGO[W]="";
SFTNAMEDGO[W]="";
SFTDINOPE1[W]="";*/
}
catch(Exception e)
{}
}
//}
%>
<%
try
{
if (level==1)
{
k=DbBean.connect();
ResultSet rs1=DbBean.execSQL("select locationname from locationmaster where locationid='" +LOCATIONID+ "'");
if(rs1.next())
{
FACTORYNAME = rs1.getString(1);
}
}
}
catch (Exception Ex)
{
FACTORYNAME="";
}//rsl =null;
DbBean.close();
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script language="javascript" src="../../JavaScriptsFiles/cal2.js"></script>
<script language="javascript" src="../../JavaScriptsFiles/cal_conf2.js"></script>

<%! String replacestr(String str)
{
str = str.replaceAll( "'","''" );
return str;
}
String getSelection(String str1,String str2)
{
if(str1.equalsIgnoreCase(str2))
{
return "selected";
}
else
{
return "";
}
}
String getChecked(String str1,String str2)
{
if(str1.equalsIgnoreCase(str2))
{
return "checked";
}
else
{
return "";
}
}
%>
<script language="JavaScript">
function chklength(txt)
{
if(document.Form24GJ[txt].value.length > 255)
{
document.Form24GJ[txt].focus();
alert("Error: More than 255 character!")
var str=document.Form24GJ[txt].value.substr(0,254);
document.Form24GJ[txt].value=str;
}
}
/*function chknum(txt)
{
if(isNaN(document.Form24GJ[txt].value)==true)
{
document.Form24GJ[txt].value=0;
alert("Error: Please select number!")
}
}*/

/*function chklength(txt)
{
if(document.Form24GJ[txt].value.length > 230)
{
document.Form24GJ[txt].focus();
alert("Error: More than 255 character!")
var str=document.Form24GJ[txt].value.substr(0,230);
document.Form24GJ[txt].value=str;
}
}*/
/*function datechk(DY,MN,YR)
{
if( YR > 4000 | DY >31 | MN > 12 | YR < 1900 )
{
alert("Error : Invalid date format!" );
return false;
}
else
{
if(YR%4==0)
{
if((MN=="02") & (parseInt(DY)>29))
{
alert("Error: Invalid selection of day in February Month ");
return false;
}
}
else
{
if((MN=="02") & (parseInt(DY)>28))
{
alert("Error: Invalid selection of day in February Month ");
return false;
}

}
if(parseInt((MN) >8 & parseInt(MN)%2 !=0 ) &(parseInt(DY)>30))
{
alert("Error: Invalid selection of day in selected Month! ");
return false;
}
else
{
if(parseInt((MN) <=7 & parseInt(MN)%2 ==0 ) &(parseInt(DY)>30))
{
alert("Error: Invalid selection of day in selected Month! ");
return false;
}
else
{
return true;
}
}
}
}*/
/*function newRow(md)
{
document.Form24GJ.method="POST";
document.Form24GJ.action="Form24GJ.jsp?MODE=" + md + "&totcnt=<%=(txtcnt +1)%>";
document.Form24GJ.submit();
}

/*function newRow1(md)
{
document.Form24GJ.method="POST";
document.Form24GJ.action="Form24GJ.jsp?MODE=" + md + "&totcnt1=<%=(txtcnt1 +1)%>&totcnt=<%=(txtcnt)%>&rCheck=2";
document.Form24GJ.submit();
}*/
function fldchk()
{
var ii,jj;
ii=0;
//jj=<%=(txtcnt)%>;
//var fldid=["txtDANGOPENAME","txtNAMEDANGOPE","txtGOPENAMEDAN","MEDGOPENA","txtPENAMEDGO","txtAVGEMPDINOPE"];
/*if(trimString(document.Form24GJ.txtREGNO.value)=="")
{
alert("Registration no. cannot be blank!" );
document.Form24GJ.txtREGNO.focus()
return false;
}
alert("There is error");
else if(trimString(document.Form24GJ.txtFACTORYNAME.value)=="")
{
alert("Factory name cannot be blank!" );
document.Form24GJ.txtFACTORYNAME.focus()
return false;
}
else if(trimString(document.Form24GJ.txtOCCUPIERNAME.value)=="")
{
alert("Occuper name cannot be blank!" );
document.Form24GJ.txtOCCUPIERNAME.focus()
return false;
}
else if(trimString(document.Form24GJ.txtMANAGERNAME.value)=="")
{
alert("Manager cannot be blank!" );
document.Form24GJ.txtMANAGERNAME.focus()
return false;
}
else if(trimString(document.Form24GJ.txtDISTRICT.value)=="")
{
alert("District cannot be blank!" );
document.Form24GJ.txtDISTRICT.focus()
return false;
}
else if(trimString(document.Form24GJ.txtPOSTALADDRESS.value)=="")
{
alert("Postal address cannot be blank!" );
document.Form24GJ.txtPOSTALADDRESS.focus()
return false;
}
else if(trimString(document.Form24GJ.txtINDUSTRYNATURE.value)=="")
{
alert("Industry nature cannot be blank!" );
document.Form24GJ.txtINDUSTRYNATURE.focus()
return false;
}
else if(trimString(document.Form24GJ.txtYRMANDAYWORKED.value)=="")
{
alert("Man days in a year cannot be blank!" );
document.Form24GJ.txtYRMANDAYWORKED.focus()
return false;
}*/

/*else if(isNaN(document.Form24GJ.txtYRMANDAYWORKED.value)==true | isNaN(document.Form24GJ.txtMENWORKED.value)==true | isNaN(document.Form24GJ.txtWOMENWORKED.value)==true | isNaN(document.Form24GJ.txtCHILDRENWORKED.value)==true | isNaN(document.Form24GJ.txtAVGDAILYEMPDADULT.value)==true | isNaN(document.Form24GJ.txtAVGDAILYEMPDADULTWOMEN.value)==true | isNaN(document.Form24GJ.txtAVGDAILYEMPDADULTMALE.value)==true | isNaN(document.Form24GJ.txtAVGDAILYEMPDADULTFEMALE.value)==true)
{
alert("Error: Not a valid Number!");
return false;
}
else if(isNaN(document.Form24GJ.txtAVGDAILYEMPDCHDMALE.value)==true | isNaN(document.Form24GJ.txtAVGDAILYEMPDCHDFEMALE.value)==true | isNaN(document.Form24GJ.txtTOTMANHRSWORKEDMEN.value)==true | isNaN(document.Form24GJ.txtTOTMANHRSWORKEDWOMEN.value)==true | isNaN(document.Form24GJ.txtTOTMANHRSWORKEDCHD.value)==true | isNaN(document.Form24GJ.txtNODISWORKERS.value)==true | isNaN(document.Form24GJ.txtNOWRKPAIDLEAVE.value)==true )
{
alert("Error: Not a valid Number!");
return false;
}
else if(isNaN(document.Form24GJ.txtSAFETYOFFAPPTD.value)==true | isNaN(document.Form24GJ.txtNOWELOFFREQD.value)==true | isNaN(document.Form24GJ.txtNOWELOFFAPPTD.value)==true | isNaN(document.Form24GJ.txtFATALACCIDENT.value)==true | isNaN(document.Form24GJ.txtNONFATALACCIDENT.value)==true | isNaN(document.Form24GJ.txtNOACCDTWRKRETND.value)==true | isNaN(document.Form24GJ.txtMANDAYLOST.value)==true | isNaN(document.Form24GJ.txtNOACCDTWRKRETNDPREV.value)==true)
{
alert("Error: Not a valid Number!");
return false;
}
else if(isNaN(document.Form24GJ.txtMANDAYLOSTPREV.value)==true | isNaN(document.Form24GJ.txtNOACCDTWRKNOTRETND.value)==true | isNaN(document.Form24GJ.txtMANDAYLOSTNOTRETND.value)==true | isNaN(document.Form24GJ.txtRECVDSUGG.value)==true | isNaN(document.Form24GJ.txtACCPDSUGG.value)==true | isNaN(document.Form24GJ.txtTOTAMTAWD.value)==true | isNaN(document.Form24GJ.txtMAXCASHPRIZEAWD.value)==true)
{
alert("Error: Not a valid Number!");
return false;
}*/

else
{
while(ii<jj)
{
if(trimString(document.Form24GJ[fldid[0] + ii].value)=="" & trimString(document.Form24GJ[fldid[1] + ii].value)=="")
{
alert("Row : find blank row!");
document.Form24GJ[fldid[0] + ii].focus();
return false;
}
else if(trimString(document.Form24GJ[fldid[0] + ii].value)=="" | trimString(document.Form24GJ[fldid[1] + ii].value)=="")
{
alert("Error: Please check all fields!");
document.Form24GJ[fldid[0] + ii].focus();
return false;
}
else if(isNaN(document.Form24GJ[fldid[1] + ii].value)==true)
{
alert("Error: Please check all fields!");
document.Form24GJ[fldid[0] + ii].focus();
return false;
}
ii=ii+1;
}
return true;
}
}

// alert(document.Form24GJ[fldid[1] + ii].value);
/*if(trimString(document.Form24GJ[fldid[0] + ii].value)=="" & trimString(document.Form24GJ[fldid[1] + ii].value)=="")
{
alert("Row : find blank row!");
document.Form24GJ[fldid[0] + ii].focus();
return false;
}

else if(trimString(document.Form24GJ[fldid[0] + ii].value)=="" | trimString(document.Form24GJ[fldid[1] + ii].value)=="")
{
alert("Error: Please check all fields1!");
document.Form24GJ[fldid[0] + ii].focus();
return false;
}
else if(isNaN(document.Form24GJ[fldid[1] + ii].value)==true)
{
alert("Error: Please check all fields2!");
document.Form24GJ[fldid[0] + ii].focus();
return false;
}
ii=ii+1;
}
return true;
}
}*/
function trimString(str)
{
while (str.charAt(0) == ' ')
str = str.substring(1);
while (str.charAt(str.length - 1) == ' ')
str = str.substring(0, str.length - 1);
return str;
}

function send(md)
{
if(md=="4")
{
document.Form24GJ.method="POST";
document.Form24GJ.action="Form24GJ.jsp?MODE=" + md + "&totcnt=<%=(txtcnt)%>";
document.Form24GJ.submit();
}
else
{
if(datechk(document.Form24GJ.selD.value,document.Form24GJ.selM.value,document.Form24GJ.selY.value)==true)
{
//alert("**********NIDHI*********>" + md);
if(fldchk()==true)
{
//alert("*********FLDCHK---------IF CONDITION**********>" );
document.Form24GJ.method="POST";
document.Form24GJ.action="Form24GJ.jsp?MODE=" + md + "&totcnt=<%=(txtcnt)%>";
document.Form24GJ.submit();
}
//else
//{
//alert("*********FLDCHK--------ELSE CONDITION**********>" );
//}
//alert("**********NIDHI**how are you*******>" + md);
}
}
}

function clk(txt)
{

showCal('Calendar1',txt,"Form24GJ");
}
function tips_openWindow(theURL,winname,features)
{
window.open(theURL,winname,features);
}
</script>
</head>
<body>
<form id="Form24GJ" name="Form24GJ" method="POST">
<table width="75%" border="0" align="center" cellpadding="1" cellspacing="1">
<tr valign="top">
<td height="21" colspan="10"><div align="center">FORM
24//Gujrat </div></td>
</tr>
<tr valign="top">
<td height="20" colspan="10"> <div align="center">(Prescribed under clause(1) of Rule107) </div></td>
</tr>
<tr valign="top">
<td colspan="10" align="center">MASTER FORM IN RESPECT OF THE FACTORIES ACT, 1948.PAYMENT OF WAGES ACT 1936 MATERNITY BENIFIT ACT, 1961,WORKMEN'S COMPENSATION ACT,1923 AND AS APPLICABLE TO REGISTERED FACTORIES COVERED UNDER THE FACTORIES ACT, 1948. </td>
</tr>
<tr valign="top">
<td colspan="10" align="center">
ANNUAL RETURN </td>
</tr>
<tr valign="top">
<td height="24" colspan="9">
FOR THE YEAR ENDING 31st DECEMBER

<% if (act==4)
{
out.println(YRENDING);
}
else
{ %>
<select name="txtYRENDING" >
<%
yer = yr.format(DATESIGN);
if(yer.length()< 2)
{
yer = yr.format(d);
}
dte=0;
dte=Integer.parseInt(yer);
yt=0;
yt1=0;
yt=Integer.parseInt(yr.format(d));
yt1=yt;
yt1 = (yt1 - 4);
ii=0;
while(ii<10)
{
if((yt1 + ii)==dte)
{
out.println("<option value=" + (yt1 + ii) + " selected>" + (yt1 + ii) + "</option>");
}
else
{
out.println("<option value=" + (yt1 + ii) + ">" + (yt1 + ii) + "</option>");
}
ii=ii+1;
}
%>
</select>
<%}%>
 </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24" colspan="8"><div align="center">PART A </div></td>
</tr>
<tr valign="top">
<td width="1%" height="24"> </td>
<td height="24"> 1.
</td>
<td height="24">(a)</td>
<td height="24" colspan="3">Registration number of factory</td>
<td height="24" colspan="3">
<%
if(act==4)
{
out.println(REGNO);
}
else
{
%>
<input name="txtREGNO" type="text" id="txtREGNO" value="<%=REGNO%>" maxlength="50">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24"> </td>
<td height="24">(b)</td>
<td height="24" colspan="3">Licence Number of Factory </td>
<td height="24" colspan="3">
<%if(act==4)
{
out.println(LICENUMOFFACT);
}
else
{
%>

<input name="txtLICENUMOFFACT" type="text" id="txtLICENUMOFFACT" value="<%=LICENUMOFFACT%>">

<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24"> </td>
<td height="24">(c)</td>
<td height="24" colspan="6">Section of the Act under which the factory is coverd Please tick the approximate box </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24"> </td>
<td height="24"> </td>
<td height="24" colspan="6">
<%
if(act==4)
{
%>
<%= SECT2Mi.equals("1")?"<img src=Click.gif>":"" %>
<%
}
%>
<%
if(act!=4)
{
%>
<input name="chkSECT2Mi" type="checkbox" id="chkSECT2Mi" value="1" <%= getChecked("1",SECT2Mi) %>>
<%}%>
Section 2(m) (i) /////////Code of this four section is not completed </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24"> </td>
<td height="24"> </td>
<td height="24" colspan="6">
<%
if(act==4)
{
%>
<%= SECT2Mii.equals("1")?"<img src=Click.gif>":"" %>
<%
}
%>
<%
if(act!=4)
{
%>
<input name="chkSECT2Mii" type="checkbox" value="1" <%= getChecked("1",SECT2Mii) %>>
<%}%>
Section 2(m) (ii) </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24"> </td>
<td height="24"> </td>
<td height="24" colspan="6">
<%
if(act==4)
{
%>
<%= SECCHEMI.equals("1")?"<img src=Click.gif>":"" %>
<%
}
%>
<%
if(act!=4)
{
%>
<input name="chkSECCHEMI" type="checkbox" id="chkSECCHEMI" value="1" <%= getChecked("1",SECCHEMI) %>>
<%}%>
Section 85-Chemical </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24"> </td>
<td height="24"> </td>
<td height="24" colspan="6">
<%
if(act==4)
{
%>
<%= SECNONCHEM.equals("1")?"<img src=Click.gif>":"" %>
<%}%>
<%
if(act!=4)
{
%>
<input name="chkSECNONCHEM" type="checkbox" id="chkSECNONCHEM" value="1" <%= getChecked("1",SECNONCHEM) %>>
<%}%>
Section 85-non-chemical </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24" colspan="5">2.
Name of factory</td>
<td height="24" colspan="3">
<%
if(act==4)
{
out.println(FACTORYNAME);
}
else
{
%>
<input name="txtFACTORYNAME" type="text" id="txtFACTORYNAME" value="<%=FACTORYNAME%>" maxlength="100">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24" colspan="5"> 
3. Name of occupier</td>
<td colspan="3">
<%
if(act==4)
{
out.println(OCCUPIERNAME);
}
else
{
%>
<input name="txtOCCUPIERNAME" type="text" id="txtOCCUPIERNAME" value="<%=OCCUPIERNAME%>" maxlength="100">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24" colspan="5"> 4.
Name of the manager</td>
<td colspan="3">
<%
if(act==4)
{
out.println(MANAGERNAME);
}
else
{
%>
<input name="txtMANAGERNAME" type="text" id="txtMANAGERNAME" value="<%=MANAGERNAME%>" maxlength="100">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24" colspan="5">5.
District</td>
<td colspan="3">
<%
if(act==4)
{
out.println(DISTRICT);
}
else
{
%>
<input name="txtDISTRICT" type="text" id="txtDISTRICT" value="<%=DISTRICT%>" maxlength="50">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="30"> </td>
<td height="35" colspan="5">6. Full postal address of factory including PIN Code </td>
<td colspan="3">
<%
if(act==4)
{
out.println( "<pre>" + POSTALADDRESS +" </pre>");
}
else
{
%>
<textarea name="txtPOSTALADDRESS" id="textarea" onChange=javascript:chklength('txtPOSTALADDRESS'); ><%=POSTALADDRESS%></textarea>
<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td>7.</td>
<td colspan="7">Industry</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td>  </td>
<td>(a)</td>
<td>(i)</td>
<td colspan="3">Nature of industry Menction what is actualy manufactured, including repairs of all types, following the National Industrial Classification 1987 at the digit level) </td>
<td width="35" colspan="2">
<%
if(act==4)
{
out.println(INDUSTRYNATURE);
}
else
{
%>
<input name="txtINDUSTRYNATURE" type="text" id="txtINDUSTRYNATURE" value="<%=INDUSTRYNATURE%>" maxlength="100">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td> </td>
<td>(ii)</td>
<td colspan="3">NIC Code Number (4 digit as given in the Licence) </td>
<td colspan="2">
<%
if(act==4)
{
out.println(NICCODE);
}
else
{
%>

<input name="txtNICCODE" type="text" id="txtNICCODE" value="<%=NICCODE%>">

<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td>(b)</td>
<td> </td>
<td colspan="5">Sectory of Industry (Please tick() the appropriate box) </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td> </td>
<td> </td>
<td colspan="3">
<%
if(act==4)
{
%>
<%= PUBLICSEC.equals("1")?"<img src=Click.gif>":"" %>
<%
}
%>
<%
if(act!=4)
{
%>
<input name="chkPUBLICSEC" type="checkbox" id="chkPUBLICSEC" value="1" <%= getChecked("1",PUBLICSEC) %>>
<%}%>
Public Sector Code is not completed </td>
<td colspan="2"> </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td> </td>
<td> </td>
<td colspan="3">
<%
if(act==4)
{
%>
<%= JOINTSEC.equals("1")?"<img src=Click.gif>":"" %>
<%}%>
<%
if(act!=4)
{
%>
<input name="chkJOINTSEC" type="checkbox" id="chkJOINTSEC" value="1" <%= getChecked("1",JOINTSEC) %>>
<%}%>
Joint Sector </td>
<td colspan="2"> </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td> </td>
<td> </td>
<td colspan="3">
<%
if(act==4)
{
%>
<%= COOPERSEC.equals("1")?"<img src=Click.gif>":"" %>
<%}%>
<%
if(act!=4)
{
%>
<input name="chkCOOPERSEC" type="checkbox" id="chkCOOPERSEC" value="1" <%= getChecked("1",COOPERSEC) %>>
<%}%>
Co-operative Sector </td>
<td colspan="2"> </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td> </td>
<td> </td>
<td colspan="3">
<%
if(act==4)
{
%>
<%= PRIVATSEC.equals("1")?"<img src=Click.gif>":"" %>
<%}%>
<%
if(act!=4)
{
%>
<input name="chkPRIVATSEC" type="checkbox" id="chkPRIVATSEC" value="1" <%= getChecked("1",PRIVATSEC) %>>
<%}%>
Private Sector</td>
<td colspan="2"> </td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td>(c)</td>
<td> </td>
<td colspan="5">In case the factory is a major: Accident Hazard(MAH) Installation fernish the fallowing information (See Explanatory Note "AA") </td>
</tr>
<tr valign="top">
<td height="24" colspan="9"><jsp:include page="part1.jsp" /></td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td> </td>
<td> </td>
<td> </td>
<td colspan="3">Name of the MAH substance (See Explanatory Note "BB") </td>
<td colspan="2"> </td>
</tr>

<tr valign="top">
<td height="24"> </td>
<td height="24">8. </td>
<td height="24">(a)</td>
<td height="24"> </td>
<td height="24" colspan="3">Number of days the factory worked in the year(see explanatory note B)</td>
<td colspan="2">
<%
if(act==4)
{
out.println(YRMANDAYWORKED1);
}
else
{
%>
<input name="txtYRMANDAYWORKED" type="text" id="txtYRMANDAYWORKED" onChange=javascript:chknum('txtYRMANDAYWORKED'); onClick=javascript:chknum('txtYRMANDAYWORKED'); value="<%=YRMANDAYWORKED1%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="24"> </td>
<td height="24"> </td>
<td height="24">(b)</td>
<td height="24"> </td>
<td height="24" colspan="3">Number of weeks the factory worked in the year</td>
<td colspan="2">
<%
if(act==4)
{
out.println(NUMOFWEEKS1);
}
else
{
%>

<input name="txtNUMOFWEEKS" type="text" id="txtNUMOFWEEKS" value="<%=NUMOFWEEKS%>">

<%}%>
</td>
</tr>
<tr valign="top">
<td height="21"> </td>
<td height="21" colspan="8">Number of Workers and Particulars of Employment : </td>
</tr>
<tr valign="top">
<td height="21"> </td>
<td height="21">9.. </td>
<td height="21" colspan="7">Number of Man-days worked (ie Aggregate number of attendence during the year)during the year(See explane ator4y note "C")</td>
</tr>
<tr valign="top">
<td height="21"> </td>
<td height="21"> </td>
<td height="21" align="right">(a)</td>
<td height="21" colspan="3">
Adult </td>
<td colspan="3"> </td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td width="3%">(i) </td>
<td colspan="2">Men</td>
<td colspan="3">
<%
if(act==4)
{
out.println(NMDWADULTMEN);
}
else
{
%>
<input name="txtNMDWADULTMEN" type="text" id="txtNMDWADULTMEN" onChange=javascript:chknum('txtNMDWADULTMEN'); onClick=javascript:chknum('txtNMDWADULTMEN'); value="<%=NMDWADULTMEN%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(ii)</td>
<td colspan="2">Women</td>
<td colspan="3">
<%
if(act==4)
{
out.println(NMDWADULTWOMEN);
}
else
{
%>
<input name="txtNMDWADULTWOMEN" type="text" id="txtNMDWADULTWOMEN" onChange=javascript:chknum('txtNMDWADULTWOMEN'); onClick=javascript:chknum('txtNMDWADULTWOMEN'); value="<%=NMDWADULTWOMEN%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="21"> </td>
<td height="21"> </td>
<td height="21" align="right">(b)
</td>
<td height="21" colspan="3">
Adolescent</td>
<td colspan="3"> </td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td width="3%">(i) </td>
<td colspan="2">Male</td>
<td colspan="3">
<%
if(act==4)
{
out.println(NMDWADOLMALE);
}
else
{
%>
<input name="txtNMDWADOLMALE" type="text" id="txtNMDWADOLMALE" onChange=javascript:chknum('txtNMDWADOLMALE'); onClick=javascript:chknum('txtNMDWADOLMALE'); value="<%=NMDWADOLMALE%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(ii)</td>
<td colspan="2">Female</td>
<td colspan="3">
<%
if(act==4)
{
out.println(NMDWADOLFEMALE);
}
else
{
%>
<input name="txtNMDWADOLFEMALE" type="text" id="txtNMDWADOLFEMALE" onChange=javascript:chknum('txtNMDWADOLFEMALE'); onClick=javascript:chknum('txtNMDWADOLFEMALE'); value="<%=NMDWADOLFEMALE%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td height="21"> </td>
<td height="21"> </td>
<td height="21" align="right">(c)
</td>
<td height="21" colspan="3">
Children</td>
<td colspan="3"> </td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td width="3%">(i) </td>
<td colspan="2">Boys</td>
<td colspan="3">
<%
if(act==4)
{
out.println(NMDWCHILBOYS);
}
else
{
%>
<input name="txtNMDWCHILBOYS" type="text" id="txtNMDWCHILBOYS" onChange=javascript:chknum('txtNMDWCHILBOYS'); onClick=javascript:chknum('txtNMDWCHILBOYS'); value="<%=NMDWCHILBOYS%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(ii)</td>
<td colspan="2">Girls</td>
<td colspan="3">
<%
if(act==4)
{
out.println(NMDWCHILGIRLS);
}
else
{
%>
<input name="txtNMDWCHILGIRLS" type="text" id="txtNMDWCHILGIRLS" onChange=javascript:chknum('txtNMDWCHILGIRLS'); onClick=javascript:chknum('txtNMDWCHILGIRLS'); value="<%=NMDWCHILGIRLS%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td colspan="3">Total</td>
<td colspan="3">
<%
if(act==4)
{
out.println(NMDWTOTAL);
}
else
{
%>
<input name="txtNMDWTOTAL" type="text" id="txtNMDWTOTAL" size="8" onChange=javascript:chknum('txtNMDWTOTAL'); onClick=javascript:chknum('txtNMDWTOTAL'); value="<%=NMDWTOTAL%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right">10.</td>
<td colspan="7">Average number of workers employed daily ie Mandays worked divided by Number of days worked.(See explanator4y note "D")</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right">(a)</td>
<td colspan="6">Adult </td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(i)</td>
<td colspan="2">Men</td>
<td colspan="3">
<%
if(act==4)
{
out.println(AVGNEADULTMEN);
}
else
{
%>
<input name="txtAVGNEADULTMEN" type="text" id="txtAVGNEADULTMEN" onChange=javascript:chknum('txtAVGNEADULTMEN'); onClick=javascript:chknum('txtAVGNEADULTMEN'); value="<%=AVGNEADULTMEN%>" maxlength="7">
<% } %>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(ii)</td>
<td colspan="2">Women</td>
<td colspan="3">
<%
if(act==4)
{
out.println(AVGNEADULTWOMEN);
}
else
{
%>
<input name="txtAVGNEADULTWOMEN" type="text" id="txtAVGNEADULTWOMEN" onChange=javascript:chknum('txtAVGNEADULTWOMEN'); onClick=javascript:chknum('txtAVGNEADULTWOMEN'); value="<%=AVGNEADULTWOMEN%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right">(b)</td>
<td colspan="6">Adolescent</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(i)</td>
<td colspan="2">Male</td>
<td colspan="3">
<%
if(act==4)
{
out.println(AVGNEADULTMALE);
}
else
{
%>
<input name="txtAVGNEADULTMALE" type="text" id="txtAVGNEADULTMALE" onChange=javascript:chknum('txtAVGNEADULTMALE'); onClick=javascript:chknum('txtAVGNEADULTMALE'); value="<%=AVGNEADULTMALE%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(ii)</td>
<td colspan="2">Female</td>
<td colspan="3">
<%
if(act==4)
{
out.println(AVGNEADULTFEMALE);
}
else
{
%>
<input name="txtAVGNEADULTFEMALE" type="text" id="txtAVGNEADULTFEMALE" onChange=javascript:chknum('txtAVGNEADULTFEMALE'); onClick=javascript:chknum('txtAVGNEADULTFEMALE'); value="<%=AVGNEADULTFEMALE%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right">(c)</td>
<td colspan="6">Children</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(i)</td>
<td colspan="2">Boys</td>
<td colspan="3">
<%
if(act==4)
{
out.println(AVGNECHILBOYS);
}
else
{
%>
<input name="txtAVGNECHILBOYS" type="text" id="txtAVGNECHILBOYS" onChange=javascript:chknum('txtAVGNECHILBOYS'); onClick=javascript:chknum('txtAVGNECHILBOYS'); value="<%=AVGNECHILBOYS%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td>(ii)</td>
<td colspan="2">Girls</td>
<td colspan="3">
<%
if(act==4)
{
out.println(AVGNECHILGIRLS);
}
else
{
%>
<input name="txtAVGNECHILGIRLS" type="text" id="txtAVGNECHILGIRLS" onChange=javascript:chknum('txtAVGNECHILGIRLS'); onClick=javascript:chknum('txtAVGNECHILGIRLS'); value="<%=AVGNECHILGIRLS%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24" align="right"> </td>
<td align="right"> </td>
<td></td>
<td colspan="2">Total</td>
<td colspan="3">
<%
if(act==4)
{
out.println(TOTAVGWORKERS);
}
else
{
%>
<input name="txtTOTAVGWORKERS" type="text" id="txtTOTAVGWORKERS" size="8" onChange=javascript:chknum('txtTOTAVGWORKERS'); onClick=javascript:chknum('txtTOTAVGWORKERS'); value="<%=TOTAVGWORKERS%>" maxlength="7">
<%}%>
</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24">11. </td>
<td height="24" colspan="7"> Total No. of man-hours worked including over time but excluding rest interval (See explainator4y note "E").</td>
</tr>
<tr valign="top">
<td> </td>
<td height="24"> </td>
<td height="24">(a)</td>
<td height="24" colspan="6">Adults</td>
</tr>

Answers

Hi ragini,

In this line goving error. idform not found,

FORMID=idform(request.getParameter("fid"),"FAFORM24GJMASTER");

Please ragini, send at my id.

----------------------------

Amardeep.

Thanks.

More Questions

Post Answers

Ask Question Facing Programming Problem?