alterdatabase.java

基于Java的地图数据管理软件。使用MySQL数据库管理系统。

			List newXzList = (List) newLDMap.get(key); //本次报部路线(分市)
			List oldXzList = (List) oldLDMap.get(key); //上次报部路线(分市)
			//List newLdList = (List) newLDMap.get(key); //上次报部路线(分市)
			   for (int i = 0 ; newXzList != null && i < newXzList.size(); i++){
				   lineStr = (String)newXzList.get(i);
				   childStr = lineStr.split("\t");
				   n = 0;
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
				      if ( oldchildStr[5].equals(childStr[5] )){
				    	  n ++ ;
				    	  break;
				      }
				
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的路段：   "+ childStr[4] + "   " +  childStr[5]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
//	建制村变更
	public void AlterJzc() throws IOException{
		Iterator it = newJzcMap.keySet().iterator();
		String lineStr = "";
		String [] childStr = null;
		String oldlineStr = "";
		String [] oldchildStr = null;
		int n = 0;
	    String cityName = "";
		while (it.hasNext()) {
			
			String key = (String) it.next(); //城市名称
			if (key.equals("3402")) continue;
			for (int k = 0; cityArray != null && k < cityArray.length; k++){
				if (key.equals(cityArray[k][0]))
					{cityName = cityArray[k][1];
				    break;
					}
			}
		    System.err.println("***************正在处理  "+ cityName + "  数据!  ********************");	
			FileOperate fo = new FileOperate();
			String outPutFile = this.outFilePath + cityName + "\\Jzcjbqk.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newJzcMap.get(key); //本次报部路线(分市)
			List oldXzList = (List) oldJzcMap.get(key); //上次报部路线(分市)
			//List newLdList = (List) newLDMap.get(key); //上次报部路线(分市)
			   for (int i = 0 ; newXzList != null && i < newXzList.size(); i++){
				   lineStr = (String)newXzList.get(i);
				   childStr = lineStr.split("\t");
				   n = 0;
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
					   if (childStr[4].equals(oldchildStr[4]) && oldchildStr[5].equals(childStr[5] ) ) 
							   break;
					   if (((!childStr[4].equals(oldchildStr[4]) && oldchildStr[5].equals(childStr[5] ) ) 
								|| (childStr[4].equals(oldchildStr[4]) && !oldchildStr[5].equals(childStr[5] )))
								&& oldchildStr[5].substring(0,9).equals(childStr[5].substring(0,9) )){
							   n ++;
						   break;
					   }
				
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的建制村：   "+ childStr[4] + "   " +  childStr[5]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
//	乡镇变更
	public void AlterXz() throws IOException{
		Iterator it = newXzMap.keySet().iterator();
		String lineStr = "";
		String [] childStr = null;
		String oldlineStr = "";
		String [] oldchildStr = null;
int n = 0;
	    String cityName = "";
		while (it.hasNext()) {
			
			String key = (String) it.next(); //城市名称
			if (!key.equals("3402")) continue;
			for (int k = 0; cityArray != null && k < cityArray.length; k++){
				if (key.equals(cityArray[k][0]))
					{cityName = cityArray[k][1];
				    break;
					}
			}
		    System.err.println("***************正在处理  "+ cityName + "  数据!  ********************");	
			FileOperate fo = new FileOperate();
			String outPutFile = this.outFilePath + cityName + "\\Xzjbqk.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newXzMap.get(key); //本次报部路线(分市)
			List oldXzList = (List) oldXzMap.get(key); //上次报部路线(分市)
			//List newLdList = (List) newLDMap.get(key); //上次报部路线(分市)
			   for (int i = 0 ; newXzList != null && i < newXzList.size(); i++){
				   lineStr = (String)newXzList.get(i);
				   childStr = lineStr.split("\t");
				   n = 0;
				
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
					   if (childStr[4].equals(oldchildStr[4]) && oldchildStr[5].equals(childStr[5] ) ) 
							   break;
					   if (((!childStr[4].equals(oldchildStr[4]) && oldchildStr[5].equals(childStr[5] ) ) 
								|| (childStr[4].equals(oldchildStr[4]) && !oldchildStr[5].equals(childStr[5] )))
								&& oldchildStr[5].substring(0,4).equals(childStr[5].substring(0,4) )){
							   n ++;
						   break;
					   }
				
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的乡镇：   "+ childStr[4] + "   " +  childStr[5]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
//	建制村通达变更
	public void AlterJzcTd() throws IOException{
		Iterator it = newJzcTdMap.keySet().iterator();
		String lineStr = "";
		String townNumber = "";
		String [] childStr = null;
		String oldlineStr = "";
		String oldtownNumber = "";
		String [] oldchildStr = null;
		String jinDu = "";
		String weiDu = "";
		int n = 0;
	    String cityName = "";
		NewCommClass cc = new NewCommClass();
		while (it.hasNext()) {
			
			String key = (String) it.next(); //城市名称
			//if (!key.equals("3404")) continue;
			for (int k = 0; cityArray != null && k < cityArray.length; k++){
				if (key.equals(cityArray[k][0]))
					{cityName = cityArray[k][1];
				    break;
					}
			}
		    System.err.println("***************正在处理  "+ cityName + "  数据!  ********************");	
			FileOperate fo = new FileOperate();
			String outPutFile = this.outFilePath + cityName + "\\Jzctdqk.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newJzcTdMap.get(key); //本次报部路线(分市)
			List oldXzList = (List) oldJzcTdMap.get(key); //上次报部路线(分市)
			//List newLdList = (List) newLDMap.get(key); //上次报部路线(分市)
			   for (int i = 0 ; newXzList != null && i < newXzList.size(); i++){
				   lineStr = (String)newXzList.get(i);
				   childStr = lineStr.split("\t");
				   n = 0;
				
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
					   if (childStr[5].equals(oldchildStr[5]) && oldchildStr[7].equals(childStr[7] ) ) 
						   break;
				   if (((!childStr[5].equals(oldchildStr[5]) && oldchildStr[7].equals(childStr[7] ) ) 
							|| (childStr[5].equals(oldchildStr[5]) && !oldchildStr[7].equals(childStr[7] )))){
							//&& oldchildStr[5].substring(0,6).equals(childStr[5].substring(0,6) )
						   n ++;
					   break;
				   }
				
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的建制村通达：   "+ childStr[4] + "   " +  childStr[5]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
//	乡镇通达变更
	public void AlterXzTd() throws IOException{
		Iterator it = newXzTdMap.keySet().iterator();
		String lineStr = "";
		String [] childStr = null;
		String oldlineStr = "";
		String [] oldchildStr = null;
		int n = 0;
	    String cityName = "";
		while (it.hasNext()) {
			
			String key = (String) it.next(); //城市名称
			//if (!key.equals("3404")) continue;
			for (int k = 0; cityArray != null && k < cityArray.length; k++){
				if (key.equals(cityArray[k][0]))
					{cityName = cityArray[k][1];
				    break;
					}
			}
		    System.err.println("***************正在处理  "+ cityName + "  数据!  ********************");	
			FileOperate fo = new FileOperate();
			String outPutFile = this.outFilePath + cityName + "\\Xztdqk.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newXzTdMap.get(key); //本次报部路线(分市)
			List oldXzList = (List) oldXzTdMap.get(key); //上次报部路线(分市)
			//List newLdList = (List) newLDMap.get(key); //上次报部路线(分市)
			   for (int i = 0 ; newXzList != null && i < newXzList.size(); i++){
				   lineStr = (String)newXzList.get(i);
				   childStr = lineStr.split("\t");
				   n = 0;
				
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
					   if (childStr[5].equals(oldchildStr[5]) && oldchildStr[7].equals(childStr[7] ) ) 
							   break;
					   if (((!childStr[5].equals(oldchildStr[5]) && oldchildStr[7].equals(childStr[7] ) ) 
								|| (childStr[5].equals(oldchildStr[5]) && !oldchildStr[7].equals(childStr[7] )))){
								//&& oldchildStr[5].substring(0,6).equals(childStr[5].substring(0,6) )
							   n ++;
						   break;
					   }
				
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的乡镇通达：   "+ childStr[4] + "   " +  childStr[5]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
	public  static void main(String [] args) throws IOException{
		//  NewCommClass cc = new NewCommClass();
		// System.out.println("==========count========" + cc.getCityCount("3405"));
		AlterDataBase tst = new AlterDataBase();
		   tst.readData();
		   tst.AlterQl();
		   //tst.AlterJzcTd();
		  
	}

}