pkinfordao.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 570 行 · 第 1/2 页

	      stmt.addBatch();
	      stmt.setInt(1,id+36);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,37);
	      stmt.setString(4,pkinfor.getKcmc37());
	      stmt.addBatch();
	      stmt.setInt(1,id+37);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,38);
	      stmt.setString(4,pkinfor.getKcmc38());
	      stmt.addBatch();
	      stmt.setInt(1,id+38);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,39);
	      stmt.setString(4,pkinfor.getKcmc39());
	      stmt.addBatch();
	      stmt.setInt(1,id+39);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,40);
	      stmt.setString(4,pkinfor.getKcmc40());
	      stmt.addBatch();
	      stmt.setInt(1,id+40);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,41);
	      stmt.setString(4,pkinfor.getKcmc41());
	      stmt.addBatch();
	      stmt.setInt(1,id+41);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,42);
	      stmt.setString(4,pkinfor.getKcmc42());
	      stmt.addBatch();
	      stmt.setInt(1,id+42);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,43);
	      stmt.setString(4,pkinfor.getKcmc43());
	      stmt.addBatch();
	      stmt.setInt(1,id+43);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,44);
	      stmt.setString(4,pkinfor.getKcmc44());
	      stmt.addBatch();
	      stmt.setInt(1,id+44);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,45);
	      stmt.setString(4,pkinfor.getKcmc45());
	      stmt.addBatch();
	      stmt.setInt(1,id+45);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,46);
	      stmt.setString(4,pkinfor.getKcmc46());
	      stmt.addBatch();
	      stmt.setInt(1,id+46);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,47);
	      stmt.setString(4,pkinfor.getKcmc47());
	      stmt.addBatch();
	      stmt.setInt(1,id+47);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,48);
	      stmt.setString(4,pkinfor.getKcmc48());
	      stmt.addBatch();
	      stmt.setInt(1,id+48);
	      stmt.setInt(2,pkinfor.getBjbh());
	      stmt.setInt(3,49);
	      stmt.setString(4,pkinfor.getKcmc49());
	      stmt.addBatch();
	      
	      stmt.executeBatch();
	      flag=true;
	    }else
	    {
	    	stmt=conn.prepareStatement("update m_sortcurrm set kcmc=? where bjbh=? and jcid=?");
		      stmt.setString(1,pkinfor.getKcmc1());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,1);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc2());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,2);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc3());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,3);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc4());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,4);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc5());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,5);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc6());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,6);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc7());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,7);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc8());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,8);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc9());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,9);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc10());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,10);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc11());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,11);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc12());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,12);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc13());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,13);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc14());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,14);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc15());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,15);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc16());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,16);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc17());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,17);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc18());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,18);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc19());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,19);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc20());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,20);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc21());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,21);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc22());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,22);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc23());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,23);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc24());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,24);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc25());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,25);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc26());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,26);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc27());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,27);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc28());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,28);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc29());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,29);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc30());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,30);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc31());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,31);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc32());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,32);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc33());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,33);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc34());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,34);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc35());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,35);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc36());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,36);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc37());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,37);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc38());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,38);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc39());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,39);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc40());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,40);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc41());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,41);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc42());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,42);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc43());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,43);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc44());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,44);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc45());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,45);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc46());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,46);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc47());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,47);
		      stmt.addBatch();
		      stmt.setString(1,pkinfor.getKcmc48());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,48);
		      stmt.addBatch();
		     
		      stmt.setString(1,pkinfor.getKcmc49());
		      stmt.setInt(2,pkinfor.getBjbh());
		      stmt.setInt(3,49);
		      stmt.addBatch();
		      int[] d=stmt.executeBatch();
	   //System.out.println("pkinfor.getKcmc49()--->"+pkinfor.getKcmc49()); 
		System.out.println("dd--->"+d.length);  
	    }
	  }catch(Exception e)
	  {
		System.out.println(e);  
	  }finally
	  {
		  DBUtils.closeStatement(stmt);
		  DBUtils.closeConnection(conn);
	  }
	  return flag;
  }
}