📄 pkaddaction.java
字号:
stmt.addBatch();
stmt.setInt(1,id+4);
stmt.setInt(2,getBjbh());
stmt.setInt(3,5);
stmt.setString(4,getKcmc5());
stmt.addBatch();
stmt.setInt(1,id+5);
stmt.setInt(2,getBjbh());
stmt.setInt(3,6);
stmt.setString(4,getKcmc6());
stmt.addBatch();
stmt.setInt(1,id+6);
stmt.setInt(2,getBjbh());
stmt.setInt(3,7);
stmt.setString(4,getKcmc7());
stmt.addBatch();
stmt.setInt(1,id+7);
stmt.setInt(2,getBjbh());
stmt.setInt(3,8);
stmt.setString(4,getKcmc8());
stmt.addBatch();
stmt.setInt(1,id+8);
stmt.setInt(2,getBjbh());
stmt.setInt(3,9);
stmt.setString(4,getKcmc9());
stmt.addBatch();
stmt.setInt(1,id+9);
stmt.setInt(2,getBjbh());
stmt.setInt(3,10);
stmt.setString(4,getKcmc10());
stmt.addBatch();
stmt.setInt(1,id+10);
stmt.setInt(2,getBjbh());
stmt.setInt(3,11);
stmt.setString(4,getKcmc11());
stmt.addBatch();
stmt.setInt(1,id+11);
stmt.setInt(2,getBjbh());
stmt.setInt(3,12);
stmt.setString(4,getKcmc12());
stmt.addBatch();
stmt.setInt(1,id+12);
stmt.setInt(2,getBjbh());
stmt.setInt(3,13);
stmt.setString(4,getKcmc13());
stmt.addBatch();
stmt.setInt(1,id+13);
stmt.setInt(2,getBjbh());
stmt.setInt(3,14);
stmt.setString(4,getKcmc14());
stmt.addBatch();
stmt.setInt(1,id+14);
stmt.setInt(2,getBjbh());
stmt.setInt(3,15);
stmt.setString(4,getKcmc15());
stmt.addBatch();
stmt.setInt(1,id+15);
stmt.setInt(2,getBjbh());
stmt.setInt(3,16);
stmt.setString(4,getKcmc16());
stmt.addBatch();
stmt.setInt(1,id+16);
stmt.setInt(2,getBjbh());
stmt.setInt(3,17);
stmt.setString(4,getKcmc17());
stmt.addBatch();
stmt.setInt(1,id+17);
stmt.setInt(2,getBjbh());
stmt.setInt(3,18);
stmt.setString(4,getKcmc18());
stmt.addBatch();
stmt.setInt(1,id+18);
stmt.setInt(2,getBjbh());
stmt.setInt(3,19);
stmt.setString(4,getKcmc19());
stmt.addBatch();
stmt.setInt(1,id+19);
stmt.setInt(2,getBjbh());
stmt.setInt(3,20);
stmt.setString(4,getKcmc20());
stmt.addBatch();
stmt.setInt(1,id+20);
stmt.setInt(2,getBjbh());
stmt.setInt(3,21);
stmt.setString(4,getKcmc21());
stmt.addBatch();
stmt.setInt(1,id+21);
stmt.setInt(2,getBjbh());
stmt.setInt(3,22);
stmt.setString(4,getKcmc22());
stmt.addBatch();
stmt.setInt(1,id+22);
stmt.setInt(2,getBjbh());
stmt.setInt(3,23);
stmt.setString(4,getKcmc23());
stmt.addBatch();
stmt.setInt(1,id+23);
stmt.setInt(2,getBjbh());
stmt.setInt(3,24);
stmt.setString(4,getKcmc24());
stmt.addBatch();
stmt.setInt(1,id+24);
stmt.setInt(2,getBjbh());
stmt.setInt(3,25);
stmt.setString(4,getKcmc25());
stmt.addBatch();
stmt.setInt(1,id+25);
stmt.setInt(2,getBjbh());
stmt.setInt(3,26);
stmt.setString(4,getKcmc26());
stmt.addBatch();
stmt.setInt(1,id+26);
stmt.setInt(2,getBjbh());
stmt.setInt(3,27);
stmt.setString(4,getKcmc27());
stmt.addBatch();
stmt.setInt(1,id+27);
stmt.setInt(2,getBjbh());
stmt.setInt(3,28);
stmt.setString(4,getKcmc28());
stmt.addBatch();
stmt.setInt(1,id+28);
stmt.setInt(2,getBjbh());
stmt.setInt(3,29);
stmt.setString(4,getKcmc29());
stmt.addBatch();
stmt.setInt(1,id+29);
stmt.setInt(2,getBjbh());
stmt.setInt(3,30);
stmt.setString(4,getKcmc30());
stmt.addBatch();
stmt.setInt(1,id+30);
stmt.setInt(2,getBjbh());
stmt.setInt(3,31);
stmt.setString(4,getKcmc31());
stmt.addBatch();
stmt.setInt(1,id+31);
stmt.setInt(2,getBjbh());
stmt.setInt(3,32);
stmt.setString(4,getKcmc32());
stmt.addBatch();
stmt.setInt(1,id+32);
stmt.setInt(2,getBjbh());
stmt.setInt(3,33);
stmt.setString(4,getKcmc33());
stmt.addBatch();
stmt.setInt(1,id+33);
stmt.setInt(2,getBjbh());
stmt.setInt(3,34);
stmt.setString(4,getKcmc34());
stmt.addBatch();
stmt.setInt(1,id+34);
stmt.setInt(2,getBjbh());
stmt.setInt(3,35);
stmt.setString(4,getKcmc35());
stmt.addBatch();
stmt.setInt(1,id+35);
stmt.setInt(2,getBjbh());
stmt.setInt(3,36);
stmt.setString(4,getKcmc36());
stmt.addBatch();
stmt.setInt(1,id+36);
stmt.setInt(2,getBjbh());
stmt.setInt(3,37);
stmt.setString(4,getKcmc37());
stmt.addBatch();
stmt.setInt(1,id+37);
stmt.setInt(2,getBjbh());
stmt.setInt(3,38);
stmt.setString(4,getKcmc38());
stmt.addBatch();
stmt.setInt(1,id+38);
stmt.setInt(2,getBjbh());
stmt.setInt(3,39);
stmt.setString(4,getKcmc39());
stmt.addBatch();
stmt.setInt(1,id+39);
stmt.setInt(2,getBjbh());
stmt.setInt(3,40);
stmt.setString(4,getKcmc40());
stmt.addBatch();
stmt.setInt(1,id+40);
stmt.setInt(2,getBjbh());
stmt.setInt(3,41);
stmt.setString(4,getKcmc41());
stmt.addBatch();
stmt.setInt(1,id+41);
stmt.setInt(2,getBjbh());
stmt.setInt(3,42);
stmt.setString(4,getKcmc42());
stmt.addBatch();
stmt.setInt(1,id+42);
stmt.setInt(2,getBjbh());
stmt.setInt(3,43);
stmt.setString(4,getKcmc43());
stmt.addBatch();
stmt.setInt(1,id+43);
stmt.setInt(2,getBjbh());
stmt.setInt(3,44);
stmt.setString(4,getKcmc44());
stmt.addBatch();
stmt.setInt(1,id+44);
stmt.setInt(2,getBjbh());
stmt.setInt(3,45);
stmt.setString(4,getKcmc45());
stmt.addBatch();
stmt.setInt(1,id+45);
stmt.setInt(2,getBjbh());
stmt.setInt(3,46);
stmt.setString(4,getKcmc46());
stmt.addBatch();
stmt.setInt(1,id+46);
stmt.setInt(2,getBjbh());
stmt.setInt(3,47);
stmt.setString(4,getKcmc47());
stmt.addBatch();
stmt.setInt(1,id+47);
stmt.setInt(2,getBjbh());
stmt.setInt(3,48);
stmt.setString(4,getKcmc48());
stmt.addBatch();
stmt.setInt(1,id+48);
stmt.setInt(2,getBjbh());
stmt.setInt(3,49);
stmt.setString(4,getKcmc49());
stmt.addBatch();
stmt.executeBatch();
flag=true;
}else
{
stmt=conn.prepareStatement("update m_sortcurrm set kcmc=? where bjbh=? and jcid=?");
stmt.setString(1,getKcmc1());
stmt.setInt(2,getBjbh());
stmt.setInt(3,1);
stmt.addBatch();
stmt.setString(1,getKcmc2());
stmt.setInt(2,getBjbh());
stmt.setInt(3,2);
stmt.addBatch();
stmt.setString(1,getKcmc3());
stmt.setInt(2,getBjbh());
stmt.setInt(3,3);
stmt.addBatch();
stmt.setString(1,getKcmc4());
stmt.setInt(2,getBjbh());
stmt.setInt(3,4);
stmt.addBatch();
stmt.setString(1,getKcmc5());
stmt.setInt(2,getBjbh());
stmt.setInt(3,5);
stmt.addBatch();
stmt.setString(1,getKcmc6());
stmt.setInt(2,getBjbh());
stmt.setInt(3,6);
stmt.addBatch();
stmt.setString(1,getKcmc7());
stmt.setInt(2,getBjbh());
stmt.setInt(3,7);
stmt.addBatch();
stmt.setString(1,getKcmc8());
stmt.setInt(2,getBjbh());
stmt.setInt(3,8);
stmt.addBatch();
stmt.setString(1,getKcmc9());
stmt.setInt(2,getBjbh());
stmt.setInt(3,9);
stmt.addBatch();
stmt.setString(1,getKcmc10());
stmt.setInt(2,getBjbh());
stmt.setInt(3,10);
stmt.addBatch();
stmt.setString(1,getKcmc11());
stmt.setInt(2,getBjbh());
stmt.setInt(3,11);
stmt.addBatch();
stmt.setString(1,getKcmc12());
stmt.setInt(2,getBjbh());
stmt.setInt(3,12);
stmt.addBatch();
stmt.setString(1,getKcmc13());
stmt.setInt(2,getBjbh());
stmt.setInt(3,13);
stmt.addBatch();
stmt.setString(1,getKcmc14());
stmt.setInt(2,getBjbh());
stmt.setInt(3,14);
stmt.addBatch();
stmt.setString(1,getKcmc15());
stmt.setInt(2,getBjbh());
stmt.setInt(3,15);
stmt.addBatch();
stmt.setString(1,getKcmc16());
stmt.setInt(2,getBjbh());
stmt.setInt(3,16);
stmt.addBatch();
stmt.setString(1,getKcmc17());
stmt.setInt(2,getBjbh());
stmt.setInt(3,17);
stmt.addBatch();
stmt.setString(1,getKcmc18());
stmt.setInt(2,getBjbh());
stmt.setInt(3,18);
stmt.addBatch();
stmt.setString(1,getKcmc19());
stmt.setInt(2,getBjbh());
stmt.setInt(3,19);
stmt.addBatch();
stmt.setString(1,getKcmc20());
stmt.setInt(2,getBjbh());
stmt.setInt(3,20);
stmt.addBatch();
stmt.setString(1,getKcmc21());
stmt.setInt(2,getBjbh());
stmt.setInt(3,21);
stmt.addBatch();
stmt.setString(1,getKcmc22());
stmt.setInt(2,getBjbh());
stmt.setInt(3,22);
stmt.addBatch();
stmt.setString(1,getKcmc23());
stmt.setInt(2,getBjbh());
stmt.setInt(3,23);
stmt.addBatch();
stmt.setString(1,getKcmc24());
stmt.setInt(2,getBjbh());
stmt.setInt(3,24);
stmt.addBatch();
stmt.setString(1,getKcmc25());
stmt.setInt(2,getBjbh());
stmt.setInt(3,25);
stmt.addBatch();
stmt.setString(1,getKcmc26());
stmt.setInt(2,getBjbh());
stmt.setInt(3,26);
stmt.addBatch();
stmt.setString(1,getKcmc27());
stmt.setInt(2,getBjbh());
stmt.setInt(3,27);
stmt.addBatch();
stmt.setString(1,getKcmc28());
stmt.setInt(2,getBjbh());
stmt.setInt(3,28);
stmt.addBatch();
stmt.setString(1,getKcmc29());
stmt.setInt(2,getBjbh());
stmt.setInt(3,29);
stmt.addBatch();
stmt.setString(1,getKcmc30());
stmt.setInt(2,getBjbh());
stmt.setInt(3,30);
stmt.addBatch();
stmt.setString(1,getKcmc31());
stmt.setInt(2,getBjbh());
stmt.setInt(3,31);
stmt.addBatch();
stmt.setString(1,getKcmc32());
stmt.setInt(2,getBjbh());
stmt.setInt(3,32);
stmt.addBatch();
stmt.setString(1,getKcmc33());
stmt.setInt(2,getBjbh());
stmt.setInt(3,33);
stmt.addBatch();
stmt.setString(1,getKcmc34());
stmt.setInt(2,getBjbh());
stmt.setInt(3,34);
stmt.addBatch();
stmt.setString(1,getKcmc35());
stmt.setInt(2,getBjbh());
stmt.setInt(3,35);
stmt.addBatch();
stmt.setString(1,getKcmc36());
stmt.setInt(2,getBjbh());
stmt.setInt(3,36);
stmt.addBatch();
stmt.setString(1,getKcmc37());
stmt.setInt(2,getBjbh());
stmt.setInt(3,37);
stmt.addBatch();
stmt.setString(1,getKcmc38());
stmt.setInt(2,getBjbh());
stmt.setInt(3,38);
stmt.addBatch();
stmt.setString(1,getKcmc39());
stmt.setInt(2,getBjbh());
stmt.setInt(3,39);
stmt.addBatch();
stmt.setString(1,getKcmc40());
stmt.setInt(2,getBjbh());
stmt.setInt(3,40);
stmt.addBatch();
stmt.setString(1,getKcmc41());
stmt.setInt(2,getBjbh());
stmt.setInt(3,41);
stmt.addBatch();
stmt.setString(1,getKcmc42());
stmt.setInt(2,getBjbh());
stmt.setInt(3,42);
stmt.addBatch();
stmt.setString(1,getKcmc43());
stmt.setInt(2,getBjbh());
stmt.setInt(3,43);
stmt.addBatch();
stmt.setString(1,getKcmc44());
stmt.setInt(2,getBjbh());
stmt.setInt(3,44);
stmt.addBatch();
stmt.setString(1,getKcmc45());
stmt.setInt(2,getBjbh());
stmt.setInt(3,45);
stmt.addBatch();
stmt.setString(1,getKcmc46());
stmt.setInt(2,getBjbh());
stmt.setInt(3,46);
stmt.addBatch();
stmt.setString(1,getKcmc47());
stmt.setInt(2,getBjbh());
stmt.setInt(3,47);
stmt.addBatch();
stmt.setString(1,getKcmc48());
stmt.setInt(2,getBjbh());
stmt.setInt(3,48);
stmt.addBatch();
stmt.setString(1,getKcmc49());
stmt.setInt(2,getBjbh());
stmt.setInt(3,49);
stmt.addBatch();
int[] d=stmt.executeBatch();
//System.out.println("getKcmc49()--->"+getKcmc49());
System.out.println("dd--->"+d.length);
}
}catch(Exception e)
{
System.out.println(e);
}finally
{
DBUtils.closeStatement(stmt);
DBUtils.closeConnection(conn);
}
return SUCCESS;
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -