日魂月魄

导航

批量分段插入

 for(int j=0;j<groupArray.length();j++)
	 	  {
	 		  JSONArray singleArray=groupArray.getJSONArray(j);
	 		  
	 	  for(int i=0;i<singleArray.length();i++)
	 	  {
	 		  
	 		  JSONObject SingleObject=singleArray.getJSONObject(i) ;
	 		  String manufacturer=SingleObject.getString("manufacturer").replace(" ", "");
	 		  String model=SingleObject.getString("model").replace(manufacturer, "").replace(" ", "");
	 		   //model=SingleObject.getString("model").replace(manufacturer+"-", "").replace(manufacturer+"_", "").replace(" ", "");
	 		  model=SingleObject.getString("model").replace(manufacturer.toLowerCase(), "").replace(manufacturer.toUpperCase(), "").replace(" ", "");
	 		  
	 		  if(model!=null&&manufacturer!=null)
	 		  {
	 			  if(model.length()>1&&manufacturer.length()>1)
	 			  {
	 		   String beginSub=model.substring(0, 1);
	 		   if (beginSub.equals("-")||beginSub.equals("_"))
              {
            	  model=model.substring(1);
              }
	 		   
	 		  String groupInfo=manufacturer+","+model+"&";
			   size=size+1;
			   builderxx=builderxx+groupInfo;
			    if(size==50)
			    {
			    	forArray.put(builderxx);
			    	size=0;
			    	builderxx="";
			    	
			    }
	 		  }
	 		  }
			    
	 		   
	 		  
	 	  }
	 	  if(j==groupArray.length()-1)
	 	  {
	 		 forArray.put(builderxx);
	 	  }
	 	  
	 	  }
	 	  
	 	  for(int i=0;i<forArray.length();i++)
	 	  {
	 	  String[] arr=forArray.getString(i).split("&");
	 	 helper.batchInsertDeviceInfo(arr);
	 	  }
	 	  
	 	  
	 	  System.out.println(String.valueOf(masterArray.length()));
	 	  

  

posted on 2019-06-25 16:06  L-H  阅读(496)  评论(0)    收藏  举报