alterdatabase.java

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

		Iterator it = newDkMap.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 + "\\Dk.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newDkMap.get(key); //本次报部渡口(分市)
			List oldXzList = (List) oldDkMap.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");
				   townNumber = childStr[5];
				   n = 0;
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
					   oldtownNumber = oldchildStr[5];
					    if ( (oldchildStr[7].equals(childStr[7] ) && oldchildStr[8].equals(childStr[8] )))
								break;
					   if (((!childStr[7].equals(oldchildStr[7]) && oldchildStr[8].equals(childStr[8] ) ) 
								|| (childStr[7].equals(oldchildStr[7]) && !oldchildStr[8].equals(childStr[8] )))
								&& oldchildStr[5].equals(childStr[5] )){
							   n ++;
						   break;
					   }
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的渡口：   "+ childStr[7] + "   " +  childStr[8]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
//	桥梁变更
	public void AlterQl() throws IOException{
		Iterator it = newQlMap.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 + "\\Ql.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newQlMap.get(key); //本次报部渡口(分市)
			List oldXzList = (List) oldQlMap.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");
				   townNumber = childStr[5];
				   n = 0;
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
					   oldtownNumber = oldchildStr[5];
					    if ( (oldchildStr[7].equals(childStr[7] ) && oldchildStr[8].equals(childStr[8] ))
					    		&& oldchildStr[5].equals(childStr[5]))
								{
					    	// System.out.println("====================OK!===================");
					    	break;
								}
					   if (((!childStr[7].equals(oldchildStr[7]) && oldchildStr[8].equals(childStr[8] ) ) 
								|| (childStr[7].equals(oldchildStr[7]) && !oldchildStr[8].equals(childStr[8] )))
								&& oldchildStr[5].equals(childStr[5] )){
							   n ++;
						   break;
					   }
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的桥梁：   "+ childStr[7] + "   " +  childStr[8]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
	
//	隧道变更
	public void AlterSd() throws IOException{
		Iterator it = newSdMap.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 + "\\Sd.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newSdMap.get(key); //本次报部渡口(分市)
			List oldXzList = (List) oldSdMap.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");
				   townNumber = childStr[5];
				   n = 0;
				   for (int j = 0 ; oldXzList != null && j < oldXzList.size(); j++){
					   oldlineStr = (String)oldXzList.get(j);
					   oldchildStr = oldlineStr.split("\t");
					   oldtownNumber = oldchildStr[5];
					    if ( (oldchildStr[7].equals(childStr[7] ) && oldchildStr[8].equals(childStr[8] )))
								break;
					   if (((!childStr[7].equals(oldchildStr[7]) && oldchildStr[8].equals(childStr[8] ) ) 
								|| (childStr[7].equals(oldchildStr[7]) && !oldchildStr[8].equals(childStr[8] )))
								&& oldchildStr[5].equals(childStr[5] )){
							   n ++;
						   break;
					   }
				   }
				   
				   if ( n != 0 ) {
					   System.out.println("变更的隧道：   "+ childStr[7] + "   " +  childStr[8]);
					    myFile.write(lineStr+"\r\n");
				   }
			   }
		 	  myFile.close();  
		 	  System.err.println("***************  "+ cityName + " 数据，处理完毕!  ********************");	
		}
	
	}
//	路线变更
	public void AlterLx() throws IOException{
		Iterator it = newLxMap.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 + "\\Lx.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);
			
			List newXzList = (List) newLxMap.get(key); //本次报部路线(分市)
			List oldXzList = (List) oldLxMap.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 AlterLd() throws IOException{
		Iterator it = newLDMap.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 + "\\Ld.txt";
			File newFile = fo.createFolder(outPutFile);
			FileWriter resultFile = new FileWriter(newFile);
			PrintWriter myFile = new PrintWriter(resultFile);