-
March 11th, 2010, 02:13 AM
#1
in the below mention code how can we convert by looping.
Statement stmt3=con.createStatement();
ResultSet rs3=stmt3.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='3' AND PBR_YEAR='"+yr2+"') ");
if(rs3.next())
{
cgegis3=rs3.getString("PBR_CGEGIS");
itax3=rs3.getString("PBR_ITAX");
gpf_sub3=rs3.getString("PBR_GPF_SUB");
hba_adv3=rs3.getString("PBR_HBA_ADV");
hba_int3=rs3.getString("PBR_HBA_INT");
cpf_sub3=rs3.getString("PBR_CPF_SUB");
pli3=rs3.getString("PBR_PLI");
lic3=rs3.getString("PBR_LIC");
it_scharge3=rs3.getString("PBR_IT_SCHARGE");
afee3=rs3.getString("PBR_AFEE");
edu_cess3=rs3.getString("PBR_EDU_CESS");
pm_relf3=rs3.getString("PBR_PM_RELF");
govt_cont3=rs3.getString("PBR_GOVT_CONT");
emp_tier_13=rs3.getString("PBR_EMP_TIER_1");
}
else
{
cgegis3="0";
itax3="0";
gpf_sub3="0";
hba_adv3="0";
hba_int3="0";
cpf_sub3="0";
pli3="0";
lic3="0";
it_scharge3="0";
afee3="0";
edu_cess3="0";
pm_relf3="0";
govt_cont3="0";
emp_tier_13="0";
}
stmt3.close();
Statement stmt4=con.createStatement();
ResultSet rs4=stmt4.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='4' AND PBR_YEAR='"+yr2+"') ");
if(rs4.next())
{
cgegis4=rs4.getString("PBR_CGEGIS");
itax4=rs4.getString("PBR_ITAX");
gpf_sub4=rs4.getString("PBR_GPF_SUB");
hba_adv4=rs4.getString("PBR_HBA_ADV");
hba_int4=rs4.getString("PBR_HBA_INT");
cpf_sub4=rs4.getString("PBR_CPF_SUB");
pli4=rs4.getString("PBR_PLI");
lic4=rs4.getString("PBR_LIC");
it_scharge4=rs4.getString("PBR_IT_SCHARGE");
afee4=rs4.getString("PBR_AFEE");
edu_cess4=rs4.getString("PBR_EDU_CESS");
pm_relf4=rs4.getString("PBR_PM_RELF");
govt_cont4=rs4.getString("PBR_GOVT_CONT");
emp_tier_14=rs4.getString("PBR_EMP_TIER_1");
}
else
{
cgegis4="0";
itax4="0";
gpf_sub4="0";
hba_adv4="0";
hba_int4="0";
cpf_sub4="0";
pli4="0";
lic4="0";
it_scharge4="0";
afee4="0";
edu_cess4="0";
pm_relf4="0";
govt_cont4="0";
emp_tier_14="0";
}
stmt4.close();
Statement stmt5=con.createStatement();
ResultSet rs5=stmt5.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='5' AND PBR_YEAR='"+yr2+"') ");
if(rs5.next())
{
cgegis5=rs5.getString("PBR_CGEGIS");
itax5=rs5.getString("PBR_ITAX");
gpf_sub5=rs5.getString("PBR_GPF_SUB");
hba_adv5=rs5.getString("PBR_HBA_ADV");
hba_int5=rs5.getString("PBR_HBA_INT");
cpf_sub5=rs5.getString("PBR_CPF_SUB");
pli5=rs5.getString("PBR_PLI");
lic5=rs5.getString("PBR_LIC");
it_scharge5=rs5.getString("PBR_IT_SCHARGE");
afee5=rs5.getString("PBR_AFEE");
edu_cess5=rs5.getString("PBR_EDU_CESS");
pm_relf5=rs5.getString("PBR_PM_RELF");
govt_cont5=rs5.getString("PBR_GOVT_CONT");
emp_tier_15=rs5.getString("PBR_EMP_TIER_1");
}
else
{
cgegis5="0";
itax5="0";
gpf_sub5="0";
hba_adv5="0";
hba_int5="0";
cpf_sub5="0";
pli5="0";
lic5="0";
it_scharge5="0";
afee5="0";
edu_cess5="0";
pm_relf5="0";
govt_cont5="0";
emp_tier_15="0";
}
stmt5.close();
Statement stmt6=con.createStatement();
ResultSet rs6=stmt6.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='6' AND PBR_YEAR='"+yr2+"') ");
if(rs6.next())
{
cgegis6=rs6.getString("PBR_CGEGIS");
itax6=rs6.getString("PBR_ITAX");
gpf_sub6=rs6.getString("PBR_GPF_SUB");
hba_adv6=rs6.getString("PBR_HBA_ADV");
hba_int6=rs6.getString("PBR_HBA_INT");
cpf_sub6=rs6.getString("PBR_CPF_SUB");
pli6=rs6.getString("PBR_PLI");
lic6=rs6.getString("PBR_LIC");
it_scharge6=rs6.getString("PBR_IT_SCHARGE");
afee6=rs6.getString("PBR_AFEE");
edu_cess6=rs6.getString("PBR_EDU_CESS");
pm_relf6=rs6.getString("PBR_PM_RELF");
govt_cont6=rs6.getString("PBR_GOVT_CONT");
emp_tier_16=rs6.getString("PBR_EMP_TIER_1");
}
else
{
cgegis6="0";
itax6="0";
gpf_sub6="0";
hba_adv6="0";
hba_int6="0";
cpf_sub6="0";
pli6="0";
lic6="0";
it_scharge6="0";
afee6="0";
edu_cess6="0";
pm_relf6="0";
govt_cont6="0";
emp_tier_16="0";
}
stmt6.close();
Statement stmt7=con.createStatement();
ResultSet rs7=stmt7.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='7' AND PBR_YEAR='"+yr2+"') ");
if(rs7.next())
{
cgegis7=rs7.getString("PBR_CGEGIS");
itax7=rs7.getString("PBR_ITAX");
gpf_sub7=rs7.getString("PBR_GPF_SUB");
hba_adv7=rs7.getString("PBR_HBA_ADV");
hba_int7=rs7.getString("PBR_HBA_INT");
cpf_sub7=rs7.getString("PBR_CPF_SUB");
pli7=rs7.getString("PBR_PLI");
lic7=rs7.getString("PBR_LIC");
it_scharge7=rs7.getString("PBR_IT_SCHARGE");
afee7=rs7.getString("PBR_AFEE");
edu_cess7=rs7.getString("PBR_EDU_CESS");
pm_relf7=rs7.getString("PBR_PM_RELF");
govt_cont7=rs7.getString("PBR_GOVT_CONT");
emp_tier_17=rs7.getString("PBR_EMP_TIER_1");
}
else
{
cgegis7="0";
itax7="0";
gpf_sub7="0";
hba_adv7="0";
hba_int7="0";
cpf_sub7="0";
pli7="0";
lic7="0";
it_scharge7="0";
afee7="0";
edu_cess7="0";
pm_relf7="0";
govt_cont7="0";
emp_tier_17="0";
}
stmt7.close();
Statement stmt8=con.createStatement();
ResultSet rs8=stmt8.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='8' AND PBR_YEAR='"+yr2+"') ");
if(rs8.next())
{
cgegis8=rs8.getString("PBR_CGEGIS");
itax8=rs8.getString("PBR_ITAX");
gpf_sub8=rs8.getString("PBR_GPF_SUB");
hba_adv8=rs8.getString("PBR_HBA_ADV");
hba_int8=rs8.getString("PBR_HBA_INT");
cpf_sub8=rs8.getString("PBR_CPF_SUB");
pli8=rs8.getString("PBR_PLI");
lic8=rs8.getString("PBR_LIC");
it_scharge8=rs8.getString("PBR_IT_SCHARGE");
afee8=rs8.getString("PBR_AFEE");
edu_cess8=rs8.getString("PBR_EDU_CESS");
pm_relf8=rs8.getString("PBR_PM_RELF");
govt_cont8=rs8.getString("PBR_GOVT_CONT");
emp_tier_18=rs8.getString("PBR_EMP_TIER_1");
}
else
{
cgegis8="0";
itax8="0";
gpf_sub8="0";
hba_adv8="0";
hba_int8="0";
cpf_sub8="0";
pli8="0";
lic8="0";
it_scharge8="0";
afee8="0";
edu_cess8="0";
pm_relf8="0";
govt_cont8="0";
emp_tier_18="0";
}
stmt8.close();
Statement stmt9=con.createStatement();
ResultSet rs9=stmt9.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='9' AND PBR_YEAR='"+yr2+"') ");
if(rs9.next())
{
cgegis9=rs9.getString("PBR_CGEGIS");
itax9=rs9.getString("PBR_ITAX");
gpf_sub9=rs9.getString("PBR_GPF_SUB");
hba_adv9=rs9.getString("PBR_HBA_ADV");
hba_int9=rs9.getString("PBR_HBA_INT");
cpf_sub9=rs9.getString("PBR_CPF_SUB");
pli9=rs9.getString("PBR_PLI");
lic9=rs9.getString("PBR_LIC");
it_scharge9=rs9.getString("PBR_IT_SCHARGE");
afee9=rs9.getString("PBR_AFEE");
edu_cess9=rs9.getString("PBR_EDU_CESS");
pm_relf9=rs9.getString("PBR_PM_RELF");
govt_cont9=rs9.getString("PBR_GOVT_CONT");
emp_tier_19=rs9.getString("PBR_EMP_TIER_1");
}
else
{
cgegis9="0";
itax9="0";
gpf_sub9="0";
hba_adv9="0";
hba_int9="0";
cpf_sub9="0";
pli9="0";
lic9="0";
it_scharge9="0";
afee9="0";
edu_cess9="0";
pm_relf9="0";
govt_cont9="0";
emp_tier_19="0";
}
stmt9.close();
Statement stmt10=con.createStatement();
ResultSet rs10=stmt10.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='10' AND PBR_YEAR='"+yr2+"') ");
if(rs10.next())
{
cgegis10=rs10.getString("PBR_CGEGIS");
itax10=rs10.getString("PBR_ITAX");
gpf_sub10=rs10.getString("PBR_GPF_SUB");
hba_adv10=rs10.getString("PBR_HBA_ADV");
hba_int10=rs10.getString("PBR_HBA_INT");
cpf_sub10=rs10.getString("PBR_CPF_SUB");
pli10=rs10.getString("PBR_PLI");
lic10=rs10.getString("PBR_LIC");
it_scharge10=rs10.getString("PBR_IT_SCHARGE");
afee10=rs10.getString("PBR_AFEE");
edu_cess10=rs10.getString("PBR_EDU_CESS");
pm_relf10=rs10.getString("PBR_PM_RELF");
govt_cont10=rs10.getString("PBR_GOVT_CONT");
emp_tier_110=rs10.getString("PBR_EMP_TIER_1");
}
else
{
cgegis10="0";
itax10="0";
gpf_sub10="0";
hba_adv10="0";
hba_int10="0";
cpf_sub10="0";
pli10="0";
lic10="0";
it_scharge10="0";
afee10="0";
edu_cess10="0";
pm_relf10="0";
govt_cont10="0";
emp_tier_110="0";
}
stmt10.close();
Statement stmt11=con.createStatement();
ResultSet rs11=stmt11.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='11' AND PBR_YEAR='"+yr2+"') ");
if(rs11.next())
{
cgegis11=rs11.getString("PBR_CGEGIS");
itax11=rs11.getString("PBR_ITAX");
gpf_sub11=rs11.getString("PBR_GPF_SUB");
hba_adv11=rs11.getString("PBR_HBA_ADV");
hba_int11=rs11.getString("PBR_HBA_INT");
cpf_sub11=rs11.getString("PBR_CPF_SUB");
pli11=rs11.getString("PBR_PLI");
lic11=rs11.getString("PBR_LIC");
it_scharge11=rs11.getString("PBR_IT_SCHARGE");
afee11=rs11.getString("PBR_AFEE");
edu_cess11=rs11.getString("PBR_EDU_CESS");
pm_relf11=rs11.getString("PBR_PM_RELF");
govt_cont11=rs11.getString("PBR_GOVT_CONT");
emp_tier_111=rs11.getString("PBR_EMP_TIER_1");
}
else
{
cgegis11="0";
itax11="0";
gpf_sub11="0";
hba_adv11="0";
hba_int11="0";
cpf_sub11="0";
pli11="0";
lic11="0";
it_scharge11="0";
afee11="0";
edu_cess11="0";
pm_relf11="0";
govt_cont11="0";
emp_tier_111="0";
}
stmt11.close();
Statement stmt12=con.createStatement();
ResultSet rs12=stmt12.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='12' AND PBR_YEAR='"+yr2+"') ");
if(rs12.next())
{
cgegis12=rs12.getString("PBR_CGEGIS");
itax12=rs12.getString("PBR_ITAX");
gpf_sub12=rs12.getString("PBR_GPF_SUB");
hba_adv12=rs12.getString("PBR_HBA_ADV");
hba_int12=rs12.getString("PBR_HBA_INT");
cpf_sub12=rs12.getString("PBR_CPF_SUB");
pli12=rs12.getString("PBR_PLI");
lic12=rs12.getString("PBR_LIC");
it_scharge12=rs12.getString("PBR_IT_SCHARGE");
afee12=rs12.getString("PBR_AFEE");
edu_cess12=rs12.getString("PBR_EDU_CESS");
pm_relf12=rs12.getString("PBR_PM_RELF");
govt_cont12=rs12.getString("PBR_GOVT_CONT");
emp_tier_112=rs12.getString("PBR_EMP_TIER_1");
}
else
{
cgegis12="0";
itax12="0";
gpf_sub12="0";
hba_adv12="0";
hba_int12="0";
cpf_sub12="0";
pli12="0";
lic12="0";
it_scharge12="0";
afee12="0";
edu_cess12="0";
pm_relf12="0";
govt_cont12="0";
emp_tier_112="0";
}
stmt12.close();
Statement stmt1=con.createStatement();
ResultSet rs1=stmt1.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='01' AND PBR_YEAR='"+(yr2+1) +"') ");
if(rs1.next())
{
cgegis1=rs1.getString("PBR_CGEGIS");
itax1=rs1.getString("PBR_ITAX");
gpf_sub1=rs1.getString("PBR_GPF_SUB");
hba_adv1=rs1.getString("PBR_HBA_ADV");
hba_int1=rs1.getString("PBR_HBA_INT");
cpf_sub1=rs1.getString("PBR_CPF_SUB");
pli1=rs1.getString("PBR_PLI");
lic1=rs1.getString("PBR_LIC");
it_scharge1=rs1.getString("PBR_IT_SCHARGE");
afee1=rs1.getString("PBR_AFEE");
edu_cess1=rs1.getString("PBR_EDU_CESS");
pm_relf1=rs1.getString("PBR_PM_RELF");
govt_cont1=rs1.getString("PBR_GOVT_CONT");
emp_tier_11=rs1.getString("PBR_EMP_TIER_1");
}
else
{
cgegis1="0";
itax1="0";
gpf_sub1="0";
hba_adv1="0";
hba_int1="0";
cpf_sub1="0";
pli1="0";
lic1="0";
it_scharge1="0";
afee1="0";
edu_cess1="0";
pm_relf1="0";
govt_cont1="0";
emp_tier_11="0";
}
stmt1.close();
Statement stmt2=con.createStatement();
ResultSet rs2=stmt2.executeQuery("select * from EW_T_PBR_"+yr1+" where (PBR_EID="+bkpuname1+" AND PBR_MONTH='02' AND PBR_YEAR='"+(yr2+1)+"') ");
if(rs2.next())
{
cgegis2=rs2.getString("PBR_CGEGIS");
itax2=rs2.getString("PBR_ITAX");
gpf_sub2=rs2.getString("PBR_GPF_SUB");
hba_adv2=rs2.getString("PBR_HBA_ADV");
hba_int2=rs2.getString("PBR_HBA_INT");
cpf_sub2=rs2.getString("PBR_CPF_SUB");
pli2=rs2.getString("PBR_PLI");
lic2=rs2.getString("PBR_LIC");
it_scharge2=rs2.getString("PBR_IT_SCHARGE");
afee2=rs2.getString("PBR_AFEE");
edu_cess2=rs2.getString("PBR_EDU_CESS");
pm_relf2=rs2.getString("PBR_PM_RELF");
govt_cont2=rs2.getString("PBR_GOVT_CONT");
emp_tier_12=rs2.getString("PBR_EMP_TIER_1");
}
else
{
cgegis2="0";
itax2="0";
gpf_sub2="0";
hba_adv2="0";
hba_int2="0";
cpf_sub2="0";
pli2="0";
lic2="0";
it_scharge2="0";
afee2="0";
edu_cess2="0";
pm_relf2="0";
govt_cont2="0";
emp_tier_12="0";
}
stmt2.close();
-
March 11th, 2010, 08:04 AM
#2
Re: in the below mention code how can we convert by looping.
You post a huge mass of unformatted, uncommented code, with meaningless variable names, and no explanation of what it is supposed to do or how it is supposed to work, and ask a terminally vague question about looping...
Did you really expect an answer?
Judge a man by his questions, rather than his answers...
Voltaire
Please use [CODE]...your code here...[/CODE] tags when posting code. If you get an error, please post the full error message and stack trace, if present.
-
March 11th, 2010, 01:22 PM
#3
Re: in the below mention code how can we convert by looping.
Is this a decompiler generated code? Anyways:
1. Please use CODE tags when posting code;
2. Please explain what is the actual problem;
3. If there is any exception thrown please post it as well;
Posts like this one will not be answered or even read here...
Wanna install linux on a vacuum cleaner. Could anyone tell me which distro sucks better?
I had a nightmare last night. I was dreaming that I’m 64-bit and my blanket is 32-bit and I couldn’t cover myself with it, so I’ve spent the whole night freezing. And in the morning I find that my blanket just had fallen off the bed. =S (from: bash.org.ru)
//always looking for job opportunities in AU/NZ/US/CA/Europe :P
willCodeForFood(Arrays.asList("Java","PHP","C++","bash","Assembler","XML","XHTML","CSS","JS","PL/SQL"));
USE [code] TAGS! Read this FAQ if you are new here. If this post was helpful, please rate it!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|